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