Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Upgrade from 7.5 to Latest Stable Version
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrade from 7.5 to Latest Stable Version

 Post Reply Post Reply Page  <12
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 9:14am
The problem is that we are not able to replicate this issue in the lab and have not seen this issue with any other version 7.x upgrades, so seems this issue is unique to your own setup, which makes making a 'fix' as you call it in future updates not possible as it may not be the forum code in error here.

I have gone through to compare the code for passwords at login time and the code is identical for version 7.x and version 10.x, the only difference is that in version 7.x all passwords are set to lower case, whereas version 10 does not lower case passwords.

If you want passwords to be lower case like in version 7.x then change the line 148 in the file functions/functions_login.asp to that below:-

strPassword = LCase(strPassword) & rsCommon("Salt")


Edited by WebWiz-Bruce - 30 June 2011 at 4:45pm
Back to Top
rjcarter View Drop Down
Newbie
Newbie


Joined: 27 June 2011
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote rjcarter Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 3:31pm
So I am positive the issue is with the case sensitivity of passwords.  In the 7.x version passwords are set to lower case as your state.  But there is no indication on the login or register screen to inform the users of that fact.  So, my users are under the assumption that what they typed as a password is their password.  If I rollout this upgrade users will type in their password as they remember it not as the system stores it, lower case 7.x, in the 10.x system and will not be allowed to login.  Kinda of confusing.

I tried to edit the file functions/functions_login_user.asp in v 10.x to see if this can be a workaround, but that file does not exists.  If you can tell me the areas where I can change the code to lower case passwords then we might have a workaround.

Also, how will this change effect future accounts?  I would thing that a change would need to take place in the register and update password functions as well.  So if I update a password or create a new one and that code does not lower case the password, but the login screen does then we might have a password mismatch as well.

Thanks for your continued support in helping resolve this matter.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 3:51pm
If you want passwords to be lower case like in version 7.x then change the line 148 in the file functions/functions_login.asp to that below:-

strPassword = LCase(strPassword) & rsCommon("Salt")
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 4:00pm
In all versions of Web Wiz Forums prior to version 10 passwords where stored in lower case. Version 10 adds a new option whereby you can enforce password complexity so that members have to have passwords with lower case, upper case, and a number. This has been bought in as some government organisations require this.

This means that all forums prior to version 10 has their passwords are stored in lower case no matter what case the member entered their passwords. Version 10 honours the case that the member enters their password and does not change it to lower case.


Edited by WebWiz-Bruce - 30 June 2011 at 4:48pm
Back to Top
kiklop View Drop Down
Groupie
Groupie


Joined: 14 July 2005
Status: Offline
Points: 137
Post Options Post Options   Thanks (0) Thanks(0)   Quote kiklop Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 4:47pm
Just to let you know that i did experienced the same issue; it made me crazy but luckily i found this thread.

In my case however, i have v10 installed on my local server (with online database restored locally) for testing purposes. I have my password with mixed case that is working online (v9) but on the local forum (which i updated to v10) i need to use lower case only.

Back to Top
rjcarter View Drop Down
Newbie
Newbie


Joined: 27 June 2011
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote rjcarter Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 6:31pm
I downloaded and installed WWF 9.74
I registered a user testuser with a password, 'TestPassword' Of course we know the system will store 'testpassword', but the user does not know this.  There is nothing telling them this.

I downloaded and installed WWF 10 - Upgraded the WWF 9.74 to 10
I tried to login with the same user 'testuser' and password, 'TestPassword' and it fails since version 9.74 lowercased my password without letting the user know.

So I have about 3500 registered users in my 7.x forum. They have no idea that the system lower cased their passwords. So, when I upgrade to 10.x they would not be able to login because their passwords are lower case and they don't know this.

Workarounds
Send a mass email my registered users notifying them that their passwords are really lower case so they can login and then change to mixed case if they wish.  Don't know how effective this would be.

Rollback the case sensitivity in the login form.  Tried this but if a new user registers then the password is stored in mixed case and the login form will lower case the password and new user will not be able to login.  If you can tell me where I need to make the LCase() to handle passwords changes and new user registrations, I can do that.  This might be a temporary workaround until a more permanent fix could be implemented.  The places I have seen are:

login_user.asp line 110 - strPassword = Trim(Mid(Request.Form("password"), 1, 20))
This will lower case the password they type when they login
Change to:
strPassword = LCase(Trim(Mid(Request.Form("password"), 1, 20)))

register.asp line 333 - strPassword = Trim(Mid(Request.Form("password1"), 1, 20))
This will lower case the password they type in when they register or update their password.
Change to:
strPassword = LCase(Trim(Mid(Request.Form("password1"), 1, 20)))


What do you think about those changes?

EDIT:
Found those lines of code here as well:
admin.asp line 89
admin_register.asp line 145


Edited by rjcarter - 30 June 2011 at 6:41pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2011 at 7:22pm
The next release version 10.01 will have a system to allow old legacy passwords to work, so this would not be an issue as those with older lower cased passwords will still be able to login as will those with newer case sensitive passwords.



Edited by WebWiz-Bruce - 01 July 2011 at 9:02am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2011 at 9:04am
Have now released a new minor release, Web Wiz Forums 10.01, that has a fix for this issue as it will automatically detect old legacy passwords allowing members to login with both legacy and new case sensitive passwords.

You can download 10.01 with this fix from the Web Wiz Forums Download page.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.