[asterisk-users] 1.6.2.7 SIP realtime problem

[Bruce Ferrell]

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! :)