Fog Centralized management issues


  • Testers

    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.


  • Senior Developer

    I think I got this.


Log in to reply
 

376
Online

39198
Users

10850
Topics

103281
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.