Hi,
I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.
I’m having a problem when adding subscriber on Kamailio, it gives me an error:
From Siremis GUI: [2018-01-15 09:54:34 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list' Script name and line number of error: /var/www/html/openbiz/bin/data/BizDataObj_Lite.php:447
function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/modules/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/html/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/html/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/html/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/bin/controller.php 6 function: include ( "/var/www/html/siremis/bin/controller.php" ) @ /var/www/html/siremis/bin/_forward.php 102 function: include ( "/var/www/html/siremis/bin/_forward.php" ) @ /var/www/html/siremis/index.php 3
and via kamcli commands [root@localhost html]# kamctl add test1@192.168.1.204 test which: no gdb in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/) MySQL password for user 'kamailio@localhost': ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using password: YES) ERROR: introducing the new user 'test1@192.168.1.204' to the database failed
The password Is correct I can add Domain but not an subscriber or Location list.
How can I overcome this issue?
Also can you support on how I can do authentication on Kamailio using Asterisk database?
Thanks Alex
Hello Alexandre,
Replies in Line.
Best Regards José Seabra
2018-01-15 11:08 GMT+00:00 Alexandre Cardoso alexandre.cardoso@byside.com:
Hi,
I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.
I’m having a problem when adding subscriber on Kamailio, it gives me an error:
From Siremis GUI: [2018-01-15 09:54:34 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list' Script name and line number of error: /var/www/html/openbiz/bin/ data/BizDataObj_Lite.php:447
function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/ modules/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/html/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/html/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/html/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/bin/controller.php 6 function: include ( "/var/www/html/siremis/bin/controller.php" ) @ /var/www/html/siremis/bin/_forward.php 102 function: include ( "/var/www/html/siremis/bin/_forward.php" ) @ /var/www/html/siremis/index.php 3
By the logs, it seems that the table "location" doesn't contains all the
columns required by the sql query done by Siremis, confirm that the table was correctly installed during Siremis installation.
and via kamcli commands [root@localhost html]# kamctl add test1@192.168.1.204 test which: no gdb in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/ bin:/) MySQL password for user 'kamailio@localhost': ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using password: YES) ERROR: introducing the new user 'test1@192.168.1.204' to the database failed
The password Is correct I can add Domain but not an subscriber or Location list.
How can I overcome this issue?
It seems that you didn't have configured the kamctlrc file with database
credentials, please edit the file and configure it properly.
Also can you support on how I can do authentication on Kamailio using Asterisk database?
Do you mean using the asterisk data model instead of kamailio subscriber table?
Thanks Alex
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi José, Thanks for your answer :)
Yes it was missing configuration on kamctlrc file.
Regarding:
Do you mean using the asterisk data model instead of kamailio subscriber table?
The idea is to eliminate the register messages going forward to Asterisk but to minimize the amount of data in several databases.
Thanks Alex Cardoso
On 15 Jan 2018, at 14:08, José Seabra joseseabra4@gmail.com wrote:
Hello Alexandre,
Replies in Line.
Best Regards José Seabra
2018-01-15 11:08 GMT+00:00 Alexandre Cardoso <alexandre.cardoso@byside.com mailto:alexandre.cardoso@byside.com>: Hi,
I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.
I’m having a problem when adding subscriber on Kamailio, it gives me an error:
From Siremis GUI: [2018-01-15 09:54:34 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id http://t0.id/, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list' Script name and line number of error: /var/www/html/openbiz/bin/data/BizDataObj_Lite.php:447
function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/modules/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/html/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/html/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/html/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/bin/controller.php 6 function: include ( "/var/www/html/siremis/bin/controller.php" ) @ /var/www/html/siremis/bin/_forward.php 102 function: include ( "/var/www/html/siremis/bin/_forward.php" ) @ /var/www/html/siremis/index.php 3
By the logs, it seems that the table "location" doesn't contains all the columns required by the sql query done by Siremis, confirm that the table was correctly installed during Siremis installation.
and via kamcli commands [root@localhost html]# kamctl add test1@192.168.1.204 mailto:test1@192.168.1.204 test which: no gdb in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/) MySQL password for user 'kamailio@localhost': ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using password: YES) ERROR: introducing the new user 'test1@192.168.1.204 mailto:test1@192.168.1.204' to the database failed
The password Is correct I can add Domain but not an subscriber or Location list.
How can I overcome this issue?
It seems that you didn't have configured the kamctlrc file with database credentials, please edit the file and configure it properly.
Also can you support on how I can do authentication on Kamailio using Asterisk database?
Do you mean using the asterisk data model instead of kamailio subscriber table?
Thanks Alex
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hello Alexandre, I think that the following link can guide you on what do you need. http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb
Regards José
2018-01-15 16:03 GMT+00:00 Alexandre Cardoso alexandre.cardoso@byside.com:
Hi José, Thanks for your answer :)
Yes it was missing configuration on kamctlrc file.
Regarding:
Do you mean using the asterisk data model instead of kamailio subscriber table?
The idea is to eliminate the register messages going forward to Asterisk but to minimize the amount of data in several databases.
Thanks Alex Cardoso
On 15 Jan 2018, at 14:08, José Seabra joseseabra4@gmail.com wrote:
Hello Alexandre,
Replies in Line.
Best Regards José Seabra
2018-01-15 11:08 GMT+00:00 Alexandre Cardoso <alexandre.cardoso@byside.com
:
Hi,
I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.
I’m having a problem when adding subscriber on Kamailio, it gives me an error:
From Siremis GUI: [2018-01-15 09:54:34 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id http://t0.id/, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list' Script name and line number of error: /var/www/html/openbiz/bin/data /BizDataObj_Lite.php:447
function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/modules/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/html/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/html/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/html/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/bin/controller.php 6 function: include ( "/var/www/html/siremis/bin/controller.php" ) @ /var/www/html/siremis/bin/_forward.php 102 function: include ( "/var/www/html/siremis/bin/_forward.php" ) @ /var/www/html/siremis/index.php 3
By the logs, it seems that the table "location" doesn't contains all the
columns required by the sql query done by Siremis, confirm that the table was correctly installed during Siremis installation.
and via kamcli commands [root@localhost html]# kamctl add test1@192.168.1.204 test which: no gdb in (/usr/local/sbin:/usr/local/bi n:/usr/sbin:/usr/bin:/root/bin:/) MySQL password for user 'kamailio@localhost': ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using password: YES) ERROR: introducing the new user 'test1@192.168.1.204' to the database failed
The password Is correct I can add Domain but not an subscriber or Location list.
How can I overcome this issue?
It seems that you didn't have configured the kamctlrc file with database
credentials, please edit the file and configure it properly.
Also can you support on how I can do authentication on Kamailio using Asterisk database?
Do you mean using the asterisk data model instead of kamailio subscriber table?
Thanks Alex
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Alexandre Cardoso -
José Seabra