Saya menjalankan server Ubuntu 14.04 LTS dan saya mencoba membuat phpMyAdmin berfungsi. Setiap kali saya membuka 192.168.0.xxx/phpmyadmin
itu memberi saya kesalahan 403. Saya juga telah menginstal WordPress dan saya dapat mengaksesnya tanpa masalah.
Saya sudah mencoba:
- Menyetel kepemilikan ke Apache
- Memulai ulang komputer/server saya
- Menggunakan komputer lain
- Mencopot/menginstal ulang (termasuk
uninstall
→install
,purge
→install
, daninstall --reinstall
) - Membaca banyak dari tutorial/pertanyaan AU/postingan/blog tentang cara memperbaikinya, namun tidak ada satupun yang menunjukkan solusi yang valid kepada saya.
Satu hal aneh yang saya temukan ketika melihat “homepage” situs (yaitu tidak ada /foobar
di akhir), ini menunjukkan file explorer. Namun, itu tidak menunjukkan phpMyAdmin. Juga, itu berfungsi beberapa hari yang lalu, dan saya tidak ingat mengubah apa pun. Satu-satunya hal yang terlihat aneh tentang ini adalah biasanya ada sesuatu dengan /serv
IIRC, tapi mungkin itu yang saya lakukan di server lain…
Catatan:tidak ada .htaccess
file di /usr/share/phpmyadmin
map. Saya telah melihat beberapa artikel yang mengisyaratkan bahwa seharusnya ada, tetapi saya tidak dapat menemukan jawaban yang pasti.
/etc/phpmyadmin/apache.conf file:
# phpMyAdmin default Apache configuration
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
order deny,allow
#deny from all
allow from all
<IfModule mod_php5.c>
AddType application/x-httpd-php .php
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
</Directory>
# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Directory>
#Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
Order Deny,Allow
Deny from All
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
Order Deny,Allow
Deny from All
</Directory>
File konfigurasi Apache:
# The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
#
Mutex file:${APACHE_LOCK_DIR} default
# PidFile: The file in which the server should record its process
# identification number when it starts.
# This needs to be set in /etc/apache2/envvars
#
PidFile ${APACHE_PID_FILE}
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 300
KeepAlive On
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5
# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}
# HostnameLookups
HostnameLookups Off
# ErrorLog: The location of the error log file.
ErrorLog ${APACHE_LOG_DIR}/error.log
# LogLevel: Control the severity of messages logged to the error_log.
# Available values: trace8, ..., trace1, debug, info, notice, warn,
# error, crit, alert, emerg.
# It is also possible to configure the log level for particular modules, e.g.
# "LogLevel info ssl:warn"
#
LogLevel warn
# Include module configuration:
IncludeOptional mods-enabled/*.load
IncludeOptional mods-enabled/*.conf
# Include list of ports to listen on
Include ports.conf
# Sets the default security model of the Apache2 HTTPD server. It does
# not allow access to the root filesystem outside of /usr/share and /var/www.
# The former is used by web applications packaged in Debian,
# the latter may be used for local directories served by the web server. If
# your system is serving content from a sub-directory in /srv you must allow
# access here, or in any related virtual host.
<Directory />
Options FollowSymLinks
AllowOverride None
Require all denied
</Directory>
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
# AccessFileName: The name of the file to look for in each directory
# for additional configuration directives. See also the AllowOverride
# directive.
#
AccessFileName .htaccess
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^.ht">
Require all denied
</FilesMatch>
# The following directives define some format nicknames for use with
# a CustomLog directive.
#
# These deviate from the Common Log Format definitions in that they use %O
# (the actual bytes sent including headers) instead of %b (the size of the
# requested file), because the latter makes it impossible to detect partial
# requests.
#
# Note that the use of %{X-Forwarded-For}i instead of %h is not recommended.
# Use mod_remoteip instead.
#
LogFormat "%v:%p %h %l %u %t "%r" %>s %O "%{Referer}i" "%{User-Agent}i"" vhost_combined
LogFormat "%h %l %u %t "%r" %>s %O "%{Referer}i" "%{User-Agent}i"" combined
LogFormat "%h %l %u %t "%r" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
# Include of directories ignores editors' and dpkg's backup files,
# see README.Debian for details.
# Include generic snippets of statements
IncludeOptional conf-enabled/*.conf
# Include the virtual host configurations:
IncludeOptional sites-enabled/*.conf
# vim: syntax=apache ts=4 sw=4 sts=4 sr noet
Include /etc/phpmyadmin/apache.conf
(Saya minta maaf karena membuang banyak teks di sini, tetapi saya telah mengerjakan ini selama sekitar tiga jam dan saya tidak dapat menemukan cara untuk memperbaikinya. Saya akan dengan senang hati memberikan lebih banyak lagi file jika diperlukan, tinggalkan komentar.)
Apa yang menyebabkan ini dan bagaimana cara memperbaikinya?
Terkait:Nonaktifkan Aplikasi Mulai Otomatis?Jawaban yang Diterima:
Ubah beberapa baris berikut di /etc/phpmyadmin/apache.conf
dari ini:
<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
order deny,allow
#deny from all
allow from all
Untuk ini:
<Directory /usr/share/phpmyadmin>
Options Indexes FollowSymLinks MultiViews
DirectoryIndex index.php
AllowOverride all
Require all granted
Apache Anda adalah 2.4+, jadi ia menggunakan Require all granted
alih-alih Allow from all
.
Hanya tip lain untuk dijatuhkan di sini:Anda dapat melihat file error.log Apache Anda untuk mencari tahu mengapa Anda ditolak (kesalahan 403), ini bisa memberikan petunjuk tentang apa masalahnya. File error.log biasanya ada di direktori root (biasanya /var/www/html).