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.card...@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 <joseseab...@gmail.com> wrote: > > Hello Alexandre, > > Replies in Line. > > > Best Regards > José Seabra > > 2018-01-15 11:08 GMT+00:00 Alexandre Cardoso <alexandre.card...@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@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@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 > > -- Cumprimentos José Seabra
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users