<html><head></head><body><div class="ydpa1c44146yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">Hi, </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I added two scripts </div><div dir="ltr" data-setdir="false">1- to create tables </div><div dir="ltr" data-setdir="false">2- Insert some basic data in address table</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Statement 1 executed and tables created but second .sql file not executed although it showed in logs. What shall I do to insert some basic data?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thanks.</div><div><br></div>
</div><div id="yahoo_quoted_5470913334" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, November 5, 2020, 07:03:04 PM GMT+5, me.projects@yahoo.com <me.projects@yahoo.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv6002497606"><div><div class="yiv6002497606ydpbe428d64yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div dir="ltr">Hi,</div><div dir="ltr"><br clear="none"></div><div dir="ltr">Thanks for your reply. Some times we need to provide Initial Data in some tables so I think we can use something you suggested. </div><div dir="ltr"><br clear="none"></div>
</div><div class="yiv6002497606yqt4348086070" id="yiv6002497606yqt31493"><div class="yiv6002497606yahoo_quoted" id="yiv6002497606yahoo_quoted_4772722700">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, November 5, 2020, 06:00:23 PM GMT+5, Daniel-Constantin Mierla <miconda@gmail.com> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv6002497606"><div>
<div class="yiv6002497606moz-cite-prefix">Hello,</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">if you put the sql to create the table
in share/kamailio/mysql/customtable-create.sql</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">then you can run:</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">kamdbctl add-tables customtable</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">This has to be done after the kamdbctl
create command.</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">If you plan for long term, also taking
in consideration the option to add management of customtable
records in the cli, I can recommend to look at kamcli:</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix"> * <a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-freetext" target="_blank" href="https://github.com/kamailio/kamcli">https://github.com/kamailio/kamcli</a></div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">It can also create the customtable
using:</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">kamcli db create-tables-group
customtable</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">The 'kamcli db' offers what old
'kamdbctl' and 'kamctl db ...' do.</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">But then you can just add your own
python file in 'kamcli/commands/cmd_customtable.py' to manage
records in that table (for example, you can use cmd_aliasdb.py as
a starting point).</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix">Cheers,<br clear="none">
Daniel<br clear="none">
</div>
<div class="yiv6002497606moz-cite-prefix"><br clear="none">
</div>
<div class="yiv6002497606yqt9388296344" id="yiv6002497606yqt17312"><div class="yiv6002497606moz-cite-prefix">On 05.11.20 13:40,
<a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-abbreviated" ymailto="mailto:me.projects@yahoo.com" target="_blank" href="mailto:me.projects@yahoo.com">me.projects@yahoo.com</a> wrote:<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div></div><div class="yiv6002497606yqt9388296344" id="yiv6002497606yqt58094"><div><div class="yiv6002497606yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">
<div dir="ltr">Hi,</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">I want add some custom Table
Creation during installation of Kamailio. </div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr"><span>I want to add my Custom
Table during the execution of </span></div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr"><span><b>kamdbctl create</b></span><span><br clear="none">
</span></div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr"><span>command. Currently I am
adding my script in </span></div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr"><span><b>share/kamailio/mysql/auth_db-create.sql</b></span></div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Thanks,</div>
</div>
<br clear="none">
<fieldset class="yiv6002497606mimeAttachmentHeader"></fieldset>
<pre class="yiv6002497606moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-abbreviated" ymailto="mailto:sr-users@lists.kamailio.org" target="_blank" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-freetext" target="_blank" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
<p><br clear="none">
</p>
<pre class="yiv6002497606moz-signature">--
Daniel-Constantin Mierla -- <a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-abbreviated" target="_blank" href="http://www.asipto.com">www.asipto.com</a>
<a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-abbreviated" target="_blank" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-abbreviated" target="_blank" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a rel="nofollow" shape="rect" class="yiv6002497606moz-txt-link-freetext" target="_blank" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</div></div></div></div>
</div>
</div></div></div></div></div>
</div>
</div></body></html>