petsoukos Posted January 27, 2014 Share 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 Link to comment Share on other sites More sharing options...
d00p Posted January 27, 2014 Share Posted January 27, 2014 Is MySQL even running? Link to comment Share on other sites More sharing options...
petsoukos Posted January 28, 2014 Author Share Posted January 28, 2014 Ofcourse it is. Link to comment Share on other sites More sharing options...
d00p Posted January 28, 2014 Share 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? Link to comment Share on other sites More sharing options...
petsoukos Posted January 28, 2014 Author Share 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. Link to comment Share on other sites More sharing options...
d00p Posted January 28, 2014 Share Posted January 28, 2014 Something in any log-file? there must be something. Link to comment Share on other sites More sharing options...
petsoukos Posted January 28, 2014 Author Share Posted January 28, 2014 Found the misconfig in the my.cnf file. It didn't allow remote access... duh Link to comment Share on other sites More sharing options...
d00p Posted January 28, 2014 Share Posted January 28, 2014 remote-access? localhost? Don't know how that should be related, but as long as it works - great Link to comment Share on other sites More sharing options...
petsoukos Posted January 28, 2014 Author Share 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.