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
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
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
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
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
-
Daniel-Constantin Mierla -
Jan Hazenberg