• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Fog Centralized management issues

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    2
    1.3k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Greg PlamondonG
      Greg Plamondon Testers
      last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        I think I got this.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        218

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project