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, 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

_______________________________________________
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