Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

So reading the following: *Parameters* *unescaped_string* The string that is to be escaped. *link_identifier* The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect is

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

php.i686 5.3.3-48.el6_8 @updates php-cli.i686 5.3.3-48.el6_8 @updates php-common.i6865.3.3-48.el6_8 @updates php-gd.i6865.3.3-48.el6_8 @updates php-mysql.i686 5.3.3-48.el6_8 @updates

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

My bad, the len was replaced with flags between 1.8 and 1.9 :) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 26.08.2016 17:38, Jeff Wilkie wrote: I'll check the versions. As for the flag field in dialplan, I guess the documents are wrong?

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

I'll check the versions. As for the flag field in dialplan, I guess the documents are wrong? I show it as flag field in 1.10.x which I am currently running http://www.opensips.org/html/docs/modules/1.10.x/dialplan.html#id293827 Jeff On Fri, Aug 26, 2016 at 5:24 AM, Bogdan-Andrei Iancu

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Attempting to edit any of these fields produces these warnings and null entries. 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 292 Warning: mysql_real_escape_string() expects parameter 2

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

I'll check the versions. As for the flag field in dialplan, I guess the documents are wrong? I show it as flag field in 1.10.x which I am currently running http://www.opensips.org/html/docs/modules/1.10.x/dialplan.html#id293827 Thanks Jeff ___

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Hi Jeff, Maybe the version of MDB2 or MDB2::mysql php pear ? The CP versions are correlated with the OpenSIPS versions. The len field was moved to a flag field (in dialplan table) in opensips 1.11, corresponding to CP 6.0 (6.1 matches opensips 2.1 and CP trunk matches the 2.2) Regards,

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Hi Jeff, That is really weird as the $link is valid (you can print it to doublecheck) as it is later used in the code for running the sql code. I'm not a php expert :P, but just googling, I found this: http://stackoverflow.com/questions/19888928/why-mysql-real-escape-string-returns-boolean

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

I just loaded all the web directory content from git to test but the results are the same. The config dir for dialplan are the same other than the toggle for 1 on text attributes. Are there other files/dirs that would affect the dial plan section of CP? Also, the git download does not include

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

When using $match_exp = mysql_real_escape_string($match_exp, *$link*); I get NULL with var_dump When using $match_exp = mysql_real_escape_string($match_exp); I get with a var_dump string(10) "^\\+1907.*" Thanks Jeff ___ Users mailing list

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Hi Jeff, I run some test with the exact code on GITHUB (branch 5.0) and the edit actually worked well (without any further changes). The $link is a variable that is initialized in the included file lib/db_connect.php, so it valid (anyhow, it is used later for the actual query, which works

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Disregard the statement I made about the select statement. This is where you're checking for duplicates. But I do notice the regex is not present here either. Thanks Jeff Wilkie USIP Communications On Aug 24, 2016 6:22 PM, "Jeff Wilkie" wrote: > Here is what it looks like

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Yes. After any edits followed by a save with the attribute field active as text causes "Matching Regular Expression" to be deleted. Thanks Jeff On Wed, Aug 24, 2016 at 5:15 PM, Bogdan-Andrei Iancu wrote: > Jeff, > > You mean "Matching Regular Expression", right ? upon

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Jeff, You mean "Matching Regular Expression", right ? upon performing an edit + save where you only changed the attrs, the "Matching Regular Expression" gets to empty ? Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 24.08.2016 23:25, Jeff

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Ok. The value now displays but if you modify the value and hit save, it kills the regex value upon saving. Also, you cannot add the regex value back into the row. All other values appear to be kept. Thanks Jeff On Wed, Aug 24, 2016 at 11:35 AM, Bogdan-Andrei Iancu

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Hi Jeff, I spotted the issue and fixed it on GIT repo. Please give it a try and let me know if it works for you too. Thanks and regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 24.08.2016 17:46, Jeff Wilkie wrote: Yes, The text box is there

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Yes, The text box is there but when you place a value in a preexisting dial plan, the result in the DB is just the value in the text attribute field with no dial plan information. By editing or adding an attribute it kills the rest of the dial plan that you were editing and you cannot add the

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

Hi Jeff, You mean you do not get the Attributes text area at all in the Edit section ? Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 23.08.2016 00:56, Jeff Wilkie wrote: New small issue with DIALPLAN in the CP. Running OSIPS 1.10 with CP

[OpenSIPS-Users] OPENSIPS_CP DIALPLAN

New small issue with DIALPLAN in the CP. Running OSIPS 1.10 with CP 5.0 It appears that when modifying the CP for Dialplan attributes as text, they do not appear in the edit section once applied. The attributes do show up in the view list of dial plans but if you go back to edit the attrs