Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2       115G  3.3G  106G   4% /
devtmpfs        919M     0  919M   0% /dev
tmpfs           928M     0  928M   0% /dev/shm
tmpfs           928M  8.5M  920M   1% /run
tmpfs           928M     0  928M   0% /sys/fs/cgroup
/dev/sdb1       932G  249G  684G  27% /images
/dev/sda1       477M  172M  276M  39% /boot
tmpfs           186M     0  186M   0% /run/user/1000

Gigs worth of space.

Command results:

mysql -u root fog -p
show tables;

+------------------------+
| Tables_in_fog          |
+------------------------+
| aloLog                 |
| clientUpdates          |
| dirCleaner             |
| globalSettings         |
| greenFog               |
| groupMembers           |
| groups                 |
| history                |
| hostAutoLogOut         |
| hostMAC                |
| hostScreenSettings     |
| hosts                  |
| imageGroupAssoc        |
| imagePartitionTypes    |
| imageTypes             |
| images                 |
| imagingLog             |
| inventory              |
| ipxeTable              |
| keySequence            |
| moduleStatusByHost     |
| modules                |
| multicastSessions      |
| multicastSessionsAssoc |
| nfsFailures            |
| nfsGroupMembers        |
| nfsGroups              |
| os                     |
| oui                    |
| plugins                |
| printerAssoc           |
| printers               |
| pxeMenu                |
| scheduledTasks         |
| schemaVersion          |
| snapinAssoc            |
| snapinGroupAssoc       |
| snapinJobs             |
| snapinTasks            |
| snapins                |
| supportedOS            |
| taskLog                |
| taskStates             |
| taskTypes              |
| tasks                  |
| userCleanup            |
| userTracking           |
| users                  |
| virus                  |
+------------------------+
49 rows in set (0.00 sec)

No proxy server. Again, 4/5 worked, but number 5 is not alive.

It’s a physically remote server that I’ve detailed my travails in build 7102 ‘Backing up database … failed’ .

For posterity, what are the precise commands you are suggesting for?

• drop the FOG database from the SQL
• remove the fog folder from /var/html/fog server

Given that it’s running on CentoS 7.

Do I not need to stop services, startups at all?

I’m considering performing a complete uninstallation of FOG trunk on a naughty server, but the wiki article for uninstalling FOG is a bit dated.

What would the latest, greatest method be ?

So far I’ve tried updating to 7102, 7104 and 7106 on this server and it continues to fail at Backing up database.

My fresh iron build using the same source files and installed identically, works. yargen.

A little help? What has broken on this naughty server?

I’m building a duplicate server right now from the same source files to see what shakes out.

Visiting the server via another session, while it was stuck on backing up database, I tried:

systemctl restart mysql.service
systemctl restart httpd.service
systemctl restart httpd

No change.

So far everything appears to still be working. I can export hosts, images, settings. This particular server was a recent rebuild from fresh iron and doesn’t have any hosts yet so that export is 0 KB .

I can actually visit the schema updater page and click through it. Even though the installer has bailed, the server appears to be working fine. …

Updating to build 7102 from 6821 has worked on 5 other servers so far, but I have one that insists on failing at …

Backing up database.........................................Failed!

From /opt/trunksvn/fogproject/bin/error_logs

Apr 07 00:01:21 xyzfog systemd[1]: Starting The PHP FastCGI Process Manager...
Apr 07 00:01:21 xyzfog systemd[1]: Started The PHP FastCGI Process Manager.
--2016-04-07 00:01:23--  http://172.19.244.32/fog//management/export.php?type=sql
Connecting to 172.19.244.32:80... connected.
HTTP request sent, awaiting response... Read error (Connection reset by peer) in headers.
Retrying.
... Giving up. after 20 attempts

Also /var/log/httpd/error_log:

[Wed Apr 06 23:32:53.046956 2016] [:error] [pid 2919] [client 192.168.54.120:57605] PHP Warning:  mysqli::real_connect(): MySQL server has gone away in /var/www/html/fog/lib/db/mysql.class.php on line 29
[Wed Apr 06 23:32:57.487734 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::real_connect(): MySQL server has gone away in /var/www/html/fog/lib/db/mysql.class.php on line 29
[Wed Apr 06 23:32:57.487869 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 29
[Wed Apr 06 23:32:57.487883 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::set_charset(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 30
[Wed Apr 06 23:32:57.487896 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 39
[Wed Apr 06 23:32:57.487915 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 39
[Wed Apr 06 23:32:57.487927 2016] [:error] [pid 2852] [client 172.22.57.44:49402] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 51

Each server is identically configured on CentOS7, although … The first 4 servers were originally installed onto CentOS7.1.1503, this one was originally built upon CentOS7.2.1511.

Six of one …

If I use a “+” in an image name, the resulting image path as displayed by FOG includes the +, but the real directory created uses a < space > .

Image name = “abcd_+_"
Image path = "abcd_+_"
Real directory = "abcd_ _"

Leads to chaining path errors etc.

That did the trick. Thank you!

Tried again with build 6687. Same results.
Snipped from bottom of /opt/trunkgit/fogproject/bin/error_logs/fog_error_6687.log

Getting CA Private Key
ln: failed to create symbolic link ‘/var/www/html/fog/fog’: File exists
Job for httpd.service failed because the control process exited with error code. See "systemctl status httpd.service" and "journalctl -xe" for details.
● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2016-03-11 15:27:03 EST; 2s ago
     Docs: man:httpd(8)
           man:apachectl(8)
  Process: 4345 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=1/FAILURE)
  Process: 4337 ExecStart=/usr/sbin/httpd $OPTIONS -DFOREGROUND (code=exited, status=1/FAILURE)
 Main PID: 4337 (code=exited, status=1/FAILURE)

Mar 11 15:27:03 devfog systemd[1]: Starting The Apache HTTP Server...
Mar 11 15:27:03 devfog httpd[4337]: AH00526: Syntax error on line 15 of /etc/httpd/conf.d/fog.conf:
Mar 11 15:27:03 devfog httpd[4337]: SSLCertificateKeyFile: file '/etc/httpd/\\/opt\\/fog\\/snapins\\/ssl\\/.srvprivate.key' does not exist or is empty
Mar 11 15:27:03 devfog systemd[1]: httpd.service: main process exited, code=exited, status=1/FAILURE
Mar 11 15:27:03 devfog kill[4345]: kill: cannot find process ""
Mar 11 15:27:03 devfog systemd[1]: httpd.service: control process exited, code=exited status=1
Mar 11 15:27:03 devfog systemd[1]: Failed to start The Apache HTTP Server.
Mar 11 15:27:03 devfog systemd[1]: Unit httpd.service entered failed state.
Mar 11 15:27:03 devfog systemd[1]: httpd.service failed.

● php-fpm.service - The PHP FastCGI Process Manager
   Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2016-03-11 15:27:03 EST; 2s ago
 Main PID: 4338 (php-fpm)
   Status: "Ready to handle connections"
   CGroup: /system.slice/php-fpm.service
           ├─4338 php-fpm: master process (/etc/php-fpm.conf
           ├─4339 php-fpm: pool www
           ├─4340 php-fpm: pool www
           ├─4341 php-fpm: pool www
           ├─4342 php-fpm: pool www
           └─4343 php-fpm: pool www

Mar 11 15:27:03 devfog systemd[1]: Starting The PHP FastCGI Process Manager...
Mar 11 15:27:03 devfog systemd[1]: Started The PHP FastCGI Process Manager.

Any update on this?

Performing an in-place upgrade on a build 6403 to build 6683, installation halts at …

 * Resetting SSL Permissions...................................OK
 * Setting up SSL FOG Server...................................OK
 * Restarting Apache2 for fog vhost............................Failed!

From /var/log/httpd/error_log (CentOS 7.1)

PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 115
PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 116

Build 6351 did the trick. Thank you again for a great response time.

Build 6349 passes muster. A big thank you for your prompt attention.

It didn’t, but I’ll try it again.