Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Site Migration

Asked Modified Viewed 1,340 times
S
SurreyPool
S
  • Newbie, joined since
  • Contributed 5 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
asked
Newbie

We have an old site based on an old CMS called MyPHPnuke.

We have replicated the site, and all of it's news articles on PHPFusion, and are ready to move.

But....

We have over 400 registered users on the old site, and would like to move them automatically without them having to register again.

Is it even possible to map the old data across to the new database, or is it likely that the password encryption method used would be completely different?

Thx for any words of advice.
Edited by SurreyPool on 10-02-2008 20:15,
0 replies

7 posts

M
MrSimple
M
Make it work... keep it simple...
  • Senior Member, joined since
  • Contributed 324 posts on the community forums.
  • Started 7 threads in the forums
answered
Senior Member

Not a real answer but a suggestion on how to get around this....
I guess that password encryption is different on both cms's. So exporting the users from one and importing them to the other most likely isn't going to work.
You could import them and set a default password. Send them a message with the default password and let them change their password. But don't use the same default for all users....
Not an easy way but it might work....
0 replies
S
SurreyPool
S
  • Newbie, joined since
  • Contributed 5 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie

Thanks for your advice, I will bear it in mind.

MPN uses MD5 one-way password encryption, so I guess that really does mean it will be impossible to export and then import users to Fusion?

Is Fusion MD5 also? And if it is, will a database export and import of our Users work?
Edited by SurreyPool on 10-02-2008 17:53,
0 replies
J
Josso
J
Josso 10
–––
Without faith, nothing is possible. With it, nothing is impossible
  • Senior Member, joined since
  • Contributed 309 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

Yes and no,

After v6.01.11/12 (can't remember which) we are using double MD5-hash.
But that shouldn't be that big problem, I guess.
0 replies
S
SurreyPool
S
  • Newbie, joined since
  • Contributed 5 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie

Some further info...

I've just checked the hashed password in 3 different databases.

In 2 different Fusion systems, where I use the same password, the hash string was identical.

In MyPHPnuke, the same password gives completely different hash string.

But... if I then take the hash from MyPHPnuke database, and hash that hash (I guess that's what you mean by double hash) then it gives the same string as those that are in the Fusion databases.

So MyPHPnuke = MD5 single hash
Fusion = MD5 double hash

So I'm guessing (guess is accurate, this is all very new to me) that this is do-able, and if get the hashed data from the MPN database, then somehow can manage to hash it again, that will give me the correct string to enter into the users section of the Fusion database.

Any advice on how I might achieve this easily - because I don't really want to manually set-up all 400 of the old user accounts myself?

Or am I talking complete nonsense? :o

Apologies if I am, I'm no expert, I'm learning this 'MD5 hash' stuff on-the-fly.
Edited by SurreyPool on 10-02-2008 20:42,
0 replies
B
Basti
B
Basti 10
[PHP-Fusion Crew Member & Admin from June 2008 - December 2010]

http://basti2web.de - Support Site for my infusions
  • Veteran Member, joined since
  • Contributed 1,099 posts on the community forums.
  • Started 32 threads in the forums
answered
Veteran Member

Quote

Josso wrote:
Yes and no,

After v6.01.11/12 (can't remember which) we are using double MD5-hash.
But that shouldn't be that big problem, I guess.


That's no problem at all.
The (old) passwords, which are not in double MD5-Hash, also work ;)
Edited by Basti on 10-02-2008 22:24,
0 replies
S
SurreyPool
S
  • Newbie, joined since
  • Contributed 5 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie

Excellent news, thank you for confirming Slaughter.

So if old MD5-single hash passwords will work, can someone advise me on best way to get our old users added to Fusion with least amount of manual work?

Anyone got a script, or an easy way to add multiple users from CSV with just basic info (username, email, password)?
0 replies
S
SurreyPool
S
  • Newbie, joined since
  • Contributed 5 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie

No-one have an answer?

This is all that is holding up launch of our Fusion site now, so any additional guidance would be greatly appreciated.

Apologies for going on, it is simply that I have very little PHP or mySQL experience.

Me = Photoshop and front-end HTML only.
Edited by SurreyPool on 12-02-2008 14:12,
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 7 posts
  • Votes 0 votes
  • Topic users 4 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet