No Login History Clients
-
Server
- FOG Version: 1.4.1
- OS: Ubuntu 16.04
Client
- Service Version:
- OS:
Description
We updated to 1.4.1 from 1.4.0-RC-7 about 1.5 weeks ago. So maybe it happened then. Service setting is checked on clients and it is enabled globally.
Just tried to look at Login History for some hosts and notice there was nothing. I checked others same issue. I then when to a computer I know was working and nada. I logged in checked the log and it appears to be working but FOG is no longer capturing the data.
What should I check? Permissions on there the login history is stored?
-
Any apache errors?
-
I cant post the code Forum blocks it as spam.
-
-
My bet is this.
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message -
[Thu Jun 15 10:30:31.285221 2017] [php7:warn] [pid 26872] [client 10.129.155.160:56686] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Thu Jun 15 10:54:48.837428 2017] [php7:warn] [pid 29851] [client 10.129.155.160:50266] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Thu Jun 15 11:32:35.543437 2017] [php7:warn] [pid 3763] [client 10.91.150.122:49837] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Thu Jun 15 12:16:28.052326 2017] [php7:warn] [pid 11035] [client 10.122.1.48:49452] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Thu Jun 15 12:41:24.840645 2017] [php7:warn] [pid 14833] [client 10.88.1.83:49160] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Thu Jun 15 15:07:13.640008 2017] [php7:error] [pid 4719] [client 10.129.152.214:52563] PHP Fatal error: Uncaught Exception: #!im in /var/www/html/fog/lib/fog/fogbase.class.php:519\nStack trace:\n#0 /var/www/html/fog/lib/client/registerclient.class.php(46): FOGBase::getHostItem(true, false, false, true)\n#1 /var/www/html/fog/lib/fog/fogpage.class.php(2843): RegisterClient->json()\n#2 /var/www/html/fog/lib/fog/fogpage.class.php(267): FOGPage->requestClientInfo()\n#3 /var/www/html/fog/lib/pages/processlogin.class.php(57): FOGPage->__construct('')\n#4 [internal function]: ProcessLogin->__construct()\n#5 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#6 /var/www/html/fog/management/index.php(31): FOGBase::getClass('ProcessLogin')\n#7 {main}\n thrown in /var/www/html/fog/lib/fog/fogbase.class.php on line 519 [Thu Jun 15 15:11:56.809027 2017] [php7:error] [pid 5504] [client 10.129.152.106:51062] PHP Fatal error: Uncaught Exception: #!im in /var/www/html/fog/lib/fog/fogbase.class.php:519\nStack trace:\n#0 /var/www/html/fog/lib/client/registerclient.class.php(46): FOGBase::getHostItem(true, false, false, true)\n#1 /var/www/html/fog/lib/fog/fogpage.class.php(2843): RegisterClient->json()\n#2 /var/www/html/fog/lib/fog/fogpage.class.php(267): FOGPage->requestClientInfo()\n#3 /var/www/html/fog/lib/pages/processlogin.class.php(57): FOGPage->__construct('')\n#4 [internal function]: ProcessLogin->__construct()\n#5 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#6 /var/www/html/fog/management/index.php(31): FOGBase::getClass('ProcessLogin')\n#7 {main}\n thrown in /var/www/html/fog/lib/fog/fogbase.class.php on line 519 -
@UWPVIOLATOR said in No Login History Clients:
My bet is this.
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this messageThis error is common, it’s not causing it. Just means you don’t have a valid DNS entry for the box. The FTP errors don’t look related either, though those are an issue.
What I have to do is setup a FOG 1.4 box and test the login history, and slowly step through releases and commits until I find the one that caused the problem. I won’t be able to get to this until sometime this weekend. Others are free to try before then.
-
So I’m not seeing any problems with user logon. I did see an issue with powermanagement and while I was looking into that, I did notice user tracking appeared to be doing what was expected.
Can you provide the fog.log of a machine that’s not sending the user login/logout information?
-
Sorry for delay was out of town. Here is a log file. Nothing out of the ordinary. BUT I did remember something over the break. Our Sysadmin actually updated to the working branch on accident then went down to 1.4.1. We saw 1.4.3 was released so we will update to that and report back.
------------------------------------------------------------------------------ --------------------------------Authentication-------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Version: 0.11.12 6/21/2017 7:31 AM Client-Info OS: Windows 6/21/2017 7:31 AM Middleware::Authentication Waiting for authentication timeout to pass 6/21/2017 7:31 AM Middleware::Communication Download: http://fogserver/fog/management/other/ssl/srvpublic.crt 6/21/2017 7:31 AM Data::RSA FOG Server CA cert found 6/21/2017 7:31 AM Middleware::Authentication Cert OK 6/21/2017 7:31 AM Middleware::Communication POST URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&authorize&newService 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM Middleware::Authentication Authenticated 6/21/2017 7:31 AM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&configure&newService&json 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&mac=B4:B5:2F:DB:8B:01&newService&json 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?clientver&newService&json 6/21/2017 7:31 AM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?newService&json 6/21/2017 7:31 AM Service Creating user agent cache 6/21/2017 7:31 AM Middleware::Response Module is disabled globally on the FOG server 6/21/2017 7:31 AM Middleware::Response Module is disabled on the host 6/21/2017 7:31 AM Middleware::Response Module is disabled globally on the FOG server 6/21/2017 7:31 AM Service Initializing modules ------------------------------------------------------------------------------ ---------------------------------ClientUpdater-------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Success ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ ----------------------------------TaskReboot---------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Module is disabled globally on the FOG server ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ --------------------------------HostnameChanger------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM HostnameChanger Checking Hostname 6/21/2017 7:31 AM HostnameChanger Hostname is correct 6/21/2017 7:31 AM HostnameChanger Attempting to join domain 6/21/2017 7:31 AM HostnameChanger Host already joined to target domain ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ ---------------------------------SnapinClient--------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response No snapins ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ --------------------------------PrinterManager-------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Module is disabled on the host ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ --------------------------------PowerManagement------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM PowerManagement Calculating tasks to unschedule 6/21/2017 7:31 AM PowerManagement Calculating tasks to schedule ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ ----------------------------------UserTracker--------------------------------- ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Client-Info Client Version: 0.11.12 6/21/2017 7:31 AM Client-Info Client OS: Windows 6/21/2017 7:31 AM Client-Info Server Version: 1.4.1 6/21/2017 7:31 AM Middleware::Response Success 6/21/2017 7:31 AM Middleware::Communication URL: http://fogserver/fog/service/usertracking.report.php?action=login&user=228-LMC-109546\t711933-228&mac=B4:B5:2F:DB:8B:01&newService&json ------------------------------------------------------------------------------ 6/21/2017 7:31 AM Service Sleeping for 506 seconds``` -
Updated to 1.4.3 still nothing. Here is the latest apache log.
[Wed Jun 21 06:25:14.153774 2017] [mpm_prefork:notice] [pid 1028] AH00163: Apache/2.4.25 (Ubuntu) OpenSSL/1.0.2l configured -- resuming normal operations [Wed Jun 21 06:25:14.153809 2017] [core:notice] [pid 1028] AH00094: Command line: '/usr/sbin/apache2' [Wed Jun 21 08:07:06.676028 2017] [php7:warn] [pid 26493] [client 10.129.1.37:49415] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 09:44:52.393556 2017] [php7:warn] [pid 9086] [client 10.76.1.6:49246] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Wed Jun 21 10:32:17.794234 2017] [php7:warn] [pid 17431] [client 10.129.151.26:49669] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Wed Jun 21 10:34:02.754763 2017] [php7:warn] [pid 18250] [client 10.129.151.50:60507] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Wed Jun 21 10:54:53.498757 2017] [php7:warn] [pid 21450] [client 10.129.151.50:58827] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 10:56:03.217208 2017] [php7:warn] [pid 21452] [client 10.129.151.26:52434] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 11:02:22.145291 2017] [php7:warn] [pid 21849] [client 10.77.1.14:57073] PHP Warning: fopen(ftp://...@10.130.66.31/opt/fog/snapins/Firefox_Setup_52.1.2esr.exe): failed to open stream: FTP server reports 550 Could not get file size.\r\n in /var/www/html/fog/lib/client/snapinclient.class.php on line 620 [Wed Jun 21 11:11:17.999235 2017] [php7:warn] [pid 23821] [client 10.77.1.14:57203] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 11:32:29.216502 2017] [php7:warn] [pid 27157] [client 10.77.1.14:57849] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 12:10:33.289273 2017] [php7:warn] [pid 1174] [client 10.100.1.186:49532] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 [Wed Jun 21 13:36:41.001598 2017] [php7:error] [pid 24593] [client 10.77.150.46:53224] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent('SEARCH_PAGES', Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/management/index.php(23): FOGBase::getClass('FOGPageManager')\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443, referer: http://fog/fog/management/index.php?node=home [Wed Jun 21 13:36:41.030259 2017] [php7:error] [pid 10922] [client 10.77.150.46:53248] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent('SEARCH_PAGES', Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/management/index.php(23): FOGBase::getClass('FOGPageManager')\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443, referer: http://fog/fog/management/index.php?node=home [Wed Jun 21 13:36:42.221974 2017] [php7:error] [pid 1749] [client 10.129.1.27:53953] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent('SEARCH_PAGES', Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/management/index.php(23): FOGBase::getClass('FOGPageManager')\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443, referer: http://fog/fog/management/index.php?node=task&sub=active [Wed Jun 21 13:36:47.606015 2017] [mpm_prefork:notice] [pid 1028] AH00169: caught SIGTERM, shutting down [Wed Jun 21 13:37:23.456720 2017] [mpm_prefork:notice] [pid 2404] AH00163: Apache/2.4.25 (Ubuntu) OpenSSL/1.0.2l configured -- resuming normal operations [Wed Jun 21 13:37:23.456771 2017] [core:notice] [pid 2404] AH00094: Command line: '/usr/sbin/apache2' [Wed Jun 21 13:37:36.762133 2017] [php7:error] [pid 2438] [client 10.130.66.31:35176] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 144 Table './fog/userTracking' is marked as crashed and last (automatic?) repair failed in /var/www/html/fog/lib/db/mysqldump.class.php:580\nStack trace:\n#0 /var/www/html/fog/lib/db/mysqldump.class.php(580): PDO->query('SHOW CREATE TAB...')\n#1 /var/www/html/fog/lib/db/mysqldump.class.php(505): Mysqldump->getTableStructure('userTracking')\n#2 /var/www/html/fog/lib/db/mysqldump.class.php(348): Mysqldump->exportTables()\n#3 /var/www/html/fog/lib/fog/schema.class.php(200): Mysqldump->start('/tmp/fog_backup...')\n#4 /var/www/html/fog/lib/fog/reportmaker.class.php(261): Schema->exportdb('fog_backup_2017...')\n#5 /var/www/html/fog/maintenance/backup_db.php(23): ReportMaker->outputReport()\n#6 {main}\n thrown in /var/www/html/fog/lib/db/mysqldump.class.php on line 580 [Wed Jun 21 13:51:33.234045 2017] [php7:warn] [pid 3001] [client 10.122.150.82:49382] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0 -
@UWPVIOLATOR said in No Login History Clients:
Uncaught PDOException: SQLSTATE[HY000]: General error: 144 Table './fog/userTracking' is marked as crashed and last (automatic?) repair failed in ...This error looks interesting. Never seen this before. Check out this: https://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed (good advices on trying to fix this table)
-
@Sebastian-Roth We have an article for fixing that: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Repair_broken_database
-
Thank you. We will give this a shot in the am. What about those PHP warnings? How can we fix those?
-
The repair worked Thank you all. But what about those other Apache errors? Should we be concerned or how can we fix those?
-
@UWPVIOLATOR the others aren’t concerning. Feel free to fix them though. Google is your friend.
