Problem with installation on DS916+ 8GB

Paul Barrett
Posts: 57
Joined: Sun Apr 08, 2018 6:52 pm

Problem with installation on DS916+ 8GB

Post by Paul Barrett » Fri Nov 08, 2019 7:56 am

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?
Paul Barrett
pfbarrett.uk

Steve
Posts: 79
Joined: Sun Oct 01, 2017 3:08 pm

Re: Problem with installation on DS916+ 8GB

Post by Steve » Sat Nov 09, 2019 10:46 pm

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
Posts: 57
Joined: Sun Apr 08, 2018 6:52 pm

Re: Problem with installation on DS916+ 8GB

Post by Paul Barrett » Mon Nov 11, 2019 5:55 pm

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
Paul Barrett
pfbarrett.uk

Steve
Posts: 79
Joined: Sun Oct 01, 2017 3:08 pm

Re: Problem with installation on DS916+ 8GB

Post by Steve » Mon Nov 11, 2019 6:13 pm

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.