Joomla! Discussion Forums



It is currently Mon Nov 23, 2009 11:16 pm (All times are UTC )

 


Forum rules

Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 10 posts ] 
Author Message
Posted: Mon Mar 16, 2009 2:23 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Mar 16, 2009 2:00 pm
Posts: 8
Hi!
I need to migrate some users from an no-J! website to a J! website.
The password of that users are a 32 hash string.
I need to add to this string the salt for be compatible with J! 1.5

How i can do this?

Thanks

;)


Top
  E-mail  
 
Posted: Mon Mar 16, 2009 2:33 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Mar 15, 2009 9:40 pm
Posts: 8
you could copy everyone over then run a password reseting script that emails them there new passwords.

you cant keep the passwords unless you know what salts where used and how and edit the login system to use that.


Top
  E-mail  
 
Posted: Mon Mar 16, 2009 2:40 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Mar 16, 2009 2:00 pm
Posts: 8
Madpeter wrote:
you could copy everyone over then run a password reseting script that emails them there new passwords.

you cant keep the passwords unless you know what salts where used and how and edit the login system to use that.


My objective is to maintain the existing password. There are about 4000 users and is not very professional change their password.

With the usernames can i make the salts?


Top
  E-mail  
 
Posted: Mon Mar 16, 2009 4:46 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Mar 15, 2009 9:40 pm
Posts: 8
normaly there are 2 salts but what they are change based on the system and if the user made any changes (sometimes theres script allready made to mirgate users from a database format to a new one, what are you using currently?)


Top
  E-mail  
 
Posted: Tue Mar 17, 2009 12:18 am 
User avatar
Joomla! Ace
Joomla! Ace
Offline

Joined: Thu Aug 18, 2005 9:27 am
Posts: 1258
Location: Toowoomba, Queensland, Australia
32 characters sounds suspiciously like they're already in MD5 format, which if that is the case you can pop them into Joomla!'s password field and it will pick them up and convert them to Joomla!'s salted hash format the first time that they log into the site. You would need to take care to ensure that you put the right fields in a few other link tables (core_acl_aro and core_acl_aro_group_map iirc) but beyond that things should be relatively easy.

_________________
Sam Moffatt
Dev WG: Update and Install Technologies, Authentication Systems, Migrator Component, Summer of Code Mentor
S&I WG: Package Builder Maintainer, JoomlaCode Backend Systems
Core Team: Collector of Titles


Top
   
 
Posted: Tue Mar 17, 2009 8:30 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Mar 16, 2009 2:00 pm
Posts: 8
Madpeter wrote:
normaly there are 2 salts but what they are change based on the system and if the user made any changes (sometimes theres script allready made to mirgate users from a database format to a new one, what are you using currently?)


I have written a little script.
Which script do you recommend?
Thanks ;)


Top
  E-mail  
 
Posted: Tue Mar 17, 2009 9:05 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Mar 16, 2009 2:00 pm
Posts: 8
pasamio wrote:
32 characters sounds suspiciously like they're already in MD5 format, which if that is the case you can pop them into Joomla!'s password field and it will pick them up and convert them to Joomla!'s salted hash format the first time that they log into the site. You would need to take care to ensure that you put the right fields in a few other link tables (core_acl_aro and core_acl_aro_group_map iirc) but beyond that things should be relatively easy.


Yes, the password is yet in MD5 format.
So i must insert the users in jos_users and insert into core_acl_aro and core_acl_aro_group_map the references to the groups?
Thanks ;)


Top
  E-mail  
 
Posted: Tue Mar 17, 2009 12:10 pm 
User avatar
Joomla! Ace
Joomla! Ace
Offline

Joined: Thu Aug 18, 2005 9:27 am
Posts: 1258
Location: Toowoomba, Queensland, Australia
Yes, you need one entry in jos_users to grab the base level stuff, one in core_acl_aro to give that user a mapping into the ACL system and then using the aro_id that you'll get from an insert into the core_acl_aro table you push that into the core_acl_aro_group_map table with the appropriate group that you want to dump the users in. You could probably do something with the JUser object to have it handle creating most of those items for you.

_________________
Sam Moffatt
Dev WG: Update and Install Technologies, Authentication Systems, Migrator Component, Summer of Code Mentor
S&I WG: Package Builder Maintainer, JoomlaCode Backend Systems
Core Team: Collector of Titles


Top
   
 
Posted: Wed Mar 18, 2009 11:57 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Mar 16, 2009 2:00 pm
Posts: 8
pasamio wrote:
Yes, you need one entry in jos_users to grab the base level stuff, one in core_acl_aro to give that user a mapping into the ACL system and then using the aro_id that you'll get from an insert into the core_acl_aro table you push that into the core_acl_aro_group_map table with the appropriate group that you want to dump the users in. You could probably do something with the JUser object to have it handle creating most of those items for you.



I have solved my problem with your suggestions.

Thanks ;)


Top
  E-mail  
 
Posted: Wed Mar 18, 2009 10:25 pm 
User avatar
Joomla! Ace
Joomla! Ace
Offline

Joined: Thu Aug 18, 2005 9:27 am
Posts: 1258
Location: Toowoomba, Queensland, Australia
Great news :)

_________________
Sam Moffatt
Dev WG: Update and Install Technologies, Authentication Systems, Migrator Component, Summer of Code Mentor
S&I WG: Package Builder Maintainer, JoomlaCode Backend Systems
Core Team: Collector of Titles


Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

Quick reply

 



Who is online

Users browsing this forum: Meimuna, NFP Publisher and 25 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group