Error 500 or blank page on step 2 during install (log included)

jeybird966368

New Member
YetiShare User
Dec 29, 2016
20
1
1
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:
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'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.
 

sukhman21

Member
YetiShare User
YetiShare Supporter
Jan 26, 2015
508
3
18
your nginx fastcgi://127.0.0.1:9071 is incorrect. Not sure if you copied from yetishare nginx configuration text file but you are supposed to replace this text 127.0.0.1:9071 with what you had in your nginx when you installed it.
 

jeybird966368

New Member
YetiShare User
Dec 29, 2016
20
1
1
It was correct and matched my pool.d config. I have made sure that the proper changes were made to the default nginx configuration.

I actually was able to get Yetishare to work through a round-a-bout method.
I skipped the installer, edited _config.inc.php manually, and imported my database backup.
After that Yetishare functioned as expected, all I need to do now is upload my files and themes folders.

I am not sure why the installer wasn't working, perhaps this strange behavior could be looked into? Especially since someone without a backup wouldn't of been able to do this.
If possible I would be able to provide more information.

But for now I have fixed my problem. Than you.
 

paypal1352

New Member
YetiShare User
Wurlie User
Mar 2, 2012
297
2
0
do you have any sort of additions to your conf that detect and disallow sql injections etc.. or maybe and more likely your sql credentials are not correct, u should try and connect manually via the command line to test this

mysql -u username -p

im willing to bet your credentials wont work and thats whats causing you the issues with the installer
 

sukhman21

Member
YetiShare User
YetiShare Supporter
Jan 26, 2015
508
3
18
Believe it or not, my test server is nginx and my production server is apache and i know the installer works on nginx and apache because i installed it myself.
Anyways if its working for you, its all good i guess...
 

jeybird966368

New Member
YetiShare User
Dec 29, 2016
20
1
1
Thank you for the responses.

I have no doubt that Yetishare would function in either NGINX or Aapche! As I said before I was actually already using it on NGINX before moving servers.

hmm...my sql credentials do work as expected in the command line so it doesn't appear to be an issue there.
I'm not really sure, for the most part my configuration near stock.

Even when trying the default configurations on fresh Ubuntu and Debian installs Yetishare still fails to install, resulting in either a blank page or a 500 error. It just seemed as though the values I was putting in weren't taking.

If I figure out why I'll mention it for anyone who might encounter a similar issue.
 

paypal1352

New Member
YetiShare User
Wurlie User
Mar 2, 2012
297
2
0
this now sounds to me like an nginx conf file issue, i hope ur not forgetting to run nginx -t then if u have no issues restart nginx