Nextcloud installation: Error while trying to create admin user on Synology Running DSM 6.2.3

Hello,

Trying to install NC 19.0.1 on DSM v6.2.3 and keep getting an error at the initial configuration page after entering all the correct info. Running Apache 2.4. MariaDB 10 and PHP 7.3 through web station on the Synology NAS DS411+ II and DS918+. The initial webpage comes up with no issues but fails every time with a connection refused error after inputting all the correct details. Any ideas from anyone with the same issue…have tried on 2 different Synology devices with the exact same error.

Looks like the DB is refusing the connection but no idea how to correct despite using 127.0.0.1:3307. I can login to PHPmyadmin with root with no issues using password. I even went into nextcloud/config config.php and added ‘allow_local_remote_servers’ => true, and no change. Please see the error below after clicking OK and the log. Rookie here so please be gentle :slight_smile: Thanks for any help.

“Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused”

“reqId”:“RKczOA0TWJt4Y9HMb8qg”,“level”:3,“time”:“2020-07-18T10:38:11+00:00”,“remoteAddr”:“192.168.0.10”,“user”:"–",“app”:“PHP”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“session_start(): A session had already been started - ignoring at /volume1/web/nextcloud/lib/private/Session/Internal.php#209”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0”,“version”:“19.0.1.1”}
{“reqId”:“RKczOA0TWJt4Y9HMb8qg”,“level”:2,“time”:“2020-07-18T10:38:11+00:00”,“remoteAddr”:“192.168.0.10”,“user”:"–",“app”:“no app in context”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“Host 192.168.0.32 was not connected to because it violates local access rules”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0”,“version”:“19.0.1.1”}
{“reqId”:“RKczOA0TWJt4Y9HMb8qg”,“level”:2,“time”:“2020-07-18T10:38:11+00:00”,“remoteAddr”:“192.168.0.10”,“user”:"–",“app”:“no app in context”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“Host 192.168.0.32 was not connected to because it violates local access rules”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0”,“version”:“19.0.1.1”}
{“reqId”:“RKczOA0TWJt4Y9HMb8qg”,“level”:3,“time”:“2020-07-18T10:38:11+00:00”,“remoteAddr”:“192.168.0.10”,“user”:"–",“app”:“jsresourceloader”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“Could not find resource js/setup.js to load”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0”,“version”:“19.0.1.1”}

SUCCESS

I found that it is indeed Synology settings that was causing the problem. In the Web Station app on the Synology, open the PHP settings for your preferred PHP version. There are extensions and look for mysqli.default_socket and use the value in that field. I ended up having to use the entry below to get by the install screen and the server now runs with MariaDB 10

localhost:/run/mysqld/mysqld10.sock