[SR-Users] Configuration Help

[Alexandre Cardoso]

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 at gmail.com> wrote:
> 
> Hello Alexandre,
> 
> Replies in Line.
> 
> 
> Best Regards
> José Seabra
> 
> 2018-01-15 11:08 GMT+00:00 Alexandre Cardoso <alexandre.cardoso at byside.com <mailto: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 <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 at localhost html]# kamctl add test1 at 192.168.1.204 <mailto: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 <mailto: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 <mailto:sr-users at 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 at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <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/78bf653e/attachment.html>