Sunday, January 25, 2009

Invalid database specified

If you've upgraded Asterisk to the most recent version (1.6.0.5) and you're suddenly receiving the "MySQL RealTime: Invalid database specified: asterisk" error, it's because the configuration file parser was tweaked. Where previously, an entry in /etc/asterisk/extconfig.conf of "extensions => mysql,asterisk,extensions_table" would indicate "use the extensions_table table in the asterisk database on MySQL", the second field now denotes the context in /etc/asterisk/res_mysql.conf.

In other words, if you've used the default "[general]" context in res_mysql.conf, your line in /etc/asterisk/extconfig.conf should look like "extensions => mysql,general,extensions_table".