<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">======================issues===================================<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Pgsq log info.<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2019-04-18 02:52:28.074 CDT [2410] STATEMENT: select count(*) from dialplan order by dpid, pr, match_op, match_exp asc<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Php log info.<o:p></o:p></p>
<p class="MsoNormal">[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<o:p></o:p></p>
<p class="MsoNormal">[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<o:p></o:p></p>
<p class="MsoNormal">[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<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">======================system modules installed =====================<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Linux Fedora release 30 (Thirty)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">version: PHP 7.3.4 (cli) (built: Apr 2 2019 13:48:50) ( NTS )<o:p></o:p></p>
<p class="MsoNormal">php.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-cli.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-common.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-fedora-autoloader.noarch 1.0.0-6.fc30 @fedora<o:p></o:p></p>
<p class="MsoNormal">php-fpm.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-gd.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-json.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-pdo.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-pear.noarch 1:1.10.9-2.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-pear-MDB2.noarch 2.5.0-0.18.b5.fc30 @fedora<o:p></o:p></p>
<p class="MsoNormal">php-pear-MDB2-Driver-pgsql.noarch 1.5.0-0.17.b4.fc30 @fedora<o:p></o:p></p>
<p class="MsoNormal">php-pecl-apcu.x86_64 5.1.17-1.fc30 @fedora<o:p></o:p></p>
<p class="MsoNormal">php-pecl-apcu-bc.x86_64 1.0.5-1.fc30 @fedora<o:p></o:p></p>
<p class="MsoNormal">php-pgsql.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-process.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-xml.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">php-xmlrpc.x86_64 7.3.4-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">version: postgres (PostgreSQL) 11.2<o:p></o:p></p>
<p class="MsoNormal">postgresql.x86_64 11.2-3.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">postgresql-server.x86_64 11.2-3.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">postgresql-server-devel.x86_64 11.2-3.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">version: Server:: OpenSIPS (2.4.5 (x86_64/linux))<o:p></o:p></p>
<p class="MsoNormal">opensips.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-db_postgresql.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-httpd.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-json.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-mi_json.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-presence.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-presence_callinfo.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-presence_dialoginfo.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-presence_mwi.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-presence_xml.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-pua.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-pua_bla.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-pua_dialoginfo.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-pua_usrloc.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-rls.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-xcap.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal">opensips-xcap_client.x86_64 2.4.5-1.fc30 @updates-testing<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>