I have configured asterisk to take its dialplan and sippeers and sip users from a mysql backend in realtime - configured using extconfig using sippeers => mysql,asterisk,sip etc
I want to have it so that the sip configuation and dialplan is downloaded to the asterisk server, ie the information is stored locally, until a reload is done and any changes made in the mysql data will be refreshed to the asterisk box. I have been reading this article, but can find little else out there on this, which is any real use.
1.The article talks about a STATIC function, cannot find this in the source code at all, and have been through everything I know to look for it.
- the configuation in extconfig is sip.conf => mysql, asterisk, sip
[Jul 13 14:01:51] WARNING: res_config_mysql.c:412 config_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
[Jul 13 14:01:51] NOTICE: chan_sip.c:16361 reload_config: Unable to load config sip.conf
this is the output I get, but do not know where to check debug for more info.
Does anyone have a working configuation of this “static realtime” configuation that can give me some advice?