[OpenSER-Users] Version table

[Henning Westerholt]

On Wednesday 07 May 2008, Bård Aase wrote:
> I am trying to switch from SER to OpenSER, and I'm using mysql for
> data storage. Asterisk's sip_buddies table is supposed to contain
> authentication data.
> The configuration is set up, the openser database is appearantly set
> up and working, but when I try to authenticate against
> asterisk.sip_buddies i get the following errors:
>
> May  6 12:36:58 [25672] ERROR:auth_db:auth_fixup: invalid table
> version (use openser_mysql.sh reinstall)
> [..]
>
> The version tables in asterisk and openser is as follows:
> SELECT * FROM asterisk.`version`
> 5
> SELECT * FROM openser.`version`
> 6
>
> What is the differences between database version 5 and 6?
>
> Since the asterisk database is shared between multiple asterisks and
> SER instances, its not trivial to upgrade the tables if that would
> have implications on asterisk and/or ser

Hi Bård,

OpenSER checks on startup during the fixup process of the config script that 
the table version is correct. This version data is read from the 
openser.version table. The auth_db module uses normally the 'subscriber' 
table, thus its expect the table version entry under the same name.

from trunk: select table_version from version where table_name='subscriber';
-> 6

If the asterisk.sip_buddies table has the correct format (compare against a 
fresh DB setup with your OpenSER version), then it should be sufficient to 
add a entry with the correct version number (check in auth_db 
source, 'VERSION') in the version table, or just remove the check from the 
source code. To get the differences you could also just setup a fresh 
installation of the DB, and use the usual tools to show the table format. For 
more information you should provide the OpenSER version you use, and the 
table format of the table you authenticate against.

Cheers,

Henning