Cant upload snapins anymore

[Darrell Lanson]

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’

[ch3i]

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

[Darrell Lanson]

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

[ch3i]

@Darrell-Lanson

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

[Darrell Lanson]

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

[ch3i]

@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

[Darrell Lanson]

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.

[Darrell Lanson]

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

[Wayne Workman]

This post is deleted!

[Tom Elliott]

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

[Darrell Lanson]

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.