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