RESOLVED: MySQL RealTime: Invalid database specified:

Having upgraded a test install to 1.6.2 from 1.4.x I’m having an issue with errors loading sip peers in realtime.

I get lots of error messages saying database not found. I’ve read a number of posts saying read the upgrade and sample files as the format of this file has changed. However, the latest version of 1.6.2. has these files as being 2 years old :cry:

Can anyone give me a clue as to where I can find out what needs to be changed? (also heard extconfig.conf has changed as well)

It’s not clear about the change, and too many others have asked the same question anyway.

In Extconf.conf, the old way of writting an entry was

sipusers => mysql,mydbatabase,sip_table_name

and in res_mysql.conf, you had a [General] section and all of your db details

What’s changed is that mydatabase in extconf is actualy the SECTION in the res_mysql file. So in order for this to work with the original format of that file, you would need to change extconf to the following

sippeers => mysql,general,sip_table_name

My guess is that the reason for the change is that you can now read from one host and write to another.

In short, the second parameter in a extconf entry must have a corresponding section in res_mysql

sippeers => mysql,SECTION,sip_table_name
…^^^

Must have a matching [SECTION] in res_config_mysql

Regards