JR Richardson wrote: >> Thought I'd post this, see if anyone has experienced this...I am using >> Asterisk 1.6 from the SVN branch and Asterisk-addons 1.6 from the SVN >> branch. Mysql is running and I've connected using the information that >> is in res_mysql.conf but when I try to check the realtime status I get >> the following: >> Connected to Asterisk SVN-branch-1.6.0-r117183 currently running on >> ubuntu (pid = 31371) >> Verbosity is at least 3 >> -- Remote UNIX connection >> ubuntu*CLI> module reload res_config_mysql.so >> -- Reloading module 'res_config_mysql.so' (MySQL RealTime >> Configuration Driver) >> == Parsing '/etc/asterisk/res_mysql.conf': == Found >> == MySQL RealTime reloaded. >> ubuntu*CLI> realtime mysql status >> Command 'realtime mysql status' failed. >> >> Here's a sanitized version of res_mysql.conf >> [general] >> dbhost = localhost >> dbport = 3306 >> dbname = **db** >> dbuser = **user** >> dbpass = **pass** >> dbsock = /var/lib/mysql/mysql.sock >> >> Any thoughts? >> > > I'm currently testing this as well. In the res_mysql.conf, use dbhost > = 127.0.0.1 instead of 'localhost'. > > Also try to connect to the mysql database with the user/pass at the > command line just to ensure mysql is accepting connections for that > user on the local machine. > > # mysql -u **user** -p > > In /etc/mysql/my.cnf ensure: > bind-address = 0.0.0.0 > or > bind-address = 127.0.0.1 > > My test is connecting fine to local and remote databases, I'm use > Asterisk 1.6-current and addon-1.6-current from digium ftp, not trunk. > > Hope this helps. > > JR > Thanks, the change to 127.0.0.1 did the trick. Sherwood McGowan
_______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
