Using sql, make sure there is a user_role_association record for every role in the role table for this user. Let me know if that is not the problem, and we'll have to dig a bit deeper. On Apr 30, 2010, at 9:28 AM, SHAUN WEBB wrote:

Hi Greg, all of those records are fine and nothing is missing. Any other ideas?

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.

Greg Von Kuster Galaxy Development Team greg@bx.psu.edu

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.