Почему запрещён доступ с этого компьютера к phpmyadmin?

Question

[Arkadii026]

Подскажите пожалуйста, после установки phpmyadmin на centos при попытке зайти на него с другого компа через браузер получаю сообщение.
Forbidden
You don't have permission to access /phpmyadmin/ on this server.
Версия httpd
Server version: Apache/2.4.6 (CentOS)
Server built: Jun 27 2018 13:48:59
Лог ошибок в httpd
[Wed Oct 10 10:55:20.127987 2018] [mpm_prefork:notice] [pid 2419] AH00170: caught SIGWINCH, shutting down gracefully
[Wed Oct 10 10:55:21.208769 2018] [suexec:notice] [pid 2451] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message
[Wed Oct 10 10:55:21.230472 2018] [auth_digest:notice] [pid 2451] AH01757: generating secret for digest authentication ...
[Wed Oct 10 10:55:21.231036 2018] [lbmethod_heartbeat:notice] [pid 2451] AH02282: No slotmem from mod_heartmonitor
[Wed Oct 10 10:55:21.233679 2018] [mpm_prefork:notice] [pid 2451] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations
[Wed Oct 10 10:55:21.233726 2018] [core:notice] [pid 2451] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

конфиг phpmyadmin в httpd

# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin


AddDefaultCharset UTF-8


# Apache 2.4

#Require ip 127.0.0.1
#Require ip ::1
Require all granted



# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1





# Apache 2.4

#Require ip 127.0.0.1
#Require ip ::1
Require all granted



# Apache 2.2
Order Deny,Allow
Deny from All
# Allow from All
# Allow from ::1
Require all granted



# These directories do not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#

Order Deny,Allow
Deny from All
Allow from None



Order Deny,Allow
Deny from All
Allow from None



Order Deny,Allow
Deny from All
Allow from None


# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc. This may break your mod_security implementation.
#
#
#
# SecRuleInheritance Off
#
#
Помогите пожалуйста, что только не пробовал.

Answer 1

[Владислав Лысков]

в mysql доступ к базе по умолчанию доступен только с локалхоста
тебе нужно в конфиге mysql указать Ip, с которых к базе будет доступ

Comments

[Arkadii026]

С локального входа получаю такую же фигню

[Arkadii026]

Конфиг mysql не содержит ничего подобного

# For advice on how to change settings please see
# dev.mysql.com/doc/refman/8.0/en/server-configurati...

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-sys...
# default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[Владислав Лысков]

Arkadii026, блин, а это тебя не смущает?
Order Deny,Allow
Deny from All
Allow from None

Order Deny,Allow
Deny from All
Allow from None

Order Deny,Allow
Deny from All

[Владислав Лысков]

Arkadii026, ты сам ото всех закрыл

[Arkadii026]

Владислав Лысков, Понял, спасибо, буду пробовать.

Answer 2

[Fedor]

У тебя же в конфигах апача написано:

#Apache X.X

#Require ip 127.0.0.1
#Require ip ::1
Require all granted

# Apache 2.2
Order Deny,Allow
Deny from All                 # - запретить доступ со всех ip
Allow from 127.0.0.1      # - разрешить с 127.0.0.1 (это локалхост)
Allow from ::1                 # - разрешить с ::1 (это тоже локалхост)

Нужно написать:

Order Deny,Allow
Allow from All           # - доступ к phpmyadmin с любого ip

Answer 3

[Arkadii026]

Привел phpmyadmin.conf к вот такому виду, вроде всё разрешил что можно, но проблема осталась.
Я уже не знаю куда копать... бред какой то.
# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

AddDefaultCharset UTF-8


# Apache 2.4

Require all granted
Require ip ::1

# Apache 2.2
Order Deny,Allow
Deny from None
Allow from All
Allow from 192.168.0.82
Allow from ::1

# Apache 2.4

Require all granted
#Require ip ::1

# Apache 2.2
Order Deny,Allow
Deny from None
Allow from All
Allow from 192.168.0.82
Allow from ::1


# These directories do not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#

Order Deny,Allow
Allow from All
Deny from None
#Allow from None

Order Deny,Allow
Allow from All
Deny from None
#Allow from None

Order Deny,Allow
Allow from All
Deny from None
#Allow from None

# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc. This may break your mod_security implementation.
#
#
#
# SecRuleInheritance Off
#
#

Comments

[Руслан Федосеев]

AllowOverride All
найдите эту директиву в конфиге апача и разрешите. Везде для начала.

[Arkadii026]

Привет, конфиг к вот такому виду
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

AddDefaultCharset UTF-8
Require all granted

Require all granted


Order Deny,Allow
Deny from All
Allow from None

Order Deny,Allow
Deny from All
Allow from None

Order Deny,Allow
Deny from All
Allow from None

Проблема осталась, может еще где есть конфиг у phpmyadmin