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

[Jan Hazenberg]

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