Re: [OpenSIPS-Users] Control Panel 6.2 doesn´t work with postgres and using user management

[Bogdan-Andrei Iancu]

Hello Martin,

Do you see (in apache logs or postgres logs) the actual query performed 
by CP 6.2? It will help to see if there is something wrong in it.  Or at 
least some error logs


In the Users tab, do you apply some filters ? or you get the error when 
listing all users (without any filtering) ?


Best regards,

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

OpenSIPS Summit May 2017 Amsterdam
  http://www.opensips.org/events/Summit-2017Amsterdam.html

On 03/29/2017 12:11 PM, M L wrote:


Hi,


I just want to give a heads-up that control panel 6.2 does not work 
with postgres when using user management. It gives some MDB2 errors.


It is related to changed behaviour of select syntax between 6.1 and 6.2.


In 6.2 you will find this select syntax in user_management.main.php

Line 185

$sql_command="from ".$table." s ".$sql_search." order by s.id asc";

Line 193

$resultset = $link->queryAll("select count(*) ".$sql_command);


In 6.1 that still works with postgres for user management and opensips 
2.2 select syntax is:


Line 157

$sql_command="select * from ".$table." s where (1=1) ".$sql_search." 
order by s.id asc";


Line 166

$resultset = $link->queryAll($sql_command);


Not sure reason of why select syntax is changed in 6.2 but you should 
correct it so it works for postgres. Meanwhile a workaround is to use 
cp 6.1 if you use pgsql as db for opensips.



Regards,

Martin



___
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] Control Panel 6.2 doesn´t work with postgres and using user management

[M L]

Hi,


I just want to give a heads-up that control panel 6.2 does not work with 
postgres when using user management. It gives some MDB2 errors.

It is related to changed behaviour of select syntax between 6.1 and 6.2.


In 6.2 you will find this select syntax in user_management.main.php

Line 185

$sql_command="from ".$table." s ".$sql_search." order by s.id asc";

Line 193

$resultset = $link->queryAll("select count(*) ".$sql_command);


In 6.1 that still works with postgres for user management and opensips 2.2 
select syntax is:

Line 157

$sql_command="select * from ".$table." s where (1=1) ".$sql_search." order by 
s.id asc";

Line 166

$resultset = $link->queryAll($sql_command);


Not sure reason of why select syntax is changed in 6.2 but you should correct 
it so it works for postgres. Meanwhile a workaround is to use cp 6.1 if you use 
pgsql as db for opensips.


Regards,

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