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....@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=’h...@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:* emulato...@gmail.com [mailto:emulato...@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....@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:* emulato...@gmail.com [mailto:emulato...@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....@qmul.ac.uk> wrote: > > Hi Martin > > > > I am using Postgresql. > > > > Best regards! > > Jun > > > > *From:* emulato...@gmail.com [mailto:emulato...@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....@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/ > > > > > > >
___________________________________________________________ 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/
