Cant upload snapins anymore



  • 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’



  • 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.


  • Senior Developer

    @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.


  • Moderator

    This post is deleted!


  • 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



  • 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.


  • Moderator

    @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



  • 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


  • Moderator

    @Darrell-Lanson

    sudo mysqlcheck -u fog -p fog
    Enter password: (type your mysql fog user password)
    


  • 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


  • Moderator

    @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)


Log in to reply
 

360
Online

39.3k
Users

11.0k
Topics

104.4k
Posts

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