<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Sven,<br>
<br>
I think I have a clue about your problem.<br>
In the code we call mysql_real_escape string like this : <font
color="#ff0000">"mysql_real_escape_string($match_exp,$link)"</font>
... you get the following error (on our test platform it runs free of
warnings) : <br>
<font color="#ff0000" face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">PHP Warning: mysql_real_escape_string()
expects parameter 2 to be resource</span></font><br>
<br>
If you check this <a
href="http://php.net/manual/en/function.mysql-real-escape-string.php">http://php.net/manual/en/function.mysql-real-escape-string.php</a>
you will see that the warning message that you are getting is caused by
the lack of connection to the db. As it is said in the php online
manual :<br>
<br>
<font color="#ff0000">If the
link identifier is not specified, the last link opened by
<span class="function"><a
href="http://www.php.net/manual/en/function.mysql-connect.php"
class="function">mysql_connect()</a></span> is assumed. If no such
link is found, it
will try to create one as if <span class="function"><a
href="http://www.php.net/manual/en/function.mysql-connect.php"
class="function">mysql_connect()</a></span> was called
with no arguments. If no connection is found or established, an
<b><tt>E_WARNING</tt></b> level error is generated. <br>
<br>
</font>So, my guess is that there is something wrong with your db
connection, since on our platform works ... <br>
You could try to see if the rest of the modules run error free and let
me know, maybe we can narrow down the possible causes of this issue.<br>
<br>
Regards,<br>
Alex<br>
<br>
<br>
On 6/11/2010 21:07, Sven Schulz wrote:
<blockquote cite="mid:C837F3AC.1C3EE%25svens@psu.edu" type="cite">
<title>Re: [OpenSIPS-Users] Opensips-cp Dialplan Problem</title>
<font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">Alex,<br>
<br>
I just took the latest from svn trunk and still getting the same
results.<br>
I did see these php warnings in the log, not sure igf its helpful or
not:<br>
<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: dpid in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 91<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: pr in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 97<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: match_exp in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 109<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: match_len in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 115<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: subst_exp in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 121<br>
[11-Jun-2010 14:00:39] PHP Notice: Undefined variable: repl_exp in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.add.php
on line 127<br>
[11-Jun-2010 14:00:57] PHP Warning: mysql_real_escape_string() expects
parameter 2 to be resource, object given in
/var/www/opensips-cp/web/tools/system/dialplan/dialplan.php on line 119<br>
[11-Jun-2010 14:00:57] PHP Warning: mysql_real_escape_string() expects
parameter 2 to be resource, object given in
/var/www/opensips-cp/web/tools/system/dialplan/dialplan.php on line 139<br>
[11-Jun-2010 14:00:57] PHP Warning: mysql_real_escape_string() expects
parameter 2 to be resource, object given in
/var/www/opensips-cp/web/tools/system/dialplan/dialplan.php on line 141<br>
[11-Jun-2010 14:00:57] PHP Notice: Undefined index: dialplan_id in
/var/www/opensips-cp/web/tools/system/dialplan/template/dialplan.main.php
on line 28<br>
<br>
<br>
<br>
On 6/10/10 11:18 AM, "Alex Ionescu" <<a moz-do-not-send="true"
href="alex@opensips.org">alex@opensips.org</a>> wrote:<br>
<br>
</span></font>
<blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">Hi Sven,<br>
<br>
I've tried exactly your example. It worked for me.<br>
Please take the last version of opensips-cp from svn trunk. Maybe that
will work for you.<br>
<br>
Regards,<br>
Alex<br>
On 6/4/2010 16:12, Sven Schulz wrote: <br>
</span></font>
<blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"> Re: [OpenSIPS-Users] Opensips-cp Dialplan
Problem For example, if I use control panel cp to add a new rule:<br>
<br>
DialplanID = 0<br>
Rule Priority = 1<br>
Matching Operator=1<br>
Matching reg exp= ^(2|3|5|7)[0-9]{4}<br>
Matching str len=0<br>
Subst Reg Exp= (^(2|3|5|7)[0-9]{4})<br>
Repl Reg Exp=181486\1<br>
Attr= I leave this blank unchecked<br>
<br>
Then the webpage doesn’t give any errors and creates the rule like this:<br>
<br>
DialplanID = 0<br>
Rule Priority = 1<br>
Matching Operator=1<br>
Matching reg exp=<br>
Matching str len=0<br>
Subst Reg Exp= <br>
Repl Reg Exp=<br>
Attr= <br>
<br>
Then I hit apply changes to do a dp_reload and the box segfaults.<br>
<br>
Im running Centos5.4 64 bit and using cp version 4.0<br>
<br>
<br>
<br>
<br>
On 6/4/10 5:53 AM, "Alex Ionescu" <<a moz-do-not-send="true"
href="alex@opensips.org">alex@opensips.org</a>> wrote:<br>
<br>
<br>
</span></font>
<blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">Hi Sven,<br>
<br>
I have tested the latest version of CP (taken from SVN). <br>
I've inserted a few rules, and it worked just fine. All the fields were
populated. <br>
Can you be more specific please ? <br>
<br>
Regards,<br>
Alex<br>
On 6/3/2010 16:55, Sven Schulz wrote: <br>
<br>
</span></font>
<blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"> Opensips-cp Dialplan Problem Using
opensips-cp latest version from SVN.<br>
<br>
Whenever I use CP to insert a new rule, some of the fields arnt
populated. <br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true" href="Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
</span></font></blockquote>
<font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"> <br>
<br>
</span></font></blockquote>
<font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"> <br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true" href="Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</span></font></blockquote>
<font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"><br>
</span></font></blockquote>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>
<br>
<pre class="moz-signature" cols="72">--
Alex Ionescu
<a class="moz-txt-link-abbreviated" href="http://www.voice-system.ro">www.voice-system.ro</a> </pre>
</body>
</html>