Error 1045 During Install on Storage Nodes

[Wayne Workman]

There is a new feature in the current trunk that I had a hand in. The storage node installer now automatically adds storage nodes into storage management for you. This is done using the fogstorage username and password. The error in the installer indicates that it could not connect to the main server from the node using these credentials. I’m going to guess that remote access isn’t enabled on the main servers database. If you look in the wiki for “troubleshoot MySQL” there is sections in there that allow you to test the connection from the node to the main server manually and also steps on how to enable remote access.

[Tom Elliott]

@Raymond-Bell what OS is the server running?

[Raymond Bell]

@Tom-Elliott said in Error 1045 During Install on Storage Nodes:

@Raymond-Bell what OS is the server running?

Server = Xubuntu 15.10 Minimal
Node = Ubuntu 14.04 LTS

[Tom Elliott]

@Raymond-Bell please edit the file /etc/mysql/my.cnf and look for bind-address. Comment the line with a hash symbol.

[Raymond Bell]

@Tom-Elliott said in Error 1045 During Install on Storage Nodes:

@Raymond-Bell please edit the file /etc/mysql/my.cnf and look for bind-address. Comment the line with a hash symbol.

on server or node

[Tom Elliott]

@Raymond-Bell main server and when done restart the service with service mysql restart

[Raymond Bell]

@Tom-Elliott
Dont see it sorry

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
~
~
~

[Raymond Bell]

@Tom-Elliott Found it on Storage Node side trying it now

[Tom Elliott]

@Raymond-Bell I don’t like ubuntu for these reasons…

They move things around and try to make it more “modular”

At anyrate, while in the server’s /etc/mysql folder (cd /etc/mysql) run the command grep -rl 'bind-address' . it should return the filename to the file (or files I suppose) that have that line in them.

[Raymond Bell]

@Tom-Elliott No Change

[Raymond Bell]

@Tom-Elliott said in Error 1045 During Install on Storage Nodes:

@Raymond-Bell I don’t like ubuntu for these reasons…

They move things around and try to make it more “modular”

At anyrate, while in the server’s /etc/mysql folder (cd /etc/mysql) run the command grep -rl 'bind-address' . it should return the filename to the file (or files I suppose) that have that line in them.

Found it

vi /etc/mysql/mysql.conf.d/mysqld.cnf

[Wayne Workman]

Wanna say to the Ubuntu-Linux devs that the mysql conf file structure is really over-the-top confusing and complex.

[Raymond Bell]

@Tom-Elliott
@Wayne-Workman

Run installer again on Storage Node to see if it get this error

[Raymond Bell]

@Tom-Elliott
@Wayne-Workman

Same issue after commenting out Bind Address and restarting mysql

 * Starting FOGSnapinReplicator Service........................OK
 * Starting FOGScheduler Service...............................OK
 * Starting FOGPingHosts Service...............................OK
 * Setting up exports file.....................................OK
 * Setting up and starting RPCBind.............................OK
 * Setting up and starting NFS Server..........................OK
ERROR 1045 (28000): Access denied for user 'fogstorage'@'10.24.28.16' (using password: YES)
ERROR 1045 (28000): Access denied for user 'fogstorage'@'10.24.28.16' (using password: YES)

 * Setup complete


 * You still need to setup this node in the fog management
 | portal. You will need the username and password listed
 | below.

[Wayne Workman]

@Raymond-Bell You don’t have to run the installer to test if it’s working or not, that takes way too long.

Instructions on connecting via CLI are in the wiki:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Testing_MySQL

mysql -u UserNameHere -pPasswordHere -h X.X.X.X -D fog
exit

Or for you, use this and put in the password. Please note there is no space between -p and the password, this is correct and intentional.

mysql -u fogstorage -pPasswordHere -h x.x.x.x -D fog
exit

If you get access denied, it’s not working. If you get in, it’s working.

[Tom Elliott]

@Wayne-Workman The @10.24.28.16 is HIS side, not the IP to the server.

[Wayne Workman]

@Tom-Elliott correct and corrected.

[Raymond Bell]

@Tom-Elliott
@Wayne-Workman

root@fog-GX620-K2:/home/fog/Downloads/svn/bin# mysql -u fogstorage -ppassword -h 10.24.28.18 -D fog
ERROR 1045 (28000): Access denied for user 'fog'@'10.24.28.16' (using password: YES)
root@fog-GX620-K2:/home/fog/Downloads/svn/bin#

[Raymond Bell]

@Tom-Elliott
@Wayne-Workman
Got it to connect doing this command
And the error is gone…

Thanks guys we can close this issue now

mysql
GRANT ALL PRIVILEGES ON fog.* TO 'MysqlUserNameGoesHere'@'%' IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;

[Wayne Workman]

Wanting to point out to readers this problem was due to no remote access enabled on the database, and the answer is in the wiki article “Troubleshoot MySQL”.