I have recently upgraded our companys internal forum from snitz 3.4.03 to snitz 3.4.06 and wish to replace the existing DB based authentication with NT based one (its becoming dificult to remember a domain password and then logon to forum with another). I want to preserve my earlier posts.
We have a win 2k based Active directory domain. But since it runs in mixed mode i can use NT authentication as well.
Forgot to mention that the NT login works fine provided the DB does not already have a username or email id that is same as the 2000 domain. If the username in DB matches one in domain i get the error
There Was A Problem With Your Details
* E-mail Address already in use, Please Choose Another * E-mail Address already in use, Please Choose Another Go Back To Enter Data
Now the problem i face is all my forum user id match their windows domain user id. This was initially done so that people dont have to remember multiple usernames (though they need to remember password)
How can i migrate to windows NT authentication by matching the DB user with corresponding NT domain userid?
secondly when i login i can only act as user "admin". i cannot be logon as sibi. The top right of the forum displays
You are logged on as admin (sibi)
I cleared the browsers cache and cookies and now snitz says
Please register to post in these Forums Forgot your Admin Password?
If i try the register link i get
Registration for this account is not necessary.
This NT User account has already been registered.
If i try to post something i get the editor but it has to new fields "username" and "password" just below the "screensize" dropdown. If i enter username as "sibi" and then my password the posting succeeds but when i look at the posting it shows the user who did the posting as "admin"
Assuming that their DB Username is the same as their NT username, you could write up a little script to copy all the values in M_NAME to M_USERNAME. It would be a very good idea to shut down the forums while you were doing this... and make backups just in case.
Thank you very much it worked for me. But now i face a new problem. when a new user (was not previously present in the members table in database ) tried to register for the first time i got the error
There Was A Problem With Your Details
* E-mail Address already in use, Please Choose Another
i checked the table but could not find any matching email id.
quote:Originally posted by AnonJr
Assuming that their DB Username is the same as their NT username, you could write up a little script to copy all the values in M_NAME to M_USERNAME. It would be a very good idea to shut down the forums while you were doing this... and make backups just in case.