OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



change usernames

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

change usernames

Postby Krekels » Wed Apr 26, 2006 8:28 am

Hello,

For an new launch of an existing journal we import the current user registration files. That all works fine. But now we initially register the users by ther registration number which will easily be forgotten. It would be very nice if users could change their username in their profile. Is this in any way possible.

Kind Regards,

Hubert Krekels
Krekels
 
Posts: 17
Joined: Mon Dec 05, 2005 9:02 am

Postby asmecher » Wed Apr 26, 2006 8:39 am

Hi Hubert,

You'll have to do this in the database as follows:
Code: Select all
UPDATE users SET username='new_username_here', password=MD5(CONCAT('new_username_here', 'new_password_here')) WHERE username='old_username_here';
Note that you'll have to reset passwords as well, since they are part of the password hash. (In this example, I'm using MD5 hashing; check which hashing function you're using in OJS's config.inc.php file.)

Regards,
Alec Smecher
Open Journal Systems Team
Last edited by asmecher on Tue May 22, 2007 9:42 am, edited 1 time in total.
asmecher
 
Posts: 8869
Joined: Wed Aug 10, 2005 12:56 pm

username key in system?

Postby Liz » Mon Jul 24, 2006 3:28 pm

I just want to check that the username is not a key elsewhere in the system that will cause problems later down the road?
Liz
 
Posts: 17
Joined: Wed Nov 16, 2005 12:15 pm

Postby asmecher » Mon Jul 24, 2006 3:47 pm

Hi Liz,

No, the username is not used as a key elsewhere. The only gotcha is that you'll have to re-hash the password as above.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 8869
Joined: Wed Aug 10, 2005 12:56 pm

Re: change usernames

Postby msengulj » Mon Oct 20, 2014 3:26 pm

Hello Alec, Thanks for this detail. Has anything changed in terms of changing usernames since 2006? I would like to change the usernames of a few members of our journal on their behalf. If not, I am also unclear exactly what it means to "do this in the database as follows:" where would the "database" be that I'd be inserting new code?

Thanks for your help in advance.
MSJ
msengulj
 
Posts: 6
Joined: Tue Aug 05, 2014 12:11 am

Re: change usernames

Postby asmecher » Mon Oct 20, 2014 3:49 pm

Hi MSJ,

No, we're still using the same approach to usernames. The statement quoted above is a database SQL statement; you'll have to execute it in a database client, e.g. phpMyAdmin.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8869
Joined: Wed Aug 10, 2005 12:56 pm

Re: change usernames

Postby msengulj » Mon Oct 20, 2014 5:29 pm

Hi Alec, thanks for the quick response. I actually found a different work-around. I enrolled users using different email addresses and this time put their preferred username. Then I went in and merged the users, so that the old user was merged with the new user. Then I changed the email address so that their initial address was affiliated with the entry.
msengulj
 
Posts: 6
Joined: Tue Aug 05, 2014 12:11 am


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 5 guests