[SR-Users] Configuration Help

[José Seabra]

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 at 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 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
> >:
>
>> 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 test
>> which: no gdb in (/usr/local/sbin:/usr/local/bi
>> n:/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
>>
>>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>


-- 
Cumprimentos
José Seabra
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180115/fcbf1d1f/attachment.html>