delete user and all trace of user

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

delete user and all trace of user

fernandez Edgar

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/
Reply | Threaded
Open this post in threaded view
|

Re: delete user and all trace of user

Martin Čech
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 <[hidden email]> 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/
Reply | Threaded
Open this post in threaded view
|

Re: delete user and all trace of user

fernandez Edgar

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:[hidden email]]
Sent: September-08-16 12:30 PM
To: Fernandez Edgar <[hidden email]>; [hidden email]
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 <[hidden email]> 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/
Reply | Threaded
Open this post in threaded view
|

Re: delete user and all trace of user

Martin Čech
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 <[hidden email]> 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:[hidden email]]
Sent: September-08-16 12:30 PM
To: Fernandez Edgar <[hidden email]>; [hidden email]
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 <[hidden email]> 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/