[OpenSIPS-Devel] opensips-cp issues

[Dwight Romero]

For your consideration. I've recently built an opensips box using Opensips-cp to manage the server. There are issues with a 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.

======================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/20190418/428429ee/attachment-0001.html>