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, 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/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@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
