Fresh Instal of 4.0.5

Install and configure FormaLMS and DoceboCE
Post Reply
pkimemiah
Newbie
Posts: 3
Joined: Wed Jul 03, 2013 2:05 pm

Fresh Instal of 4.0.5

Post by pkimemiah »

When I go to the step three am unable to proceed

I have

OS Red Hat Enterprise Edition 5
using user root

Step 2: Information
Server information

* Server software : : Apache/2.2.3 (Red Hat)
* PHP Version : : 5.4.7
* Mysql Client Version : : 5.0.10
* Multibyte Support: OFF
* mime_content_type() support: ON
* Ldap : : ON

PHP Information :

* magic_quotes_gpc : : OFF
* Safe mode : : OFF
* register_global : : OFF
* upload_max_filsize : : 2M
* post_max_size : : 8M
* max_execution_time : : 30s


Looks like I have to set Multibye to ON....how do you do that ....please help
Last edited by pkimemiah on Sun Jul 21, 2013 9:52 pm, edited 1 time in total.
pkimemiah
Newbie
Posts: 3
Joined: Wed Jul 03, 2013 2:05 pm

Re: Fresh Install of 4.0.5

Post by pkimemiah »

Solved the problem

Installed PHP from Oracle https://oss.oracle.com/projects/php/dis ... ation.html with mbstring rpm file

Packages installed are

php54-5.4.7-1.el5
php54-cli-5.4.7-1.el5
php54-ldap-5.4.7-1.el5
php54-common-5.4.7-1.el5
php54-pdo-5.4.7-1.el5
php54-mysql-5.4.7-1.el5
php54-mbstring-5.4.7-1.el5

The MySQL Datbase was set to MYSQL40 mode since default for MySQL 5.6 is strict mode.

mysql> set @@global.sql_mode ='MYSQL40';

I was able to advance to step 6/7

Step 6: Database data setup
Database
loading Importing database

Languages
loading English

it has been there for +1 hour.

What could be the problem? or should I just wait?
pkimemiah
Newbie
Posts: 3
Joined: Wed Jul 03, 2013 2:05 pm

Re: Fresh Instal of 4.0.5

Post by pkimemiah »

Problem Solved

Used PHP 5.4.7 from Oracle Red Hat and it worked

Set MySQL 5.7 to work in "ANSI" mode. I had previously used "MYSQL40"

mysql set @@global.sql_mode = "ANSI"; // not this is temporary , resets back when you re-boot

I hope this helps some one else

Regards
User avatar
alberto
FormaLms Guru
Posts: 1136
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: Fresh Instal of 4.0.5

Post by alberto »

Hi pkimemiah, thanks for your feedbak.
With php 5.4 you may encounter some issue on multilanguage installations, 5.3 is a better choice at the moment
User avatar
mmefectiva
Newbie
Posts: 3
Joined: Mon Aug 01, 2016 3:32 am
Version: forma.lms 1.4.2

Re: Fresh Instal of 4.0.5

Post by mmefectiva »

You have MySQL strict mode enabled; forma.lms doesn't support it, so please turn it off
In OSX this is the solution for MYSQL strict:
created a /etc/mysql/my.cnf with the following contents:-
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
Source:
http://stackoverflow.com/questions/1876 ... e-in-mysql
Post Reply