Can't login after user import
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=25366
Printed Date: 03 April 2026 at 9:45am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Can't login after user import
Posted By: venamore
Subject: Can't login after user import
Date Posted: 29 February 2008 at 6:25am
|
Hi,
I thought I may have seen a topic about this a couple of weeks ago but I don't seem to be able to find it again, so forgive me if this has already been asked...
I have imported my users from a SQL Server database, but now when I try to log in as any of those newly created users it says the password is wrong. I have redone it a couple of times now to ensure that I entered the password field correctly, but I still get this problem.
Any ideas? I would appreciate it greatly.
 |
Replies:
Posted By: StarDust
Date Posted: 29 February 2008 at 7:24am
|
Sometimes passwords do not remain the same during an update/migration. Your members will have to use forget password link from the login screen or you have to reset the passwords.
------------- http://board.ebizbd.net/">  Tips, mods and skins for WWF v9.x
|
Posted By: venamore
Date Posted: 29 February 2008 at 9:39pm
|
Thanks Stardust.
But this is a brand new WWF9 installation, not an upgrade. I am importing members from another entirely different database (ie an intranet member database from my work).
Do the passwords in the old database (the one I am importing from) need to be encrypted in the exact same way as they are in WWF for the passwords to come across successfully? At the moment I have them in just plain unencrypted text format.
Thanks.
|
Posted By: WebWiz-Bruce
Date Posted: 29 February 2008 at 10:19pm
|
Plain text passwords should import fine, they are encrypted as they are imported into Web Wiz Forums. Owing to the different schemas of different databases importing from another database will always be slightly hit and miss. If you don't succeed the first try and again, making sure the field names you enter are correct for the member name and password fields. ------------- 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: venamore
Date Posted: 02 March 2008 at 11:15pm
|
Hi again,
Thanks. I have tried the import again, but it again does not import the passwords correctly (looking at the database tables directly shows that the user name seems to have come across correctly though).
I thought that it may be something to do with the field name I was using in the database I was importing from. I had it called 'Password' and it was an nvarchar(8). So I renamed it to 'Passwordy' just to make sure there was no reserved word conflict or something. The same problem was occurring though.
More detail on my setup is that I created the import tables in the Forum database. (I created separate tables for each different group that I was importing to in my forum, so that I could import my access DB into each of these tables I had created) Is this likely to cause an issue? Is there some other more stable way of doing it? Thanks.
|
Posted By: venamore
Date Posted: 04 March 2008 at 1:24am
|
Anyone else got any ideas about how to fix this issue? I'm really struggling here now because being able to import users with the correct password is critical to my implementation. Thanks. |
Posted By: WebWiz-Bruce
Date Posted: 04 March 2008 at 9:50am
|
If you are wanting to combine the forum with a present membership system have you thought about using the existing member API instead. It gives a very tight integration between your own member system and the forums.
------------- 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: venamore
Date Posted: 05 March 2008 at 3:51am
|
OK. I got that working after your idea. I was actually trying to create a situation where the members in my website database were only a subset of those allowed access to the forum. Which is why I wanted to import the users from my DB into the forum and then create 'extra' forum members after doing that.
So setting the API setting worked nicely (it turns out even though I did import the members from my other DB, that I didn't need to worry about the password anyway, because the API sorted this out for me).
Thanks again for sorting me out.
|
Posted By: sphrasch
Date Posted: 01 July 2008 at 4:12pm
|
Hi!
I too have this problem.
I import about 3000 users in a new installation of the forum.
I import from plain text, but the password does not work after import.
If I alter the password after having sent a new one from the login page, then it works.
I believe there is something wrong with the import function when encrypting the passwords.
I know that I am using the correct database fields
regards,
Steinar
|
Posted By: WebWiz-Bruce
Date Posted: 01 July 2008 at 4:20pm
|
Try removing line 403 of admin_import_members.asp and see if that works.
------------- 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: sphrasch
Date Posted: 01 July 2008 at 5:03pm
|
Hi!
No, this did not work either.
There must be something else.
Is it possible to import in plain text and login in plain text?
Steinar
|
Posted By: WebWiz-Bruce
Date Posted: 01 July 2008 at 5:16pm
|
Passwords would need to be encrypted. Make sure the passwords that you are bringing in our not encrypted. The generic import tool does work in allot of cases, but as you don'[t know how the data is stored then you can not guarantee that the import will work. For example if the imported data is in a different character set it can mean that it would fail. ------------- 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: sphrasch
Date Posted: 01 July 2008 at 5:22pm
|
Hi!
The character sets are identical: database_default and nvarchar.
Usernames from import are like: demo
Password from import are like: demo01
Is there a way to check if the passwords are getting encrypted the right way when importing?
Steinar
|
Posted By: WebWiz-Bruce
Date Posted: 02 July 2008 at 8:01am
|
They are encrypted in the correct way as other people are able to use this tool and in our own tests it does work. However, like I mention many things can course issues, although the database maybe using nvarchar it may not store the data in the same way. The database may be using a different collation the data may have used an ISO character set on the previous website to store the data, and Web Wiz Forums is using UTF-8. There are many possabilities that could course the type of issue you have. ------------- 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: PedroCury
Date Posted: 20 July 2008 at 7:14pm
|
I had the same problem. I did the import on almost 11.000 users (and it was a pain, since the server always timed out!) and they can´t login.
The password field used to be plaintexto too.
I will not go over the import process again, since I had to do it for each letter. So I´m choosing to let the users retrive their login via the password remembering page.
The problem is... The "Forgot your password" link is not showing up!!! Why ?
Do I need to activate it somehow by a forum config ? It´s a brand new wwf 9.5 instalation.
Any help ?
|
Posted By: WebWiz-Bruce
Date Posted: 21 July 2008 at 9:00am
|
You need to enable the email notification from the email settings page in the admin area. You will then see a 'forgotten password' link next to the text box you use to put in your password. ------------- 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: intrinicity
Date Posted: 06 August 2008 at 4:47pm
|
Hi Bruce, I too, am having the exact same issue. I have given up trying to import the 1500 entries that I have and have been testing it by creating a nice clean access database with one record, with username and password typed in clear text - and I still can't login in with the password.
The username is obviously OK, because I can request a new password to be sent, which works fine. I read in this post that this facility works fine in your testing, so I was wondering if you could send me a single record DB that DOES work for you, so I can compare yours with mine. I am using Access 2002 and both the username and password are default text fields (50 chars). Is there a way of reversing the encryption so I can see what is being stored? I guess not ...
Anyway, if I could just make it work for a single text record, that would give me a clue as to what I am doing wrong - thanks
|