Ok, I corrected the values and kamailio now starts.

I also looked at the modules and I see where the check is being performed. What events cause the table version numbers to change? I don’t want to take a chance on them changing on me.

Thanks for the help!

From: Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Sent: Friday, December 28, 2012 4:30 PM
To: Daniel W. Graham
Cc: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Subject: Re: [SR-Users] GROUP - change database table

The 'same version number' has to be the value that corresponds to 'grp' table. It does not work with any kind of value.

The version per table is used as a mechanism to check that table structure is the one expected by the module.

Cheers,
Daniel

On 12/28/12 8:22 PM, Daniel W. Graham wrote:

Thanks for the reply –

I tried - modparam("auth_db", "version_table", 0) and setting subscriber and grp tables to the same version number and kamailio still doesn’t start.

I would be interested in patching the module if that fixes it, however I have never done this so I’d have to do some poking around.

Just curious, what is the purpose of the table version checks in situations like this?

From: Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Sent: Thursday, December 27, 2012 3:57 AM
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Cc: Daniel W. Graham
Subject: Re: [SR-Users] GROUP - change database table

Hello,

I guess this is an issue with database table versions, grp and subscriber have different versions (see table version).

There is an option for auth_db to skip checking the database table version. You can set that in config and then update table version for subscriber to match expected one for grp.

Alternatives:
- use a table view over subscriber
- patch group modules to skip checking the database table version

Cheers,
Daniel

On 12/20/12 9:17 PM, Daniel W. Graham wrote:

I am attempting to move the location of the GROUP ‘grp’ table.

I created column grp in subscriber table and configured column with same settings as default table and updated column name as follows:

modparam("group", "db_url", DBURL)

modparam("group", "table", "subscriber")

modparam("group", "use_domain", 1)

As the other required column names are present in the subscriber table and also default params for this module, I didn’t specify them, but I have also tried doing that with same result.

I have debugging enabled and when attempting to restart / start kamailio it simply doesn’t start and no debug errors are detected, also nothing in log file.

If I change to modparam("group", "table", "grp"), kamailio starts fine.

Any ideas out there as to what would cause this?

Thanks for your time-

-dan

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda