Web Wiz Support and Community Forums : Importing member user name passwords https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 21:18:16 +0000 Wed, 17 Dec 2003 07:34:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7931 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Importing member user name passwords : The Hash1 functions are fully...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41828.html#41828 Author: michael
Subject: 7931
Posted: 17 December 2003 at 7:34am

The Hash1 functions are fully VBA compatible so you can just paste the whole code into a new module in Access and Create an update query to encrypt your passwords.]]> Wed, 17 Dec 2003 07:34:29 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41828.html#41828 <![CDATA[Importing member user name passwords : Yes, but your method involves...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41760.html#41760 Author: ljamal
Subject: 7931
Posted: 16 December 2003 at 4:48pm

Yes, but your method involves having a 6.x database which is not readily available. It's much easier to just import the usernames and passwords as plain text, generate a SALT value and then encrypt.]]> Tue, 16 Dec 2003 16:48:02 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41760.html#41760 <![CDATA[Importing member user name passwords : Precisely ljamal. That&#039;s...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41744.html#41744 Author: Nigelo
Subject: 7931
Posted: 16 December 2003 at 3:53pm

Precisely ljamal. That's why I described an easy way to do just that using my Migrator App which already has Borg's encryption process built in!

Edited by Nigelo]]> Tue, 16 Dec 2003 15:53:43 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41744.html#41744 <![CDATA[Importing member user name passwords : The easiest way to get to encrypted...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41334.html#41334 Author: ljamal
Subject: 7931
Posted: 14 December 2003 at 9:54pm

The easiest way to get to encrypted passwords from unencrypted passwords is import the unencrypted password and then update the passwords with the encryption.]]> Sun, 14 Dec 2003 21:54:00 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41334.html#41334 <![CDATA[Importing member user name passwords : Use a v6.x version of Borg&#039;s...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41299.html#41299 Author: Nigelo
Subject: 7931
Posted: 14 December 2003 at 5:56pm

Use a v6.x version of Borg's DB and copy your users/pws into the appropriate fields in tblAuthors. You may need to set some other v6.x fields in tblAuthors to their logical defaults AND paying attention to related tables (GroupId being one of them - So remember to set the Groups first!). Finally, run it through the migrator app being sure to follow instructions.

This should work but remember the migrator was designed for a standard production v6.x source and not an artificially built dataset.  

]]> Sun, 14 Dec 2003 17:56:13 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post41299.html#41299 <![CDATA[Importing member user name passwords : You misunderstand what I am trying...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40380.html#40380 Author: donaldhill
Subject: 7931
Posted: 09 December 2003 at 4:08am

You misunderstand what I am trying to say Borg. Or rather, I am probably not explaining myself clearly enough.

 

This sis what I am trying to do.

I have alist of 1000 user names and passwords from an external database. I wish to insert these records into your forum database but the passwords are not encrypted and they need to be. Also, I plan to change the user names at yearly intervals and put them into diferent groups within the forum.

So each year I plan to import the user name and password list from external database and then place them into yopur database then migrate them into the final database as encrypted user name passwords.

My problem is to get them imported to the database encrypted.

 

(It is a school based list of names and they are bing matched to teachers so each forum can be for a class and teacher)

 

 

]]> Tue, 09 Dec 2003 04:08:22 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40380.html#40380 <![CDATA[Importing member user name passwords : The upgrade tool is for version...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40378.html#40378 Author: WebWiz-Bruce
Subject: 7931
Posted: 09 December 2003 at 4:03am

The upgrade tool is for version 6.x to 7.x this tool is not needed for upgrading between versions 7.x to 7.x

If you are using access version 7.x all you need to do is keep your old database and just replace the files.
]]> Tue, 09 Dec 2003 04:03:48 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40378.html#40378 <![CDATA[Importing member user name passwords : I downloaded the mograting tool...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40373.html#40373 Author: donaldhill
Subject: 7931
Posted: 09 December 2003 at 3:53am

I downloaded the mograting tool but since I did not have  an earlier version of 6.34 I decided to try to migrate a databse 7.01 to 7.6 and followed the procedure as mentioned in migration tool read me.

 

When I ran the migrating tool it came up with a dialogue box asking for a parameterer value. I tried -1 and that did nothing but when I used 1 it processed then came up with an error 0.

 

When I looked at the new database it had the users name and passwords transferred from the 7.01 database and all encrypted.

 

This seems to work but I havent tried to open the forum etc yet.

 

Can anyone of you who knows whats going on in this process say whether the migrating tool will work ok in this instance???

 

If it does, then everyone can move large databse rtecords of user names/passwords into a temp database and then migrate them to a real databsae as encrypted users.

 

 

And what happens to any original data and posts in the original database?

If I wanted to start with a new customer list each year but keep the forum categories etc are they unchanged?



Edited by donaldhill]]> Tue, 09 Dec 2003 03:53:12 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40373.html#40373 <![CDATA[Importing member user name passwords : psycotik wrote:Which version...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40257.html#40257 Author: india
Subject: 7931
Posted: 08 December 2003 at 1:51am

Originally posted by psycotik psycotik wrote:

Which version is it that encryption started? If you find the code for the upgrade wizard you will find a way to convert passwords to hashes.


The encryption has been used for v7.0 and above.
There is a way but im not SURE whether it works or not.
if you have forum v6.x copt the userid and pass in the db and run in v6.0. then upgrade to v7.0. it should auto encrypt]]> Mon, 08 Dec 2003 01:51:27 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40257.html#40257 <![CDATA[Importing member user name passwords : donaldhill wrote: thanks guys, but...]]> https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40256.html#40256 Author: india
Subject: 7931
Posted: 08 December 2003 at 1:49am

Originally posted by donaldhill donaldhill wrote:

thanks guys,

 

but does that turning off the encryption process mean the passwords are never encrypted?

*** How will you turn off encryption?
Moreover, its a security risk.
Forum v7.0 and above have pass encrypted but if you write in plain text it WILL NOT WORK.

What can be done to encrypt them?

*** my R&D says there is a way out. Like suppose you are installing a new forum. You register and put user xyz pass abc. Go to database. Notice the encryptedd form of the pass abc. then copy in all of them. so all users will get a pass of abc by default

My replies in " *** " 

]]> Mon, 08 Dec 2003 01:49:26 +0000 https://forums.webwiz.net/importing-member-user-name-passwords_topic7931_post40256.html#40256