[OpenSIPS-Devel] opensips-cp tools issues

[Dwight Romero]

For your consideration. I've recently built an opensips box using Opensips-cp to manage the server. There are issues with some Opensips-cp tools and are listed below. I used postgresql instead of mysql because of the issues opensips-cp mysql has with php 7.

======================issues===================================
issue 1: When I use a web browser with an add blocker enabled, the edit, delete, and other buttons in all the tools do not show up. So you can't edit or delete entries. With add blocker disabled all buttons seem to work ok.

issue 2: dialplan tool reports "No Data Found". The pgsql log gives a hint of the cause for the issue. All other dialplan functions seem to work ok. I've also verified that there is dialplan data in the database.

Pgsq log info.
2019-04-18 02:52:28.074 CDT [2410] ERROR:  column "dialplan.dpid" must appear in the GROUP BY clause or be used in an aggregate function at character 40
2019-04-18 02:52:28.074 CDT [2410] STATEMENT:  select count(*) from dialplan order by dpid, pr, match_op, match_exp asc

issue 3: MI tool not working. The tool reports "Unknwon/Unsupported type[] for MI URL <>". The select dropdown has no entries. The php log gives a hint of the cause for the issue.

Php log info.
[18-Apr-2019 16:39:28 America/Chicago] PHP Notice:  Undefined variable: box_val in /var/www/html/opensips-cp/web/tools/system/mi/lib/functions.inc.php on line 55
[18-Apr-2019 16:39:28 America/Chicago] PHP Warning:  count(): Parameter must be an array or an object that implements Countable in /var/www/html/opensips-cp/web/tools/system/mi/lib/functions.inc.php on line 32
[18-Apr-2019 16:51:35 America/Chicago] PHP Notice:  Undefined index: dialplan_id in /var/www/html/opensips-cp/web/tools/system/dialplan/template/dialplan.main.php on line 29

======================system modules installed =====================

Linux Fedora release 30 (Thirty)

version: PHP 7.3.4 (cli) (built: Apr  2 2019 13:48:50) ( NTS )
php.x86_64                               7.3.4-1.fc30                           @updates-testing
php-cli.x86_64                           7.3.4-1.fc30                           @updates-testing
php-common.x86_64                        7.3.4-1.fc30                           @updates-testing
php-fedora-autoloader.noarch             1.0.0-6.fc30                           @fedora
php-fpm.x86_64                           7.3.4-1.fc30                           @updates-testing
php-gd.x86_64                            7.3.4-1.fc30                           @updates-testing
php-json.x86_64                          7.3.4-1.fc30                           @updates-testing
php-pdo.x86_64                           7.3.4-1.fc30                           @updates-testing
php-pear.noarch                          1:1.10.9-2.fc30                        @updates-testing
php-pear-MDB2.noarch                     2.5.0-0.18.b5.fc30                     @fedora
php-pear-MDB2-Driver-pgsql.noarch        1.5.0-0.17.b4.fc30                     @fedora
php-pecl-apcu.x86_64                     5.1.17-1.fc30                          @fedora
php-pecl-apcu-bc.x86_64                  1.0.5-1.fc30                           @fedora
php-pgsql.x86_64                         7.3.4-1.fc30                           @updates-testing
php-process.x86_64                       7.3.4-1.fc30                           @updates-testing
php-xml.x86_64                           7.3.4-1.fc30                           @updates-testing
php-xmlrpc.x86_64                        7.3.4-1.fc30                           @updates-testing

version: postgres (PostgreSQL) 11.2
postgresql.x86_64                        11.2-3.fc30                            @updates-testing
postgresql-server.x86_64                 11.2-3.fc30                            @updates-testing
postgresql-server-devel.x86_64           11.2-3.fc30                            @updates-testing

version: Server:: OpenSIPS (2.4.5 (x86_64/linux))
opensips.x86_64                          2.4.5-1.fc30                           @updates-testing
opensips-db_postgresql.x86_64            2.4.5-1.fc30                           @updates-testing
opensips-httpd.x86_64                    2.4.5-1.fc30                           @updates-testing
opensips-json.x86_64                     2.4.5-1.fc30                           @updates-testing
opensips-mi_json.x86_64                  2.4.5-1.fc30                           @updates-testing
opensips-presence.x86_64                 2.4.5-1.fc30                           @updates-testing
opensips-presence_callinfo.x86_64        2.4.5-1.fc30                           @updates-testing
opensips-presence_dialoginfo.x86_64      2.4.5-1.fc30                           @updates-testing
opensips-presence_mwi.x86_64             2.4.5-1.fc30                           @updates-testing
opensips-presence_xml.x86_64             2.4.5-1.fc30                           @updates-testing
opensips-pua.x86_64                      2.4.5-1.fc30                           @updates-testing
opensips-pua_bla.x86_64                  2.4.5-1.fc30                           @updates-testing
opensips-pua_dialoginfo.x86_64           2.4.5-1.fc30                           @updates-testing
opensips-pua_usrloc.x86_64               2.4.5-1.fc30                           @updates-testing
opensips-rls.x86_64                      2.4.5-1.fc30                           @updates-testing
opensips-xcap.x86_64                     2.4.5-1.fc30                           @updates-testing
opensips-xcap_client.x86_64              2.4.5-1.fc30                           @updates-testing


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20190421/cd247f5d/attachment-0001.html>