Current time: 11-26-2024, 02:47 PM Hello There, Guest! (LoginRegister)


Post Reply 
ERROR: Unable to connect SQL server !
Author Message
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #11
RE: ERROR: Unable to connect SQL server !
please more infos - stop proftpd and run it like this:
proftpd -nd 5
output post here...

/J
12-01-2009 07:57 AM
Visit this user's website Find all posts by this user Quote this message in a reply
motokochan Offline
Member
***

Posts: 274
Joined: Jul 2008
Reputation: 1
Post: #12
RE: ERROR: Unable to connect SQL server !
Is MySQL listening on port 3306?

Some distributions include the "--skip-networking" option on MySQL startup, which leaves MySQL only listening on a local socket. ispCP needs MySQL to listen on a network port.
(This post was last modified: 12-01-2009 01:17 PM by motokochan.)
12-01-2009 01:17 PM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #13
RE: ERROR: Unable to connect SQL server !
hm, either -skip-networking or bind-address=127.0.0.1 do IMHO the same...

mysql must listen on localhost - the external IP is not a must.

/J
12-01-2009 05:45 PM
Visit this user's website Find all posts by this user Quote this message in a reply
motokochan Offline
Member
***

Posts: 274
Joined: Jul 2008
Reputation: 1
Post: #14
RE: ERROR: Unable to connect SQL server !
(12-01-2009 05:45 PM)joximu Wrote:  hm, either -skip-networking or bind-address=127.0.0.1 do IMHO the same...

They actually are different. Giving --skip-networking (just skip-networking in my.cnf) has MySQL not use any IP address. It only opens a local socket. Using bind-address does cause MySQL to listen on a port on a specific IP.


(12-01-2009 05:45 PM)joximu Wrote:  mysql must listen on localhost - the external IP is not a must.

Indeed, having it only bind to localhost is fine and will work fine. However, skip-networking will not work. The first step in debugging this issue is making sure MySQL is listening on a port.
(This post was last modified: 12-01-2009 06:00 PM by motokochan.)
12-01-2009 05:58 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)