Reading the forum I was expecting this answer, but I tried it equals! hahaha
I will move to 1.3.0.

I have less tan 15 clients, I can do it manually

Thank you very much!

Server

• FOG Version: 1.2.0
• OS: Ubuntu 16.04

Description

Hi all,

I’m installing Fog 1.2.0 in a new VM with Ubuntu 16.04, preparing an update of my old server, with Fog .32 and Ubuntu 12.04.

After a few work, finaly i have it working in 16.04, to get it i did:
- Delete referenes of php5 in install file fog_1.2.0/lib/ubuntu/config and install manually the php7 versions
- Delete line “@set_magic_quotes_runtime(0);” of file /var/www/fog/commons/init.php to avoid it, because is deprecated function in php7
- Dissable “Strict SQL Mode” adding a file “disable_strict_mode.cnf” in configuration folder with this content:
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

After this tweaks I have Fog 1.2.0 apparently working, but I have two questions:

First, I want to upgrade my old database, I try follow the instructions (Wiki -> Upgrade to 1.x.x) but when I import the sql dump of old DB, nothing happends. I miss something?

The other problem also is related with database, with 0.32 version I had the DB in other host, a dedicated DB server (with diferents DB), but with 1.2.0 I can’t find the right way to do it. I tried to change it before install, indicating the host, user and pass (with snmysqluser, snmysqlpass, snmysqlhost) in .install.sh but fog still connecting to localhost. In 0.32 version exist a file …fog/commons/config.php with a directive MYSQL_HOST that I used for this purpose.

Any idea?

Thanks in advance!