/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.

@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.

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 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.

@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.

@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 I get ls: cannot access /var/lib/mysql*: No such file or directory.

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

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

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

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

@Sebastian-Roth You are absolutely correct. This server was built and is managing by another team outside of our institution. We don’t have direct control over it.

Hello All,

I’m getting some issues with installation FOG on RHEL7.7 (I have a working box with Debian but we have to migrate it to RHEL due to some policy reason). The installation stop at Installing now everything is updated ........Failed…Upon inspecting fog_error_1.5.7.50.log, I saw a bunch of errors like this:

Update notice FEDORA-EPEL-2014-4398 (from epel) is broken, or a bad duplicate, skipping.
Update notice FEDORA-EPEL-2019-4e237c3a93 (from epel) is broken, or a bad duplicate, skipping.
Update notice FEDORA-EPEL-2016-b072b4c9c7 (from epel) is broken, or a bad duplicate, skipping.

and

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

Does anyone have any experience or has anyone encountered this similar issues?

Thanks in advance for any assistance.

@Sebastian-Roth Thank you very much. We had an outage last week so I didn’t have time to follow up. I just upgraded to latest dev-branch and things are working now. Advanced menu is working as it was before. Thanks everyone involved!

@Sebastian-Roth Whenever I selected Advanced Menu and signed in, the machine will either beep or display a black screen (sounded like missing RAM beeping sound). I installed dev-branch on a test server with fresh installed ubuntu 18.04 with same issues.

@kafluke It happens to me too. Also on the latest dev-branch, Advance Menu has stopped working.

@Sebastian-Roth @Wayne-Workman Thank you for reminding me about another DHCP server. I double checked with our network admin and we found the old IP in DHCP server. We did some tests before but couldn’t get pxe to work so we opted for dnsmasq option and left the IP there.
Thank you again for your help!

We have to migrate our servers to a different building so we need to change our FOG IP. I follow instructions to change the server IP and IP in FOG website as instructed in here: https://forums.fogproject.org/topic/10841/problems-after-changing-fog-server-ip/2. I even ran updateIP tool and reran the installation several times. Client boots up fine but when it gets the palce to download default.ipxe file through tftp, it is still looking for the OLD server IP. FOG is running on Debian 8.11 with DNSMASQ 2.76. I checked dnsmasq configuration file and it does have the new IP and it’s not providing tftp service. I’m using tftpd-hpa for TFTP service . config.class.php does have the new IP as well. What am I missing here?

Thanks in advance for your helps or suggestions.

@nsherin I didn’t use any other files beside the ones came with 18.04.1 LTS. Can you re-extract all files in 18.04.1LTS iso and then reupload them back to /images/os/ubuntu/18.04/mate. You might need to add this line to your /etc/exports file and restart nfs services or restart your fog server.

/images/os/ubuntu/18.04/mate *(ro,sync,no_wdelay,insecure_locks,no_root_squash,insecure)

Internet connection is still an issue with this method. You need to go to /etc/network/interfaces and change from manual to dhcp then restart your interface sudo /etc/init.d/networking restart

You need to add initrd=initrd.lz. I found it here: https://forums.fogproject.org/topic/11063/ubuntu-17-10-desktop-pxe-boot-no-internetl and it worked for me.

Your code should look something like this.

kernel nfs://192.168.0.14/images/os/ubuntu/18.04/mate/casper/vmlinuz
initrd nfs://192.168.0.14/images/os/ubuntu/18.04/mate/casper/initrd.lz 
imgargs vmlinuz initrd=initrd.lz root=/dev/nfs boot=casper netboot=nfs nfsroot=192.168.0.14:/images/os/ubuntu/18.04/mate/ locale=en_GB.UTF-8 keyboard-configuration/layoutcode=gb quiet splash toram ip=dhcp rw
boot || goto MENU