Hello, what operating system are you using? How did you install kamailio, from sources or packages? Is lcr module used as well? Cheers, Daniel On 06/01/15 21:53, Jan Hazenberg wrote: > Hi, > > I'm trying to use a custom table for the permissions module and run > into a issue with the tag field, all other fields seem to work fine. > > Here is my config: > > modparam("permissions", "db_url", DBURL) > modparam("permissions", "db_mode", 1) > modparam("permissions", "peer_tag_avp", "$avp(permissions_tag)") > modparam("permissions", "trusted_table", "trunks") > modparam("permissions", "source_col", "ip") > modparam("permissions", "proto_col", "transport") > modparam("permissions", "from_col", "from_pattern") > modparam("permissions", "tag_col", "trunk_uuid") > > When i start kamailio i see the following error in the log: > > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: db_mysql > [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: > Unknown column 'trunk_uuid' in 'field list' > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: <core> > [db_query.c:132]: db_do_query_internal(): error while submitting query > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: permissions > [address.c:112]: reload_address_table(): failed to query database > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: CRITICAL: permissions > [address.c:363]: init_addresses(): reload of address table failed > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: permissions > [permissions.c:631]: mod_init(): failed to initialize the > allow_address function > Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: <core> > [sr_module.c:968]: init_mod(): Error while initializing module > permissions > (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so) > Jan 6 21:49:58 sip kamailio: ERROR: <core> [daemonize.c:315]: > daemonize(): Main process exited before writing to pipe > > > If i change the tag_col to tag it works fine, both fields are > varchar(64). And the field trunk_uuid exists in the trunks table. > > I'm running kamailio 4.2.1 > > Thanks, > > Jan Hazenberg > > _______________________________________________ > 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

Looking closer at the log messages, the error is when loading the 'address' table. Apparently the tag column name parameter is shared between address and trusted tables. Cheers, Daniel On 07/01/15 19:27, Jan Hazenberg wrote: > Daniel, > > No i do not use the lcr module. It is kamailio 4.2.1 running on ubuntu > server Ubuntu 14.04.1 LTS > > Packages are installed from from the http://deb.kamailio.org/kamailio > repository > > Jan > > Daniel-Constantin Mierla schreef op 2015-01-07 00:29: >> Hello, >> >> what operating system are you using? How did you install kamailio, >> from >> sources or packages? >> >> Is lcr module used as well? >> >> Cheers, >> Daniel >> >> On 06/01/15 21:53, Jan Hazenberg wrote: >>> Hi, >>> >>> I'm trying to use a custom table for the permissions module and run >>> into a issue with the tag field, all other fields seem to work fine. >>> >>> Here is my config: >>> >>> modparam("permissions", "db_url", DBURL) >>> modparam("permissions", "db_mode", 1) >>> modparam("permissions", "peer_tag_avp", "$avp(permissions_tag)") >>> modparam("permissions", "trusted_table", "trunks") >>> modparam("permissions", "source_col", "ip") >>> modparam("permissions", "proto_col", "transport") >>> modparam("permissions", "from_col", "from_pattern") >>> modparam("permissions", "tag_col", "trunk_uuid") >>> >>> When i start kamailio i see the following error in the log: >>> >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: db_mysql >>> [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: >>> Unknown column 'trunk_uuid' in 'field list' >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: <core> >>> [db_query.c:132]: db_do_query_internal(): error while submitting >>> query >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: permissions >>> [address.c:112]: reload_address_table(): failed to query database >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: CRITICAL: permissions >>> [address.c:363]: init_addresses(): reload of address table failed >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: permissions >>> [permissions.c:631]: mod_init(): failed to initialize the >>> allow_address function >>> Jan 6 21:49:57 sip /usr/sbin/kamailio[24327]: ERROR: <core> >>> [sr_module.c:968]: init_mod(): Error while initializing module >>> permissions >>> (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so) >>> Jan 6 21:49:58 sip kamailio: ERROR: <core> [daemonize.c:315]: >>> daemonize(): Main process exited before writing to pipe >>> >>> >>> If i change the tag_col to tag it works fine, both fields are >>> varchar(64). And the field trunk_uuid exists in the trunks table. >>> >>> I'm running kamailio 4.2.1 >>> >>> Thanks, >>> >>> Jan Hazenberg >>> >>> _______________________________________________ >>> 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 > > _______________________________________________ > 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