[SR-Users] rtpproxy database structure for kamailio 4.2.3

[Daniel-Constantin Mierla]

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

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - http://asipto.com/kat