How to reset admin password?

[edmarrp]

Hello,

I'm not a software specialist. Only a user.

I installed yesterday at night the Formtools. After, I created the first form and did tests for your use in my website. But It needs adjusts in layout and I would do it today.

But, when I wanted to do it, I couldn't access the formtools, because the admin password was changed.

In true, was add a 2nd password in one DB field called: "temp_reset_password".

I deleted the content of this field, thinking that the original password would be work, but it not has. I don't want redo the install if possible.

Questions:

1) Is this field original in the accounts table or was created by invasion?

2) How can I return to use the original password?

3) If it will be impossible, how can I reset the admin password? What command do I need use in Mysql panel?

Thank you!

[alexh]

First, try the password reset link. If that does not work, use these instructions from the documentation:


Tutorial Index
Restting Admin Password
You may find yourself in the sticky position where you've forgotten your administrator password. Ordinarily, you can just request the password to be sent to you via the "Forgot Password" link on the Form Tools login page, but if for whatever reason your email configuration isn't set up properly, you're rather stuck!

This short, one-page tutorial explains how to manually re-set your administrator password.

Requirements
Access to your database via a tool like phpMyAdmin, or something like it. If you don't have this, you will need to contact your hosting provider to ask them for access.

Resetting the password
All passwords are encrypted in the database, so you can't just update the database record with the new one. First, you need to encrypt it.

Go here: http://docs.formtools.org/encrypt.php
On that page, enter your new password and submit the form. Copy and paste the encrypted password to your clipboard.
Now access your database via phpMyAdmin and locate the ft_accounts table. The actual name of your table will depend on the database table prefix you chose when first installing it, but the default is ft_. If you're not sure, take a look at your /global/config.php file and the $g_table_prefix setting.
View the contents of the table and look at the very first row (account_id = 1). Edit the record and for the password column, paste the encrypted password into the field and save.
Now try logging into Form Tools. All should be well! If not, double-check that when you copied the password, it didn't tack on an extra space at the end. Browsers / OSs can do that, occasionally.

Hello,

I'm not a software specialist. Only a user.

I installed yesterday at night the Formtools. After, I created the first form and did tests for your use in my website. But It needs adjusts in layout and I would do it today.

But, when I wanted to do it, I couldn't access the formtools, because the admin password was changed.

In true, was add a 2nd password in one DB field called: "temp_reset_password".

I deleted the content of this field, thinking that the original password would be work, but it not has. I don't want redo the install if possible.

Questions:

1) Is this field original in the accounts table or was created by invasion?

2) How can I return to use the original password?

3) If it will be impossible, how can I reset the admin password? What command do I need use in Mysql panel?

Thank you!

[edmarrp]

First, try the password reset link. If that does not work, use these instructions from the documentation:


Tutorial Index
Restting Admin Password
You may find yourself in the sticky position where you've forgotten your administrator password. Ordinarily, you can just request the password to be sent to you via the "Forgot Password" link on the Form Tools login page, but if for whatever reason your email configuration isn't set up properly, you're rather stuck!

This short, one-page tutorial explains how to manually re-set your administrator password.

Requirements
Access to your database via a tool like phpMyAdmin, or something like it. If you don't have this, you will need to contact your hosting provider to ask them for access.

Resetting the password
All passwords are encrypted in the database, so you can't just update the database record with the new one. First, you need to encrypt it.

Go here: http://docs.formtools.org/encrypt.php
On that page, enter your new password and submit the form. Copy and paste the encrypted password to your clipboard.
Now access your database via phpMyAdmin and locate the ft_accounts table. The actual name of your table will depend on the database table prefix you chose when first installing it, but the default is ft_. If you're not sure, take a look at your /global/config.php file and the $g_table_prefix setting.
View the contents of the table and look at the very first row (account_id = 1). Edit the record and for the password column, paste the encrypted password into the field and save.
Now try logging into Form Tools. All should be well! If not, double-check that when you copied the password, it didn't tack on an extra space at the end. Browsers / OSs can do that, occasionally.

Hello,

I'm not a software specialist. Only a user.

I installed yesterday at night the Formtools. After, I created the first form and did tests for your use in my website. But It needs adjusts in layout and I would do it today.

But, when I wanted to do it, I couldn't access the formtools, because the admin password was changed.

In true, was add a 2nd password in one DB field called: "temp_reset_password".

I deleted the content of this field, thinking that the original password would be work, but it not has. I don't want redo the install if possible.

Questions:

1) Is this field original in the accounts table or was created by invasion?

2) How can I return to use the original password?

3) If it will be impossible, how can I reset the admin password? What command do I need use in Mysql panel?

Thank you!

Thank you for your attention. But it didn't resolve. Can be because were created the aditional field in the table? 2nd password in other DB field called: "temp_reset_password".

Is this field original in the table?

Where is the code settings for this field? Can be that is changed in the original code for password seach?

[alexh]

Yes temp_reset_password should be there and my guess is it's used in some way during password resets.

What kind of error do you get when you tried to follow the above instructions? Remember, you can't just put a new password in the database as-is be ause the system uses one way encryption.

Alex

[edmarrp]

"Sorry, that password does not match."

[alexh]

Just confirming that you used the http://docs.formtools.org/encrypt.php and pasted the response (with no added space characters) to password column for the admin account (account_id=1)? Then you tried to log in with the text that you entered to be encrypted i.e. your new password?

[Crexis]

Just confirming that you used the http://docs.formtools.org/encrypt.php and pasted the response (with no added space characters) to password column for the admin account (account_id=1)?  Then you tried to log in with the text that you entered to be encrypted i.e. your new password?

Argh! Exactly what I was looking for but the abovementioned link gives me a Page Not Found response. Had a look through the API.PHP and from what I could see, the password captured at account creation is just stored as an MD5 hash? Tried using an online MD5 encryption tool, pasted the hash into admin account password field but still get a "Sorry, that password does not match" error. Is the encrypt.php page available at another link? and/or can someone shed some light on how to correctly encrypt a new admin password PLEASE? TIA

[Crexis]

Just confirming that you used the http://docs.formtools.org/encrypt.php and pasted the response (with no added space characters) to password column for the admin account (account_id=1)?  Then you tried to log in with the text that you entered to be encrypted i.e. your new password?

Argh! Exactly what I was looking for but the abovementioned link gives me a Page Not Found response. Had a look through the API.PHP and from what I could see, the password captured at account creation is just stored as an MD5 hash? Tried using an online MD5 encryption tool, pasted the hash into admin account password field but still get a "Sorry, that password does not match" error. Is the encrypt.php page available at another link? and/or can someone shed some light on how to correctly encrypt a new admin password PLEASE? TIA

I figured it out! Took another look at api.php and realised it's an MD5 of an MD5 of the plain text pwd. Hallelujah!