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

    Cant upload snapins anymore

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    11
    4.7k
    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.
    • D
      Darrell Lanson
      last edited by

      So I discovered I couldn’t upload snapins and I found this error I have no idea on how to fix any help would be appreciated I am thinking this happened while I was imaging a computer and the power went out but don’t know the commands to do a repair.

      8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/groups’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/groups’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/history’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/history’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/hosts’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/hosts’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/images’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/images’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/imagingLog’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/imagingLog’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/inventory’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/inventory’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/tasks’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/tasks’
      150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/userTracking’ is marked as crashed and should be repaired
      150626 8:22:07 [Warning] Checking table: ‘./fog/userTracking’

      Ubuntu 14.04.5 LTS 64bit
      Fog 1.5.3

      ch3iC Wayne WorkmanW 2 Replies Last reply Reply Quote 0
      • ch3iC
        ch3i Moderator @Darrell Lanson
        last edited by

        @Darrell-Lanson said:

        So I discovered I couldn’t upload snapins and I found this error I have no idea on how to fix any help would be appreciated I am thinking this happened while I was imaging a computer and the power went out but don’t know the commands to do a repair.

        8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/groups’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/groups’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/history’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/history’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/hosts’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/hosts’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/images’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/images’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/imagingLog’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/imagingLog’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/inventory’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/inventory’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/tasks’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/tasks’
        150626 8:22:07 [ERROR] /usr/sbin/mysqld: Table ‘./fog/userTracking’ is marked as crashed and should be repaired
        150626 8:22:07 [Warning] Checking table: ‘./fog/userTracking’

        Can you check your database integrity ? (https://dev.mysql.com/doc/refman/5.1/en/check-table.html)

        1 Reply Last reply Reply Quote 0
        • D
          Darrell Lanson
          last edited by

          I am unsure of the default DB name or the table names that have been used so I wouldn’t know what to type in exactly

          Ubuntu 14.04.5 LTS 64bit
          Fog 1.5.3

          ch3iC 1 Reply Last reply Reply Quote 0
          • ch3iC
            ch3i Moderator @Darrell Lanson
            last edited by ch3i

            @Darrell-Lanson

            sudo mysqlcheck -u fog -p fog
Enter password: (type your mysql fog user password)
            1 Reply Last reply Reply Quote 0
            • D
              Darrell Lanson
              last edited by

              I get this error but I know the password is correct I can still make upload and download images just can’t use the snapins so is my password corrupted somehow now

              Got error 1045: acess denied for user fog@localhost using password yes when trying to connect

              Ubuntu 14.04.5 LTS 64bit
              Fog 1.5.3

              ch3iC 1 Reply Last reply Reply Quote 0
              • ch3iC
                ch3i Moderator @Darrell Lanson
                last edited by

                @Darrell-Lanson said:

                I get this error but I know the password is correct I can still make upload and download images just can’t use the snapins so is my password corrupted somehow now

                Got error 1045: acess denied for user fog@localhost using password yes when trying to connect

                Try to install phpmyadmin, there are some tools to check repair tables :

                sudo apt-get install phpmyadmin

                It have a user friendly interface, after install go to : http://your_server_fog/phpmyadmin

                1 Reply Last reply Reply Quote 0
                • D
                  Darrell Lanson
                  last edited by

                  Ok got the database working properly but now when I go to upload the snapin when I click on Add it just refreshes the page with this at the top of the page: “Please enter a name to give this Snapin!” Its like something else is wrong now almost like its not pulling the name I entered with it.

                  Ubuntu 14.04.5 LTS 64bit
                  Fog 1.5.3

                  1 Reply Last reply Reply Quote 0
                  • D
                    Darrell Lanson
                    last edited by

                    Ok now I found this in the Apache error log not sure what it means though
                    ttp://10.2.8.5/fog/management/index.php?node=snapin&sub=add
                    [Fri Jun 26 14:07:45 2015] [error] [client 10.2.8.61] PHP Warning: POST Content-Length of 10593868 bytes exceeds the limit of 8388608 bytes in Unknown on line 0, referer: http://10.2.8.5/fog/management/index.php?node=snapin&sub=add

                    Ubuntu 14.04.5 LTS 64bit
                    Fog 1.5.3

                    Tom ElliottT 1 Reply Last reply Reply Quote 0
                    • Wayne WorkmanW
                      Wayne Workman @Darrell Lanson
                      last edited by

                      This post is deleted!
                      1 Reply Last reply Reply Quote 0
                      • Tom ElliottT
                        Tom Elliott @Darrell Lanson
                        last edited by Wayne Workman

                        @Darrell-Lanson This sounds like your php configurations options for max upload size and post max filesize need to be setup.

                        SVN does this with a value of 100M (100 Megabytes), but earlier versions did not do this.

                        The way SVN does it is:
                        Debian Variants (as root user)

                        sed -i 's/post_max_size\ \=\ 8M/post_max_size\ \=\ 100M/g' /etc/php5/{apache2,cli}/php.ini
sed -i 's/upload_max_filesize\ \=\ 2M/upload_max_filesize\ \=\ 100M/g' /etc/php5/{apache2,cli}/php.ini
service apache2 restart

                        Redhat Variants (as root user)

                        sed -i 's/post_max_size\ \=\ 8M/post_max_size\ \=\ 100M/g' /etc/php.ini
sed -i 's/upload_max_filesize\ \=\ 2M/upload_max_filesize\ \=\ 100M/g' /etc/php.ini
service httpd restart

                        The things to take note, it only changes the values if the values are set as:

                        post_max_size = 8M
upload_max_filesize = 2M

                        What’s this means is if you set the values yourself, these sed statements will not do anything to the file(s) as the sed replacement does not match

                        You can set these values to whatever you want. Hopefully this helps.

                        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 1
                        • D
                          Darrell Lanson
                          last edited by

                          Now I feel stupid I was positive I changed those settings when I first built my server as I uploaded a lot of snapins prior to this problem but when I checked they were at the default it is now fixed thank you for the help.

                          Ubuntu 14.04.5 LTS 64bit
                          Fog 1.5.3

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

                          176

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project