Joomla to Dolphin

Hello guys,

I have searched a lot for this, but I can't seem to find a decent answer. 

Is there any way to migrate my old site's Joomla data to Dolphin? (ie. users/passwords, comprofiler profiles, kunena forum maybe?)

J.

There are none that i am aware of. You would most likely need to hire someone to do it.

Most all data as long as there is a place in dolphin that data from joomla can be copied to could be transferred.

It's the passwords that are the major problem. No site stores clear text versions of passwords for security reasons, so if clear text passwords are not available then MD5 hashes of the passwords are the only other option. So if joomla does not use MD5 for the passwords then exported working passwords will not be possible.

Okay, thanks. The passwords is not a big deal. It would be cool to get other data migrated though. 

I will see if I can make a script or find one

And then there's the salt...

I've used and looked at a lot of migration scripts, and most of them seem to issue new passwords to their members upon a successful transfer.  Just sends out an email to them with a new, random password.

Hey Nathan,

Do you have, by any chance, a list of migration scripts that you used for different kinds of data?

Is jFusion any good? 

J

None for Dolphin.  And I don't code much, either.

With a little SQL know how this is easy, if tedious to do. Time requirements depends on how much you want to bring over. Profiles are easy, blogs, forums, comments, photos not so much.

Even the passwords can be saved / used if you are willing to change the dolphin password checking function. You can even go as far as including a first log in check that allows the use of the old password and adds the salt after first log in.

I really need to learn joomla, wordpress and all these other popular scripts. I could easily write scripts to do that, but not knowing the tables of the other sites and what data they contain, it kinda sticks a big spear in my side.

Sometimes i wish a day was a lot longer, or better yet, i wish i was younger. I used to be able to stay up 3 days in a row without sleep. Now i am lucky if i can sit at my computer for more than a couple of hours at a time before my neck, back, and head begin to ache.

I need more DRUGS.

 I think you are wrong here, the md5 hash is generated with the user pass and a random salt. As far as i remember.

 Yes, but dolphin can be modified to use another password system as well. It's an overkill method, but can be done, and after first logon, a clear text version of the password is thus obtained and then converted to the current dolphin format. So yes, i can be done as long as you know how the other system created the passwords.

 Deano has the right of it.

When the user logs in to the site, you have access to the clear text version of the password. There really isn't anything stopping the programer seeing it 'in the clear' as it is checked to see if it matches the encrypted hash in the database.

So you do an MD5 of the user provided password, check it against the old password database, and if they match uses dolphins password function to add a salt.

This makes for a rather simple way to migrate from no salt to salt as users log in. If your concerned about an additional security issues created you can eventually turn this added feature off and then users can restore to using the reset password function.

You'll have to use Dean's method if you want to avoid sending out new passwords... Joomla's system is deep, very deep..

(stolen from stackoverflow.com)

1. Generate a password
2. Generate 32 random characters
3. Concatenate 1 and 2
4. md5(3)
5. store 4:2

Example:

1. Generate a password - we'll use 'password'
2. Generate 32 random characters - we'll use 'WnvTroeiBmd5bjGmmsVUnNjppadH7giK'
3. Concatenate 1 and 2 - passwordWnvTroeiBmd5bjGmmsVUnNjppadH7giK
4. md5(3) - 3c57ebfec712312f30c3fd1981979f58
5. store 4:2 - 3c57ebfec712312f30c3fd1981979f58:WnvTroeiBmd5bjGmmsVUnNjppadH7giK

Deano is right but i never told that its not possible.

@mscott - hmm! joomla looks very scary. I will hate joomla more now lol.

Nice following you have there Deano.

Hi mScott,

Is this for Joonla or for Dolphin?

Thanks everyone for answering so far. 

 Its for joomla.

How does Dolphin generate its password? This way I could make a page that generates a correct string for putting it in the boonex database after the user logged in with their correct joomla pass

Here are the 3 functions you need. It's a little confusing at first but it uses the genRndPwd function to generate the salt. Then takes that salt and the users password and runs it through encryptUserPwd to get the encrypted password. They are all located in /inc/utils.inc.php

// Generate Random Password

function genRndPwd($iLength = 8, $bSpecialCharacters = true) {

$sPassword = '';

$sChars = "abcdefghijkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789";

if($bSpecialCharacters === true)

$sChars .= "!?=/&+,.";

srand((double)microtime()*1000000);

for($i = 0; $i < $iLength; $i++) {

$x = mt_rand(0, strlen($sChars) -1);

$sPassword .= $sChars{$x};

}

return $sPassword;

}

// Generate Random Salt for Password encryption

function genRndSalt() {

    return genRndPwd(8, true);

}

// Encrypt User Password

function encryptUserPwd($sPwd, $sSalt) {

    return sha1(md5($sPwd) . $sSalt);

}