Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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
assumed. If no such link is found, it will try to create one as if
mysql_connect

had
been called with no arguments. If no connection is found or established, an
E_WARNING level error is generated.

*Return Values*

Returns the escaped string, or FALSE on error.

*Errors/Exceptions*

Executing this function without a MySQL connection present will also emit
E_WARNING level PHP errors. Only execute this function with a valid MySQL
connection present.
I decided to remove the $link from each of the sections under the "modify"
portion of the code.  Assuming since in the code we call the DB connection
in the include statement anyway, the $link should already be established
and able to be assumed.  The code executes as expected with no warnings.
This does not tell me why is doesn't work yet but it does tell me that the
connection to the DB is established and working as expected along with the
code minus this one parameter.

I checked all of my patch versions and PDO with mysqli shouldn't be
required until 5.5 where I'm on 5.3.  Using PDO would have me rewriting
this entire section I would think.

Thanks

Jeff
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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

php-pdo.i686   5.3.3-48.el6_8
@updates

php-pear.noarch1:1.9.4-5.el6
@base

php-xmlrpc.i6865.3.3-48.el6_8
@updates

*Installed packages, channel pear.php.net :*

=

*Package*   *Version* *State*

Archive_Tar   1.3.7   stable

Console_Getopt1.2.3   stable

Log   1.12.8  stable

MDB2  2.4.1   stable

MDB2_Driver_mysql 1.4.1   stable

PEAR  1.9.4   stable

Structures_Graph  1.0.4   stable

XML_RPC   1.5.4   stable

XML_Util  1.2.1   stable


freeradius-mysql.i686  2.2.6-6.el6_7
@updates

lua-sql-mysql.i686 2.1.1-7.el6
@epel

mysql.i686 5.1.73-7.el6
@base

mysql-devel.i686   5.1.73-7.el6
@base

mysql-libs.i6865.1.73-7.el6
@base

mysql-server.i686  5.1.73-7.el6
@base

php-mysql.i686 5.3.3-48.el6_8
@updates


I'll run those tests with mysqli.  I'm not currently using that though.
Will report today.

Jeff Wilkie
Chief Technology Officer
US IP Communications
919.297.1057


*"This e-mail communication and any attachments may contain confidential
and privileged information and is for use by the designated addressee(s)
named above only. Any files transmitted with it are confidential and
intended solely for the use of the individual to whom it is addressed. Any
views or opinions presented are solely those of the author and do not
necessarily represent those of USIPCOM, LLC. If you are not the intended
addressee, you are hereby notified that you have received this
communication in error and that any use or reproduction of this email or
its contents is strictly prohibited and may be unlawful. If you have
received this communication in error, please notify us immediately by
replying to this message and deleting it from your computer. Thank you". *

On Tue, Aug 30, 2016 at 4:12 AM, Bogdan-Andrei Iancu 
wrote:

> Hi Jeff,
>
> We are getting closer :).
>
> I found this http://stackoverflow.com/questions/9014877/mysql-real-
> escape-string-error-despite-connecting-to-database-what-am-i-doing
>
> where the problem goes into mysql versus mysqli. I guess your MDB2 uses
> mysqli ?? Could you list all the php packages you have on your system along
> with all the php pears (pear list) ?
>
> Also, for testing purposes, try to change mysql_real_escape_string() into
> mysqli_real_escape_string()
>
>
> Thanks,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 30.08.2016 00:41, Jeff Wilkie wrote:
>
> Got this from a var dump on $link when i process if !is_resource.  Not
> sure if this actually provides any information that may help.  I'm digging
> online to see why the $link is not connecting as a resource in this portion
> for whatever reason:
>
> 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 288
>
>
>
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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?  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 
> wrote:


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,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com 

On 26.08.2016 08:33, Jeff Wilkie wrote:

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 the changes from

expression string length to expression flags (5.0 cp)
Jeff
On Thu, Aug 25, 2016 at 5:11 PM, Bogdan-Andrei Iancu
> wrote:

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 ;) ).
Could you check if the return of mysql_real_escape_string()
is actually something valid or is it FALSE ?

http://stackoverflow.com/questions/3005135/mysql-real-escape-string-just-makes-an-empty-string


Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 25.08.2016 05:33, Jeff Wilkie wrote:

If I modify the file
/var/www/opensips_cp/web/tools/system/dialplan/dialplan.php
and comment out the following:

// if(get_magic_quotes_gpc()==0){

  //  $match_exp =
mysql_real_escape_string($match_exp, *$link*);

//  }

The updates work fine.  I think noticed that the ref to
*$link* sits below this line in the "modify" section so I
decided to remove the $link ref in the above lines and then
uncommented the lines leaving the modify section like this

if ($errors=="") {

if(get_magic_quotes_gpc()==0){

$match_exp =
mysql_real_escape_string($match_exp);

}

$sql = "SELECT * FROM ".$table.

" WHERE dpid=" .$dpid. " AND
match_exp='" .$match_exp. "'".

" AND id!=".$id;

  $resultset = *$link*->queryAll($sql);

Let me know if I've broken something as a result but this
appears to have corrected the problem I was having.  Unknown
of any side effects currently :)  Take a look and let me
know your thoughts.
Jeff
On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie
> wrote:

Here is what it looks like to my db when I create a
DialPlan

  20 QuerySELECT * FROM dialplan WHERE dpid=36 AND
match_exp='877'

  20 QueryPREPARE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
FROM 'INSERT INTO dialplan\n(dpid, pr, match_op,
match_exp, match_flags, subst_exp, \nrepl_exp, attrs)
VALUES \n(36, 0,1, \'877\',0,\'\',\'\',\'.30\')'

  20 PrepareINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')

  20 QueryEXECUTE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74

  20 ExecuteINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')

This is what happens when I edit that same DialPlan

  23 Queryselect * from dialplan where 

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 
wrote:

> 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,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 26.08.2016 08:33, Jeff Wilkie wrote:
>
> 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 the changes from expression string length to expression flags (5.0
> cp)
>
> Jeff
>
>
> On Thu, Aug 25, 2016 at 5:11 PM, Bogdan-Andrei Iancu 
> wrote:
>
>> 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 ;) ).
>>
>> Could you check if the return of mysql_real_escape_string() is actually
>> something valid or is it FALSE ?
>> http://stackoverflow.com/questions/3005135/mysql-real-escape
>> -string-just-makes-an-empty-string
>>
>> Regards,
>>
>> Bogdan-Andrei Iancu
>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>>
>> On 25.08.2016 05:33, Jeff Wilkie wrote:
>>
>> If I modify the file /var/www/opensips_cp/web/
>> tools/system/dialplan/dialplan.php and comment out the following:
>>
>> //  if(get_magic_quotes_gpc()==0){
>>
>> //  $match_exp =
>> mysql_real_escape_string($match_exp, *$link*);
>>
>> //  }
>> The updates work fine.  I think noticed that the ref to *$link* sits
>> below this line in the "modify" section so I decided to remove the $link
>> ref in the above lines and then uncommented the lines leaving the modify
>> section like this
>>
>> if ($errors=="") {
>>
>> if(get_magic_quotes_gpc()==0){
>>
>> $match_exp =
>> mysql_real_escape_string($match_exp);
>>
>> }
>>
>> $sql = "SELECT * FROM ".$table.
>>
>> " WHERE dpid=" .$dpid. " AND match_exp='"
>> .$match_exp. "'".
>>
>> " AND id!=".$id;
>>
>> $resultset = *$link*->queryAll($sql);
>> Let me know if I've broken something as a result but this appears to have
>> corrected the problem I was having.  Unknown of any side effects currently
>> :)  Take a look and let me know your thoughts.
>> Jeff
>> On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie 
>> wrote:
>>>
>>> Here is what it looks like to my db when I create a DialPlan
>>>
>>>   20 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='877'
>>>
>>>   20 Query PREPARE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
>>> FROM 'INSERT INTO dialplan\n (dpid, pr, match_op, match_exp,
>>> match_flags, subst_exp, \n repl_exp, attrs) VALUES \n (36, 0,1,
>>> \'877\',0,\'\',\'\',\'.30\')'
>>>
>>>   20 Prepare INSERT INTO dialplan
>>>
>>> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>>>
>>> repl_exp, attrs) VALUES
>>>
>>> (36, 0,1, '877',0,'','','.30')
>>>
>>>   20 Query EXECUTE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
>>>
>>>   20 Execute INSERT INTO dialplan
>>>
>>> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>>>
>>> repl_exp, attrs) VALUES
>>>
>>> (36, 0,1, '877',0,'','','.30')
>>> This is what happens when I edit that same DialPlan
>>>
>>>   23 Query select * from dialplan where id='9030'
>>>
>>>   23 Quit
>>>
>>>   24 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='' AND
>>> id!=9030
>>>
>>>   24 Query PREPARE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
>>> FROM 'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp =\'\',
>>> match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs= \'.30\' WHERE
>>> id=9030'
>>>
>>>   24 Prepare UPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
>>> match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30'
>>> WHERE id=9030
>>>
>>>   24 Query EXECUTE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
>>>
>>>   24 Execute UPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
>>> match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30'
>>> WHERE id=9030

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 to be
resource, object given in
/var/www/opensips_cp/web/tools/system/dialplan/dialplan.php on line 320
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 322

All three of these errors reference the $link resource pulled from the lib
dir.

"pear/MDB2", version 2.4.1

I just updated all the others but still get the same error.

Jeff
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 26.08.2016 08:33, Jeff Wilkie wrote:
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 the changes from expression string length to 
expression flags (5.0 cp)


Jeff


On Thu, Aug 25, 2016 at 5:11 PM, Bogdan-Andrei Iancu 
> wrote:


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 ;) ).

Could you check if the return of mysql_real_escape_string() is
actually something valid or is it FALSE ?

http://stackoverflow.com/questions/3005135/mysql-real-escape-string-just-makes-an-empty-string



Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com 

On 25.08.2016 05:33, Jeff Wilkie wrote:

If I modify the file
/var/www/opensips_cp/web/tools/system/dialplan/dialplan.php and
comment out the following:

// if(get_magic_quotes_gpc()==0){

  //  $match_exp =
mysql_real_escape_string($match_exp, *$link*);

//  }

The updates work fine.  I think noticed that the ref to *$link*
sits below this line in the "modify" section so I decided to
remove the $link ref in the above lines and then uncommented the
lines leaving the modify section like this

if ($errors=="") {

if(get_magic_quotes_gpc()==0){

$match_exp =
mysql_real_escape_string($match_exp);

}

$sql = "SELECT * FROM ".$table.

" WHERE dpid=" .$dpid. " AND match_exp='"
.$match_exp. "'".

" AND id!=".$id;

  $resultset = *$link*->queryAll($sql);

Let me know if I've broken something as a result but this appears
to have corrected the problem I was having.  Unknown of any side
effects currently :)  Take a look and let me know your thoughts.
Jeff
On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie > wrote:

Here is what it looks like to my db when I create a DialPlan

  20 QuerySELECT * FROM dialplan WHERE dpid=36 AND
match_exp='877'

  20 QueryPREPARE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74 FROM
'INSERT INTO dialplan\n(dpid, pr, match_op, match_exp,
match_flags, subst_exp, \nrepl_exp, attrs) VALUES \n(36, 0,1,
\'877\',0,\'\',\'\',\'.30\')'

  20 PrepareINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')

  20 QueryEXECUTE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74

  20 ExecuteINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')

This is what happens when I edit that same DialPlan

  23 Queryselect * from dialplan where id='9030'

  23 Quit

  24 QuerySELECT * FROM dialplan WHERE dpid=36 AND
match_exp='' AND id!=9030

  24 QueryPREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2 FROM
'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp
=\'\', match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs=
\'.30\' WHERE id=9030'

  24 PrepareUPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
match_exp ='', match_flags=0, subst_exp = '', repl_exp='',
attrs= '.30' WHERE id=9030

  24 QueryEXECUTE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2

  24 ExecuteUPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
match_exp ='', match_flags=0, subst_exp = '', repl_exp='',
attrs= '.30' WHERE id=9030

  24 QueryDEALLOCATE PREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2

 

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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

Could you add the error_reporting(E_ALL) as suggested in the first 
response, maybe we get a clue on what is going wrong.


Thanks,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 26.08.2016 06:05, Jeff Wilkie wrote:

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
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 the changes from expression string length to expression flags (5.0
cp)

Jeff


On Thu, Aug 25, 2016 at 5:11 PM, Bogdan-Andrei Iancu 
wrote:

> 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 ;) ).
>
> Could you check if the return of mysql_real_escape_string() is actually
> something valid or is it FALSE ?
> http://stackoverflow.com/questions/3005135/mysql-real-
> escape-string-just-makes-an-empty-string
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 25.08.2016 05:33, Jeff Wilkie wrote:
>
> If I modify the file 
> /var/www/opensips_cp/web/tools/system/dialplan/dialplan.php
> and comment out the following:
>
> //  if(get_magic_quotes_gpc()==0){
>
>
> //  $match_exp = 
> mysql_real_escape_string($match_exp,
> *$link*);
>
> //  }
>
> The updates work fine.  I think noticed that the ref to *$link* sits
> below this line in the "modify" section so I decided to remove the $link
> ref in the above lines and then uncommented the lines leaving the modify
> section like this
>
> if ($errors=="") {
>
> if(get_magic_quotes_gpc()==0){
>
>
> $match_exp = mysql_real_escape_string($
> match_exp);
>
> }
>
>
> $sql = "SELECT * FROM ".$table.
>
> " WHERE dpid=" .$dpid. " AND match_exp='"
> .$match_exp. "'".
>
> " AND id!=".$id;
>
> $resultset = *$link*->queryAll($sql);
>
>
> Let me know if I've broken something as a result but this appears to have
> corrected the problem I was having.  Unknown of any side effects currently
> :)  Take a look and let me know your thoughts.
>
> Jeff
>
>
>
> On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie  wrote:
>
>> Here is what it looks like to my db when I create a DialPlan
>>
>>   20 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='877'
>>
>>   20 Query PREPARE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
>> FROM 'INSERT INTO dialplan\n (dpid, pr, match_op, match_exp,
>> match_flags, subst_exp, \n repl_exp, attrs) VALUES \n (36, 0,1,
>> \'877\',0,\'\',\'\',\'.30\')'
>>
>>   20 Prepare INSERT INTO dialplan
>>
>> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>>
>> repl_exp, attrs) VALUES
>>
>> (36, 0,1, '877',0,'','','.30')
>>
>>   20 Query EXECUTE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
>>
>>   20 Execute INSERT INTO dialplan
>>
>> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>>
>> repl_exp, attrs) VALUES
>>
>> (36, 0,1, '877',0,'','','.30')
>>
>> This is what happens when I edit that same DialPlan
>>
>>   23 Query select * from dialplan where id='9030'
>>
>>   23 Quit
>>
>>   24 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='' AND
>> id!=9030
>>
>>   24 Query PREPARE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
>> FROM 'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp =\'\',
>> match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs= \'.30\' WHERE
>> id=9030'
>>
>>   24 Prepare UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp
>> ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030
>>
>>   24 Query EXECUTE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
>>
>>   24 Execute UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp
>> ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030
>>
>>   24 Query DEALLOCATE PREPARE MDB2_STATEMENT_mysql_880efa45d
>> 78ebff7cbf5f617428df4d2
>>
>>   24 Quit
>>
>>
>> You can see that the container for match_ex is not getting passed to the
>> '24' SELECT statement which ends in a 0 results query apparently.
>>
>>
>> Thanks
>>
>> Jeff
>>
>> On Wed, Aug 24, 2016 at 5:30 PM, Jeff Wilkie  wrote:
>>
>>> 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 <
>>> bog...@opensips.org> wrote:
>>>
 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 

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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 ;) ).


Could you check if the return of mysql_real_escape_string() is actually 
something valid or is it FALSE ?

http://stackoverflow.com/questions/3005135/mysql-real-escape-string-just-makes-an-empty-string

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 25.08.2016 05:33, Jeff Wilkie wrote:
If I modify the file 
/var/www/opensips_cp/web/tools/system/dialplan/dialplan.php and 
comment out the following:


// if(get_magic_quotes_gpc()==0){


  //  $match_exp = 
mysql_real_escape_string($match_exp, *$link*);


//  }


The updates work fine.  I think noticed that the ref to *$link* sits 
below this line in the "modify" section so I decided to remove the 
$link ref in the above lines and then uncommented the lines leaving 
the modify section like this


if ($errors=="") {

if(get_magic_quotes_gpc()==0){


$match_exp = 
mysql_real_escape_string($match_exp);


}


$sql = "SELECT * FROM ".$table.

" WHERE dpid=" .$dpid. " AND match_exp='" 
.$match_exp. "'".


" AND id!=".$id;

  $resultset = *$link*->queryAll($sql);



Let me know if I've broken something as a result but this appears to 
have corrected the problem I was having.  Unknown of any side effects 
currently :)  Take a look and let me know your thoughts.


Jeff



On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie > wrote:


Here is what it looks like to my db when I create a DialPlan

  20 QuerySELECT * FROM dialplan WHERE dpid=36 AND match_exp='877'

  20 QueryPREPARE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74 FROM 'INSERT
INTO dialplan\n(dpid, pr, match_op, match_exp, match_flags,
subst_exp, \nrepl_exp, attrs) VALUES \n(36, 0,1,
\'877\',0,\'\',\'\',\'.30\')'

  20 PrepareINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')

  20 QueryEXECUTE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74

  20 ExecuteINSERT INTO dialplan

(dpid, pr, match_op, match_exp, match_flags, subst_exp,

repl_exp, attrs) VALUES

(36, 0,1, '877',0,'','','.30')


This is what happens when I edit that same DialPlan

  23 Queryselect * from dialplan where id='9030'

  23 Quit

  24 QuerySELECT * FROM dialplan WHERE dpid=36 AND match_exp=''
AND id!=9030

  24 QueryPREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2 FROM 'UPDATE
dialplan SET dpid=36, pr = 0, match_op= 1, match_exp =\'\',
match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs= \'.30\'
WHERE id=9030'

  24 PrepareUPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs=
'.30' WHERE id=9030

  24 QueryEXECUTE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2

  24 ExecuteUPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs=
'.30' WHERE id=9030

  24 QueryDEALLOCATE PREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2

  24 Quit



You can see that the container for match_ex is not getting passed
to the '24' SELECT statement which ends in a 0 results query
apparently.


Thanks

Jeff

On Wed, Aug 24, 2016 at 5:30 PM, Jeff Wilkie > wrote:

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
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 Wilkie wrote:

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.

   

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 to my db when I create a DialPlan
>
>   20 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='877'
>
>   20 Query PREPARE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
> FROM 'INSERT INTO dialplan\n (dpid, pr, match_op, match_exp, match_flags,
> subst_exp, \n repl_exp, attrs) VALUES \n (36, 0,1,
> \'877\',0,\'\',\'\',\'.30\')'
>
>   20 Prepare INSERT INTO dialplan
>
> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>
> repl_exp, attrs) VALUES
>
> (36, 0,1, '877',0,'','','.30')
>
>   20 Query EXECUTE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
>
>   20 Execute INSERT INTO dialplan
>
> (dpid, pr, match_op, match_exp, match_flags, subst_exp,
>
> repl_exp, attrs) VALUES
>
> (36, 0,1, '877',0,'','','.30')
>
> This is what happens when I edit that same DialPlan
>
>   23 Query select * from dialplan where id='9030'
>
>   23 Quit
>
>   24 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='' AND
> id!=9030
>
>   24 Query PREPARE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
> FROM 'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp =\'\',
> match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs= \'.30\' WHERE
> id=9030'
>
>   24 Prepare UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp
> ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030
>
>   24 Query EXECUTE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
>
>   24 Execute UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp
> ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030
>
>   24 Query DEALLOCATE PREPARE MDB2_STATEMENT_mysql_
> 880efa45d78ebff7cbf5f617428df4d2
>
>   24 Quit
>
>
> You can see that the container for match_ex is not getting passed to the
> '24' SELECT statement which ends in a 0 results query apparently.
>
>
> Thanks
>
> Jeff
>
> On Wed, Aug 24, 2016 at 5:30 PM, Jeff Wilkie  wrote:
>
>> 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 performing an edit
>>> + save where you only changed the attrs, the "Matching Regular
>>> Expression" gets to empty ?
>>>
>>> Regards,
>>>
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>>>
>>> On 24.08.2016 23:25, Jeff Wilkie wrote:
>>>
>>> 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 <
>>> bog...@opensips.org> wrote:
>>>
 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 Developerhttp://www.opensips-solutions.com

 On 24.08.2016 17:46, Jeff Wilkie wrote:

 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 dial plan information back in via the CP as long as an attribute in
 text form is added.  The same does not happen if using check box.  I can
 provide pics if you'd like.  The only var changed is the

 $dialplan_attributes_mode = 1

 Jeff Wilkie
 Chief Technology Officer
 US IP Communications 919.297.1057 *"This e-mail communication and any
 attachments may contain confidential and privileged information and is for
 use by the designated addressee(s) named above only. Any files transmitted
 with it are confidential and intended solely for the use of the individual
 to whom it is addressed. Any views or opinions presented are solely those
 of the author and do not necessarily represent those of USIPCOM, LLC. If
 you are not the intended addressee, you are hereby notified that you have
 received this communication in error and that any use or reproduction of
 this email or its contents is strictly prohibited and may be unlawful. If
 you have received this communication in error, please notify us immediately
 by replying to this message and deleting it from your computer. Thank you".
 *

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 performing an edit +
> save where you only changed the attrs, the "Matching Regular Expression"
> gets to empty ?
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 24.08.2016 23:25, Jeff Wilkie wrote:
>
> 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  > wrote:
>
>> 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 Developerhttp://www.opensips-solutions.com
>>
>> On 24.08.2016 17:46, Jeff Wilkie wrote:
>>
>> 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 dial plan information back in via the CP as long as an attribute in
>> text form is added.  The same does not happen if using check box.  I can
>> provide pics if you'd like.  The only var changed is the
>>
>> $dialplan_attributes_mode = 1
>>
>> Jeff Wilkie
>> Chief Technology Officer
>> US IP Communications 919.297.1057 *"This e-mail communication and any
>> attachments may contain confidential and privileged information and is for
>> use by the designated addressee(s) named above only. Any files transmitted
>> with it are confidential and intended solely for the use of the individual
>> to whom it is addressed. Any views or opinions presented are solely those
>> of the author and do not necessarily represent those of USIPCOM, LLC. If
>> you are not the intended addressee, you are hereby notified that you have
>> received this communication in error and that any use or reproduction of
>> this email or its contents is strictly prohibited and may be unlawful. If
>> you have received this communication in error, please notify us immediately
>> by replying to this message and deleting it from your computer. Thank you".
>> *
>> On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu > > wrote:
>>>
>>> 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 Developerhttp://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 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
>>> again, they are not there.  I dot not have the same problem when using
>>> attrs as checkboxes.  Is there more code in the local files that require
>>> editing to display these values?  Also, if an entry in the Dialplan was
>>> once a checkbox value but I've not converted the mode to text, the value
>>> does not show up in the text box to be edited.
>>>
>>> # Attention : advanced options !!
>>>
>>>  //database tables
>>>
>>>  $config->table_dialplan = "dialplan";
>>>
>>>  $config->results_per_page = 20;
>>>
>>>  $config->results_page_range = 5;
>>>
>>>  $config->attrs_cb=array(
>>>
>>> // name , description
>>>
>>> array("a","Descr a"),
>>>
>>> array("b","Descr b"),
>>>
>>> array("c","Descr c"),
>>>
>>> array("d","Descr d"),
>>>
>>> array("e","Descr e"),
>>>
>>> array("f","Descr f"),
>>>
>>> );
>>>
>>>  $config->cb_per_row = 3;
>>>
>>>  $talk_to_this_assoc_id = 1 ;
>>>
>>> // Dialplan - Add/Edit new Translation Rule - Attributes input type
>>>
>>> // 0 - checkboxes
>>>
>>> // 1 - text
>>>
>>> $dialplan_attributes_mode = 1  ;
>>>
>>> ?>
>>> Jeff
>>>
>>> ___
>>> Users mailing 
>>> listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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 Wilkie wrote:
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 
> wrote:


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 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 dial plan
information back in via the CP as long as an attribute in text
form is added.  The same does not happen if using check box.  I
can provide pics if you'd like.  The only var changed is the


$dialplan_attributes_mode = 1


Jeff Wilkie
Chief Technology Officer
US IP Communications 919.297.1057  /"This
e-mail communication and any attachments may contain confidential
and privileged information and is for use by the designated
addressee(s) named above only. Any files transmitted with it are
confidential and intended solely for the use of the individual to
whom it is addressed. Any views or opinions presented are solely
those of the author and do not necessarily represent those of
USIPCOM, LLC. If you are not the intended addressee, you are
hereby notified that you have received this communication in
error and that any use or reproduction of this email or its
contents is strictly prohibited and may be unlawful. If you have
received this communication in error, please notify us
immediately by replying to this message and deleting it from your
computer. Thank you". /
On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu
> wrote:

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 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 again, they
are not there.  I dot not have the same problem when using
attrs as checkboxes.  Is there more code in the local files
that require editing to display these values?  Also, if an
entry in the Dialplan was once a checkbox value but I've not
converted the mode to text, the value does not show up in
the text box to be edited.

# Attention : advanced options !!

 //database tables

 $config->table_dialplan = "dialplan";

 $config->results_per_page = 20;

 $config->results_page_range = 5;

 $config->attrs_cb=array(

  // name , description

  array("a","Descr a"),

  array("b","Descr b"),

  array("c","Descr c"),

  array("d","Descr d"),

  array("e","Descr e"),

  array("f","Descr f"),

  );

 $config->cb_per_row = 3;

 $talk_to_this_assoc_id = 1 ;

// Dialplan - Add/Edit new Translation Rule - Attributes
input type

// 0 - checkboxes

// 1 - text

$dialplan_attributes_mode = 1  ;

?>

Jeff

___
Users mailing list
Users@lists.opensips.org 
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 
wrote:

> 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 Developerhttp://www.opensips-solutions.com
>
> On 24.08.2016 17:46, Jeff Wilkie wrote:
>
> 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 dial plan information back in via the CP as long as an attribute in
> text form is added.  The same does not happen if using check box.  I can
> provide pics if you'd like.  The only var changed is the
>
> $dialplan_attributes_mode = 1
>
> Jeff Wilkie
> Chief Technology Officer
> US IP Communications
> 919.297.1057
>
>
> *"This e-mail communication and any attachments may contain confidential
> and privileged information and is for use by the designated addressee(s)
> named above only. Any files transmitted with it are confidential and
> intended solely for the use of the individual to whom it is addressed. Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of USIPCOM, LLC. If you are not the intended
> addressee, you are hereby notified that you have received this
> communication in error and that any use or reproduction of this email or
> its contents is strictly prohibited and may be unlawful. If you have
> received this communication in error, please notify us immediately by
> replying to this message and deleting it from your computer. Thank you". *
>
> On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu 
> wrote:
>
>> 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 Developerhttp://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 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
>> again, they are not there.  I dot not have the same problem when using
>> attrs as checkboxes.  Is there more code in the local files that require
>> editing to display these values?  Also, if an entry in the Dialplan was
>> once a checkbox value but I've not converted the mode to text, the value
>> does not show up in the text box to be edited.
>>
>> # Attention : advanced options !!
>>
>>  //database tables
>>
>>  $config->table_dialplan = "dialplan";
>>
>>  $config->results_per_page = 20;
>>
>>  $config->results_page_range = 5;
>>
>>  $config->attrs_cb=array(
>>
>> // name , description
>>
>> array("a","Descr a"),
>>
>> array("b","Descr b"),
>>
>> array("c","Descr c"),
>>
>> array("d","Descr d"),
>>
>> array("e","Descr e"),
>>
>> array("f","Descr f"),
>>
>> );
>>
>>  $config->cb_per_row = 3;
>>
>>  $talk_to_this_assoc_id = 1 ;
>>
>> // Dialplan - Add/Edit new Translation Rule - Attributes input type
>>
>> // 0 - checkboxes
>>
>> // 1 - text
>>
>> $dialplan_attributes_mode = 1  ;
>>
>> ?>
>> Jeff
>>
>> ___
>> Users mailing 
>> listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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 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 dial plan information back in via the CP as 
long as an attribute in text form is added.  The same does not happen 
if using check box.  I can provide pics if you'd like.  The only var 
changed is the


$dialplan_attributes_mode = 1


Jeff Wilkie
Chief Technology Officer
US IP Communications
919.297.1057


/"This e-mail communication and any attachments may contain 
confidential and privileged information and is for use by the 
designated addressee(s) named above only. Any files transmitted with 
it are confidential and intended solely for the use of the individual 
to whom it is addressed. Any views or opinions presented are solely 
those of the author and do not necessarily represent those of USIPCOM, 
LLC. If you are not the intended addressee, you are hereby notified 
that you have received this communication in error and that any use or 
reproduction of this email or its contents is strictly prohibited and 
may be unlawful. If you have received this communication in error, 
please notify us immediately by replying to this message and deleting 
it from your computer. Thank you". /


On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu 
> wrote:


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 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 again, they are not there.  I dot not
have the same problem when using attrs as checkboxes.  Is there
more code in the local files that require editing to display
these values?  Also, if an entry in the Dialplan was once a
checkbox value but I've not converted the mode to text, the value
does not show up in the text box to be edited.

# Attention : advanced options !!

 //database tables

 $config->table_dialplan = "dialplan";

 $config->results_per_page = 20;

 $config->results_page_range = 5;

 $config->attrs_cb=array(

  // name , description

  array("a","Descr a"),

  array("b","Descr b"),

  array("c","Descr c"),

  array("d","Descr d"),

  array("e","Descr e"),

  array("f","Descr f"),

  );

 $config->cb_per_row = 3;

 $talk_to_this_assoc_id = 1 ;

// Dialplan - Add/Edit new Translation Rule - Attributes input type

// 0 - checkboxes

// 1 - text

$dialplan_attributes_mode = 1  ;

?>

Jeff

___
Users mailing list
Users@lists.opensips.org 
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 dial
plan information back in via the CP as long as an attribute in text form is
added.  The same does not happen if using check box.  I can provide pics if
you'd like.  The only var changed is the

$dialplan_attributes_mode = 1

Jeff Wilkie
Chief Technology Officer
US IP Communications
919.297.1057


*"This e-mail communication and any attachments may contain confidential
and privileged information and is for use by the designated addressee(s)
named above only. Any files transmitted with it are confidential and
intended solely for the use of the individual to whom it is addressed. Any
views or opinions presented are solely those of the author and do not
necessarily represent those of USIPCOM, LLC. If you are not the intended
addressee, you are hereby notified that you have received this
communication in error and that any use or reproduction of this email or
its contents is strictly prohibited and may be unlawful. If you have
received this communication in error, please notify us immediately by
replying to this message and deleting it from your computer. Thank you". *

On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu 
wrote:

> 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 Developerhttp://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 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
> again, they are not there.  I dot not have the same problem when using
> attrs as checkboxes.  Is there more code in the local files that require
> editing to display these values?  Also, if an entry in the Dialplan was
> once a checkbox value but I've not converted the mode to text, the value
> does not show up in the text box to be edited.
>
> # Attention : advanced options !!
>
>
>
>  //database tables
>
>  $config->table_dialplan = "dialplan";
>
>  $config->results_per_page = 20;
>
>  $config->results_page_range = 5;
>
>
>  $config->attrs_cb=array(
>
> // name , description
>
> array("a","Descr a"),
>
> array("b","Descr b"),
>
> array("c","Descr c"),
>
> array("d","Descr d"),
>
> array("e","Descr e"),
>
> array("f","Descr f"),
>
> );
>
>  $config->cb_per_row = 3;
>
>  $talk_to_this_assoc_id = 1 ;
>
>
> // Dialplan - Add/Edit new Translation Rule - Attributes input type
>
> // 0 - checkboxes
>
> // 1 - text
>
> $dialplan_attributes_mode = 1  ;
>
>
> ?>
>
>
>
> Jeff
>
>
>
>
>
>
> ___
> Users mailing 
> listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Bogdan-Andrei Iancu]

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 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 again, they are not there.  I dot not have the same problem 
when using attrs as checkboxes.  Is there more code in the local files 
that require editing to display these values?  Also, if an entry in 
the Dialplan was once a checkbox value but I've not converted the mode 
to text, the value does not show up in the text box to be edited.


# Attention : advanced options !!



 //database tables

 $config->table_dialplan = "dialplan";

 $config->results_per_page = 20;

 $config->results_page_range = 5;


 $config->attrs_cb=array(

  // name , description

  array("a","Descr a"),

  array("b","Descr b"),

  array("c","Descr c"),

  array("d","Descr d"),

  array("e","Descr e"),

  array("f","Descr f"),

  );

 $config->cb_per_row = 3;

 $talk_to_this_assoc_id = 1 ;


// Dialplan - Add/Edit new Translation Rule - Attributes input type

// 0 - checkboxes

// 1 - text

$dialplan_attributes_mode = 1  ;


?>




Jeff






___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

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 again,
they are not there.  I dot not have the same problem when using attrs as
checkboxes.  Is there more code in the local files that require editing to
display these values?  Also, if an entry in the Dialplan was once a
checkbox value but I've not converted the mode to text, the value does not
show up in the text box to be edited.

# Attention : advanced options !!



 //database tables

 $config->table_dialplan = "dialplan";

 $config->results_per_page = 20;

 $config->results_page_range = 5;


 $config->attrs_cb=array(

// name , description

array("a","Descr a"),

array("b","Descr b"),

array("c","Descr c"),

array("d","Descr d"),

array("e","Descr e"),

array("f","Descr f"),

);

 $config->cb_per_row = 3;

 $talk_to_this_assoc_id = 1 ;


// Dialplan - Add/Edit new Translation Rule - Attributes input type

// 0 - checkboxes

// 1 - text

$dialplan_attributes_mode = 1  ;


?>



Jeff
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users