How to: Integrate with Joomla 1.5
I would like to use only one login for Joomla 1.5 website and ProjectPier.
And would like to have the same users in both systems. Could you try to suggest me some possible solution, so only one login and password would be used. And users will have access to both systems. So when user will log in to Joomla website with his user login and password he will be able to click on user menu link and will get access to his ProjectPier account.
Ps:
I found some extensions which maybe could help with this, but I observed there is little difference in ProjectPier database - there is username, token and salt in ProjectPier pp_users table.
pp_users:
id company_id username email token salt twister display_name title avatar_file office_number fax_number mobile_number home_number timezone created_on created_by_id updated_on last_login last_visit last_activity is_admin auto_assign
While in Joomla 1.5 database there is username, password.
jos_users:
id name username email password usertype block sendEmail gid registerDate lastvisitDate activation params
I found this extensions which could be somehow maybe useful, but I need your help:
MySQL Auth for Joomla 1.0
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,642/Itemid,3...
MySQL Auth Plugin for Joomla 1.5
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,3444/Itemid,...
Wrapper-Login
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,765/Itemid,3...
JFusion -> Universal User Integration Hot
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,3723/Itemid,...
Maybe also use of Open ID could help since in Joomla is possible to use Open ID for authentication.
Thanks in advance for any help or suggestion.
Hello there,
I saw this thread a while ago and set about trying to make a bridge between the two products. However, due to some real life issues I wasn't really able to start the integration.
From having a quick look at the mysql auth plugin, it shouldn't be too difficult to modify it to work with PP (though the bridge would only be one way - PP -> Joomla).
You would need to change the way the mysql auth plugin compares the two passwords, however this should only be a minor change.
If you look in the user class, PP checks the user's password in the following way:
sha1($this->getSalt() . $check_password) == $this->getToken();So you would add the following to the mysql auth plugin(line 99):
$result_salt=mysql_result($result,0,'salt');Which fetches the salt from the database.
Now change (line 105):
} elseif ($result_pwd == md5($username['password'])) {To:
} elseif ($result_pwd == sha1($result_salt . $username['password'])) {And everything should work ok!
Alex
PS You should the name of the password field in the plugin's settings as 'token'
Thank this has helped me get users integrated as well i'm a big fan of joomla and the community that helps support and develop it is great. For my customers i started using ready made joomla sites which install so quick and are ready out of the box for them.