Installation ERROR: Fresh Install with current git trunk version.

[paat]

Hey folks,
I am new to this so pls bear with me. Thank you in advance!

I have a problem with installing the current git trunk version. I am using a VM with Ubuntu 14.04. I already tried FOG 1.2.0 stable on a VM but I want to test the current 1.3.0 beta version. With version 1.2.0 I had a flawless installation.

For this test I set a new VM with 14.04. When I run the fog install script it stops at : You still need to install/upgrade your database schema… And prompts me to go to x.x.x.x/fog/management and install/update the database. When I do this i get following error msg in the browser: No database to work off SQL: [23] SET SESSION sql_mode=‘’ Params: 0
FYI I set no password for mysql database.

Maybe you experienced the same problem and have advice for me.

Thank you in advance!

[Wayne Workman]

Cross linking similar threads:

https://forums.fogproject.org/topic/7855/sql-error-when-upgrading-database-schema

https://forums.fogproject.org/topic/7876/installation-error-fresh-install-with-current-git-trunk-version

https://forums.fogproject.org/topic/7873/sql-error-after-updating-to-trunk-at-login

https://forums.fogproject.org/topic/7862/nfs-mount-fails-network-unreachable/16

[Tom Elliott]

This should now be fixed.

[Chris Shipley]

@Tom-Elliott I have the latest git pull. Still having this issue on a new Centos 7 installation. When I check, there is no fog database (I do have a password, but I pass that to the system). I couldn’t identify where I might be able to create the initial database in mariadb myself when the install script pauses for you to load up the rest of the DB. I assume its only needing the database to be created, then a script will create tables, etc. Am I right? If I create the fog database myself when its pausing, restart the apache 2 service, then browse to http://IP/fog/management will it take over?

[Chris Shipley]

I should say this is giving extra information on paat’s post - I am having the same issue

[Chris Shipley]

When I create my own fog datbase (mariadb> CREATE DATABASE fog;) then restart the Apache2 (systemctl restart httpd) at the pause in the installfog.sh for database installation, I have a new error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘fog.schemaVersion’ doesn’t exist SQL: [36] SELECT vValue FROM schemaVersion Params: 0

[Tom Elliott]

Please check your chat message. I believe the error you’re seeing is not even close to relevant for the other posts.

[bogg]

I am a newbie too and have exactly the same error message as @paat when I browse to ‘http://<FOGServer>/fog/management’ after the ‘Press [Enter] key when database is updated/installed.’ notification during the FOG installation process.

This is a clean CEntOS 7 x86_64 Minimal 1511 installation using FOG’s wiki.

TIA,
bogg

@paat said in Installation ERROR: Fresh Install with current git trunk version.:

Hey folks,
I am new to this so pls bear with me. Thank you in advance!

I have a problem with installing the current git trunk version. I am using a VM with Ubuntu 14.04. I already tried FOG 1.2.0 stable on a VM but I want to test the current 1.3.0 beta version. With version 1.2.0 I had a flawless installation.

For this test I set a new VM with 14.04. When I run the fog install script it stops at : You still need to install/upgrade your database schema… And prompts me to go to x.x.x.x/fog/management and install/update the database. When I do this i get following error msg in the browser: No database to work off SQL: [23] SET SESSION sql_mode=‘’ Params: 0
FYI I set no password for mysql database.

Maybe you experienced the same problem and have advice for me.

Thank you in advance!

[Chris Shipley]

Tom poked around on my setup and found an error to push out - stay tuned for his update.

[Tom Elliott]

@Chris-Shipley Already pushed the fix.

Thanks again.

[paat]

@Tom-Elliott Thank you Tom. Now the install script runs flawlessly.

[bogg]

Thank you, Everyone, for the updates and fixes.

Regards,
bogg

@paat said in Installation ERROR: Fresh Install with current git trunk version.:

@Tom-Elliott Thank you Tom. Now the install script runs flawlessly.