<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
This is a strange error, considering the fact that I am guessing you
already have DB connectivity for CP.<br>
Can you paste the rule that you are trying to add ? Maybe we can
replicate the error. <br>
<br>
Regards,<br>
Alex<br>
<br>
<br>
On 02/29/2012 04:57 PM, Alexandre Keller wrote:
<blockquote
cite="mid:76FB6537-5191-4511-B012-1AFB5FABB21F@gmail.com"
type="cite">I'm sorry for bothering you again.
<div><br>
</div>
<div>I've trying to add some rule to my DialPlan through
OpenSIPs-CP, but, it keeps me showing the following error:</div>
<div><br>
</div>
<div><span class="Apple-style-span" style="font-family: Verdana,
Arial, Helvetica, sans-serif; font-size: 12px;
-webkit-border-horizontal-spacing: 5px;
-webkit-border-vertical-spacing: 5px; ">Failed to issue query,
error message : MDB2 Error: syntax error</span></div>
<div><font class="Apple-style-span" face="Verdana, Arial,
Helvetica, sans-serif"><span class="Apple-style-span"
style="font-size: 12px; -webkit-border-horizontal-spacing:
5px; -webkit-border-vertical-spacing: 5px;"><br>
</span></font></div>
<div>
<div apple-content-edited="true"><span class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0);
font-family: 'Lucida Grande'; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-align: auto;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px;
-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto; -webkit-text-stroke-width:
0px; font-size: medium; "><span class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0);
font-family: 'Lucida Grande'; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto; -webkit-text-stroke-width:
0px; font-size: medium; ">
<div style="word-wrap: break-word; -webkit-nbsp-mode:
space; -webkit-line-break: after-white-space; "><span
class="Apple-style-span" style="border-collapse:
separate; color: rgb(0, 0, 0); font-family: 'Lucida
Grande'; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-border-horizontal-spacing:
0px; -webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; font-size: medium; ">
<div style="word-wrap: break-word; -webkit-nbsp-mode:
space; -webkit-line-break: after-white-space; "><span
class="Apple-style-span" style="border-collapse:
separate; color: rgb(0, 0, 0); font-family:
'Lucida Grande'; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2;
text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; font-size: medium;
">
<div style="word-wrap: break-word;
-webkit-nbsp-mode: space; -webkit-line-break:
after-white-space; "><span
class="Apple-style-span"
style="border-collapse: separate; color:
rgb(0, 0, 0); font-family: 'Lucida Grande';
font-size: medium; font-style: normal;
font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal;
orphans: 2; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2;
word-spacing: 0px;
-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; ">
<div style="word-wrap: break-word;
-webkit-nbsp-mode: space;
-webkit-line-break: after-white-space; "><span
class="Apple-style-span"
style="border-collapse: separate; color:
rgb(0, 0, 0); font-family: 'Lucida
Grande'; font-size: medium; font-style:
normal; font-variant: normal; font-weight:
normal; letter-spacing: normal;
line-height: normal; orphans: 2;
text-indent: 0px; text-transform: none;
white-space: normal; widows: 2;
word-spacing: 0px;
-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; ">
<div style="word-wrap: break-word;
-webkit-nbsp-mode: space;
-webkit-line-break: after-white-space; "><span
class="Apple-style-span"
style="border-collapse: separate;
color: rgb(0, 0, 0); font-family:
'Lucida Grande'; font-size: medium;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal; line-height:
normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-border-horizontal-spacing:
0px; -webkit-border-vertical-spacing:
0px;
-webkit-text-decorations-in-effect:
none; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; ">
<div style="word-wrap: break-word;
-webkit-nbsp-mode: space;
-webkit-line-break:
after-white-space; "><span
class="Apple-style-span"
style="border-collapse: separate;
color: rgb(0, 0, 0); font-family:
'Lucida Grande'; font-size:
medium; font-style: normal;
font-variant: normal; font-weight:
normal; letter-spacing: normal;
line-height: normal; orphans: 2;
text-indent: 0px; text-transform:
none; white-space: normal; widows:
2; word-spacing: 0px;
-webkit-border-horizontal-spacing:
0px;
-webkit-border-vertical-spacing:
0px;
-webkit-text-decorations-in-effect:
none; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width:
0px; ">
<div style="word-wrap: break-word;
-webkit-nbsp-mode: space;
-webkit-line-break:
after-white-space; "><span
class="Apple-style-span"
style="border-collapse:
separate; color: rgb(0, 0, 0);
font-family: 'Lucida Grande';
font-size: medium; font-style:
normal; font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal; orphans:
2; text-indent: 0px;
text-transform: none;
white-space: normal; widows:
2; word-spacing: 0px;
-webkit-border-horizontal-spacing:
0px;
-webkit-border-vertical-spacing:
0px;
-webkit-text-decorations-in-effect:
none;
-webkit-text-size-adjust:
auto;
-webkit-text-stroke-width:
0px; ">
<div style="word-wrap:
break-word;
-webkit-nbsp-mode: space;
-webkit-line-break:
after-white-space; "><span
class="Apple-style-span"
style="border-collapse:
separate; color: rgb(0, 0,
0); font-family:
Helvetica; font-size:
12px; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
orphans: 2; text-indent:
0px; text-transform: none;
white-space: normal;
widows: 2; word-spacing:
0px;
-webkit-border-horizontal-spacing:
0px;
-webkit-border-vertical-spacing:
0px;
-webkit-text-decorations-in-effect:
none;
-webkit-text-size-adjust:
auto;
-webkit-text-stroke-width:
0px; ">
<div style="word-wrap:
break-word;
-webkit-nbsp-mode:
space;
-webkit-line-break:
after-white-space; ">
<div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
13px; ">Any
ideas?</span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
13px; "><br>
</span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
13px; ">Thanks
again in
advance.</span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
13px; "><br>
</span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
13px; ">-- <br>
Atenciosamente,<br>
<br>
ALEXANDRE KELLER</span></font></div>
<div><br>
</div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
11px; "><a
moz-do-not-send="true"
href="http://twitter.com/alexandrekeller">http://twitter.com/alexandrekeller</a></span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
11px; "><a
moz-do-not-send="true"
href="http://www.facebook.com/alexandre.keller.BR">http://www.facebook.com/alexandre.keller.BR</a></span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span"
style="font-size:
11px; "><br>
</span><span
class="Apple-style-span"
style="font-size:
11px; ">"Dinheiro
é a consequência
de um trabalho
bem feito </span><span
class="Apple-style-span" style="font-size: 11px; ">e não o motivo para
se fazer um bom
trabalho."</span></font></div>
<div><font
class="Apple-style-span"
color="#008000"
face="Webdings"
size="7"><span
class="Apple-style-span"
style="font-size:
32px; "><b><font
class="Apple-style-span" color="#000000" face="Helvetica" size="3"><span
class="Apple-style-span" style="font-size: 12px; font-weight: normal; "><br>
</span></font></b></span></font></div>
</div>
<div><font
class="Apple-style-span"
color="#008000"
face="Webdings"
size="7"><span
class="Apple-style-span"
style="font-size:
32px; "><b><font
class="Apple-style-span"
color="#000000" face="Helvetica" size="3"><span class="Apple-style-span"
style="font-size:
12px;
font-weight:
normal; "><span
class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size:
22px; color:
rgb(0, 182,
151); "><b>P<font
class="Apple-style-span" size="3"><span class="Apple-style-span"
style="font-size:
11px; "> Antes
de imprimir
pense em seu
compromisso
com
o Meio Ambiente.</span></font></b></span></span></font></b></span></font></div>
</div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></span>
</div>
<br>
<div>
<div>On 29/02/2012, at 09:43, Vlad Paiu wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div bgcolor="#ffffff" text="#000000"> Hello,<br>
<br>
In your OpenSIPS script, do you have the dialog, dialplan,
dispatcher, domain or drouting modules loaded ?<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a> </pre>
<br>
On 02/29/2012 02:21 PM, Alexandre Keller wrote:
<blockquote
cite="mid:DED9190D-326D-420F-AE61-FDAD45F002DC@gmail.com"
type="cite">Hi there.
<div><br>
</div>
<div>I've just installed OpenSIPs + OpenSIP-CP, but
everytime I try to "Apply Changes to Server" or
"Refresh Dialog List", I get the following messages.</div>
<div><br>
</div>
<div>
<div>Feb 28 16:27:46 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command dlg_list is
not available</div>
<div>Feb 28 16:27:51 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command dp_reload is
not available</div>
<div>Feb 28 16:27:54 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command ds_list is not
available</div>
<div>Feb 28 16:27:55 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command ds_reload is
not available</div>
<div>Feb 28 16:28:00 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command domain_reload
is not available</div>
<div>Feb 28 16:28:05 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command dr_reload is
not available</div>
<div>Feb 28 16:28:13 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command lb_reload is
not available</div>
<div>Feb 28 16:28:25 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command nh_reload_rtpp
is not available</div>
<div>Feb 28 16:28:27 vm-opensips
/usr/sbin/opensips[5079]:
ERROR:mi_fifo:mi_fifo_server: command sip_trace is
not available</div>
</div>
<div><br>
</div>
<div>Any help is welcome.</div>
<div><br>
</div>
<div apple-content-edited="true"> <span
class="Apple-style-span" style="border-collapse:
separate; font-family: 'Lucida Grande'; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal;
orphans: 2; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
font-size: medium; "><span class="Apple-style-span"
style="border-collapse: separate; font-family:
'Lucida Grande'; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2;
text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
font-size: medium; ">
<div style="word-wrap: break-word;"><span
class="Apple-style-span"
style="border-collapse: separate; font-style:
normal; font-variant: normal; font-weight:
normal; letter-spacing: normal; line-height:
normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; font-size:
medium; ">
<div style="word-wrap: break-word;"><span
class="Apple-style-span"
style="border-collapse: separate;
font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2;
text-indent: 0px; text-transform: none;
white-space: normal; widows: 2;
word-spacing: 0px; font-size: medium; ">
<div style="word-wrap: break-word;"><span
class="Apple-style-span"
style="border-collapse: separate;
font-family: 'Lucida Grande';
font-size: medium; font-style: normal;
font-variant: normal; font-weight:
normal; letter-spacing: normal;
line-height: normal; orphans: 2;
text-indent: 0px; text-transform:
none; white-space: normal; widows: 2;
word-spacing: 0px; ">
<div style="word-wrap: break-word;"><span
class="Apple-style-span"
style="border-collapse: separate;
font-family: 'Lucida Grande';
font-size: medium; font-style:
normal; font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal; orphans: 2;
text-indent: 0px; text-transform:
none; white-space: normal; widows:
2; word-spacing: 0px; ">
<div style="word-wrap:
break-word;"><span
class="Apple-style-span"
style="border-collapse:
separate; font-size: medium;
font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal; orphans:
2; text-indent: 0px;
text-transform: none;
white-space: normal; widows:
2; word-spacing: 0px; ">
<div style="word-wrap:
break-word;"><span
class="Apple-style-span"
style="border-collapse:
separate; font-family:
'Lucida Grande';
font-size: medium;
font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
orphans: 2; text-indent:
0px; text-transform: none;
white-space: normal;
widows: 2; word-spacing:
0px; ">
<div style="word-wrap:
break-word;"><span
class="Apple-style-span"
style="border-collapse:
separate; font-family:
'Lucida Grande';
font-size: medium;
font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing:
normal; line-height:
normal; orphans: 2;
text-indent: 0px;
text-transform: none;
white-space: normal;
widows: 2;
word-spacing: 0px; ">
<div style="word-wrap:
break-word;"><span
class="Apple-style-span"
style="border-collapse:
separate;
font-family:
Helvetica;
font-size: 12px;
font-style:
normal;
font-variant:
normal;
font-weight:
normal;
letter-spacing:
normal;
line-height:
normal; orphans:
2; text-indent:
0px;
text-transform:
none; white-space:
normal; widows: 2;
word-spacing: 0px;
">
<div
style="word-wrap:
break-word;">
<div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span" style="font-size: 13px;">-- <br>
Atenciosamente,<br>
<br>
ALEXANDRE
KELLER</span></font></div>
<div><br>
</div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span" style="font-size: 11px;"><a
moz-do-not-send="true"
href="http://twitter.com/alexandrekeller">http://twitter.com/alexandrekeller</a></span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span" style="font-size: 11px;"><a
moz-do-not-send="true"
href="http://www.facebook.com/alexandre.keller.BR">http://www.facebook.com/alexandre.keller.BR</a></span></font></div>
<div><font
class="Apple-style-span"
size="3"><span
class="Apple-style-span" style="font-size: 11px;"><br>
</span><span
class="Apple-style-span"
style="font-size:
11px;">"Dinheiro
é a
consequência
de um trabalho
bem feito </span><span
class="Apple-style-span" style="font-size: 11px;">e não o motivo para se
fazer um bom
trabalho."</span></font></div>
<div><font
class="Apple-style-span"
color="#008000" face="Webdings" size="7"><span class="Apple-style-span"
style="font-size:
32px;"><b><font
class="Apple-style-span" face="Helvetica" size="3"><span
class="Apple-style-span"
style="font-size:
12px;
font-weight:
normal;"><br>
</span></font></b></span></font></div>
</div>
<div><font
class="Apple-style-span"
color="#008000" face="Webdings" size="7"><span class="Apple-style-span"
style="font-size:
32px;"><b><font
class="Apple-style-span" face="Helvetica" size="3"><span
class="Apple-style-span"
style="font-size:
12px;
font-weight:
normal;"><span
class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size:
22px; color:
rgb(0, 182,
151);"><b>P<font
class="Apple-style-span" size="3"><span class="Apple-style-span"
style="font-size:
11px;"> Antes
de imprimir
pense em seu
compromisso
com
o Meio Ambiente.</span></font></b></span></span></font></b></span></font></div>
</div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></div>
</span></span> </div>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>