FOG installation errors
-
@TaTa If you have NFS shares, FTP, Apache, TFTP services running on that server the FOG installer might mess up those configs.
-
I’m getting
Installing package: mariadb-server..........................Failed! (Will try later)
-
@TaTa Please upload the latest install error log here so we can have a look.
-
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
-
@TaTa Ok, let’s see what you have installed already:
rpm -qa | grep -i -e "mysql" -e "mariadb"
-
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
-
@TaTa Wow, that seems like a little mess. There is
mariadb101u-config
which comes from the IUS repo and then you havemysql-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 runls -al /var/lib/mysql*
to see if there are some DB files left. Just to get the full picture. -
@Sebastian-Roth I get ls: cannot access /var/lib/mysql*: No such file or directory.
-
@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. Usefind /etc -iname "*my*"
to get a list of files to backup.Then run
yum remove mariadb101u-config
and changefogproject/lib/redhat/config.sh
again. Put inmysql-community-client mysql-community-server
instead ofmariadb mariadb-server
and re-run the installer. -
@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? -
@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 figure12
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!
-
@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.
-
@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=
. -
@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.
-
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.
-
@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.
-
@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-installInstructions for setting SELinux to permissive or disabled can be found at https://wiki.fogproject.org/wiki/index.php?title=CentOS_7
-
@Daniel-Miller Thank you for your replies. I already set it to permissive. Changing line 1262 to
echo -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.
-
@TaTa I think your server config file should be at
/etc/my.cnf.d/server.cnf
.
Can you post the output ofsystemctl status mysqld.service
andjournalctl -xe
? -
/etc/my.cnf.d/ exists but it contains no files.
systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: activating (start) since Wed 2019-11-13 11:34:24 EST; 3s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 44776 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Control: 44806 (mysqld) CGroup: /system.slice/mysqld.service ├─44806 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --skip... └─44809 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --skip... Nov 13 11:34:24 fogprodapp01 systemd[1]: Starting MySQL Server...
-- Unit mysqld.service has failed. -- -- The result is failed. Nov 13 11:35:30 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state. Nov 13 11:35:30 fogprodapp01 systemd[1]: mysqld.service failed. Nov 13 11:35:30 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart. Nov 13 11:35:30 fogprodapp01 systemd[1]: Stopped MySQL Server. -- Subject: Unit mysqld.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has finished shutting down. Nov 13 11:35:30 fogprodapp01 systemd[1]: Starting MySQL Server... -- Subject: Unit mysqld.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has begun starting up. Nov 13 11:35:33 fogprodapp01 nrpe[45775]: warning: /etc/hosts.deny, line 13: missing newline or Nov 13 11:35:34 fogprodapp01 mysqld[45781]: Unable to determine if daemon is running: No such f Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service: control process exited, code=exited st Nov 13 11:35:34 fogprodapp01 systemd[1]: Failed to start MySQL Server. -- Subject: Unit mysqld.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has failed. -- -- The result is failed. Nov 13 11:35:34 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state. Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service failed. Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart. Nov 13 11:35:34 fogprodapp01 systemd[1]: Stopped MySQL Server. -- Subject: Unit mysqld.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has finished shutting down. Nov 13 11:35:34 fogprodapp01 systemd[1]: Starting MySQL Server... -- Subject: Unit mysqld.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has begun starting up. [root@fogprodapp01 my.cnf.d]# [root@fogprodapp01 my.cnf.d]# clear [root@fogprodapp01 my.cnf.d]# journalctl -xe -- Subject: Unit mysqld.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has failed. -- -- The result is failed. Nov 13 11:36:00 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state. Nov 13 11:36:00 fogprodapp01 systemd[1]: mysqld.service failed. Nov 13 11:36:00 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart. Nov 13 11:36:00 fogprodapp01 systemd[1]: Stopped MySQL Server. -- Subject: Unit mysqld.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has finished shutting down. Nov 13 11:36:00 fogprodapp01 systemd[1]: Starting MySQL Server... -- Subject: Unit mysqld.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has begun starting up. Nov 13 11:36:04 fogprodapp01 mysqld[46228]: Unable to determine if daemon is running: No such f Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service: control process exited, code=exited st Nov 13 11:36:04 fogprodapp01 systemd[1]: Failed to start MySQL Server. -- Subject: Unit mysqld.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has failed. -- -- The result is failed. Nov 13 11:36:04 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state. Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service failed. Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart. Nov 13 11:36:04 fogprodapp01 systemd[1]: Stopped MySQL Server. -- Subject: Unit mysqld.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has finished shutting down. Nov 13 11:36:04 fogprodapp01 systemd[1]: Starting MySQL Server... -- Subject: Unit mysqld.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has begun starting up.