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

[Jan Hazenberg]

Daniel,

Thanks, i will try to configure that table as well.

Jan

Daniel-Constantin Mierla schreef op 2015-01-09 15:25:
> 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 at 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 at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users