Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2006, 02:22 PM
scowby scowby is offline
 
Join Date: Jul 2006
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default importing passwords from different system - how to migrate

I have a custom-built user forum that I am migrating over into VBulletin (v3.5.4).

One issue I am facing is how to port all of the current user passwords over from the old system, which simply uses an md5 encryption of the password, and into VBulletin, which uses this additional "salt" field.

Since VBulletin uses an md5 encryption of the user's plaintext password along with this "salt" mechanism, is there any way to do this, since I don't have copies of the plain-text passwords for my users?

Or, Is there a way to get VBulletin to use a simple md5 encryption of the password only, and disable using the extra "salt?"

What is a good suggestion on how to migrate my user base into VBulletin given this password issue?

Thanks!!
Reply With Quote
  #2  
Old 07-19-2006, 03:30 PM
Mastar's Avatar
Mastar Mastar is offline
 
Join Date: Sep 2005
Posts: 680
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you using Impex? If not may I suggest it!
Reply With Quote
  #3  
Old 07-19-2006, 05:36 PM
scowby scowby is offline
 
Join Date: Jul 2006
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi, I can't use Impex because the source board is not one that's supported. Just a note that I didn't get too involved researching Impex because of this limitation.

I read through the Impex docs and it also looks like there might be issues importing passwords from other systems as well - is there any more detail to this? Like, does phpBB store passwords in md5 encrypted format, and can Impex import these password types? If so, then it'd work for me - it's just that Impex isn't natively going to be able to port my board over.

So, in summary - can passwords from other systems that encrypt using simple md5 encryption be imported?

Thanks!
Reply With Quote
  #4  
Old 07-19-2006, 05:53 PM
Mastar's Avatar
Mastar Mastar is offline
 
Join Date: Sep 2005
Posts: 680
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've imported a couple of boards from phpbb to vb using impex.
Reply With Quote
  #5  
Old 07-19-2006, 06:45 PM
scowby scowby is offline
 
Join Date: Jul 2006
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What I'm saying is I am using a *custom* built board, not phpBB, but I had the thought maybe phpBB uses md5() encryption for it's passwords, much like my current board does.

Any thoughts on this password thing?
Reply With Quote
  #6  
Old 07-19-2006, 10:06 PM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you actually enquired at vB.com regarding an import? It is possible that they may be able to help.
Reply With Quote
  #7  
Old 07-19-2006, 11:21 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vb does a double conversion like this ;

Hash = MD5( MD5(password) . SALT )

Since you have the MD5(password) already, to convert your hashes to vb format you just need to do MD5 ( HASH . SALT ) - where HASH is your current MD5 hash and SALT is the users salt (stored in the user table). Obviously for a new import, you could create the salt yourself, and then store it in the user table at the same time as everything else.
Reply With Quote
  #8  
Old 07-20-2006, 12:58 PM
scowby scowby is offline
 
Join Date: Jul 2006
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great! Thanks for your post. This is exactly the information I was looking for.

I will try it out and see how it works!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:44 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03862 seconds
  • Memory Usage 2,221KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete