Re: [SR-Users] Problem with tag field with using a custom table for the permissions module.

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