Re: [asterisk-users] 1.6.2.7 SIP realtime problem
If you become this message at start up of asterisk, then try it preload in module.conf I think it will be help. I have also became this problem on 1.6.1 version Vardan Bruce Ferrell wrote: > On 05/14/2010 04:17 PM, Tilghman Lesher wrote: >> On Friday 14 May 2010 16:09:58 Bruce Ferrell wrote: >> >>> I'm getting the following message in my full log at startup and my >>> realtime sip peers aren't being found. My realtime extensions have no >>> errors. The table sippeers exists in the database. Is this a known >>> problem? >>> >>> res_config_mysql.c: Table sippeers not found in database. This table >>> should exist if you're using realtime. >>> >> Check your [context] in res_mysql.conf. In previous versions, it was set as >> [general], but extconfig.conf had "asterisk" as the name of the connection. >> These two configuration files need to match. It's correct in the sample >> configs, but if you upgraded from a prior version, it's possible that you >> still have the bad match. >> >> > That did it. > > in res_mysql it's > > [general] > dbhost = 127.0.0.1 > dbname = asterisk > dbuser = astuser > dbpass = astpass > dbport = 3306 > dbsock = /var/run/mysql/mysql.sock > requirements=warn > > > > in extconfig the line > >sippeers => mysql,asterisk,sip_buddies > > asterisk pointed to the dbname in res_mysql, not the context. > > It still works that way in 1.4.31 > > That was fun... NOT! :) > -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] 1.6.2.7 SIP realtime problem
On 05/14/2010 04:17 PM, Tilghman Lesher wrote: > On Friday 14 May 2010 16:09:58 Bruce Ferrell wrote: > >> I'm getting the following message in my full log at startup and my >> realtime sip peers aren't being found. My realtime extensions have no >> errors. The table sippeers exists in the database. Is this a known >> problem? >> >> res_config_mysql.c: Table sippeers not found in database. This table >> should exist if you're using realtime. >> > Check your [context] in res_mysql.conf. In previous versions, it was set as > [general], but extconfig.conf had "asterisk" as the name of the connection. > These two configuration files need to match. It's correct in the sample > configs, but if you upgraded from a prior version, it's possible that you > still have the bad match. > > That did it. in res_mysql it's [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = astuser dbpass = astpass dbport = 3306 dbsock = /var/run/mysql/mysql.sock requirements=warn in extconfig the line sippeers => mysql,asterisk,sip_buddies asterisk pointed to the dbname in res_mysql, not the context. It still works that way in 1.4.31 That was fun... NOT! :) -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] 1.6.2.7 SIP realtime problem
On Friday 14 May 2010 16:09:58 Bruce Ferrell wrote: > I'm getting the following message in my full log at startup and my > realtime sip peers aren't being found. My realtime extensions have no > errors. The table sippeers exists in the database. Is this a known > problem? > > res_config_mysql.c: Table sippeers not found in database. This table > should exist if you're using realtime. Check your [context] in res_mysql.conf. In previous versions, it was set as [general], but extconfig.conf had "asterisk" as the name of the connection. These two configuration files need to match. It's correct in the sample configs, but if you upgraded from a prior version, it's possible that you still have the bad match. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] 1.6.2.7 SIP realtime problem
I'm getting the following message in my full log at startup and my realtime sip peers aren't being found. My realtime extensions have no errors. The table sippeers exists in the database. Is this a known problem? res_config_mysql.c: Table sippeers not found in database. This table should exist if you're using realtime. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users