<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div dir="ltr">Hello Daniel,</div><div dir="ltr"><br></div><div dir="ltr">Yes ,it works now .</div><div dir="ltr"><br></div><div dir="ltr">Thanks.</div><div dir="ltr">Hala</div><div><br></div><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Daniel-Constantin Mierla <miconda@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> hala alramli <doreme202002@yahoo.com>; SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List <sr-users@lists.sip-router.org><br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, 3 August 2011, 18:09:53<br><b><span
style="font-weight: bold;">Subject:</span></b> Re: [SR-Users] ERROR : when create database in kamailio 3.1.0<br></font><br><div id="yiv759281814">
Hello,<br>
<br>
do 'git pull origin' in your source tree of kamailio, re-install and
try again.<br>
<br>
The definition of db table for pipelimit module was added recently
in 3.1, but only as xml schema not as sql. I just generated it and
committed to git.<br>
<br>
Let me know if works fine now.<br>
<br>
Thanks,<br>
Daniel<br>
<br>
On 8/3/11 3:13 PM, hala alramli wrote:
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; ">
<div>
<div dir="ltr"><font class="yiv759281814Apple-style-span" face="'times new
roman', 'new york', times, serif">hello </font></div>
<div dir="ltr"><font class="yiv759281814Apple-style-span" face="'times new
roman', 'new york', times, serif"><br>
</font></div>
<div dir="ltr"><font class="yiv759281814Apple-style-span" face="'times new
roman', 'new york', times, serif">i a trying to instal
kamailio and free switch according to the tutorial in </font><a rel="nofollow" target="_blank" href="http://kb.asipto.com/freeswitch:kamailio-3.1.x-freeswitch-1.0.6d-sbc">http://kb.asipto.com/freeswitch:kamailio-3.1.x-freeswitch-1.0.6d-sbc</a></div>
<div dir="ltr"><br>
</div>
<div dir="ltr">but when i try to create the database and the
extra tables this error apear</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">could you help me?</div>
<div dir="ltr">thanks</div>
<div dir="ltr">Hala</div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif"><br>
</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif"><br>
</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">root@noga1:~# nano
/usr/local/etc/kamailio/kamctlrc</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">root@noga1:~#
/usr/local/sbin/kamdbctl create</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">MySQL password for root:</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">database engine 'mysql' loaded</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: test server charset</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: creating database kamailio
...</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: standard</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: acc</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: lcr</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: domain</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: group</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: permissions</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: registrar</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: usrloc</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: msilo</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: alias_db</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: uri_db</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: speeddial</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: avpops</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: auth_db</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: pdt</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: dialog</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: dispatcher</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating core table: dialplan</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: Core Kamailio tables
succesfully created.</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Install presence related tables?
(y/n): y</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: creating presence tables
into kamailio ...</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: Presence tables
succesfully created.</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Install tables for imc cpl
siptrace domainpolicy carrierroute</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif"> userblacklist htable purple
uac pipelimit? (y/n): y</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">INFO: creating extra tables into
kamailio ...</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: imc</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: cpl</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: siptrace</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table:
domainpolicy</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table:
carrierroute</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table:
userblacklist</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: htable</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: purple</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: uac</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">Creating extra table: pipelimit</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">/usr/local/lib64/kamailio//kamctl/kamdbctl.mysql:
line 225:
/usr/local/share/kamailio//mysql/pipelimit-create.sql: No
such file or directory</font></div>
<div><font class="yiv759281814Apple-style-span" face="'times new roman',
'new york', times, serif">ERROR: Creating extra tables
failed!</font></div>
<div style="font-size: 12pt; font-family: times, serif; "><br>
</div>
</div>
</div>
<br>
<fieldset class="yiv759281814mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a rel="nofollow" class="yiv759281814moz-txt-link-abbreviated" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a rel="nofollow" class="yiv759281814moz-txt-link-freetext" target="_blank" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="yiv759281814moz-signature">--
Daniel-Constantin Mierla -- <a rel="nofollow" class="yiv759281814moz-txt-link-freetext" target="_blank" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Oct 10-13, Berlin: <a rel="nofollow" class="yiv759281814moz-txt-link-freetext" target="_blank" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a>
<a rel="nofollow" class="yiv759281814moz-txt-link-freetext" target="_blank" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a rel="nofollow" class="yiv759281814moz-txt-link-freetext" target="_blank" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</div><br><br></div></div></div></body></html>