Hi José, Thanks for your answer :) Yes it was missing configuration on kamctlrc file. Regarding: 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 &lt;joseseabra4(a)gmail.com&gt; wrote: > > Hello Alexandre, > > Replies in Line. > > > Best Regards > José Seabra > > 2018-01-15 11:08 GMT+00:00 Alexandre Cardoso &lt;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 &#39;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? > > > 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>