Won't run using PHP 7.0

[f8ttyc8t]

Because I needed to install a new Debian distro (Debian 9 Stretch), PHP 5.x is no longer part of my system.
Now I entirely fail to use control panel.
It seems to fail in MDB2#mysql part - causing error:
PHP Parse error: syntax error, unexpected 'new' (T_NEW) in /usr/share/php/MDB2.php on line 390

Have tried it with both versions (Control Panel 7.2.3 and 6.2 as well)
Any idea about how to run opensips control panel on a recent Linux distribution?

Thanks in advance!

(Btw. digging trough your great book "Building Telephony Systems with OpenSIPS, Second Edition" - which is a great source of help!)

[bogdan-iancu]

@f8ttyc8t , yeah the Control Panel is not php 7 compatible mainly due the deprecated MDB2 . We plan to release a new version of CP for OpenSIPS 2.3, the CP 8.2.3 that will move to PDO for DB ops.

[f8ttyc8t]

@bogdan-iancu , thank you very much for letting me know!
Looking forward to new version.

[artkos]

I got CP working quite easily with PHP 7.0, but there is some problem with Statics monitors cron job script.
Uncaught Error: Call to undefined method PDO::queryAll() in /var/www/opensips-cp/cron_job/get_opensips_stats.php:41

I think it is because you have changed to PDO and these are in PEAR/MDB2 style?
Also if you grep files with "PEAR" you can find few references at:
web/tools/users/alias_management/lib/alias_management.add.validate.php
web/tools/users/alias_management/template/alias_management.main.php
might want to check those also.

[bogdan-iancu]

indeed, there is a bit of a cleanup needed :D, thanks for pointing it out

[artkos]

smonitor-diff.txt

diff file to fix cronjob script :)

[artkos]

And to eliminate cron to spam you with:

PHP Warning: Creating default object from empty value in /var/www/opensips-cp/config/db.inc.php on line 23

You could add following line to db.inc.php:
if (!isset($config)) $config = new stdClass();

[bogdan-iancu]

Good job @artkos , thank you - do you want to pack your changes as a pull request, so you will be author of the changes ?

[bogdan-iancu]

OK, all the left overs from MDB2 were addressed, so the code should be clean and totally migrated to PDO -> compatible with PHP 7

[devorel]

i have problem too

Warning: count(): Parameter must be an array or an object that implements Countable in /usr/share/php/MDB2.php on line 826

Fatal error: Uncaught Error: Call to undefined method MDB2_Error::prepare() in /var/www/opensip/web/login.php:80 Stack trace: #0 {main} thrown in /var/www/opensip/web/login.php on line 80

[bogdan-iancu]

@devorel , what version of OpenSIPS Control Panel are you using ?

[devorel]

The last. Mdb2 not running בתאריך יום ה׳, 16 באוג׳ 2018, 19:05, מאת Bogdan Andrei IANCU ‏< notifications@github.com>:

…

@devorel <https://github.com/devorel> , what version of OpenSIPS Control Panel are you using ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#41 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AQGRbBKz1oqevPQCxDeLIlBpVep_6koMks5uRZgsgaJpZM4Somgl> .

[bogdan-iancu]

You mean the master git branch ?

[devorel]

From the website . בתאריך יום ה׳, 16 באוג׳ 2018, 19:08, מאת Bogdan Andrei IANCU ‏< notifications@github.com>:

…

You mean the master git branch ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#41 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AQGRbFGkPnwlS3Syxv6RL46mh8naeTsBks5uRZj2gaJpZM4Somgl> .