Hi i am using the asterisk server on one machine and mysql on another machine.I have my mysql running on 192.168.77.75 and asterisk running on the 192.168.77.77. when executing following cli command on asterisk server on 192.168.77.77 *CLI> realtime mysql status Connected to asterisk@192.168.77.75, port 3306 with username root for 8 minutes, 45 seconds. But my phones are not getting registered with the 192.168.77.77. The phones have entry in the mysql database. my res_msql.conf on machine 192.168.77.77 have the following entries [general] dbhost=192.168.77.75 dbname=asterisk dbuser=root dbpass=root dbport=3306 dbsock=/tmp/mysql.sock When the cli shows the asterisk connected then why my phones are not able to register the 77 asterisk server. If i am running asterisk on 75 itself then the phones are able to register with the 75 server (where mysql is installed). Please suggest the solution. Thanks Chandan
try running realtime load sip_buddies exten XXXX and see what you get... SEan On Thu, 2006-05-25 at 05:10 +0530, Chandan Mishra wrote:> Hi > i am using the asterisk server on one machine and mysql on another > machine.I have my mysql running on 192.168.77.75 and asterisk running > on the 192.168.77.77. > > when executing following cli command on asterisk server on 192.168.77.77 > > *CLI> realtime mysql status > Connected to asterisk@192.168.77.75, port 3306 with username root for > 8 minutes, 45 seconds. > > But my phones are not getting registered with the 192.168.77.77. The > phones have entry in the mysql database. > > my res_msql.conf on machine 192.168.77.77 have the following entries > [general] > dbhost=192.168.77.75 > dbname=asterisk > dbuser=root > dbpass=root > dbport=3306 > dbsock=/tmp/mysql.sock > > When the cli shows the asterisk connected then why my phones are not > able to register the 77 asterisk server. If i am running asterisk on > 75 itself then the phones are able to register with the 75 server > (where mysql is installed). > > Please suggest the solution. > > Thanks > > Chandan > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
Have you configured your extconfig.conf file? If so, do you have lines similar to this: sipusers => mysql,database_name,table_name sippeers => mysql,database_name,table_name Of course you also have to have the tables correctly setup on the MySQL server. Hope that helps.. -- VoIP Street Origination Services http://www.VoIPstreet.com ----- Original Message ----- From: "Chandan Mishra" <chandan.iitr@gmail.com> To: <asterisk-users@lists.digium.com> Sent: Wednesday, May 24, 2006 6:40 PM Subject: [Asterisk-Users] Realtime Asterisk Problem Hi i am using the asterisk server on one machine and mysql on another machine.I have my mysql running on 192.168.77.75 and asterisk running on the 192.168.77.77. when executing following cli command on asterisk server on 192.168.77.77 *CLI> realtime mysql status Connected to asterisk@192.168.77.75, port 3306 with username root for 8 minutes, 45 seconds. But my phones are not getting registered with the 192.168.77.77. The phones have entry in the mysql database. my res_msql.conf on machine 192.168.77.77 have the following entries [general] dbhost=192.168.77.75 dbname=asterisk dbuser=root dbpass=root dbport=3306 dbsock=/tmp/mysql.sock When the cli shows the asterisk connected then why my phones are not able to register the 77 asterisk server. If i am running asterisk on 75 itself then the phones are able to register with the 75 server (where mysql is installed). Please suggest the solution. Thanks Chandan _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users