| Author |
 Topic Search  Topic Options
|
venamore 
Newbie
Joined: 21 February 2008
Location: Brisbane, AU
Status: Offline
Points: 10
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Can't login after user import
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.  |
 |
StarDust
Senior Member
Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
venamore
Newbie
Joined: 21 February 2008
Location: Brisbane, AU
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
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. |
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
venamore
Newbie
Joined: 21 February 2008
Location: Brisbane, AU
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
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. |
|
venamore
Newbie
Joined: 21 February 2008
Location: Brisbane, AU
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
venamore
Newbie
Joined: 21 February 2008
Location: Brisbane, AU
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
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. |
|
Tips, mods and skins for WWF v9.x