I inserted “BY” without the quotes and avoided the previous syntax errors:
mysql> ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘’;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;
Query OK, 0 rows affected (0.00 sec)
relaunched Firefox to GUI, success!
@Tom-Elliott
@@version
5.7.18-0ubuntu0.16.04.1
1 row in set (0.00 sec)
@Tom-Elliott no I don’t. I tried the ALTER USER ‘root’… command from another post but got a syntax error. .
@Tom-Elliott just upgraded to Version: 1.4.0-RC-9.2 (several times just to be sure). That didn’t fix it.
yes I ran mysql as root. I also re-ran the fog installer and rebooted the box.
Apache error log shows repeated entry:
[Sun Apr 30 18:06:56.749350 2017] [php7:error] [pid 26075] [client 127.0.0.1:36406] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(176): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(445): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443
That did not fix my problem.
when I go into MySql and paste in those two commands, I get a syntax error:
mysql> ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password ‘’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’‘’ at line 1
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password ‘’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’‘’ at line 1
mysql>
Any more suggestions? I appreciate it. Did I type something wrong?
blank screen on fog server after updating Ubuntu.
When I try to launch http://localhost/fog/management/index.php?node=schema on the fog server (locally), nothing comes up. This was working recently. I also patched Ubuntu 16.04 LTS with apt-get.
response was
Query OK, 0 rows affected (0.00 sec)
It worked! Big thanks! I’m up and running in the browser again.
ubuntu@fogserver:~$ mysql -u root fog
ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’
@Tom-Elliott
db settings from my config.class.php file:
private static function _dbSettings()
{
define(‘DATABASE_TYPE’, ‘mysql’); // mysql or oracle
define(‘DATABASE_HOST’, ‘localhost’);
define(‘DATABASE_NAME’, ‘fog’);
define(‘DATABASE_USERNAME’, ‘root’);
define(‘DATABASE_PASSWORD’, “”);
}
@Tom-Elliott
It read:
define(‘DATABASE_HOST’, ‘p:localhost’);
I changed it to:
define(DATABASE_HOST’, ‘localhost’);
and rebooted, but the problem persists.
@Wayne-Workman
I was able to successfully logon to the database using the first, second and fourth method you provided. Both ways using 127.0.0.1 failed though.
I’ve never changed the credentials. So as far as I know, they are correct. My database has no password.
Just upgraded from Ubuntu 14.04 to 16.04 and updated FOG.
install succeeded, except backing up database, which always failed but was not a problem.
Now when I attempt to launch fog in Firefox on the server (localhost), I get following error message:
Database Schema Installer / Updater
Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/html/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and if the Database service is running, check to ensure your filesystem has enough space.
I looked in the config.class.php file, but couldn’t figure out what should be changed. MySQL is running, and I have enough disk space.
@Arrowhead-IT
“What version of Ubuntu are you running?”
Ubuntu 14.04 LTS
@Junkhacker
yes they all have same BIOS.
I believe I found the problem. The environment is a classroom with 24 wired seats. 2 of the stations exhibit this problem repeatedly. When I relocate a host to another seat (a different network cable) it images just fine. So I think I need to recable some of the seats, or change out the RJ45 connectors on some stations.
Fog is version 5866
hosts are Dell Precision M4800 laptops
some work, some don’t. So far 5 imaged OK, 4 failed with the “no network interfaces found” error
I have 4 hosts (so far) that won’t perform quick registration, full registration, or deploy an image. I am using latest trunk (as of yesterday) on Ubuntu. This is a private network setup.
During boot, these hosts get an IP from the DHCP server, and even load the FOG menu. When I choose quick or full inventory, they fail to upload it to the server. No error message, just “attempting to upload inventory…” forever…
If I manually create the hosts on the server, assign an image and attempt to deploy it to them, it fails (on the client) with the message "verifying network interface configuration… Failed … An error has been detected! No network interfaces found. Computer will reboot in 1 minute.