@fredlwal Yes

@fredlwal instead of ‘password’ type ‘’ (basically nothing in between)

I used this as reference

https://wiki.fogproject.org/wiki/index.php?title=Password_Central

@Tom-Elliott I set the root user password to blank and I am able to use web gui again. I disabled system auto updates just in case for the future.

Thanks for your help!

@Tom-Elliott I guess I am confused. Everything was working fine until today. No changes have been made. Are you saying fog was not setup properly when installed ? When I installed fog I pretty much used defaults as far as I can remember.
Is there a way to get it to work again ?

@Tom-Elliott I did create the user and I was able to reset its password and restarted the service but still getting same error

@Tom-Elliott I did sudo mysql before running command.

Is it possible that the fog user disappeared by itself ? It was working just fine until this morning and no one touches that server other than me. So if I create the user that should fix it ?

Server

• FOG Version: 1.3.4
• OS: Ubuntu 16.04.2

Client

• Service Version:
• OS:

Description

I have been using this server for couple of months now, but this morning I get this error

Database Schema Installer / Updater
Your database connection appears to be invalid. FOG is unable to communicate with the database…

I am unable to use web gui at all.
I did restart my sql service and I did look through this thread but I don’t see anything that fixes it for me
https://forums.fogproject.org/topic/9344/your-database-connection-appears-to-be-invalid/18

This the status of mysql

sudo service mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: active (running) since Fri 2017-04-28 07:10:55 EDT; 39s ago
  Process: 17807 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=e
  Process: 17799 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exi
 Main PID: 17806 (mysqld)
   CGroup: /system.slice/mysql.service
           └─17806 /usr/sbin/mysqld

Apr 28 07:10:54 FOGSERV systemd[1]: Starting MySQL Community Server...
Apr 28 07:10:55 FOGSERV systemd[1]: Started MySQL Community Server.

When I try to reset the password with

ALTER USER 'fog'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPasswordGoesHere';

I get this error

ERROR 1396 (HY000): Operation ALTER USER failed for 'fog'@'localhost'

Any Ideas ?

@Junkhacker Since I got images on external HDD can I just move that and mount on new server and only import databases ?

I looked through the error log file and it has a lot of errors fetching binaries. I guess because I am on unsupported distro version(I get same errors trying to update anything). Is that why the install failed ? At this point it would it make more sense to install from scratch on newer distro ?

I guess my question is can I still use the images I already got ? I got plenty on external HDD, is there a way to export the client image DB and import to new installation (with fog being down). ? Are images made with 1.2.0 compatible with 1.3.4 ?

Server

• FOG Version: 1.2.0
• OS: Mint 16

Client

• Service Version:
• OS:

Description

I tried to update fog from 1.2.0 to 1.3.4 When I run update this is what happens (I am not really linux savvy so please be gentle). Everything was working fine before trying to update (I tried updating because FOG wouldn’t image a lenovo laptop) Any help would be appreciated, right now fog doesn’t work at all

 * Here are the settings FOG will use:
 * Base Linux: Debian
 * Detected Linux Distribution: Ubuntu
 * Server IP Address: 192.168
 * Server Subnet Mask: 
 * Interface: eth0
 * Installation Type: Normal Server
 * Donate: 0
 * Internationalization: 0
 * Image Storage Location: /images
 * Using FOG DHCP: No
 * DHCP will NOT be setup but you must setup your
 | current DHCP server to use FOG for PXE services.

 * On a Linux DHCP server you must set: next-server and filename

 * On a Windows DHCP server you must set options 066 and 067

 * Option 066/next-server is the IP of the FOG Server: (e.g. 192.168.)
 * Option 067/filename is the bootfile: (e.g. undionly.kpxe)


 * Are you sure you wish to continue (Y/N) Y

 * Installation Started

 * Installing required packages, if this fails
 | make sure you have an active internet connection.

 * Adding needed repository....................................OK
 * Preparing Package Manager...................................OK
 * Packages to be installed:

	apache2 bc build-essential cpp curl g++ gawk gcc gzip htmldoc lftp libapache2-mod-php7.1 libc6 libcurl3 m4 mysql-client mysql-server net-tools nfs-kernel-server openssh-server php7.1 php7.1-bcmath php7.1-cli php7.1-curl php7.1-fpm php7.1-gd php7.1-json php7.1-ldap php7.1-mbstring php7.1-mcrypt php7.1-mysql php7.1-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa unzip vsftpd wget xinetd zlib1g 


 * Installing package: apache2.................................Failed! (Will try later)
 * Skipping package: bc........................................(Already Installed)
 * Skipping package: build-essential...........................(Already Installed)
 * Skipping package: cpp.......................................(Already Installed)
 * Installing package: curl....................................Failed! (Will try later)
 * Skipping package: g++.......................................(Already Installed)
 * Skipping package: gawk......................................(Already Installed)
 * Skipping package: gcc.......................................(Already Installed)
 * Skipping package: gzip......................................(Already Installed)
 * Skipping package: htmldoc...................................(Already Installed)
 * Skipping package: lftp......................................(Already Installed)
 * Skipping package: libapache2-mod-php7.1.....................(Does not exist)
 * Skipping package: libc6.....................................(Already Installed)
 * Skipping package: libcurl3..................................(Already Installed)
 * Skipping package: m4........................................(Already Installed)
 * Skipping package: mysql-client..............................(Already Installed)
 * Skipping package: mysql-server..............................(Already Installed)
 * Skipping package: net-tools.................................(Already Installed)
 * Skipping package: nfs-kernel-server.........................(Already Installed)
 * Skipping package: openssh-server............................(Already Installed)
 * Skipping package: php7.1....................................(Does not exist)
 * Skipping package: php7.1-bcmath.............................(Does not exist)
 * Skipping package: php7.1-cli................................(Does not exist)
 * Skipping package: php7.1-curl...............................(Does not exist)
 * Skipping package: php7.1-fpm................................(Does not exist)
 * Skipping package: php7.1-gd.................................(Does not exist)
 * Skipping package: php7.1-json...............................(Does not exist)
 * Skipping package: php7.1-ldap...............................(Does not exist)
 * Skipping package: php7.1-mbstring...........................(Does not exist)
 * Skipping package: php7.1-mcrypt.............................(Does not exist)
 * Skipping package: php7.1-mysql..............................(Does not exist)
 * Skipping package: php7.1-mysqlnd............................(Does not exist)
 * Installing package: php-gettext.............................Failed! (Will try later)
 * Skipping package: sysv-rc-conf..............................(Already Installed)
 * Skipping package: tar.......................................(Already Installed)
 * Skipping package: tftpd-hpa.................................(Already Installed)
 * Skipping package: tftp-hpa..................................(Already Installed)
 * Skipping package: unzip.....................................(Already Installed)
 * Skipping package: vsftpd....................................(Already Installed)
 * Skipping package: wget......................................(Already Installed)
 * Skipping package: xinetd....................................(Already Installed)
 * Skipping package: zlib1g....................................(Already Installed)
 * Updating packages as needed.................................OK
 * Installing now everything is updated........................Failed!

Mod edited to use code box.