I'm stuck! FOG 1.2.0 issues Centos 7. Both server and StorageNode

BardWood

Greetings all,

Here is an outline of issues plaguing me at the moment. Any assistance or pointers to other references appreciated.

Server:
Unicast image up/down is working fine over multiple VLANs. I can re-run the install script without issue. I can connect to the ‘fog’ (MariaDB) db from the command line as root, but not as user ‘fog’. DB DOES have a password but even when I specify the fog user’s PW, it won’t let me in.

All services can be started from command line without error. But when I do a 'systemctl status FOGxxxx (any of the FOG services) I get a bunch of noise about mysql

ALA
[root@SF-FOG-V ~]# systemctl status FOGImageReplicator -l
● FOGImageReplicator.service - SYSV: Startup/shutdown script for the FOG Multicast Management service.
Loaded: loaded (/etc/rc.d/init.d/FOGImageReplicator)
Active: active (exited) since Wed 2016-02-17 16:47:29 PST; 33min ago
Docs: man:systemd-sysv-generator(8)
Process: 1062 ExecStart=/etc/rc.d/init.d/FOGImageReplicator start (code=exited, status=0/SUCCESS)

Feb 17 16:47:28 SF-FOG-V systemd[1]: Starting SYSV: Startup/shutdown script for the FOG Multicast Management service…
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: Starting FOGImageReplicator: [ OK ]
Feb 17 16:47:29 SF-FOG-V systemd[1]: Started SYSV: Startup/shutdown script for the FOG Multicast Management service…
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: PHP Warning: mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 64
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 165
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 89
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 180
Feb 17 16:47:29 SF-FOG-V FOGImageReplicator[1062]: PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /var/www/html/fog/lib/db/MySQL.class.php on line 150
Feb 17 17:20:24 SF-FOG-V systemd[1]: Started SYSV: Startup/shutdown script for the FOG Multicast Management service…

I upgraded to PHP 5.6 on both master and storage hoping that would fix stuff but alas, no change. The errors for the other FOG services, when invoked with ‘status’ are similar. In all cases, ‘systemctl start FOGXXXX’ starts the service(s) without complaining.

On master, I’ve added the StorageNode and am able to see StorageNode host stats and disk info as it should be. But no replication ever occurs in the logs.

On StorageNode, also Centos 7, no images ever populate /images or /fog_images which I created. .mntcheck exists in /images & images/dev (ditto for my second set of folders). I’ve tried it as a member of the default group, and a member (‘is master’ unchecked) of a second storage group.

I can see the NFS shares of both machines over the network and mount them. I can FTP ‘to and from’ without issue.

If anyone can give me an educated guess of where to check next or any other info needed from me please let me know. Or even a better logging method (surprisingly light on details so I must be looking in the wrong place).

THX all,
Bard

Wayne Workman

I added notes to our “Troubleshoot MYSQL” wiki article about manually recreating MySQL users. It’s a hot mess because I haven’t finished the article yet, but you can find it here: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

Try to recreate the fog user, and then try to manually log into mysql using the newly created user. If that works, then use that info when installing fog.

Wayne Workman

The “Troubleshoot MySQL” wiki article is complete. https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

Sebastian Roth

@BardWood Did you get this solved? Please help the community by describing how you solved this!

BardWood

@Sebastian-Roth Yes and no. I reverted to Centos 6.7 and all is good. To be fair there is a big disclaimer at the top of the ‘FOG on Centos 7’ page but the fix described didn’t work for me.

–bw

Wayne Workman

@BardWood The centOS 7 articles are very poorly written, confusing, and outdated.

You’d be better off following the Fedora 21 Server article when installing on CentOS 7, it’s clear, concise, and up to date.

I’m going to blast the CentOS 7 articles soon and re-write them - it will be 95% copied from the Fedora 21 Server article. I’ve only held off from doing it this long because other people wanted to do it and I have been patiently waiting for them to do it - but no such luck.