<div dir="ltr"><div><div><div>Hello Alexandre,<br></div>I think that the following link can guide you on what do you need.<br><a href="http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb">http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb</a><br><br></div>Regards<br></div>José <br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-01-15 16:03 GMT+00:00 Alexandre Cardoso <span dir="ltr"><<a href="mailto:alexandre.cardoso@byside.com" target="_blank">alexandre.cardoso@byside.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space">Hi José, Thanks for your answer :)<div><br></div><div>Yes it was missing configuration on kamctlrc file.</div><div><br></div><div>Regarding:</div><div><span class=""><blockquote type="cite"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"><span 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><br></div></span>The idea is to eliminate the register messages going forward to Asterisk but to minimize the amount of data in several databases.</div><div><br></div><div>Thanks</div><div>Alex Cardoso<div><div class="h5"><br><div><br><blockquote type="cite"><div>On 15 Jan 2018, at 14:08, José Seabra <<a href="mailto:joseseabra4@gmail.com" target="_blank">joseseabra4@gmail.com</a>> wrote:</div><br class="m_5536017920106048566Apple-interchange-newline"><div><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"><div><span style="text-align:justify;background-color:rgb(255,255,255)"></span>Hello Alexandre,<br></div><br>Replies in Line.<br><div><div><span style="text-align:justify;background-color:rgb(255,255,255)"></span><div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"><br></font></span></div><br><div>Best Regards<br></div><div>José Seabra<br></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-01-15 11:08 GMT+00:00 Alexandre Cardoso<span class="m_5536017920106048566Apple-converted-space"> </span><span dir="ltr"><<a href="mailto:alexandre.cardoso@byside.com" target="_blank">alexandre.cardoso@<wbr>byside.com</a>></span>:<br><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"><div dir="auto" style="word-wrap:break-word">Hi,<div><br></div><div>I’m new in Kamailio and Asterisk world (only 1 week), I’ve installed Kamailio for the 1st time with Siremis GUI.</div><div><br></div><div>I’m having a problem when adding subscriber on Kamailio, it gives me an error:</div><div><br></div><div><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">From Siremis GUI:</span></div><div><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">[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"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">Error message: #0, Error in query:: SELECT<span class="m_5536017920106048566Apple-converted-space"> </span><a href="http://t0.id/" target="_blank">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"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">Script name and line number of error: /var/www/html/openbiz/bin/data<wbr>/BizDataObj_Lite.php:447</span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: _run_search ( Array(2) ) @ /var/www/html/openbiz/bin/data<wbr>/BizDataObj_Lite.php 243 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: fetch ( ) @ /var/www/html/openbiz/bin/easy<wbr>/EasyForm.php 690 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: fetchDataSet ( ) @ /var/www/html/openbiz/bin/easy<wbr>/FormRenderer.php 69 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/modules<wbr>/ser/template/grid.tpl" ) @ /var/www/html/openbiz/bin/easy<wbr>/FormRenderer.php 45 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: render ( Object(EasyForm) ) @ /var/www/html/openbiz/bin/easy<wbr>/EasyForm.php 1648 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: renderHTML ( ) @ /var/www/html/openbiz/bin/easy<wbr>/EasyForm.php 1538 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: render ( ) @ /var/www/html/openbiz/bin/easy<wbr>/ViewRenderer.php 83 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/modules<wbr>/ser/template/view_tabs.tpl" ) @ /var/www/html/openbiz/bin/easy<wbr>/ViewRenderer.php 40 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: render ( Object(EasyView) ) @ /var/www/html/openbiz/bin/easy<wbr>/EasyView.php 274 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: _render ( ) @ /var/www/html/openbiz/bin/easy<wbr>/EasyView.php 237 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: render ( ) @ /var/www/html/openbiz/bin/BizC<wbr>ontroller.php 221 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/openbiz/bin/BizC<wbr>ontroller.php 107 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: dispatchRequest ( ) @ /var/www/html/openbiz/bin/BizC<wbr>ontroller.php 32 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: include_once ( "/var/www/html/openbiz/bin/Biz<wbr>Controller.php" ) @ /var/www/html/siremis/bin/cont<wbr>roller.php 6 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: include ( "/var/www/html/siremis/bin/con<wbr>troller.php" ) @ /var/www/html/siremis/bin/_for<wbr>ward.php 102 </span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">function: include ( "/var/www/html/siremis/bin/_fo<wbr>rward.php" ) @ /var/www/html/siremis/<a href="http://index.ph">index.ph</a><wbr>p 3</span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"></div></div></div></blockquote><div><span style="background-color:rgb(255,255,0)">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></div><div> </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"><div dir="auto" style="word-wrap:break-word"><div><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">and via kamcli commands</span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">[root@localhost html]# kamctl add<span class="m_5536017920106048566Apple-converted-space"> </span><a href="mailto:test1@192.168.1.204" target="_blank">test1@192.168.1.204</a><span class="m_5536017920106048566Apple-converted-space"> </span>test</span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">which: no gdb in (/usr/local/sbin:/usr/local/bi<wbr>n:/usr/sbin:/usr/bin:/root/bin<wbr>:/)</span><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">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"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">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"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">ERROR: introducing the new user '<a href="mailto:test1@192.168.1.204" target="_blank">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"><br style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify"><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)">The password Is correct I can add Domain but not an subscriber or Location list.</span></div><div><span style="color:rgb(34,34,34);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;text-align:justify;background-color:rgb(255,255,255)"><br></span></div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222">How can I overcome this issue?</font></span></div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"><br></font></span></div></div></div></blockquote><div><span style="background-color:rgb(255,255,0)"> It seems that you didn't have configured the kamctlrc file with database credentials, please edit the file and configure it properly.</span><br> <br></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"><div dir="auto" style="word-wrap:break-word"><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"></font></span></div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222">Also can you support on how I can do authentication on Kamailio using Asterisk database?</font></span></div></div></div></blockquote><div><br><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"><span style="background-color:rgb(255,255,0)">Do you mean using the asterisk data model instead of kamailio subscriber table?</span><br></font></span></div><div> </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"><div dir="auto" style="word-wrap:break-word"><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222"></font></span></div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222">Thanks</font></span></div><div><span style="text-align:justify;background-color:rgb(255,255,255)"><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" color="#222222">Alex</font></span></div></div></div><br>______________________________<wbr>_________________<br>Kamailio (SER) - Users Mailing List<br><a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><br><br></blockquote></div><br></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;float:none;display:inline!important">______________________________<wbr>_________________</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"><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;float:none;display:inline!important">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"><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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">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"><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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a></div></blockquote></div><br></div></div></div></div><br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Cumprimentos<div>José Seabra</div></div>
</div>