Database Schema Installer / Updater

[dureal99d]

Server

• FOG Version: rc-16
• OS: Ubuntu 16.04

Client

• Service Version: 11.5
• OS: windows /ubuntu

Description

the Database Schema Installer / Updater will not update no matter what I do. Ive tried the sql fix for 16.04 and it gives some error syntax at line 1.

I am at a lost for what’s wrong

[Tom Elliott]

Can you run:

sudo apt-get install gawk awk bc

Hopefully that will fix the error you’re seeing, which in turn should help fix the issue with database schema.

[dureal99d]

Ok I found the issue on the forum!!!

I guess this database nightmare is an Ubuntu 16.04 thing.

the answer is Here

Posted by @Wayne-Workman

[Wayne Workman]

@dureal99d This must not be a clean and fresh setup of Ubuntu 16? I ask because I’ve verified the last few RCs on many OSs for a bit now, and Ubuntu 16 has been fine. See here:
https://forums.fogproject.org/topic/8730/fog-installer-distro-check

I use the -y argument though. I will try without it tonight and see how that goes.

[dureal99d]

@Wayne-Workman not clean and new. Been up and running for about a year and a half to several harddrive clones.

[Wayne Workman]

@dureal99d How did you get fog to install on Ubuntu 16 a year and a half ago when Ubuntu 16 was released on April 21st, 2016 ?

Did you upgrade from an older Ubuntu?

[Tom Elliott]

Can you run:

sudo apt-get install gawk awk bc

Hopefully that will fix the error you’re seeing, which in turn should help fix the issue with database schema.

[dureal99d]

@Wayne-Workman yes. Lol. I guess i should have stated that. Lots of os upgrades

[dureal99d]

@Tom-Elliott Cool. I shall install soon.

[dureal99d]

@Tom-Elliott awk wont install. Not available.

[Tom Elliott]

@dureal99d THen can you remove “awk” from the command calls and see if that helps?

[dureal99d]

@Tom-Elliott This sudo apt-get install gawk bc worked like a charm I upgraded to RC-17 with no schema update issue. Fixed!!!