Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] asterisk-addons 1.6.0 "Command 'realtime mysql status'


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
jmr.richardson at gmai...
Guest





PostPosted: Thu May 22, 2008 12:37 pm    Post subject: [asterisk-users] asterisk-addons 1.6.0 "Command 'realti Reply with quote

Quote:
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
--
JR Richardson
Engineering for the Masses
Back to top
sherwood.mcgowan at gm...
Guest





PostPosted: Thu May 22, 2008 12:58 pm    Post subject: [asterisk-users] asterisk-addons 1.6.0 "Command 'realti Reply with quote

JR Richardson wrote:
Quote:
Quote:
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services