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