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