Cant Recover Lost PW
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20065
Printed Date: 11 April 2026 at 2:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Cant Recover Lost PW
Posted By: jamesbradford
Subject: Cant Recover Lost PW
Date Posted: 27 May 2006 at 11:06pm
I am the owner of a WW Forum and I have forgotten my password, but I cant recover it! I went into HELP and its says an option to reset it can be emailed using a link at the bottom of the login page but I see no such link! I have trid to manually go to the forgotten_password.asp but it just takes me to the main page
What can I do?
|
Replies:
Posted By: dj air
Date Posted: 27 May 2006 at 11:54pm
you have to have email features enabled and a valid email address within the profile.
the other option is to edit the database replacing the password and salt fields for the user replacing with the default values found within a fresh database/ or within the SQL install script.
|
Posted By: jamesbradford
Date Posted: 28 May 2006 at 3:46am
So I assume to enable email feature would require logging into the board as the owner?
How do I do the second thing you just stated? You're talking Greek to me, please explain in detail?
Thanks
J
|
Posted By: WebWiz-Bruce
Date Posted: 28 May 2006 at 11:10am
If you have an valid email address and enabled the email tools then you can use the forgotten password feature when loging in.
If you don't have that what you will need to do is:-
1.Open the database
2. Open the table tblAuthor
3. Find Author_ID with the value of 1, this is your admin account
4. Copy and paste the following to the username field:-
administrator
5. Copy and paste the following to the password field:-
A85B3E67CFA695D711570FB9822C0CF82871903B
6. Copy and paste the following to the 'Salt' field:-
72964E7
Your admin username and password should now be reset to:-
user: administrator
pass: letmein
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jamesbradford
Date Posted: 28 May 2006 at 4:27pm
Ok. So I've opened the database, and I've opened "tblAuthor"
I only see 'Author_ID' twice. The first is under COLUMNS, and the second is under INDEXES
I can't really determine if any of them have a value of 1 because I don't know what that means. But the first one has several "1's" in it's row. But I dont see any fields with username, apssword, or salt. What I see is this:
Type Length Prec. Scale Nullable Default Id. Id. Start Id. Seed
So clearly I must be doing something wrong.
J
|
Posted By: WebWiz-Bruce
Date Posted: 28 May 2006 at 7:44pm
You didn't mention the database version you are using, in Access you simply open the table, to view the data within the table, but in other databases you may need to run an SQL query on the table to see the data stored within the table.
Once you can view the data within the database table you can usually edit it, as per the instructions, but again it depends on the database you are using.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jamesbradford
Date Posted: 29 May 2006 at 2:15am
Ok. We're getting somewhere ;)
So in my MYSQL functions I have something that says "Query Analyser". But then there is just a big blank box underneath that I would guess I'm supposed to type something into? And then a submit/reset set of buttons. I also have the option to "show execution plan". So what now?
Thank you for your continued help
J
|
Posted By: jamesbradford
Date Posted: 30 May 2006 at 9:45pm
Posted By: WebWiz-Bruce
Date Posted: 31 May 2006 at 3:27pm
OK, now were getting somewhere, you are using mySQL.
With mySQL you will need to download some software that allows you to view and modify mySQL database tables like SQLyog
This will then allow you to enter data directly into the database tables, os you can follow the instructions I gave in my previous post.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jamesbradford
Date Posted: 31 May 2006 at 7:43pm
I'm sorry, I'm afraid I gave you wrong information. This is all so new to me, and I am having a hard time remembering whether I have MySQL or just SQL.
In fact I am NOT using "MySQL"; I am using an MS SQL Server Database.
And again, to repeat what I said above: When i go into the SQL functions I have something that says "Query Analyser". But
then there is just a big blank box underneath that I would guess I'm
supposed to type something into? And then a submit/reset set of
buttons. I also have the option to "show execution plan". So what now?
|
Posted By: WebWiz-Bruce
Date Posted: 01 June 2006 at 10:28am
SQL Sever is different again.
You don't use the query analyser in SQL Server, you should be able to right click the table and choose 'Open Table', as simple as that.
However, this can be different depending on which version of SQL Server you are using and the tool you use connecting to the database.
Before I waste anymore time going through stuff that is not applicable, could be please tell me:-
What database are you using?
What database version?
What tool are you using to connect to the database?
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|