In the table called *_users, find the line corresponding to the admin account. Note the value 'salt' for that line.
Once you have this value, you need to modify the value 'token' so that its value is the sha1 result of the concatenation of the 'salt' value and your new password. So, if the 'salt' value is beedb22a1cf74 and the password is 'dummy', put beedb22a1cf74dummy in the sha1 function.
phpMyAdmin allows you to do that easily. Doing it through command line shouldn't be too hard either.
Sorry I feel a bit stupid here. What is an sha1 value, and where do you find it?
I got as far as phpmyadmin (not sure how easy it would have been on the command line myself), and can find the pp_users table, found the salt value and then you lose me.
[1] If Forgot password fails
You will need to manually update data into database. Open users table and find your administrator user (by username). Update that row and set:
token: 0a92df346e3a833cae214d65af35e69b3cf4e5ab
salt: 6d093346fa02f
twister: 4982716305
That will set password to '123'. Login and update you password. Make sure that mailing is working (you can use Test mailing configuration tool in administration).
sha1 is a function that encrypts the password value. You can find it in phpMyAdmin when you add or edit a row.
The way to use it is to edit the row and you should see a table with 'field', 'type', 'function', 'null' and 'value'.
If you click on the function drop-down, you can select different things including 'sha1'.
So for the row 'token', you would select sha1 as the function and in the 'value' field you would type the combination salt+password and let phpMyAdmin apply the function sha1 to it.
Taking my example above, that means that if the 'salt' value is beedb22a1cf74 and the password is 'dummy', put beedb22a1cf74dummy in the 'value' cell of the row 'token' and select sha1 in the 'function' column. phpMyAdmin will take beedb22a1cf74dummy through sha1 and everything will work fine :)
If you take the example given in the documentation, and using this online tool (or any other of course), you'll see that it works the same.
Type in 6d093346fa02f123 (which is the salt and '123') and press "SHA1 THIS!". The result will be what is given in the manual for the token value:
0a92df346e3a833cae214d65af35e69b3cf4e5ab
In the table called *_users, find the line corresponding to the admin account. Note the value 'salt' for that line.
Once you have this value, you need to modify the value 'token' so that its value is the sha1 result of the concatenation of the 'salt' value and your new password. So, if the 'salt' value is beedb22a1cf74 and the password is 'dummy', put beedb22a1cf74dummy in the sha1 function.
phpMyAdmin allows you to do that easily. Doing it through command line shouldn't be too hard either.
According to the code, that will work just fine!
Tim
Sorry I feel a bit stupid here. What is an sha1 value, and where do you find it?
I got as far as phpmyadmin (not sure how easy it would have been on the command line myself), and can find the pp_users table, found the salt value and then you lose me.
Where would this sha1 be?
Though this bit of the manual has more useful way to reset the password.
http://www.projectpier.org/manual/installation/upgradefromac
somewhere down the bottom you'll find...
[1] If Forgot password fails
You will need to manually update data into database. Open users table and find your administrator user (by username). Update that row and set:
token: 0a92df346e3a833cae214d65af35e69b3cf4e5ab
salt: 6d093346fa02f
twister: 4982716305
That will set password to '123'. Login and update you password. Make sure that mailing is working (you can use Test mailing configuration tool in administration).
Hi rob0,
sha1 is a function that encrypts the password value. You can find it in phpMyAdmin when you add or edit a row.
The way to use it is to edit the row and you should see a table with 'field', 'type', 'function', 'null' and 'value'.
If you click on the function drop-down, you can select different things including 'sha1'.
So for the row 'token', you would select sha1 as the function and in the 'value' field you would type the combination salt+password and let phpMyAdmin apply the function sha1 to it.
Taking my example above, that means that if the 'salt' value is beedb22a1cf74 and the password is 'dummy', put beedb22a1cf74dummy in the 'value' cell of the row 'token' and select sha1 in the 'function' column. phpMyAdmin will take beedb22a1cf74dummy through sha1 and everything will work fine :)
If you take the example given in the documentation, and using this online tool (or any other of course), you'll see that it works the same.
Type in 6d093346fa02f123 (which is the salt and '123') and press "SHA1 THIS!". The result will be what is given in the manual for the token value:
0a92df346e3a833cae214d65af35e69b3cf4e5ab
Hope that helps!
Tim