Checkin failure?

[Jim Holcomb]

@sebastian-roth
Running Ubuntu v16.04
No OS updates run for a few months
FoG was working last week.

[Sebastian Roth]

@jim-holcomb said in Checkin failure?:

FoG was working last week.

Well, something must have changed then I suppose! Maybe Ubuntu autoupdates are on?

Try setting the correct time zone in /etc/php/7.1/fpm/php.ini. Don’t forget to remove the leading ; character in that line and do a systemctl restart php7.1-fpm after the change.

As well check in FOG Configuration -> FOG Settings -> General Settings to make sure FOG_TZ_INFO is set correctly.

[Jim Holcomb]

@sebastian-roth
Well nothing changed, auto updates are not on, and it worked before without the timezone settings?

As well check in FOG Configuration -> FOG Settings -> General Settings to make sure FOG_TZ_INFO is set correctly. *This is set as always to New York, no changes there…

[Sebastian Roth]

@jim-holcomb said in Checkin failure?:

Well nothing changed, auto updates are not on, and it worked before without the timezone settings?

Sorry to say this but I can’t see why FOG should stop working like this with nothing having changed whatsoever.

Please check the apache and PHP-FPM logs to see if you have any hint on what could be wrong in there.

[Jim Holcomb]

@jim-holcomb said in Checkin failure?:

(N): The timezone could not be found in the database (In line for 10)

This has me thinking? The error says "…(N): The timezone could not be found IN the database (In line for 10)

So is this an issue with the database itself?? Seems to me it is looking for a TZ “value” in the database that is missing?

[Sebastian Roth]

@Jim-Holcomb The (N) is just saying it does not accept “N” from “No Data” as a valid first character when parsing a time string. Take a look at the link to the code I posted and you’ll see what I mean.

Did you take a look at the apache and PHP-FPM logs?

By the way, the error message “not found in the database” is not specific to our code. Search the web and you’ll find many people with the same error.

[Jim Holcomb]

@sebastian-roth What link?

[Jim Holcomb]

The current timezone is EST:

root@fog:~# date
Thu Dec 10 16:29:02 EST 2020
root@fog:~#

[Jim Holcomb]

@jim-holcomb said in Checkin failure?:

find /etc -type f -exec grep “date.timezone” {} /dev/null ;

Now today when running this command: find /etc -type f -exec grep “date.timezone” {} /dev/null ;
find: missing argument to `-exec’

[Sebastian Roth]

@Jim-Holcomb Link I meant is: https://github.com/FOGProject/fogproject/blob/dev-branch/packages/web/lib/fog/fogbase.class.php#L1124

The find command is missing the \ as second last character: find /etc -type f -exec grep "date.timezone" {} /dev/null \;

[Jim Holcomb]

Sebastian, now the output looks like this:
find /etc -type f -exec grep “date.timezone” {} /dev/null ;
/etc/php/7.1/apache2/php.ini:; http://php.net/date.timezone
/etc/php/7.1/apache2/php.ini:;date.timezone =
/etc/php/7.1/cli/php.ini:; http://php.net/date.timezone
/etc/php/7.1/cli/php.ini:;date.timezone =
/etc/php/7.1/fpm/php.ini.ucf-dist:; http://php.net/date.timezone
/etc/php/7.1/fpm/php.ini.ucf-dist:;date.timezone =
/etc/php/7.1/fpm/php.ini:; http://php.net/date.timezone
/etc/php/7.1/fpm/php.ini:date.timezone = America/New_York

Still getting the checkin failure

[Jim Holcomb]

Well, not sure why this happened but I took the job out for the task queue and ran the image manually - this worked!

[Sebastian Roth]

@Jim-Holcomb What do you mean by “manually” - through the FOG PXE boot menu?