Recommended environment

[maruggio]

Hi

I intend to install FormaLMS 2.0 on a Linux or BSD base. What is currently a recommended and secure OS/DB constellation?

thx.

[max]

Hi Oliver,
You can check out the readme.txt file http://www.formalms.org/versions/readme.txt

[maruggio]

Thanks for your response, max. I already verified the readme and changelog. Today it is not easy to quick install formalms 2.0 (not 2.1) with latest Linux distros on test VMs for multiple testers:
Eg. Ubuntu 18.04 has standard PHP is 7.2 or other distributions use MySQL 5.7 or there were compat probs. I also wanted to install formalms on my plesk environment on ubuntu 16.04 (still) with central DB with MySQL 5.7. For that DB I do not want to change MySQLs DISTINCT found in this post: viewtopic.php?f=10&t=13146&p=19982&hili ... 5.7#p19982, because of Plesk.

My fastest VM installation to meet all formalms 2.0 requirements and versions is a VM running OpenBSD 6.4 with apache2.4, php 7.0 and MariaDB.

[max]

Thanks Oliver for your feedback. Support for Php 7.1 is coming with one of the next versions

[alfa24]

You don't have to change globally your mysql settings.
You have to rewrite some queries. They are not so many as you can think and if you rewrite them you will appreciate better performance too.
I can help if you need.

[maruggio]

@alfa24 Many thanks. Currently it is not yet necessary becuaser I am testing the features and GUI, but I'll come back to you.

[canelli]

16.04 (still) with central DB with MySQL 5.7. For that DB I do not want to change MySQLs DISTINCT found in this post: viewtopic.php?f=10&t=13146&p=19982&hili ... 5.7#p19982, because of Plesk.

My fastest VM installation to meet all formalms 2.0 requirements and versions is a VM running OpenBSD 6.4 with apache2.4, php 7.0 and MariaDB.

Not all mysql 5.7 installation come with the global setting offending formalms query, so mysql 5.7 can be used without global change in many linux dstribution and / configuration. the setting can be applied also in a "per user" methiod depending on your installation. you can also use a docker ... . Mariadb 5.x or 10.x can also be a good choice.

PHP 7.1 or greater are not supported and there are know bugs in forma 2.0 . The support for php 7.1 will not be available in forma 2.2

[maruggio]

Thanks claudio for your input concerning MySQL 5.7.