FOG installation errors

[Sebastian Roth]

@TaTa I don’t think it’s a good idea to install FOG on such a server!

That said we can still help you do this. Edit the file fogproject/lib/redhat/config.sh and jump to line 40. Change mysql mysql-server in that line to mariadb mariadb-server .

This is on your own risk!

[TaTa]

@Sebastian-Roth Thank you. What are the risks?

[Sebastian Roth]

@TaTa If you have NFS shares, FTP, Apache, TFTP services running on that server the FOG installer might mess up those configs.

[TaTa]

I’m getting Installing package: mariadb-server..........................Failed! (Will try later)

[Sebastian Roth]

@TaTa Please upload the latest install error log here so we can have a look.

[TaTa]

Last few lines in error log:

Package(s) mariadb available, but not installed.
Package(s) mariadb-server available, but not installed.
No packages marked for update
Loaded plugins: package_upload, product-id, search-disabled-repos, subscription-
              : manager
Package mariadb-server is obsoleted by mysql-community-server, trying to install mysql-community-server-5.7.26-1.el7.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.26-1.el7 will be installed
--> Processing Conflict: 1:mariadb101u-config-10.1.35-1.ius.el7.x86_64 conflicts mysql-community-server
--> Finished Dependency Resolution
Error: mariadb101u-config conflicts with mysql-community-server-5.7.26-1.el7.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

[Sebastian Roth]

@TaTa Ok, let’s see what you have installed already: rpm -qa | grep -i -e "mysql" -e "mariadb"

[TaTa]

mysql-community-libs-5.7.26-1.el7.x86_64
php-mysqlnd-7.2.24-1.el7.remi.x86_64
mysql-community-libs-compat-5.7.26-1.el7.x86_64
mariadb101u-config-10.1.35-1.ius.el7.x86_64
mysql-community-devel-5.7.26-1.el7.x86_64
nagios-plugins-mysql-2.2.2-2.20190926git1b8ad57.el7.x86_64
mysql-community-client-5.7.26-1.el7.x86_64
mysql-community-common-5.7.26-1.el7.x86_64

[Sebastian Roth]

@TaTa Wow, that seems like a little mess. There is mariadb101u-config which comes from the IUS repo and then you have mysql-community-... packages installed as well. No ...-server as far as I can see. Do you know if there is meant to be a database server running on this machine? Maybe run ls -al /var/lib/mysql* to see if there are some DB files left. Just to get the full picture.

[TaTa]

@Sebastian-Roth I get ls: cannot access /var/lib/mysql*: No such file or directory.

[Sebastian Roth]

@TaTa Ok, so seems like there never was a DB server installed. To resolve this issue I’d consider removing the package mariadb101u-config manually. As you can see here it should hold the “config file my.cnf and my.cnf.d directory”. Probably best to take backup copies of those files before remove the package. Use find /etc -iname "*my*" to get a list of files to backup.

Then run yum remove mariadb101u-config and change fogproject/lib/redhat/config.sh again. Put in mysql-community-client mysql-community-server instead of mariadb mariadb-server and re-run the installer.

[TaTa]

@Sebastian-Roth Thank you! I’m getting a bit further. The installer can’t set a password for fogproject account due New password: BAD PASSWORD: The password is shorter than 14 characters. Is there a way I can set it manually or change password length in the script so will be 14 characters or more?

[Sebastian Roth]

@TaTa Take a look at fogproject/lib/common/functions.sh line 1261. At the end of the line where it says .../dev/urandom | fold -w12 | head -n1) change the figure 12 to a higher value.

By the way. If you want to install with a proper root password set for the database you will run into an issue with the current version. I hope to get this fixed soon!

[TaTa]

@Sebastian-Roth I changed it to 14 and 16 but is getting this error. Looks like password is not complex enough

Changing shell for fogproject.
New password: BAD PASSWORD: The password contains less than 1 digits
Retype new password: BAD PASSWORD: is too simple
Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.
New password: Retype new password: Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
New password: BAD PASSWORD: The password contains less than 1 uppercase letters
Retype new password: BAD PASSWORD: is too simple
Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.
New password: Retype new password: Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.
New password: Retype new password: Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.

[Daniel Miller]

@TaTa The data being pulled in for the password is out of urandom, so it is not implausible that, as the log indicates, a given line may not include a digit or upper case letter. You may be able to run the installer a few more times and get a random password that conforms to the system’s password requirements. You may also be able to create a partial /opt/fog/.fogsettings with strong passwords compliant with your systems password policies. Format and settings are available in the Wiki. I haven’t tested this, but my understanding is that anything not set in .fogsettings is requested by the installer.

Edit: the setting you are likely interested in is password=.

[TaTa]

@Daniel-Miller I created the files but it’s still not working. This is a new installation. I don’t think it looks into .fogsettings before creating this new account.

[TaTa]

I no longer getting password too simple. It looks like it’s not accepting the password. I can set password for fogproject manually but the installation does not like this account created beforehand.

Changing password for user fogproject.
New password: Retype new password: Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.
New password: Retype new password: Retype new password: Password change aborted.
New password: Password change aborted.
New password: Password change aborted.
passwd: Have exhausted maximum number of retries for service
Changing password for user fogproject.

[Daniel Miller]

@TaTa hmm … weird. You might try using chpasswd instead of passwd. I think that is available in RHEL … maybe by default. If it is, in functions.sh#L1262, change:

echo -e "$password\n$password" | passwd $username >>$workingdir/error_logs/fog_error_${version}.log 2>&1

to

echo -e "$username:$password" | chpasswd >>$workingdir/error_logs/fog_error_${version}.log 2>&1

Don’t have a RHEL system handy to test it with, however.

[Daniel Miller]

@TaTa Actually, what is the result of getenforce?

Was searching around a bit and apparently, SELinux can cause some strange behavior…
https://forums.fogproject.org/topic/6926/setting-up-fog-password-fails-on-clean-new-centos-7-install

Instructions for setting SELinux to permissive or disabled can be found at https://wiki.fogproject.org/wiki/index.php?title=CentOS_7

[TaTa]

@Daniel-Miller Thank you for your replies. I already set it to permissive. Changing line 1262 toecho -e "$username:$password" | chpasswd >>$workingdir/error_logs/fog_error_${version}.log 2>&1 solved setting up passsword issue for fogproject account.

I went to update database schema but getting Database connection unavailable. It looks like mysqld is not starting. In /etc/my.cnf files (I can’t find /etc/mysql/my.cnf), socket is pointing to /var/lib/mysql/mysql.sock. I checked mysql.sock and the file exists.

mysql -u root and mysql -u root -p gave me ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Trying to restart mysql gave me this error: Redirecting to /bin/systemctl restart mysql.service Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.