You are viewing the PKP Support Forum | PKP Home Wiki

Forgotten Username and Password

Open Harvester Systems support questions and answers, bug reports, and development issues.

Moderators: jmacgreg, michael, John

Forum rules
Developer Resources:

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome.

Forgotten Username and Password

Postby kyle » Fri Oct 06, 2006 10:27 am

Hi All,

I cannot login into the admin section of the harvester because I have forgotten the username and password. Is there anyway to regain control of the system (Yes I know, real brillant on my part - Doh! ;-) )

Thank you in advance for any help,
Posts: 2
Joined: Fri Oct 06, 2006 10:16 am

Postby asmecher » Sat Oct 07, 2006 5:54 am

Hi Kyle,

You can find out your username with the following SQL statement in MySQL:
Code: Select all
select setting_value from site_settings where setting_name = 'username';
You can then reset your password with the following:
Code: Select all
update site_settings set setting_value = md5(concat('username_goes_here', 'password_goes_here')) where setting_name = 'password';
You may be using SHA1 hashing, if enabled in config.php; in this case, use the "sha1" function instead of the "md5" function in the above statement.

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

Return to Open Harvester Systems Support and Development

Who is online

Users browsing this forum: No registered users and 2 guests