[SR-Users] rtpproxy database structure for kamailio 4.2.3

[Jan Hazenberg]

Daniel,

Clear, i will simply add the field until we can upgrade. Thanks for the 
clarification.

Jan

Daniel-Constantin Mierla schreef op 2015-11-19 13:38:
> Hello,
> 
> it was a different value for column name in the code than in the 
> default
> rtpproxy table. The definition of the table used setid and the code
> set_name. I pushed a fix (in master, 4,3 and 4,2 branches), so the code
> is coherent with the database table.
> 
> If you don't want to upgrade to latest version in the branch, then have
> the set_name column with the same definition of setid column.
> 
> Although the type of the column is varchar, it expect to be a number --
> from the commit I assumed the developer wanted to extend to non-numeric
> set ids, but hasn't done it so far.
> 
> If you are not using set ids in the config, you can set the value for
> setid/set_name columns to "0".
> 
> You can select specific rtpproxy by grouping with a set id -- see:
> 
> http://kamailio.org/docs/modules/4.3.x/modules/rtpproxy.html#idp15531672
> 
> Cheers,
> Daniel
> 
> On 19/11/15 12:54, Jan Hazenberg wrote:
>> Hi all,
>> 
>> I'm trying to load the rtpproxy url's from database but get a error
>> when starting kamailio (4.2.3):
>> 
>> ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver
>> error on query: Unknown column 'set_name' in 'field list'
>> 
>> Looks like the field set_name is missing in the database structure,
>> but i can't find it in the docs. If i add the field kamailio starts,
>> but what is the field set_name used for. Seems it needs to be a int
>> value:
>> 
>> ERROR: rtpproxy [rtpproxy.c:528]: get_rtpp_set(): Invalid set name
>> 'test' - must be integer
>> 
>> 
>> Thanks,
>> 
>> Jan
>> 
>> 
>> 
>> 
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
>> list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users