[Asterisk-Users] cdr mysql problem

[Rich Adamson]

> > error messages informing me of error, error message is as follows : 
> > cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost" 
> > and "res_config_mysql.c : Failed to connect database server on ."
> >
> > Im realy lost and dont know whats wrong. I've checked the connection 
> > to MySql in command line using the same user and host and its been 
> > connected without any problem.
> >
> 
> I had this problem after upgrading mysql.  I had to move back to version 
> *4.0.20.  If you do a nmap on the mysql system, you'll probably not see 
> it listening on port 3306.

Or, simply do 'netstat -an | more'. Should see something like:

tcp        0      0 0.0.0.0:3306 

If that is not seen, then mysql is not listening on a tcp port.