<img alt="Liferay" src="http://cdn.www.liferay.com/osb-theme/images/custom/heading.png" width="146" height="36" />

Rank: Expert

Posts: 293

Join Date: June 8, 2008

Has anyone managed to migrate users from a Joomla site to Liferay? I had a look at the Joomla's user's table and i think its a bit difficult because the password is encrypted. Does anyone know if liferay use the same hash algorithm for encrypting the password?

Here is the jos_users table on a joomla site

mysql> describe jos_users;
+---------------+---------------------+------+-----+---------------------+----------------+
| Field       | Type             | Null | Key | Default          | Extra       |
+---------------+---------------------+------+-----+---------------------+----------------+
| id          | int(11)          | NO | PRI | NULL             | auto_increment |
| name       | varchar(255)       | NO | MUL |                   |             |
| username    | varchar(150)       | NO | MUL |                   |             |
| email       | varchar(100)       | NO | MUL |                   |             |
| password    | varchar(100)       | NO |    |                   |             |
| usertype    | varchar(25)       | NO | MUL |                   |             |
| block       | tinyint(4)       | NO |    | 0                |             |
| sendEmail    | tinyint(4)       | YES |    | 0                |             |
| gid          | tinyint(3) unsigned | NO | MUL | 1                |             |
| registerDate | datetime          | NO |    | 0000-00-00 00:00:00 |             |
| lastvisitDate | datetime          | NO |    | 0000-00-00 00:00:00 |             |
| activation | varchar(100)       | NO |    |                   |             |
| params       | text             | NO |    | NULL             |             |
+---------------+---------------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

I dont know a lot about the liferay's users table. Do you think its possible or im i up for a few long nights in the next few days?? emoticon

RE: migrating from Joomla to Liferay

August 3, 2009 3:04 PM

Answer

Rank: Junior Member

Posts: 32

Join Date: August 3, 2009

Hi,

Haven't done this this could work:
You might want to have a look at the following:

http://forum.joomla.org/viewtopic.php?f=432&t=207689

It provides the encryption class.

Next you could override the Liferay password encryption algorithm. If you look at portal.properties you see:

# Encryption is implemented by com.liferay.util.Encryptor.provider.class in
# system.properties.

So... in override system.properties

#
# Set the security provider class.
#
com.liferay.util.Encryptor.provider.class=com.sun.crypto.provider.SunJCE

And set your custom encryptor there...

Mark as an Answer

RE: migrating from Joomla to Liferay

August 6, 2009 2:20 PM

Answer

Rank: Expert

Posts: 293

Join Date: June 8, 2008

Hi thanks that was very usefull.

One of the things i am trying to do now is try and transfer the data from the joomla forum to the liferay forum. I still havent worked out the relationships in the tables for the liferay forum.

I think once i manage to migrate the data i can then use that class to modify the password?

Mark as an Answer

RE: migrating from Joomla to Liferay

August 7, 2009 2:25 AM

Answer

Rank: Junior Member

Posts: 32

Join Date: August 3, 2009

I think once i manage to migrate the data i can then use that class to modify the password?

What do you mean 'modify the password?'

Do you want your users to keep their passwords or is that not necessary??

Mark as an Answer

RE: migrating from Joomla to Liferay

August 7, 2009 3:53 AM

Answer

Rank: Expert

Posts: 293

Join Date: June 8, 2008

Yes i would like to keep the password to be the same as what it was on the Joomla site. So i need to decrypt the passowrd from the joomla site and encrypt it using the liferay encryption and save it in liferay db.

Mark as an Answer

RE: migrating from Joomla to Liferay

August 7, 2009 7:03 AM

Answer

Rank: Junior Member

Posts: 32

Join Date: August 3, 2009

Ah ok, that's what I first thought. Yes, I do believe that should be possible. Migrate the users and set their password in Liferay to correspond to the encrypted string in Joomla.
Next change the encryption class. that way when one of your users enters a password, that password is encrypted by the "Joomla algorithm" and the encrypted resulting string should be the same as what is stored in Liferay.

You will need to know the seed of Joomla. Probably specified during installation???

Mark as an Answer

RE: migrating from Joomla to Liferay

August 7, 2009 7:07 AM

Answer

Rank: Junior Member

Posts: 32

Join Date: August 3, 2009

I don't think your solution will be possible as you cannot decrypt the Joomla password. You can only encrypt.

So will need to store the Joomla encrypted passwords in Liferay and change the passwords.

Something that will save a lot of time?? Create random passwords for your users and let Liferay send them a mail. And let the users change their passwords upon first login. (IF that's an option)

Mark as an Answer

RE: migrating from Joomla to Liferay

August 7, 2009 9:47 AM

Answer

Rank: Expert

Posts: 293

Join Date: June 8, 2008

Petros Giakouvakis:

Something that will save a lot of time?? Create random passwords for your users and let Liferay send them a mail. And let the users change their passwords upon first login. (IF that's an option)

Yes i think you are right. Ill just generate some random passwords and have them change their password when they log in. I dont think its worth to spend all the time if it will only take a few minutes for the users to change their passwords.

Thanks for your help.