piercj2

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Forum: Installing WordPress
    In reply to: Error establishing a database connection
    Thread Starter piercj2

    (@piercj2)

    7 years, 9 months ago

    thanks Steve,
    On both servers i’ve set iptables to accept all inbound and outbound traffic with
    – iptables -A INPUT -j ACCEPT
    – iptables -A OUTPUT -j ACCEPT

    Still unable to connect to the database from the Web Server.

    I understand what you’re saying about it probably being a System issue rather than a WordPress issue. I’ll keep Googling to see what I can find. Thanks again,
    Jason

    Forum: Installing WordPress
    In reply to: Error establishing a database connection
    Thread Starter piercj2

    (@piercj2)

    7 years, 9 months ago

    I couldn’t install a mysql-client on the CentOS 7.4 WordPress server so I installed MariaDB-client instead.
    issuing the “mysql -u wp_svc -p wordpress -h 10.60.161.173” command from the WordPress server returns
    “ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannt be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory”

    On the Database Server, i’ve also edited /etc/my.cnf and set the port to 3306
    I’ve set the following iptables rules
    iptables -A INPUT -i 1o -p tcp –dport 3306 -j ACCEPT
    iptables -A OUTPUT -p tcp –dport 3306 -j ACCEPT

    I also disabled the firewall on the Database Server with
    systemctl disable firewalld.service
    systemctl stop firewalld.service

    Forum: Installing WordPress
    In reply to: Error establishing a database connection
    Thread Starter piercj2

    (@piercj2)

    7 years, 9 months ago

    Hi Steve
    Not sure if i’m looking in the correct file but, the contents of /etc/my.cnf are

    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    bind_address=10.60.161.173

    10.60.161.173 is the IP of CentOS-DB-01, where MySQL is installed

    Forum: Installing WordPress
    In reply to: Error establishing a database connection
    Thread Starter piercj2

    (@piercj2)

    7 years, 9 months ago

    Thanks for the reply Steve,

    Unfortunately, WordPress is installed on my CentOS-Web-01 server and MySQL is installed on my CentOS-DB-01 Server. As a result, running the MySQL command on the WordPress server, returns the error “bash: mysql: command not found…”

    If however I run the command on the MySQL Server, I successfully enter MySQL so it looks like i’ve the User Credentials entered into /var/www/html/wp-config.php correctly

    To your last point, the content of /etc/my.cnf.d/server.cnf in the MySQL server is blank.
    looks like I need to allow the Server acceptremote connections but, haven’t done this before (also new to CentOS).
    Looks like i’m of to Google again 🙂

    Thanks again for the assist,
    Jason

Viewing 4 replies - 1 through 4 (of 4 total)