Wissam, Do you have any other versions of MySQL installed on the server? Is this a ROCKS based cluster? If so, see my rant here: https://lists.sdsc.edu/pipermail/npaci-rocks-discussion/2014-March/064785.html
-Adam -- Adam Brenner Computer Science, Undergraduate Student Donald Bren School of Information and Computer Sciences System Administrator, HPC Cluster Office of Information Technology http://hpc.oit.uci.edu/ University of California, Irvine www.ics.uci.edu/~aebrenne/ [email protected] On Wed, Apr 23, 2014 at 12:47 AM, Wissam Ali <[email protected]> wrote: > Hi Mailing List, > I have installed robinhood on a linux server where lustre filesystem is > mounted, and I am getting the following error when executing robinhood > --scan --once: > > CheckFS | '/scratch' matches mount point '/scratch', type=lustre, > fs=10.10.0.42@o2ib:10.10.0.41@o2ib:/scratch > SigHdlr | Signals SIGTERM and SIGINT (daemon shutdown) are ready to be used > SigHdlr | Signal SIGHUP (config reloading) is ready to be used > SigHdlr | Signal SIGUSR1 (stats dump) is ready to be used > ListMgr | Unhandled error 1045: default conversion to DB_REQUEST_FAILED > ListMgr | Failed to connect to MySQL after 0 retries: Error: Access denied > for user 'robinhood'@'localhost' (using password: YES). Aborting. > Main | Error 6 initializing list manager > > My configuration file for the list manager has the following setting: > > ListManager > { > MySQL > { > server = localhost; > db = robinhood_lustre; > user = robinhood; > password_file = /etc/robinhood.d/.dbpassword; > } > > } > > The user robinhood on the mysql database looks like this: > > mysql> select user,host from mysql.user where user='robinhood'; > > +-----------+-----------+ > > | user | host | > > +-----------+-----------+ > > | robinhood | localhost | > > +-----------+-----------+ > > > mysql>show grants for robinhood@localhost; > +------------------------------------------------------------------------------------------------------------------+ > | Grants for robinhood@localhost > | > +------------------------------------------------------------------------------------------------------------------+ > | GRANT SUPER ON *.* TO 'robinhood'@'localhost' IDENTIFIED BY PASSWORD > '*A3D1A5853B73542DD7CFBF300F4873BAD075D819' | > | GRANT ALL PRIVILEGES ON `robinhood_lustre`.* TO 'robinhood'@'localhost' > | > +------------------------------------------------------------------------------------------------------------------+ > > When i connect to the database via the command line like this: > > [root@mgmt2 tmpfs]# mysql --user=robinhood --host=localhost > --password=robinhood robinhood_lustre > > It connects with no issues. I am puzzled as why is this happening. I have > followed the instructions on the admin guide and set up the the database > using both rbh-config and manually. I have read the mysql docs and the > permissions are correct for the user to able to login with no issues. My > conf file looks right and .dbpassword file has the passoword for the user > robinhood. Any help would be appreciated. > > Regards, > > -- > Wissam Ali > HPC System Administrator > Office Tel (UAE): +971-2-628-4751 > Mobile Tel (UAE): +971-50-106-9689 > Time Zone: GMT+4hrs > Weekends: Friday + Saturday > For HPC support please create a ticket at https://nyu.service-now.com > > NYU Abu Dhabi > Center for Science and Engineering (CSE) > P.O. Box 129188 > Abu Dhabi, United Arab Emirates > > ------------------------------------------------------------------------------ > Start Your Social Network Today - Download eXo Platform > Build your Enterprise Intranet with eXo Platform Software > Java Based Open Source Intranet - Social, Extensible, Cloud Ready > Get Started Now And Turn Your Intranet Into A Collaboration Platform > http://p.sf.net/sfu/ExoPlatform > _______________________________________________ > robinhood-support mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/robinhood-support > ------------------------------------------------------------------------------ Start Your Social Network Today - Download eXo Platform Build your Enterprise Intranet with eXo Platform Software Java Based Open Source Intranet - Social, Extensible, Cloud Ready Get Started Now And Turn Your Intranet Into A Collaboration Platform http://p.sf.net/sfu/ExoPlatform _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
