Upgraded from FOG 1.5.9 to 1.5.10.1903 and having issues

[Tom Elliott]

@Strahd Do this:

cd /root/fogproject
git checkout working-1.6
git pull
cd bin
sudo ./installfog.sh -y

[Strahd]

@Tom-Elliott

hmmm…

[Strahd]

@Strahd

ok cancel that last post I think our internet filter was getting in the way or somethine weird and i’m past that now.

[Strahd]

@Tom-Elliott ok heres the logs you requested

(FYI 10.46.101.20 is my PC’s ip address. The fog server is a VM. It is 10.46.10.40)

[Strahd]

@Tom-Elliott I did this as per your post, did not work, same DB update error as before

cd /root/fogproject
git checkout working-1.6
git pull
cd bin
sudo ./installfog.sh -y

[Tom Elliott]

@Strahd @Strahd Those logs were exactly what I needed, thank you. Two separate things going on
and neither one is your fault.

First, this line is your 500:

[proxy:error] (111)Connection refused: AH00957: FCGI: attempt to connect to 127.0.0.1:9000 (*) failed
[proxy_fcgi:error] AH01079: failed to make connection to backend: 127.0.0.1

Apache was trying to hand PHP off on port 9000 and php-fpm wasn’t listening there yet.
Notice apache came back up at 08:57:16 and there are no more of those errors after it.
So before you do anything else, just reload the page:

http://10.46.10.40/fog/management

There’s a decent chance it works now.

Second, “Updating Database…Failed!” is the part I still need to see. That curl’s
output goes into the install log, so please post:

sudo grep -A5 -i "schema\|Updating Database" /root/fogproject/bin/error_logs/fog_error_1.6.0-beta.3050.log | tail -60

That’ll tell me why the schema update itself came back an error, which is the last piece.

Third - you found a real bug. On 1.6 the schema page makes you log in first, but the
login reads a database column that doesn’t exist until the schema update runs. So it
asks you to sign in, sign in can’t work, and there’s no way out. That hits everyone
upgrading from any released FOG, not just you. I’ve fixed it and pushed it, tracked in
#927.

If the page is still dead, here’s the manual way to force the database update. Get your
token:

sudo grep FOG_SCHEMA_INSTALL_TOKEN /var/www/html/fog/lib/fog/config.class.php

Then paste it into this:

sudo curl -X POST -H "X-Fog-Install-Token: PASTE_TOKEN_HERE" -d "schemaupdate=1" \
  "http://10.46.10.40/fog/management/index.php?node=schema"

You want to see:

{"msg":"Schema updated successfully!","title":"Schema Update Success"}

I tested that against a real 1.5.9 database on PHP 7.4 here, it works.

And to put your mind at ease - none of this touches /images or your tftpboot files. You
are not going to lose your images over this, so please don’t rebuild the box yet.

One last thing. Your install log still had these:

ln: failed to create symbolic link '/lib/systemd/system/mysql.service': File exists

I fixed those on the 27th and the current code can’t print them anymore, so I don’t think
your checkout took. Run this and show me what it says:

cd /root/fogproject
git rev-parse --abbrev-ref HEAD
git log -1 --oneline

Thanks for sticking with this one. You’ve found two real bugs so far

[Tom Elliott]

@Strahd Simply put:

Please try a repull and install:

cd /root/fogproject
git pull
cd bin
sudo ./installfog.sh -y

should work?

[Strahd]

@Tom-Elliott ok here’s the latest results:

When I visit http://10.46.10.40/fog/management it immediately jumps to http://10.46.10.40/fog/management/index.php?node=schema instead and displays the following:

Clicking update reveals (if I click “here to login” again it sends me to the previous update page, making an endless loop):

Typing
sudo grep -A5 -i “schema|Updating Database” /root/fogproject/bin/error_logs/fog_error_1.6.0-beta.3050.log | tail -60
Delivers no output at all. If you are looking for the term “Updating Database” I manually opened the log with a text editor and found no reference to “Updating” anywhere in there.

I tried updating the token but it threw an error - please check my syntax

[Tom Elliott]

@Strahd IT’s likely the \ character in the line that casued the error you saw.
Either way it seems like it’s working now?

[Strahd]

@Tom-Elliott No, can’t get that command to work. I tried removing the \ or removing the quotes, no joy.

[Tom Elliott]

@Strahd IS your fog server actually having issues now?

I know you have the schema testing stuffs, but that was less important.

it seems you have a database and all that jazz

[Strahd]

@Tom-Elliott Fog server has not been working since this entire thread was created… it’s not working.
So far the database has refused to update and the web management console is 100% unavailable since the only thing it does is prompt me to update the database.

Tried the manual update with
sudo curl -X POST -H “X-Fog-Install-Token: 14dbb4a059bc201b2bf585b625087f92f4b5f8fd6dc70de8a0bef17845f00321” -d “schemaupdate=1” “http://10.46.10.40/fog/management/index.php?node=schema”

but it responded with
{“error”:“Unable to update schema”,“title”,“Schema Update Fail”}

Here’s some data you requested earlier