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
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
