Database Schema Installer/ Updater

[Tom Elliott]

Does your database have a password set for it?

This error will present any time there’s an issue with connecting to the db. The information given there is just a quick, check these types of things too, message. Are the credentials correct?

[templink]

I’ve never changed the credentials. So as far as I know, they are correct. My database has no password.

[Tom Elliott]

@templink Is there a password defined for the database in the config.class.php file?

[Wayne Workman]

@templink said in Database Schema Installer/ Updater:

I looked in the config.class.php file, but couldn’t figure out what should be changed.

Nothing should be changed in that file, make your changes inside of /opt/fog/.fogsettings so that they are permanent.

Can you access the database with any of these?

mysql -D fog
mysql -h localhost -D fog
mysql -h 127.0.0.1 -D fog
mysql -h localhost -D fog -u root -p
mysql -h 127.0.0.1 -D fog -u root -p

[templink]

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

[Tom Elliott]

@templink If you edit the config.class.php and change the
define('DATABASE_HOST', '127.0.0.1');

To read as:
define('DATABASE_HOST', 'localhost');

[templink]

@Tom-Elliott
It read:
define(‘DATABASE_HOST’, ‘p:localhost’);

I changed it to:
define(DATABASE_HOST’, ‘localhost’);

and rebooted, but the problem persists.

[Tom Elliott]

Does your config.class.php file have a defined definition for the DATABASE_PASSWORD field?

[templink]

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

@templink

What happens if you run:
mysql -u root fog as a “non-root” user?

[templink]

@Tom-Elliott

ubuntu@fogserver:~$ mysql -u root fog
ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’

[Tom Elliott]

@templink Please run:

sudo mysql -u root
Within mysql please run:

ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
exit;

Then you should be good to go.

[templink]

@Tom-Elliott

response was
Query OK, 0 rows affected (0.00 sec)

It worked! Big thanks! I’m up and running in the browser again.