Error 1045 During Install on Storage Nodes

[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”.