Backing up database failed!
-
Server
- FOG Version: 1.4
- OS: Ubuntu 16.04
Client
- Service Version:
- OS:
Description
Trying to update to latest rev 6069 and server failing on Backing up database
Storage nodes updated fine. -
Can you validate disk space?
Fog often makes a backup of the GUI folders in /home and also stores a copy of the db backup (which is failing here) in the same location under /home/fogDBbackups. There are cases where it’s just failing but typically I’ve found its due to disk space available.
-
@Tom-Elliott Yes space is not a issue Tom i checked that
-
@Raymond-Bell Can you provide the installer’s error log? It should contain some more helpful information. Also the apache error logs?
-
/usr/bin/lsb_release /bin/systemctl /opt/fog/.fogsettings Reading package lists... Building dependency tree... Reading state information... software-properties-common is already the newest version (0.96.20.7). python-software-properties is already the newest version (0.96.20.7). The following packages were automatically installed and are no longer required: libonig2 libqdbm14 snap-confine ubuntu-core-launcher Use 'sudo apt autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 17 May 08:20:29 ntpdate[2407]: adjust time server 45.127.112.2 offset -0.015201 sec gpg: keyring `/tmp/tmp75x8_9b2/secring.gpg' created gpg: keyring `/tmp/tmp75x8_9b2/pubring.gpg' created gpg: requesting key E5267A6C from hkp server keyserver.ubuntu.com gpg: /tmp/tmp75x8_9b2/trustdb.gpg: trustdb created gpg: key E5267A6C: public key "Launchpad PPA for Ondřej Surý" imported gpg: Total number processed: 1 gpg: imported: 1 (RSA: 1) OK gpg: keyring `/tmp/tmpw4d9oo70/secring.gpg' created gpg: keyring `/tmp/tmpw4d9oo70/pubring.gpg' created gpg: requesting key E5267A6C from hkp server keyserver.ubuntu.com gpg: /tmp/tmpw4d9oo70/trustdb.gpg: trustdb created gpg: key E5267A6C: public key "Launchpad PPA for Ondřej Surý" imported gpg: Total number processed: 1 gpg: imported: 1 (RSA: 1) OK Hit:1 http://us.archive.ubuntu.com/ubuntu xenial InRelease Hit:2 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease Hit:3 http://ppa.launchpad.net/ondrej/apache2/ubuntu xenial InRelease Hit:4 http://ppa.launchpad.net/ondrej/php/ubuntu xenial InRelease Get:5 http://us.archive.ubuntu.com/ubuntu xenial-backports InRelease [102 kB] Get:6 http://security.ubuntu.com/ubuntu xenial-security InRelease [102 kB] Fetched 204 kB in 3s (62.6 kB/s) Reading package lists... Reading package lists... Building dependency tree... Reading state information... ntpdate is already the newest version (1:4.2.8p4+dfsg-3ubuntu5.4). software-properties-common is already the newest version (0.96.20.7). python-software-properties is already the newest version (0.96.20.7). The following packages were automatically installed and are no longer required: libonig2 libqdbm14 snap-confine ubuntu-core-launcher Use 'sudo apt autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 17 May 08:20:52 ntpdate[2882]: adjust time server 45.127.112.2 offset -0.001657 sec Generating locales (this might take a while)... en_US.UTF-8... done Generation complete. gpg: keyring `/tmp/tmp6l0objle/secring.gpg' created gpg: keyring `/tmp/tmp6l0objle/pubring.gpg' created gpg: requesting key E5267A6C from hkp server keyserver.ubuntu.com gpg: /tmp/tmp6l0objle/trustdb.gpg: trustdb created gpg: key E5267A6C: public key "Launchpad PPA for Ondřej Surý" imported gpg: Total number processed: 1 gpg: imported: 1 (RSA: 1) OK Hit:1 http://ppa.launchpad.net/ondrej/apache2/ubuntu xenial InRelease Hit:2 http://ppa.launchpad.net/ondrej/php/ubuntu xenial InRelease Get:3 http://security.ubuntu.com/ubuntu xenial-security InRelease [102 kB] Hit:4 http://us.archive.ubuntu.com/ubuntu xenial InRelease Hit:5 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease Get:6 http://us.archive.ubuntu.com/ubuntu xenial-backports InRelease [102 kB] Fetched 204 kB in 2min 1s (1,688 B/s) Reading package lists... ii apache2 2.4.25-3+deb.sury.org~xenial+1 amd64 Apache HTTP Server ii bc 1.06.95-9build1 amd64 GNU bc arbitrary precision calculator language ii build-essential 12.1ubuntu2 amd64 Informational list of build-essential packages ii cpp 4:5.3.1-1ubuntu1 amd64 GNU C preprocessor (cpp) ii curl 7.47.0-1ubuntu2.2 amd64 command line tool for transferring data with URL syntax ii g++ 4:5.3.1-1ubuntu1 amd64 GNU C++ compiler ii gawk 1:4.1.3+dfsg-0.1 amd64 GNU awk, a pattern scanning and processing language ii gcc 4:5.3.1-1ubuntu1 amd64 GNU C compiler ii gzip 1.6-4ubuntu1 amd64 GNU compression utilities ii htmldoc 1.8.27-8ubuntu1 amd64 HTML processor that generates indexed HTML, PS, and PDF ii lftp 4.6.3a-1build2 amd64 Sophisticated command-line FTP/HTTP/BitTorrent client programs ii libapache2-mod-php7.1 7.1.5-1+deb.sury.org~xenial+1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii libc6:amd64 2.23-0ubuntu7 amd64 GNU C Library: Shared libraries ii libcurl3:amd64 7.47.0-1ubuntu2.2 amd64 easy-to-use client-side URL transfer library (OpenSSL flavour) ii m4 1.4.17-5 amd64 macro processing language ii mysql-client 5.7.18-0ubuntu0.16.04.1 all MySQL database client (metapackage depending on the latest version) mysql-server-5.6 mysql-server-5.7 mysql-server mysql-server-core-5.7 ii mysql-server 5.7.18-0ubuntu0.16.04.1 all MySQL database server (metapackage depending on the latest version) ii net-tools 1.60-26ubuntu1 amd64 NET-3 networking toolkit ii nfs-kernel-server 1:1.2.8-9ubuntu12.1 amd64 support for NFS kernel server ii openssh-server 1:7.2p2-4ubuntu2.2 amd64 secure shell (SSH) server, for secure access from remote machines ii php7.1 7.1.5-1+deb.sury.org~xenial+1 all server-side, HTML-embedded scripting language (metapackage) ii php7.1-bcmath 7.1.5-1+deb.sury.org~xenial+1 amd64 Bcmath module for PHP ii php7.1-cli 7.1.5-1+deb.sury.org~xenial+1 amd64 command-line interpreter for the PHP scripting language ii php7.1-curl 7.1.5-1+deb.sury.org~xenial+1 amd64 CURL module for PHP ii php7.1-fpm 7.1.5-1+deb.sury.org~xenial+1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php7.1-gd 7.1.5-1+deb.sury.org~xenial+1 amd64 GD module for PHP php7.1-json ii php7.1-json 7.1.5-1+deb.sury.org~xenial+1 amd64 JSON module for PHP ii php7.1-mbstring 7.1.5-1+deb.sury.org~xenial+1 amd64 MBSTRING module for PHP ii php7.1-mcrypt 7.1.5-1+deb.sury.org~xenial+1 amd64 libmcrypt module for PHP php7.1-mysql ii php7.1-mysql 7.1.5-1+deb.sury.org~xenial+1 amd64 MySQL module for PHP ii php-gettext 1.0.11-2+deb.sury.org~xenial+1 all read gettext MO files directly, without requiring anything other than PHP ii sysv-rc-conf 0.99-7 all SysV init runlevel configuration tool for the terminal ii tar 1.28-2.1ubuntu0.1 amd64 GNU version of the tar archiving utility ii tftpd-hpa 5.2+20150808-1ubuntu1.16.04.1 amd64 HPA's tftp server ii tftp-hpa 5.2+20150808-1ubuntu1.16.04.1 amd64 HPA's tftp client ii unzip 6.0-20ubuntu1 amd64 De-archiver for .zip files ii vsftpd 3.0.3-3ubuntu2 amd64 lightweight, efficient FTP server written for security ii wget 1.17.1-1ubuntu1.2 amd64 retrieves files from the web ii xinetd 1:2.3.15-6 amd64 replacement for inetd with many enhancements ii zlib1g:amd64 1:1.2.8.dfsg-2ubuntu4.1 amd64 compression library - runtime Reading package lists... Building dependency tree... Reading state information... bc is already the newest version (1.06.95-9build1). build-essential is already the newest version (12.1ubuntu2). cpp is already the newest version (4:5.3.1-1ubuntu1). g++ is already the newest version (4:5.3.1-1ubuntu1). gawk is already the newest version (1:4.1.3+dfsg-0.1). gcc is already the newest version (4:5.3.1-1ubuntu1). gzip is already the newest version (1.6-4ubuntu1). lftp is already the newest version (4.6.3a-1build2). m4 is already the newest version (1.4.17-5). net-tools is already the newest version (1.60-26ubuntu1). unzip is already the newest version (6.0-20ubuntu1). vsftpd is already the newest version (3.0.3-3ubuntu2). xinetd is already the newest version (1:2.3.15-6). htmldoc is already the newest version (1.8.27-8ubuntu1). sysv-rc-conf is already the newest version (0.99-7). curl is already the newest version (7.47.0-1ubuntu2.2). libc6 is already the newest version (2.23-0ubuntu7). libcurl3 is already the newest version (7.47.0-1ubuntu2.2). mysql-client is already the newest version (5.7.18-0ubuntu0.16.04.1). mysql-server is already the newest version (5.7.18-0ubuntu0.16.04.1). nfs-kernel-server is already the newest version (1:1.2.8-9ubuntu12.1). openssh-server is already the newest version (1:7.2p2-4ubuntu2.2). tar is already the newest version (1.28-2.1ubuntu0.1). tftp-hpa is already the newest version (5.2+20150808-1ubuntu1.16.04.1). tftpd-hpa is already the newest version (5.2+20150808-1ubuntu1.16.04.1). wget is already the newest version (1.17.1-1ubuntu1.2). zlib1g is already the newest version (1:1.2.8.dfsg-2ubuntu4.1). apache2 is already the newest version (2.4.25-3+deb.sury.org~xenial+1). php-gettext is already the newest version (1.0.11-2+deb.sury.org~xenial+1). libapache2-mod-php7.1 is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-cli is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-fpm is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-bcmath is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-curl is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-gd is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-json is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-mbstring is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-mcrypt is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1-mysql is already the newest version (7.1.5-1+deb.sury.org~xenial+1). php7.1 is already the newest version (7.1.5-1+deb.sury.org~xenial+1). Calculating upgrade... The following packages were automatically installed and are no longer required: libonig2 libqdbm14 snap-confine ubuntu-core-launcher Use 'sudo apt autoremove' to remove them. The following packages have been kept back: linux-generic linux-headers-generic linux-image-generic 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. ii apache2 2.4.25-3+deb.sury.org~xenial+1 amd64 Apache HTTP Server ii bc 1.06.95-9build1 amd64 GNU bc arbitrary precision calculator language ii build-essential 12.1ubuntu2 amd64 Informational list of build-essential packages ii cpp 4:5.3.1-1ubuntu1 amd64 GNU C preprocessor (cpp) ii curl 7.47.0-1ubuntu2.2 amd64 command line tool for transferring data with URL syntax ii g++ 4:5.3.1-1ubuntu1 amd64 GNU C++ compiler ii gawk 1:4.1.3+dfsg-0.1 amd64 GNU awk, a pattern scanning and processing language ii gcc 4:5.3.1-1ubuntu1 amd64 GNU C compiler ii gzip 1.6-4ubuntu1 amd64 GNU compression utilities ii htmldoc 1.8.27-8ubuntu1 amd64 HTML processor that generates indexed HTML, PS, and PDF ii lftp 4.6.3a-1build2 amd64 Sophisticated command-line FTP/HTTP/BitTorrent client programs ii libapache2-mod-php7.1 7.1.5-1+deb.sury.org~xenial+1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii libc6:amd64 2.23-0ubuntu7 amd64 GNU C Library: Shared libraries ii libcurl3:amd64 7.47.0-1ubuntu2.2 amd64 easy-to-use client-side URL transfer library (OpenSSL flavour) ii m4 1.4.17-5 amd64 macro processing language ii mysql-client 5.7.18-0ubuntu0.16.04.1 all MySQL database client (metapackage depending on the latest version) ii mysql-server 5.7.18-0ubuntu0.16.04.1 all MySQL database server (metapackage depending on the latest version) ii net-tools 1.60-26ubuntu1 amd64 NET-3 networking toolkit ii nfs-kernel-server 1:1.2.8-9ubuntu12.1 amd64 support for NFS kernel server ii openssh-server 1:7.2p2-4ubuntu2.2 amd64 secure shell (SSH) server, for secure access from remote machines ii php7.1 7.1.5-1+deb.sury.org~xenial+1 all server-side, HTML-embedded scripting language (metapackage) ii php7.1-bcmath 7.1.5-1+deb.sury.org~xenial+1 amd64 Bcmath module for PHP ii php7.1-cli 7.1.5-1+deb.sury.org~xenial+1 amd64 command-line interpreter for the PHP scripting language ii php7.1-curl 7.1.5-1+deb.sury.org~xenial+1 amd64 CURL module for PHP ii php7.1-fpm 7.1.5-1+deb.sury.org~xenial+1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php7.1-gd 7.1.5-1+deb.sury.org~xenial+1 amd64 GD module for PHP ii php7.1-json 7.1.5-1+deb.sury.org~xenial+1 amd64 JSON module for PHP ii php7.1-mbstring 7.1.5-1+deb.sury.org~xenial+1 amd64 MBSTRING module for PHP ii php7.1-mcrypt 7.1.5-1+deb.sury.org~xenial+1 amd64 libmcrypt module for PHP ii php7.1-mysql 7.1.5-1+deb.sury.org~xenial+1 amd64 MySQL module for PHP ii php-gettext 1.0.11-2+deb.sury.org~xenial+1 all read gettext MO files directly, without requiring anything other than PHP ii sysv-rc-conf 0.99-7 all SysV init runlevel configuration tool for the terminal ii tar 1.28-2.1ubuntu0.1 amd64 GNU version of the tar archiving utility ii tftpd-hpa 5.2+20150808-1ubuntu1.16.04.1 amd64 HPA's tftp server ii tftp-hpa 5.2+20150808-1ubuntu1.16.04.1 amd64 HPA's tftp client ii unzip 6.0-20ubuntu1 amd64 De-archiver for .zip files ii vsftpd 3.0.3-3ubuntu2 amd64 lightweight, efficient FTP server written for security ii wget 1.17.1-1ubuntu1.2 amd64 retrieves files from the web ii xinetd 1:2.3.15-6 amd64 replacement for inetd with many enhancements ii zlib1g:amd64 1:1.2.8.dfsg-2ubuntu4.1 amd64 compression library - runtime Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully Failed to stop FOGImageSize.service: Unit FOGImageSize.service not loaded. Synchronizing state of mysql.service with SysV init with /lib/systemd/systemd-sysv-install... Executing /lib/systemd/systemd-sysv-install enable mysql ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2017-05-17 08:23:30 CDT; 2s ago Process: 3967 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS) Process: 3943 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 3966 (mysqld) CGroup: /system.slice/mysql.service └─3966 /usr/sbin/mysqld May 17 08:23:29 Fog-Server-15 systemd[1]: Starting MySQL Community Server... May 17 08:23:30 Fog-Server-15 systemd[1]: Started MySQL Community Server. Site 001-fog disabled. To activate the new configuration, you need to run: systemctl reload apache2 ERROR 1698 (28000): Access denied for user 'root'@'localhost' ERROR 1698 (28000): Access denied for user 'root'@'localhost' Archive: binaries1.4.0.zip inflating: packages/kernels/bzImage inflating: packages/kernels/bzImage32 inflating: packages/inits/init_32.xz inflating: packages/inits/init.xz extracting: packages/clientfiles/FOGCrypt.zip extracting: packages/clientfiles/FogService.zip inflating: packages/clientfiles/SmartInstaller.exe inflating: packages/clientfiles/FOGService.msi inflating: packages/FOGService.msi '../packages/clientfiles/FOGCrypt.zip' -> '/var/www/fog//client/FOGCrypt.zip' '../packages/clientfiles/FOGService.msi' -> '/var/www/fog//client/FOGService.msi' '../packages/clientfiles/FogService.zip' -> '/var/www/fog//client/FogService.zip' '../packages/clientfiles/SmartInstaller.exe' -> '/var/www/fog//client/SmartInstaller.exe' '../packages/kernels/bzImage' -> '/var/www/fog//service/ipxe/bzImage' '../packages/kernels/bzImage32' -> '/var/www/fog//service/ipxe/bzImage32' '../packages/inits/init_32.xz' -> '/var/www/fog//service/ipxe/init_32.xz' '../packages/inits/init.xz' -> '/var/www/fog//service/ipxe/init.xz' mysqlnd mcrypt Synchronizing state of apache2.service with SysV init with /lib/systemd/systemd-sysv-install... Executing /lib/systemd/systemd-sysv-install enable apache2 Synchronizing state of php7.1-fpm.service with SysV init with /lib/systemd/systemd-sysv-install... Executing /lib/systemd/systemd-sysv-install enable php7.1-fpm Signature ok subject=/CN=10.24.28.18 Getting CA Private Key ln: failed to create symbolic link '/var/www/fog/fog': File exists ERROR: Module php does not exist! Considering dependency proxy for proxy_fcgi: Module proxy already enabled Module proxy_fcgi already enabled Module setenvif already enabled ERROR: Module php7.1-fpm does not exist! Module rewrite already enabled Considering dependency setenvif for ssl: Module setenvif already enabled Considering dependency mime for ssl: Module mime already enabled Considering dependency socache_shmcb for ssl: Module socache_shmcb already enabled Module ssl already enabled Enabling site 001-fog. To activate the new configuration, you need to run: systemctl reload apache2 ● apache2.service - The Apache HTTP Server Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2017-05-17 08:23:44 CDT; 2s ago Process: 4214 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS) Main PID: 4221 (apache2) CGroup: /system.slice/apache2.service ├─4221 /usr/sbin/apache2 -k start ├─4225 /usr/sbin/apache2 -k start ├─4226 /usr/sbin/apache2 -k start ├─4227 /usr/sbin/apache2 -k start ├─4228 /usr/sbin/apache2 -k start └─4229 /usr/sbin/apache2 -k start May 17 08:23:44 Fog-Server-15 systemd[1]: Starting The Apache HTTP Server... May 17 08:23:44 Fog-Server-15 apachectl[4214]: AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/apache2/sites-enabled/001-fog.conf:1 May 17 08:23:44 Fog-Server-15 apachectl[4214]: AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message May 17 08:23:44 Fog-Server-15 systemd[1]: Started The Apache HTTP Server. ● php7.1-fpm.service - The PHP 7.1 FastCGI Process Manager Loaded: loaded (/lib/systemd/system/php7.1-fpm.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2017-05-17 08:23:44 CDT; 2s ago Docs: man:php-fpm7.1(8) Main PID: 4219 (php-fpm7.1) Status: "Ready to handle connections" CGroup: /system.slice/php7.1-fpm.service ├─4219 php-fpm: master process (/etc/php/7.1/fpm/php-fpm.conf) ├─4222 php-fpm: pool www └─4223 php-fpm: pool www May 17 08:23:44 Fog-Server-15 systemd[1]: Starting The PHP 7.1 FastCGI Process Manager... May 17 08:23:44 Fog-Server-15 systemd[1]: Started The PHP 7.1 FastCGI Process Manager. --2017-05-17 08:23:46-- http://10.24.28.18//fog//maintenance/backup_db.php Connecting to 10.24.28.18:80... connected. HTTP request sent, awaiting response... 302 Found Could not parse String-Transport-Security header Location: ?node=schema [following] --2017-05-17 08:23:46-- http://10.24.28.18//fog//maintenance/backup_db.php?node=schema Connecting to 10.24.28.18:80... connected. HTTP request sent, awaiting response... 500 Internal Server Error 2017-05-17 08:23:46 ERROR 500: Internal Server Error. -
/var/www/fog/lib/db/pdodb.class.php on line 443 [Wed May 17 08:57:07.443665 2017] [php7:error] [pid 5575] [client 10.24.32.13:12086] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(176): FOGController->save()\n#2 /var/www/fog/lib/fog/bootmenu.class.php(1123): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443 [Wed May 17 08:57:21.302992 2017] [php7:error] [pid 4287] [client 10.24.32.175:65253] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(176): FOGController->save()\n#2 /var/www/fog/lib/fog/bootmenu.class.php(1123): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443 -
ISSUE RESOLVED By following this
TLDR; Rerun the fog installer if you have lost “Database Connectivity” to your fog server, or run the ALTER USER syntax shown below.
So Ubuntu 16, among others I suppose, enable a “security updates” to be applied automatically as a “default” to things. Why, well it makes it simpler to ensure your Ubuntu systems are in compliance and patched for any potential exploits. This causes unknown and unexpected issues.
I figured it’d be a safe thing to express that there could be problems (as many of you have already experienced) that when these updates go up (with or without your knowledge) it can break functionality in unexpected and inopportune ways.
The quickest fix is to simply rerun the fog installer which should correct the problem.
As a note, it seems this problem is specific only when the mysql account is the ‘root’ user AND the password is blank.
The “fix” if you must do it manually is to open a terminal and obtain root:
Super (Windows Key) + T then sudo -i (in most cases).From there, open mysql with mysql -u root
NOTE: MySQL MUST be run with ROOT.
Run:
ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘’; AND
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;It’s okay if one of them fails. This is going to fix Most people’s issues.
I would highly recommend removing the unattended-upgrades as many of these “sudden” issues came as a security patch ubuntu pushed out. By default Ubuntu typically set’s this for you as enabled and it can cause havoc on you as you (the admin) may not have “done” anything.
To prevent this problem from happening in the future you could run:
apt-get -y remove unattended-upgrades (AS Root again).