Hi Adam,
Yes it is a Rocks based cluster. The Linux server is a Rocks backup
management server. It has two instances of mysql database. One for the
rocks cluster which is the foundation-mysql and the other is the standard
package that comes from Redhat. I have installed robinhood on the Rocks
backup management server where lustre filesystem is mounted. Because the
foundation-mysql was running robinhood was trying to connect to the mysql
database using the foundation-mysql socket file residing in
/var/opt/rocks/mysql/mysql.sock instead of the default socket file in
/var/lib/mysql. I have shutdown the foundation-mysql service and I have
edited the conf file in /etc/robinhood.d/tmps under the ListManager-Mysql
Block to include this directive *socket = /var/lib/mysql/mysql.sock* to get
robinhood running and scanning the filesystem. However this "socket =
/directory" directive is no where mentioned in the admin guide. I do not
know if this a correct directive to have in the conf file. It seems adding
this line has fixed my issue. Robinhood is currently scanning the lustre
filesystem. Have you come up with any such issues?
Cheers,
Wissam
On Wed, Apr 23, 2014 at 8:43 PM, Adam Brenner <[email protected]> wrote:
> 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
> >
>
--
*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
