<div dir="ltr"><p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">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.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">======================issues===================================</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">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.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">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.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Pgsq log info.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">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</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">2019-04-18 02:52:28.074 CDT [2410] STATEMENT: select
count(*) from dialplan order by dpid, pr, match_op, match_exp asc</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">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.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Php log info.</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">[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</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">[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</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">[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</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">======================system modules installed
=====================</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Linux Fedora release 30 (Thirty)</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">version: PHP 7.3.4 (cli) (built: Apr 2 2019 13:48:50)
( NTS )</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-cli.x86_64
7.3.4-1.fc30 @updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-common.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-fedora-autoloader.noarch
1.0.0-6.fc30
@fedora</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-fpm.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-gd.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-json.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pdo.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pear.noarch
1:1.10.9-2.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pear-MDB2.noarch
2.5.0-0.18.b5.fc30
@fedora</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pear-MDB2-Driver-pgsql.noarch
1.5.0-0.17.b4.fc30
@fedora</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pecl-apcu.x86_64
5.1.17-1.fc30
@fedora</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pecl-apcu-bc.x86_64
1.0.5-1.fc30
@fedora</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-pgsql.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-process.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-xml.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">php-xmlrpc.x86_64
7.3.4-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">version: postgres (PostgreSQL) 11.2</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">postgresql.x86_64
11.2-3.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">postgresql-server.x86_64
11.2-3.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">postgresql-server-devel.x86_64
11.2-3.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">version: Server:: OpenSIPS (2.4.5 (x86_64/linux))</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-db_postgresql.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-httpd.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-json.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-mi_json.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-presence.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-presence_callinfo.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-presence_dialoginfo.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-presence_mwi.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-presence_xml.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-pua.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-pua_bla.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-pua_dialoginfo.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-pua_usrloc.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-rls.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-xcap.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">opensips-xcap_client.x86_64
2.4.5-1.fc30
@updates-testing</p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </p></div>