Hi Carrie

Was the history which is causing troubles created before you switched to external authentication? Or has the user a slightly different e-mail address now? eg different use of capital letters, like 'foo.bar@home' and 'Foo.Bar@home' - we had such problems, when we switched to external authentication.


I had to dig into our MySQL database and fix the "galaxy_user" table. In your case, I recommend looking at the "galaxy_user" table and check whether the user has more than one entry. Take the "id" (ie the number) and search the "history" table using the id as 'user_id'. I would guess you can fix your problem by changing the 'user_id' in the "history" table for the history which is causing troubles.

BUT, BE VERY CAREFUL! you can do a lot of damage to the database. Switch off the galaxy server first, and MAKE a back up the database before you change anything.

Regards, Hans-Rudolf

On 03/11/2014 11:58 PM, Ganote, Carrie L wrote:
Hi List,

I just pulled and merged from galaxy-dist (I think it's dc067a95261d),
updated my database, and migrated my tools. The issues I am able to see
are minor, but I have a user who can no longer access a particular
history. It apparently just hangs. If they delete the history, Galaxy
responds, but it will hang again when they try to add back any datasets.
Unfortunately, I don't see any errors in the paster logs about this. I
fear that their dataset entries in the Postgresql db have been corrupted
during the update, or perhaps the files themselves were purged. I cannot
reproduce their issues with my own histories - I'm able to bring up
saved histories and upload etc. I don't know if they can share a history
if it can't be loaded. How should I troubleshoot this?
I'm set up to authenticate through apache, which makes it harder to get
in as the user and see what's up. Is there an easy way to find out what
histories belong to what users? I can search the database?

Any advice would be greatly appreciated!

-Carrie


___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
   http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
   http://galaxyproject.org/search/mailinglists/

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
 http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
 http://galaxyproject.org/search/mailinglists/

Reply via email to