[SR-Users] GROUP - change database table

[Daniel-Constantin Mierla]

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
>
>     Description: dan-sig2
>
>
>
>
>     _______________________________________________
>
>     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/6ca308b2/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 5223 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20121228/6ca308b2/attachment-0001.gif>