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
