FOG Install - sql failed

[cotec]

Hi,

i installed an ubuntu 14.04 in a productive network and have installed fog_1.2.0.tar.gz.
During installation sql-error occured and the installer can’t finish.
I don’t know why its failing because is set up the same machine and used the same commands in an other network and already is fine…

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
160114

initctl: Unknown job: mysql
...
Setting up and starting MySql...Failed!
Script sone, file is /var/fog/foginstall.log

Here some details and logs:
during installation: is this normal?

after failed installation:

0_1452762053236_ERROR.LOG

0_1452762065393_FOGINSTALL.LOG

Need help =(

Thanks

Regards,
cotec

[Sebastian Roth]

How did change to the root environment? Make sure you use sudo su - (check the man page on what ‘-’ is for) or sudo -i

[cotec]

solved, thanks @ CanHasDIY in ubuntuforums

http://ubuntuforums.org/archive/index.php/t-1094853.html

do following:
sudo ./installfog.sh

IMPORTANT: Use “sudo” always, regardless if u are root or “normal” fog user.

[george1421]

marking solved.

[Wayne Workman]

Just for future readers, if you install FOG 1.2.0 on Fedora 21, 22, 23, or CentOS 7, you’ll get a similar error.

You’ll need to install mariadb and mariadb-server and php-mysqlnd instead of php-mysql.
Then, you’ll need to change the commands for mysql service start to systemctl start mysql

The only reason I know this is because @Tom-Elliott helped me with FOG 1.2.0 last night.

[Tom Elliott]

@cotec sudo is not needed if you’re root, but it mainly depends on how you are in as root. For example, sudo su does not source the root environment which can leave other the paths in a strange status which could cause problems. sudo su - sources the environment but it is more appropriate to use sudo -i.