Checkin failure?

[Jim Holcomb]

• Attempting to check in…Failed
• DateTime::__construct(): Failed to parse time string (No Data) at position 0
  (N): The timezone could not be found in the database (In line for 10)

Fog was working just fine, no changes.
TZ is new york, no changes.
So why is this happening?
Searching on here shows no answers!

[Sebastian Roth]

@Jim-Holcomb Which version of FOG do you have?

[Jim Holcomb]

@sebastian-roth Hello Sebastian, that would help, wouldn’t it?
Version1.5.6.700

[Sebastian Roth]

@Jim-Holcomb Have there been any OS updates in the last days? What Linux OS do you run?

Is your FOG version 1.5.6.700 the new FOG form working-1.6? New web UI?

The No Data in the error code points to function formatTime in fogbase.class.php which is called by the “check in”. Though this does not explain why you get this error out of the blue.

Please check if you have a timezone set in php.ini: find /etc -type f -exec grep "date.timezone" {} /dev/null \;

[Jim Holcomb]

@sebastian-roth said in Checkin failure?:

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

root@fog:~# 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 =

[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?