<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="">Hi José, Thanks for your answer :)<div class=""><br class=""></div><div class="">Yes it was missing configuration on kamctlrc file.</div><div class=""><br class=""></div><div class="">Regarding:</div><div class=""><blockquote type="cite" class=""><div dir="ltr" class=""><div class="gmail_extra"><div class="gmail_quote"><div class=""><span class="" style="text-align: justify; background-color: rgb(255, 255, 255);"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""><span class="" style="background-color: rgb(255, 255, 0);">Do you mean using the asterisk data model instead of kamailio subscriber table?</span></font></span></div></div></div></div></blockquote><div class=""><br class=""></div>The idea is to eliminate the register messages going forward to Asterisk but to minimize the amount of data in several databases.</div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Alex Cardoso<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 15 Jan 2018, at 14:08, José Seabra <<a href="mailto:joseseabra4@gmail.com" class="">joseseabra4@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""></span>Hello Alexandre,<br class=""></div><br class="">Replies in Line.<br class=""><div class=""><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""></span><div class=""><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""><br class=""></font></span></div><br class=""><div class="">Best Regards<br class=""></div><div class="">José Seabra<br class=""></div></div></div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">2018-01-15 11:08 GMT+00:00 Alexandre Cardoso<span class="Apple-converted-space"> </span><span dir="ltr" class=""><<a href="mailto:alexandre.cardoso@byside.com" target="_blank" class="">alexandre.cardoso@byside.com</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div dir="auto" style="word-wrap: break-word;" 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<span class="Apple-converted-space"> </span><a href="http://t0.id/" target="_blank" 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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">modules/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">modules/ser/template/view_<wbr class="">tabs.tpl" ) @ /var/www/html/openbiz/bin/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">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/<wbr class="">BizController.php" ) @ /var/www/html/siremis/bin/<wbr class="">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/<wbr class="">controller.php" ) @ /var/www/html/siremis/bin/_<wbr class="">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/_<wbr class="">forward.php" ) @ /var/www/html/siremis/index.<wbr class="">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=""></div></div></div></blockquote><div class=""><span style="background-color: rgb(255, 255, 0);" class="">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.</span><br class=""></div><div class=""> </div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div dir="auto" style="word-wrap: break-word;" class=""><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="">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<span class="Apple-converted-space"> </span><a href="mailto:test1@192.168.1.204" target="_blank" class="">test1@192.168.1.204</a><span class="Apple-converted-space"> </span>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/<wbr class="">bin:/usr/sbin:/usr/bin:/root/<wbr class="">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" target="_blank" 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 face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" 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 face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""><br class=""></font></span></div></div></div></blockquote><div class=""><span style="background-color: rgb(255, 255, 0);" class=""> It seems that you didn't have configured the kamctlrc file with database credentials, please edit the file and configure it properly.</span><br class=""> <br class=""></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div dir="auto" style="word-wrap: break-word;" class=""><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""></font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class="">Also can you support on how I can do authentication on Kamailio using Asterisk database?</font></span></div></div></div></blockquote><div class=""><br class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""><span style="background-color: rgb(255, 255, 0);" class="">Do you mean using the asterisk data model instead of kamailio subscriber table?</span><br class=""></font></span></div><div class=""> </div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div dir="auto" style="word-wrap: break-word;" class=""><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class=""></font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class="">Thanks</font></span></div><div class=""><span style="text-align: justify; background-color: rgb(255, 255, 255);" class=""><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222" class="">Alex</font></span></div></div></div><br class="">______________________________<wbr class="">_________________<br class="">Kamailio (SER) - Users Mailing List<br class=""><a href="mailto:sr-users@lists.kamailio.org" class="">sr-users@lists.kamailio.org</a><br class=""><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank" class="">https://lists.kamailio.org/<wbr class="">cgi-bin/mailman/listinfo/sr-<wbr class="">users</a><br class=""><br class=""></blockquote></div><br class=""></div></div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Kamailio (SER) - Users Mailing List</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="mailto:sr-users@lists.kamailio.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">sr-users@lists.kamailio.org</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></div></blockquote></div><br class=""></div></body></html>