I re-ran the installation. Everything was working properly. I rebooted the server. the same issues came back. Re-ran installation, issue fixed. How do I make sure all of the required services are running?
Posts made by TaTa
-
RE: FOG installation errors
-
RE: FOG installation errors
@Daniel-Miller I was able to update database schema. I have to created the account with localhost and altered fogstorage account and set the host to ‘%’ but storage node and create new image still didn’t work. Then I deleted fogstorage and fog database and uninstalled fog and then reinstalled FOG and was able to update database schema without issue. But Storage node and creating new image still don’t work. I’m pretty sure there are some settings in mysql that is causing this.
-
RE: FOG installation errors
@Daniel-Miller I did flush privileges a few times before reporting it. I even restarted the server a few times/ stopped/started mysql but no go.
-
RE: FOG installation errors
@Daniel-Miller You are right. I checked my other fog server and it does have a wildcard but this one is localhost.
i’m getting this error when creating one using the wildcard (after dropping fogstorage user).
ERROR 1396 (HY000): Operation CREATE USER failed for ‘fogstorage’@‘%’±--------------±--------------+
| user | host |
±--------------±--------------+
| root | [myserverIP |
| fogstorage | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
±--------------±--------------+ -
RE: FOG installation errors
@Daniel-Miller mysql does not allow using the wildcard. How do i get around it? This might be related to freezing screen when clicking on “Create New Image” and “No master nodes available” when listing all images?
-
RE: FOG installation errors
I was able to go pass that stage by changing ‘%’ to localhost. I’m not sure if it does any harm. I’m getting “Storage Node Update Warning Unable to connect using ip, user, and/or password provided!” I confirmed that fogproject account has proper access to /images folder. Any thoughts?
-
RE: FOG installation errors
I took are of password policy issue but getting a new error
“HY000”,1396,“Operation CREATE USER failed for ‘fogstorage’@‘%’”]. It doesn’t look like empty hostname as ‘%’.
-
RE: FOG installation errors
@Tom-Elliott Thank you Tom. It looks like password for fogstorage account password does not meet password policy requirement. Where do I go to change it? I searched in the forums and it looks like there is a fix for it by disabling password validation in mysql https://forums.fogproject.org/topic/11378/fog-show-me-blank-page-on-fresh-install-ubuntu-16-04/12. It would be more ideal if I can change it to a stronger password to meet password policy.
Update ID: 16 Database Error: Failed to query: Error: SQLSTATE[HY000]: General error: 1819 Your password does not satisfy the current policy requirements Error Message: Error Code: "HY000", Error Message: ["HY000",1819,"Your password does not satisfy the current policy requirements"], Debug: SQL: [58] CREATE USER 'fogstorage'@'%' IDENTIFIED BY 'fs30609984138' Params: 0
-
RE: FOG installation errors
@Daniel-Miller fog schema update or similar name does not exist in /var/log/fog. Could it be somewhere that I’m not aware of?
-
RE: FOG installation errors
@Sebastian-Roth Thank you for pointing me to the right direction. It was mysqld.pid file that was missing. I created it and re-ran the installation and reached to the point where it asks to update database schema but getting
Schema Update Fail. Unable to update schema
. I put in the same password during the installation where it asked “Is the MySQL password blank?”. I’m able to mysql -u root -p and put in that same password. -
RE: FOG installation errors
/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.
-
RE: FOG installation errors
@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.
-
RE: FOG installation errors
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.
-
RE: FOG installation errors
@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.
-
RE: FOG installation errors
@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.
-
RE: FOG installation errors
@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? -
RE: FOG installation errors
@Sebastian-Roth I get ls: cannot access /var/lib/mysql*: No such file or directory.
-
RE: FOG installation errors
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