[Rocks-Discuss] rocks command stopped working for root
Ding, Dajiang
I am testing a new install of ROCKS 5.4.3 and everything seems to be fine until I changed the root password to get phpmysql working. Right now, I can only run 'rocks' command as regular user. When I run 'rocks list host' as root user, the following error shows up:
Traceback (most recent call last):
File "/opt/rocks/bin/rocks", line 294, in ?
command.runWrapper(name, args[i:])
File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/__init__.py", line
2120, in runWrapper
self.run(self._params, self._args)
File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/list/host/__init__
.py", line 170, in run
for host in self.getHostnames(args):
File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/__init__.py", line
705, in getHostnames
for host, in self.db.fetchall():
TypeError: iteration over non-sequence
If mysqld is restarted with '--skip-grant-tables', then I can run rocks command as 'root' again.
Thanks for your help and suggestions in advance.
-DJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.sdsc.edu/pipermail/npaci-rocks-discussion/attachments/20111214/c109e956/attachment.html
Bart Brashers
http://www.rocksclusters.org/roll-documentation/base/5.4.3/customization-passwd.html
Perhaps you just need to run "rocks sync config" on the FE, after doing a "passwd" as root?
Bart
________________________________
This message contains information that may be confidential, privileged or otherwise protected by law from disclosure. It is intended for the exclusive use of the Addressee(s). Unless you are the addressee or authorized agent of the addressee, you may not review, copy, distribute or disclose to anyone the message or any information contained within. If you have received this message in error, please contact the sender by electronic reply to em...@environcorp.com and immediately delete all copies of the message.
Anoop Rajendra
> Hello,
>
> I am testing a new install of ROCKS 5.4.3 and everything seems to be fine until I changed the root password to get phpmysql working. Right now, I can only run 'rocks' command as regular user. When I run 'rocks list host' as root user, the following error shows up:
>
> Traceback (most recent call last):
> File "/opt/rocks/bin/rocks", line 294, in ?
> command.runWrapper(name, args[i:])
> File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/__init__.py", line
> 2120, in runWrapper
> self.run(self._params, self._args)
> File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/list/host/__init__
> .py", line 170, in run
> for host in self.getHostnames(args):
> File "/opt/rocks/lib/python2.4/site-packages/rocks/commands/__init__.py", line
> 705, in getHostnames
> for host, in self.db.fetchall():
> TypeError: iteration over non-sequence
>
>
> If mysqld is restarted with '--skip-grant-tables', then I can run rocks command as 'root' again.
>
>
> Thanks for your help and suggestions in advance.
>
> -DJ
I'm not sure I follow. Why did you change your root password to get
phpMySQL working?
Also, which root password did you change? The MySQL root password or
the system root password?
-a
Ding, Dajiang
/opt/rocks/bin/mysql -u root mysql -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Philip Papadopoulos
/root/.rocks.my.cnf, replacing the randomly generated password that is there
now.
-P
--
Philip Papadopoulos, PhD
University of California, San Diego
858-822-3628 (Ofc)
619-331-2990 (Fax)
-------------- next part --------------
An HTML attachment was scrubbed...
Ding, Dajiang
-DJ