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
--
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