problem fixed, the email address in the role table was slightly different to the address in the galaxy_user table, no idea how this happened but all sorted now. Thanks for your help Shaun. Quoting Hans-Rudolf Hotz <hrh@fmi.ch>:
On 04/30/2010 03:28 PM, SHAUN WEBB wrote:
Hi Greg, all of those records are fine and nothing is missing. Any other ideas?
Hi Shaun
It could be completely unrelated, but your problem kind of reminds me of a similar situation, when we switched to external authentication. It all worked fine, except for one user.
As it turned out, the e-mail address in the table "galxy_user" was all lowercase (ie firstname.lastname@fmi.ch). He used this e-mail to log in before the activation of the external authentication. Once the external authentication was in place, he was logged in as "Firstname.Lastname@fmi.ch".
After changing the entry in the MySQL table to "Firstname.Lastname@fmi.ch" it all worked fine. Though, I never investigated the problem any further.
Regards, Hans
Shaun.
Quoting Greg Von Kuster <greg@bx.psu.edu>:
Shaun,
It looks like maybe this user's private role was somehow eliminated. Try this sql against your db:
select * from role where name = <user's email address / galaxy account>
and see if the role exists there. If so, try this sql:
select * from galaxy_user where email = <user's email address / galaxy account>
to get the user's id, then
select * from user_role_association where user_id = <the user's id from the galaxy_user table> and role_id = <the user's private role id from the first select above>
If any of these are missing, you may need to manually create the records.
If this does not correct the issue, let me know. If you have to create the record in the role table for the user's private role, make sure the description is correct. It should be Private role for <user email>
Thanks!
On Apr 30, 2010, at 6:53 AM, SHAUN WEBB wrote:
Hi, we are having problems with a single user account. When using the 'edit attributes' button on a dataset an error is returned (traceback below). This is happening with each dataset/history. However, if the dataset is shared then properties can be edited by a different user or while logged out. It appears to be solely linked to this users account.
Thanks in advance for any help.
Shaun Webb
When trying to 'Edit Attributes'
URL: http://bifx3.bio.ed.ac.uk:8080/root/edit?id=2558 File '/opt/galaxy_dist/eggs/Paste-1.6-py2.5.egg/paste/exceptions/errormiddleware.py', line 143 in __call__ app_iter = self.application(environ, start_response) File '/opt/galaxy_dist/eggs/Paste-1.6-py2.5.egg/paste/debug/prints.py', line 98 in __call__ environ, self.app) File '/opt/galaxy_dist/eggs/Paste-1.6-py2.5.egg/paste/wsgilib.py', line 539 in intercept_output app_iter = application(environ, replacement_start_response) File '/opt/galaxy_dist/eggs/Paste-1.6-py2.5.egg/paste/recursive.py', line 80 in __call__ return self.application(environ, start_response) File '/opt/galaxy_dist/eggs/Paste-1.6-py2.5.egg/paste/httpexceptions.py', line 632 in __call__ return self.application(environ, start_response) File '/opt/galaxy_dist/lib/galaxy/web/framework/base.py', line 125 in __call__ body = method( trans, **kwargs ) File '/opt/galaxy_dist/lib/galaxy/web/controllers/root.py', line 364 in edit all_roles = trans.app.security_agent.get_legitimate_roles( trans, data.dataset, 'root' ) File '/opt/galaxy_dist/lib/galaxy/security/__init__.py', line 174 in get_legitimate_roles return sort_by_attr( [ role for role in roles ], 'name' ) File '/opt/galaxy_dist/lib/galaxy/security/__init__.py', line 142 in sort_by_attr intermed = map( None, map( getattr, seq, ( attr, ) * len( seq ) ), xrange( len( seq ) ), seq ) AttributeError: 'NoneType' object has no attribute 'name'
-- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.
_______________________________________________ galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev
Greg Von Kuster Galaxy Development Team greg@bx.psu.edu
-- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.