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