I was previously using Yetishare successfully and wanted to migrate to a new server.
However I am having issues getting Yetishare to function with what is essentially the same configuration.
I have included the log snippet:
I'm not sure why it cannot connect with the password I set for it, I've tried both unix sockets and TCP/IP and really don't know what else I can try.
I am using NGINX 1.11.8, MariaDB, and can switch between PHP verisons 5.6, 7.0, and 7.1 and is x86_64.
The previous server was using NGINX 1.10.x, MySQL, PHP 7.0 ot 5.6, and was 32 bit ARMv7.
edit: This appears to be an issue with PHP and not MariaDB (or Yetishare) which is strange because I haven't made any changes to the configuration. Not sure how I avoided this previously :|
edit2: I decided to wipe the server and try again, same problem as before.
now running debian with nginx 1.10 mariadb, and php7.0 with TCP/IP socket.
Thank you.
However I am having issues getting Yetishare to function with what is essentially the same configuration.
I have included the log snippet:
Code:
2017/01/22 04:41:51 [error] 32423#0: *2 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/step1.php"
2017/01/22 04:44:58 [error] 32426#0: *11 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 189.194.210.123, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/s3"
2017/01/22 04:45:05 [error] 32426#0: *11 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 189.194.210.123, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/s3"
2017/01/22 04:47:20 [error] 32529#0: *1 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9071", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/step1.php"
2017/01/22 04:47:23 [error] 32529#0: *1 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9071", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/step1.php"
2017/01/22 04:47:25 [error] 32529#0: *1 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9071", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/"
2017/01/22 04:47:28 [error] 32529#0: *1 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9071", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/"
2017/01/22 04:47:32 [error] 32529#0: *1 FastCGI sent in stderr: "PHP message: Failed connecting to the database with the supplied connection details. Please check the details are correct and your MySQL user has permissions to access this database.<br/><br/>(host: , user: , pass: ********)" while reading response header from upstream, client: 123.456.789.000, server: WEBSITE.COM, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9071", host: "WEBSITE.COM", referrer: "https://WEBSITE.COM/install/step1.php"
I am using NGINX 1.11.8, MariaDB, and can switch between PHP verisons 5.6, 7.0, and 7.1 and is x86_64.
The previous server was using NGINX 1.10.x, MySQL, PHP 7.0 ot 5.6, and was 32 bit ARMv7.
edit: This appears to be an issue with PHP and not MariaDB (or Yetishare) which is strange because I haven't made any changes to the configuration. Not sure how I avoided this previously :|
edit2: I decided to wipe the server and try again, same problem as before.
now running debian with nginx 1.10 mariadb, and php7.0 with TCP/IP socket.
Thank you.