petsoukos Posted January 27, 2014 Posted January 27, 2014 Hello, I'm having issues setting up froxlor on my VPS. I've filled the correct settings for the database but still it can't connect. I get this message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) I've tried with 'localhost' for hostname, but got another error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) I think there might be a misconfiguration on the server, but don't know where to look. I'm running: CentOS 6.5 Apache 2.2.15 PHP 5.3.3 MySQL 5.1.17 Thanks
d00p Posted January 28, 2014 Posted January 28, 2014 How am I supposed to know? Just trying to figure out where the problem might be. The error-message does not say anything about failed authentification or similar, which tells me, MySQL cannot be reached properly. Can you verify a successful login via shell?
petsoukos Posted January 28, 2014 Author Posted January 28, 2014 Yes, I can login via shell, I can then log into MySQL and work with it. As you stated, the error message doesn't give me anything else to work with that's why I'm asking for any ideas why wouldn't the software connect to it.
d00p Posted January 28, 2014 Posted January 28, 2014 Something in any log-file? there must be something.
petsoukos Posted January 28, 2014 Author Posted January 28, 2014 Found the misconfig in the my.cnf file. It didn't allow remote access... duh
d00p Posted January 28, 2014 Posted January 28, 2014 remote-access? localhost? Don't know how that should be related, but as long as it works - great
petsoukos Posted January 28, 2014 Author Posted January 28, 2014 Well maybe php wasn't able to access it... I don't know, but it works now. Time to test it!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.