[SR-Users] Configuration Help

[José Seabra]

Hello Alexandre,

Replies in Line.


Best Regards
José Seabra

2018-01-15 11:08 GMT+00:00 Alexandre Cardoso <alexandre.cardoso at 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 at localhost html]# kamctl add test1 at 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 at localhost':
> ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using
> password: YES)
> ERROR: introducing the new user 'test1 at 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 at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180115/99e5debb/attachment.html>