Fog Centralized management issues
-
I am trying to setup fog in centralized management mode and I am running into some issues with clients on the remote end. I have set the tftp server for the remote client to point to the central fog server. I can register the hosts, image them but fog will not join the PC to the domain or install snapins. it also will not “record” the hardware inventory to the fog server. I see that the hardware inventory takes place but it doesn’t update the server.
I have some errors in the log.
This message repeats in the/var/log/apache2/error.log 10.10.111.110 is the client that i am imaging
[CODE][Tue Jul 08 10:38:51 2014] [error] [client 10.10.111.110] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
[Tue Jul 08 10:38:51 2014] [error] [client 10.10.111.110] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180
[Tue Jul 08 10:38:51 2014] [error] [client 10.10.111.110] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Tue Jul 08 10:38:51 2014] [error] [client 10.10.111.110] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[/CODE]/var/log/syslog:
[CODE]Jul 8 10:38:52 10fogserver mysqld: Version: ‘5.5.37-0+wheezy1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Debian)
Jul 8 10:38:52 10fogserver mysqld: 140708 10:38:52 [ERROR] /usr/sbin/mysqld: Table ‘./fog/plugins’ is marked as crashed and should be repaired
Jul 8 10:38:52 10fogserver mysqld: 140708 10:38:52 [ERROR] /usr/sbin/mysqld: Table ‘./fog/plugins’ is marked as crashed and should be repaired
Jul 8 10:38:52 10fogserver mysqld: 140708 10:38:52 [Warning] Checking table: ‘./fog/plugins’
Jul 8 10:38:52 10fogserver /etc/mysql/debian-start[3147]: Upgrading MySQL tables if necessary.
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/hosts’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/hosts’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [Warning] Checking table: ‘./fog/hosts’
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/globalSettings’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/globalSettings’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [Warning] Checking table: ‘./fog/globalSettings’
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/moduleStatusByHost’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/moduleStatusByHost’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [Warning] Checking table: ‘./fog/moduleStatusByHost’
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/tasks’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [Warning] Checking table: ‘./fog/tasks’
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [ERROR] /usr/sbin/mysqld: Table ‘./fog/snapinJobs’ is marked as crashed and should be repaired
Jul 8 10:38:53 10fogserver mysqld: 140708 10:38:53 [Warning] Checking table: ‘./fog/snapinJobs’
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3151]: /usr/bin/mysql_upgrade: the ‘–basedir’ option is always ignored
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3151]: Looking for ‘mysql’ as: /usr/bin/mysql
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3151]: Looking for ‘mysqlcheck’ as: /usr/bin/mysqlcheck
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3151]: This installation of MySQL is already upgraded to 5.5.37, use --force if you still need to run mysql_upgrade
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3449]: Checking for insecure root accounts.
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3454]: WARNING: mysql.user contains 3 root accounts without password!
Jul 8 10:38:55 10fogserver /etc/mysql/debian-start[3455]: Triggering myisam-recover for all MyISAM tables
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/groupMembers’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/groupMembers’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/groups’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/groups’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/history’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/history’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/imagingLog’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/imagingLog’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/location’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/location’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/locationAssoc’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/locationAssoc’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/nfsFailures’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/nfsFailures’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/nfsGroupMembers’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/nfsGroupMembers’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/snapinAssoc’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/snapinAssoc’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/snapinTasks’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/snapinTasks’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/snapins’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/snapins’
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [ERROR] /usr/sbin/mysqld: Table ‘./fog/userTracking’ is marked as crashed and should be repaired
Jul 8 10:38:56 10fogserver mysqld: 140708 10:38:56 [Warning] Checking table: ‘./fog/userTracking’
Jul 8 10:39:01 10fogserver /USR/SBIN/CRON[3614]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null ; -delete)
Jul 8 10:41:52 10fogserver in.tftpd[5397]: tftp: client does not accept options
Jul 8 10:49:05 10fogserver in.tftpd[5617]: tftp: client does not accept options
Jul 8 10:49:42 10fogserver in.tftpd[5641]: tftp: client does not accept options
[/CODE]Any help would be appreciated.
Thanks. -
I think I got this.
