<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.</div><div class=""><br class=""></div><div class="">I’m having a problem when adding subscriber on Kamailio, it gives me an error:</div><div class=""><br class=""></div><div class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">From Siremis GUI:</span></div><div class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">[2018-01-15 09:54:34 (GMT)] An exception occurred while executing this script:</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">Error message: #0, Error in query:: SELECT <a href="http://T0.id" class="">T0.id</a>, 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'</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">Script name and line number of error: /var/www/html/openbiz/bin/data/BizDataObj_Lite.php:447</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data/BizDataObj_Lite.php 243 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: fetch ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 690 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 69 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy/FormRenderer.php 45 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1648 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy/EasyForm.php 1538 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: render ( ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 83 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/modules/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy/ViewRenderer.php 40 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy/EasyView.php 274 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: _render ( ) @ /var/www/html/openbiz/bin/easy/EasyView.php 237 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: render ( ) @ /var/www/html/openbiz/bin/BizController.php 221 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizController.php 107 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizController.php 32 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: include_once ( "/var/www/html/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/bin/controller.php 6 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: include ( "/var/www/html/siremis/bin/controller.php" ) @ /var/www/html/siremis/bin/_forward.php 102 </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">function: include ( "/var/www/html/siremis/bin/_forward.php" ) @ /var/www/html/siremis/index.php 3</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">and via kamcli commands</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">[root@localhost html]# kamctl add <a href="mailto:test1@192.168.1.204" class="">test1@192.168.1.204</a> test</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">which: no gdb in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/)</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">MySQL password for user 'kamailio@localhost': </span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">ERROR 1045 (28000): Access denied for user 'kamailio'@'localhost' (using password: YES)</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">ERROR: introducing the new user '<a href="mailto:test1@192.168.1.204" class="">test1@192.168.1.204</a>' to the database failed</span><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><br style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify;" class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class="">The password Is correct I can add Domain but not an subscriber or Location list.</span></div><div class=""><span style="color: rgb(34, 34, 34); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: justify; background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class="">How can I overcome this issue?</font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class=""><br class=""></font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class="">Also can you support on how I can do authentication on Kamailio using Asterisk database?</font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class=""><br class=""></font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class="">Thanks</font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font color="#222222" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" class="">Alex</font></span></div></div></body></html>