Re: [galaxy-dev] delete user and all trace of user
Hi Edgar, the 'active' column won't help you, that relates to the account activation feature vie email. Your other approach seems more viable. I would try deleting the smallest subset of constrained entries - but unless you learn/understand the logic behind the rows being deleted you are risking to end in an inconsistent state. I would also limit this on the 'deleted' users only as a purged user does not have to be deleted I think. Martin On Fri, Sep 9, 2016 at 7:41 AM Fernandez Edgar <edgar.fernan...@umontreal.ca> wrote: > Hello Martin, > > > > Thanks for the answer. > > I was hoping to find a way to remove the user or at the very least hide > them from the ADMIN user page. > > > > After a small research in the database, I found a column called "ACTIVE" > in the galaxy_user table. > > Can that column help me at all? > > > > OR > > > > I could write a script that search all the deleted/purged users, picks up > their ID in the galaxy_user table and destroys all the lines in all the > tables that has that FOREIGN KEY??? > > > > Let me know what you think… > > > > *Edgar Fernandez* > > System Administrator (Linux) > > Direction Générale des Technologies de l'Information et de la Communication > > *Université de Montréal* > > > > PAVILLON ROGER-GAUDRY, bureau X-210 > > ( Bur. : *1-514-343-6111 poste 16568* > > > > > > *From:* Martin Čech [mailto:mar...@bx.psu.edu] > *Sent:* September-08-16 12:30 PM > *To:* Fernandez Edgar <edgar.fernan...@umontreal.ca>; > galaxy-...@bx.psu.edu > *Subject:* Re: [galaxy-dev] delete user and all trace of user > > > > Hi Edgar, > > > > there is no built-in way in Galaxy to remove a user completely. 'Deleting' > just flips the flag in the DB and 'purging' is related to their > data/histories. You need to access the DB directly if you want to > completely remove a user. Beware that there might be constraints/relations > attached to the user row. > > > > Thanks for using Galaxy, > > > > Martin > > > > On Thu, Sep 8, 2016 at 12:22 PM Fernandez Edgar < > edgar.fernan...@umontreal.ca> wrote: > > Hello gents! > > > > I’ve successfully got my version 16.04 up and running and everything is > still there (user, groups roles, data and tools). > > Unfortunately , I’m still having a problem with deleting a user. I’ve > purge him and then I deleted him. > > but, he still shows up in my list of users as "purged". > > > > Is there a way to completely remove him from galaxy? > > Do I need to run a script in a cron job to clean my galaxy periodically? > > > > Thanks in advance! > > > > *Edgar Fernandez* > > System Administrator (Linux) > > Direction Générale des Technologies de l'Information et de la Communication > > *Université de Montréal* > > > > PAVILLON ROGER-GAUDRY, bureau X-210 > > ( Bur. : *1-514-343-6111 poste 16568* > > ___ > 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: > https://lists.galaxyproject.org/ > > 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: https://lists.galaxyproject.org/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Re: [galaxy-dev] delete user and all trace of user
Hello Martin, Thanks for the answer. I was hoping to find a way to remove the user or at the very least hide them from the ADMIN user page. After a small research in the database, I found a column called "ACTIVE" in the galaxy_user table. Can that column help me at all? OR I could write a script that search all the deleted/purged users, picks up their ID in the galaxy_user table and destroys all the lines in all the tables that has that FOREIGN KEY??? Let me know what you think… Edgar Fernandez System Administrator (Linux) Direction Générale des Technologies de l'Information et de la Communication Université de Montréal PAVILLON ROGER-GAUDRY, bureau X-210 • Bur. : 1-514-343-6111 poste 16568 From: Martin Čech [mailto:mar...@bx.psu.edu] Sent: September-08-16 12:30 PM To: Fernandez Edgar <edgar.fernan...@umontreal.ca>; galaxy-...@bx.psu.edu Subject: Re: [galaxy-dev] delete user and all trace of user Hi Edgar, there is no built-in way in Galaxy to remove a user completely. 'Deleting' just flips the flag in the DB and 'purging' is related to their data/histories. You need to access the DB directly if you want to completely remove a user. Beware that there might be constraints/relations attached to the user row. Thanks for using Galaxy, Martin On Thu, Sep 8, 2016 at 12:22 PM Fernandez Edgar <edgar.fernan...@umontreal.ca<mailto:edgar.fernan...@umontreal.ca>> wrote: Hello gents! I’ve successfully got my version 16.04 up and running and everything is still there (user, groups roles, data and tools). Unfortunately , I’m still having a problem with deleting a user. I’ve purge him and then I deleted him. but, he still shows up in my list of users as "purged". Is there a way to completely remove him from galaxy? Do I need to run a script in a cron job to clean my galaxy periodically? Thanks in advance! Edgar Fernandez System Administrator (Linux) Direction Générale des Technologies de l'Information et de la Communication Université de Montréal PAVILLON ROGER-GAUDRY, bureau X-210 • Bur. : 1-514-343-6111 poste 16568 ___ 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: https://lists.galaxyproject.org/ 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: https://lists.galaxyproject.org/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Re: [galaxy-dev] delete user and all trace of user
Hi Edgar, there is no built-in way in Galaxy to remove a user completely. 'Deleting' just flips the flag in the DB and 'purging' is related to their data/histories. You need to access the DB directly if you want to completely remove a user. Beware that there might be constraints/relations attached to the user row. Thanks for using Galaxy, Martin On Thu, Sep 8, 2016 at 12:22 PM Fernandez Edgar < edgar.fernan...@umontreal.ca> wrote: > Hello gents! > > > > I’ve successfully got my version 16.04 up and running and everything is > still there (user, groups roles, data and tools). > > Unfortunately , I’m still having a problem with deleting a user. I’ve > purge him and then I deleted him. > > but, he still shows up in my list of users as "purged". > > > > Is there a way to completely remove him from galaxy? > > Do I need to run a script in a cron job to clean my galaxy periodically? > > > > Thanks in advance! > > > > *Edgar Fernandez* > > System Administrator (Linux) > > Direction Générale des Technologies de l'Information et de la Communication > > *Université de Montréal* > > > > PAVILLON ROGER-GAUDRY, bureau X-210 > > ( Bur. : *1-514-343-6111 poste 16568* > ___ > 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: > https://lists.galaxyproject.org/ > > 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: https://lists.galaxyproject.org/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
[galaxy-dev] delete user and all trace of user
Hello gents! I’ve successfully got my version 16.04 up and running and everything is still there (user, groups roles, data and tools). Unfortunately , I’m still having a problem with deleting a user. I’ve purge him and then I deleted him. but, he still shows up in my list of users as "purged". Is there a way to completely remove him from galaxy? Do I need to run a script in a cron job to clean my galaxy periodically? Thanks in advance! Edgar Fernandez System Administrator (Linux) Direction Générale des Technologies de l'Information et de la Communication Université de Montréal PAVILLON ROGER-GAUDRY, bureau X-210 • Bur. : 1-514-343-6111 poste 16568 ___ 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: https://lists.galaxyproject.org/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
