[OpenSIPS-Users] User Management frame in OpenSIPS-CP has no display

[Jennifer Hashimoto]

Jerry,

I use opensips-cp maybe I can help.

A couple things - I have not found there is an extraneous } that needed to be removed, I would suggest putting it back.

What database are you using? I am using postgres instead of mysql and I found that there was a query where it did a count of users to see if it had anything to display and it was mistakenly finding that it had no users to display.

I suggest finding the part where it does a count on users and modifying the php file to echo the sql it uses (just add a few lines like echo $sql;) then test the sql against your database.

I had to change something like
< $data_no=$resultset[0]['count'];
---
> $data_no=$resultset[0]['count(*)’];

Jennifer


---------------------------------------------------
Jennifer Akemi Hashimoto
Caztel Communications
jennifer.hashimoto at caztel.com <mailto:jennifer.hashimoto at caztel.com>
905-836-5445 

> On Jul 31, 2017, at 1:37 PM, jhchinn <jhchinn at thenavisway.com> wrote:
> 
> Bogdan,
> 
> Is there any other advice on how to proceed?
> 
> Thanks,
> 
> Jerry
> 
> 
> 
> --
> View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/User-Management-frame-in-OpenSIPS-CP-has-no-display-tp7608166p7608194.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20170731/1c864c93/attachment.html>