Problem with installation on DS916+ 8GB

[Paul Barrett]

It's been a while since I did a WordPress installation on my Synology.

In the meantime, php7.2 for Syno has been released and installed.

I have followed the instructions but when I run the 5 min install I can't get a connection to the database.

Has anything changed?

[steven]

Nothing has changed. Are you using WordPress from Synology or WordPress.org?

I ask because if you use the WordPress.org version you need to make sure you are using the correct socket. Also check the mysql.default_port in the php core configuration. Synology defaults to 3306 but MariaDB 10 uses 3307. While checking the core, make sure the correct socket is specified.

The php 7.2 configuration for MariaDB10 mysql.default_socket is as follows:

Code: Select all

/run/mysqld/mysqld10.sock

Plus the line below must be in your WordPress configuration file:

Code: Select all

define('DB_HOST', 'localhost:/run/mysqld/mysqld10.sock');

If these are correct make sure you do not have any typos for the database name, user and password.

Last, check that the user has the correct privileges. Which is explained in this post.

[Paul Barrett]

I'm using WordPress.org.

Just for a stopgap, I tried installing the Syno package and discovered to my horror that although it installs WP 5.2, it STILL does it on php5.6!!!!

I'll try those tips.

Thanks

[steven]

It appears Synology REALLY LIKES php 5.6 even though it is obsolete. Unfortunately they have a few programs that still require this version. I sent a request asking them to update their programs, so I could delete php5.6, but never received a reply.

One thing I forgot to mention is to run phpinfo.php to verify mysql is enabled. This is a simple file you can create yourself by inserting the code below:

Code: Select all

<?php
    phpinfo();
?>

Additionally I added this post some time ago about connecting to MariaDB.