The only way I could find to clear it was through the database.
You could use the event scheduler to automatically clear the table.
Here’s what I came up with to remove completed tasks older than a month.
USE fog;
CREATE EVENT clear_snapinTasks
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MONTH
DO
DELETE FROM fog.snapinTasks WHERE stCompleteDate < DATE_SUB(NOW(), INTERVAL 1 MONTH);
Is mysql running? You can typically check by running service mysqld status
If so, can you log into mysql using the credentials in config.class.php?
Grep your credentials with:grep DATABASE /var/www/html/fog/lib/fog/config.class.php
root@Fed-Fog:~# grep DATABASE /var/www/html/fog/lib/fog/config.class.php
define('DATABASE_TYPE', 'mysql'); // mysql or oracle
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'fog');
define('DATABASE_USERNAME', 'fog');
define('DATABASE_PASSWORD', "password");
Test your connection with:mysql -u fog -p
root@Fed-Fog:~# mysql -u fog -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 10385683
Server version: 5.5.50-0+deb8u1 (Debian)
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]>
To continue on with @THEMCV 's solution.
Either change the following in 000-default.conf
DocumentRoot /var/www/html to DocumentRoot /var/www
or the block @THEMCV posted would change to:
a2ensite 000-default
service apache restart
mkdir /var/www/html/dban
mount -t iso9660 -o loop /iso/dban.iso /var/www/html/dban```First, I haven’t tested this. If I had a usb drive laying around I’d gladly test it first.
Do you know how many partitions you have in your image?
On your server you can run ls /images/W7PUniversalx64STANDARD
I only have one partition, here is my output:
root@Fed-Fog:~# ls /images/StaffWindows10/
d1.fixed_size_partitions d1.mbr d1.minimum.partitions d1.original.fstypes
d1.original.swapuuids d1p1.img d1.partitions
My thoughts:
Set up a bootable linux usb. It needs to have at least partclone and pigz installed.
Copy the d1p1.img file to a usable spot on the drive at /images/d1p1.img for ease.
Boot the machine from the usb
Partition disk correctly, and create filesystem
Write the image to the hard drive using:
cat /images/d1p1.img | pigz -dc | partclone.restore --ignore_crc -O /dev/sda1 -N -f 1
I’ll bring a drive tomorrow to test and follow up.
Those having issues, do you have any errors in your Apache logs?
Fedora/CentOS
tail /var/log/httpd/error_log
Debian/Ubuntu
tail /var/log/apache2/error.log
The package is subversion on Debian.
sudo apt-get update && sudo apt-get install subversion
Give this a try: https://forums.fogproject.org/topic/5264/peek-into-img-files/4
@cml said:
It seems like it would be easier to just restore the image to a client, but I had to find a way.
All of this is done on Debian 7 and like Wayne I would not advise you doing this on your production server.
Breakdown:
Install ntfs-3g, partclone, and pigz
Decompress image and restore to a file
Mount imageapt-get install ntfs-3g partclone pigz cd /images/SecurityE420s/ cat d1p2.img | pigz -d -c | partclone.restore -C -s - -O d1p2_extracted.img mount -t ntfs-3g d1p2_extracted.img /mnt ls -lah /mnt total 6.9G drwxrwxrwx 1 root root 4.0K Aug 27 2014 . drwxr-xr-x 28 root root 4.0K Jun 18 17:15 .. lrwxrwxrwx 2 root root 60 Jul 14 2009 Documents and Settings -> /mnt/Users -rwxrwxrwx 1 root root 9.5K Aug 28 2014 fog.log -rwxrwxrwx 1 root root 3.0G Aug 28 2014 hiberfil.sys drwxrwxrwx 1 root root 0 Aug 27 2014 Intel drwxrwxrwx 1 root root 0 Jun 11 2014 MSOCache -rwxrwxrwx 1 root root 4.0G Aug 28 2014 pagefile.sys drwxrwxrwx 1 root root 0 Jul 13 2009 PerfLogs drwxrwxrwx 1 root root 4.0K Aug 28 2014 ProgramData drwxrwxrwx 1 root root 8.0K Aug 27 2014 Program Files drwxrwxrwx 1 root root 8.0K Aug 27 2014 Program Files (x86) -rwxrwxrwx 1 root root 3.1K Aug 28 2014 QcOSD.txt drwxrwxrwx 1 root root 0 Aug 26 2014 $Recycle.Bin drwxrwxrwx 1 root root 4.0K Jun 11 2014 System Volume Information drwxrwxrwx 1 root root 4.0K Nov 20 2010 Users drwxrwxrwx 1 root root 40K Aug 28 2014 Windows
Can you get to a terminal on your server?
https://wiki.fogproject.org/wiki/index.php?title=Reset_WebUI_FOG_password
Everything is in the link Wayne posted. Specifically, https://wiki.fogproject.org/wiki/index.php/Troubleshoot_FTP#Permissions and https://wiki.fogproject.org/wiki/index.php/Troubleshoot_FTP#Credentials_.2F_Passwords
Let us know if you continue to run into issues.