[SR-Users] GROUP - change database table

[Daniel W. Graham]

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 01CDE506.B3EB9E20]




_______________________________________________

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://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20121228/e54af030/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/e54af030/attachment.gif>