[SR-Users] GROUP - change database table

[Daniel W. Graham]

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 at 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 at 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

[cid:image001.gif at 01CDE51C.BD641430]





_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org<mailto:sr-users at 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://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda



--

Daniel-Constantin Mierla - http://www.asipto.com

http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20121228/882de750/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 5223 bytes
Desc: image001.gif
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20121228/882de750/attachment.gif>