Hi Jun,

the account activation is meant for multi-processor environments and these have to have the following option turned on in the configuration:

track_jobs_in_database = True

Please try to change it.

thank you

Martin

On Thu, Apr 24, 2014 at 4:27 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin

  I am using Postgresql.

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Thursday, April 24, 2014 5:21 PM *To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

what kind of database are you using? This feature might not be supported for SQLite (as no production Galaxy should run on it :))

best

Martin

Galaxy Team

On Thu, Apr 24, 2014 at 11:42 AM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi everyone

   I followed the instruction at

https://wiki.galaxyproject.org/Admin/UserAccounts to add email verification. I am using GMAIL SMTP server to send out the verification emails. Everything seems fine. If using one of the banned email, an error is there. After register, a verification email is successfully sent out and the page does say that without verification, no job and upload can be done. However when I tried, I CAN upload files and run jobs. The grace period is set to be 0. From the comment, I assume that there is no grace period at all which means no user activity can be carried out. Could anyone point out what I have done wrongly?

   The by-product of above test is that I need to delete the user I

created for test. I searched the dev mail list. The most recent one concerning this is the one sent by Nate in Nov 2011. I just could not find the py file he mentioned, probably that email is too old. I have done a grep search for “operations.append” and “item.deleted” and found two files requests_admin.py and requests.py under lib/galaxy/webapps/galaxy/controllers/. But they are not commented which means that I cannot uncomment them to make “delete user” function available in the UI as Nate suggested. Any guidance?

Best regards!

Jun

---

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/

Hi Jun,

Galaxy does not really delete users. If you are trying to clear the user, just change its email as an admin and register the user again with the same address as before.

Martin

On Thu, Apr 24, 2014 at 8:56 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin,

  Thanks for the hint. After setting track_jobs_in_database to True,

the status of the new upload is waiting to run, which should be the behavior expected.

 Luckily when I modified the setting in universal_wsgi.ini, I noticed

that there is an option allow_user_deletion = True which enables the user deletion in UI. The problem is that even I deleted and purged one email, I still can re-register with that email. What is the solution to this? Direct SQL operation?

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Thursday, April 24, 2014 9:50 PM

*To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

the account activation is meant for multi-processor environments and these have to have the following option turned on in the configuration:

track_jobs_in_database = True

Please try to change it.

thank you

Martin

On Thu, Apr 24, 2014 at 4:27 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin

  I am using Postgresql.

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Thursday, April 24, 2014 5:21 PM *To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

what kind of database are you using? This feature might not be supported for SQLite (as no production Galaxy should run on it :))

best

Martin

Galaxy Team

On Thu, Apr 24, 2014 at 11:42 AM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi everyone

   I followed the instruction at

https://wiki.galaxyproject.org/Admin/UserAccounts to add email verification. I am using GMAIL SMTP server to send out the verification emails. Everything seems fine. If using one of the banned email, an error is there. After register, a verification email is successfully sent out and the page does say that without verification, no job and upload can be done. However when I tried, I CAN upload files and run jobs. The grace period is set to be 0. From the comment, I assume that there is no grace period at all which means no user activity can be carried out. Could anyone point out what I have done wrongly?

   The by-product of above test is that I need to delete the user I

created for test. I searched the dev mail list. The most recent one concerning this is the one sent by Nate in Nov 2011. I just could not find the py file he mentioned, probably that email is too old. I have done a grep search for “operations.append” and “item.deleted” and found two files requests_admin.py and requests.py under lib/galaxy/webapps/galaxy/controllers/. But they are not commented which means that I cannot uncomment them to make “delete user” function available in the UI as Nate suggested. Any guidance?

Best regards!

Jun

---

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/

Hi Jun,

you can change any user's email through admin interface of Galaxy, no need for SQL. You may break consistency when using SQL for changing users, which might have happened to you.

best

Martin

On Fri, Apr 25, 2014 at 7:49 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin,

  Thanks for the tip of changing email and username under SQL. I

managed that (update galaxy_user set email=’haha@haha.com’, username=’haha’ where id = NNN) and tried to re-register with the same email. Then I got some error saying “Internal Server Error

*Galaxy was unable to successfully complete your request*

An error occurred.

This may be an intermittent problem due to load or other unpredictable factors, reloading the page may address the problem.

*The error has been logged to our team.*

“

    Also the link in the verification email does not do the job.

Anyway, I used the SQL again to bypass this issue (active=’t’, activation_token=’’)

    Problem solved. Many thanks for your help.

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Friday, April 25, 2014 5:05 PM

*To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

Galaxy does not really delete users. If you are trying to clear the user, just change its email as an admin and register the user again with the same address as before.

Martin

On Thu, Apr 24, 2014 at 8:56 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin,

  Thanks for the hint. After setting track_jobs_in_database to True,

the status of the new upload is waiting to run, which should be the behavior expected.

 Luckily when I modified the setting in universal_wsgi.ini, I noticed

that there is an option allow_user_deletion = True which enables the user deletion in UI. The problem is that even I deleted and purged one email, I still can re-register with that email. What is the solution to this? Direct SQL operation?

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Thursday, April 24, 2014 9:50 PM

*To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

the account activation is meant for multi-processor environments and these have to have the following option turned on in the configuration:

track_jobs_in_database = True

Please try to change it.

thank you

Martin

On Thu, Apr 24, 2014 at 4:27 PM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi Martin

  I am using Postgresql.

Best regards!

Jun

*From:* emulatorer@gmail.com [mailto:emulatorer@gmail.com] *On Behalf Of *Martin Cech *Sent:* Thursday, April 24, 2014 5:21 PM *To:* Jun Fan *Cc:* galaxy-dev@lists.bx.psu.edu *Subject:* Re: [galaxy-dev] user account

Hi Jun,

what kind of database are you using? This feature might not be supported for SQLite (as no production Galaxy should run on it :))

best

Martin

Galaxy Team

On Thu, Apr 24, 2014 at 11:42 AM, Jun Fan j.fan@qmul.ac.uk wrote:

Hi everyone

   I followed the instruction at

https://wiki.galaxyproject.org/Admin/UserAccounts to add email verification. I am using GMAIL SMTP server to send out the verification emails. Everything seems fine. If using one of the banned email, an error is there. After register, a verification email is successfully sent out and the page does say that without verification, no job and upload can be done. However when I tried, I CAN upload files and run jobs. The grace period is set to be 0. From the comment, I assume that there is no grace period at all which means no user activity can be carried out. Could anyone point out what I have done wrongly?

   The by-product of above test is that I need to delete the user I

created for test. I searched the dev mail list. The most recent one concerning this is the one sent by Nate in Nov 2011. I just could not find the py file he mentioned, probably that email is too old. I have done a grep search for “operations.append” and “item.deleted” and found two files requests_admin.py and requests.py under lib/galaxy/webapps/galaxy/controllers/. But they are not commented which means that I cannot uncomment them to make “delete user” function available in the UI as Nate suggested. Any guidance?

Best regards!

Jun

---

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/