Re: [SR-Users] rtpproxy database structure for kamailio 4.2.3

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(a)lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users