SugarCRM authentication plugin for Joomla
I wrote a plugin for Joomla 1.5 and SugarCRM (4.5 or higher) that authenticates SugarCRM contacts in Joomla. If you install this plugin you can automatically grant your clients access to your public website, without actually giving them an account in the website software. The plugin is based on the new modular authentication system in Joomla 1.5. An administrator configures which fields in the SugarCRM contacts module are used as username and password. The plugin allows you to configure website access to individual customers with only minimal preparation on the SugarCRM side. You can define any contact field as username, so having your clients login with the email address is easy. The plugin works like this: if a clients tries to login to your Joomla website and he has no Joomla username yet the plugin checks the SugarCRM contacts module. The communication between Joomla and SugarCRM operates through Sugar's SOAP API. The plugin will search through all contacts for a matching username / password combination. If you've configured a contact to use the given username and password, Joomla will automatically generate a username with the details from the contact record. The emailaddress from the contacts record is used, as well as the full name of the contact. This effectively moves your Joomla user management to SugarCRM for any normal user. You can still use Joomla to raise the security level of the newly created contacts. If the username, password, or active status of the contact changes in SugarCRM, these changes are instantly mirrored in Joomla. I also built a component that allows your customers to change their own contact details in SugarCRM remotely from Joomla. They can alter the details of their own contact record (personal info) or a matching account record (business info). I'll post more information on this component as soon as it's done and ready for public release. Both the plugin and the component are downloadable from the SugarBridge project on the JoomlaForge.
Comments
Sugar Auth for Joomla 1.5 - Does it work with Sugar 5.5.0?
CAnne » 20 February 2010 - 02:39Thank you so much for this plugin, unfortunately I'm having a difficult time getting them to cooperate together. I've watched your videos. I've got newly installed versions of both Joomla and SugarCRM, but I just cannot get it to work. So I'm wondering if SugarCRM 5.5 is too new to work with this plugin from Joomla? I keep getting the error that the user doesn't exist or have an account yet in Joomla. I've checked and double-checked my settings, and they seem to be correct. I'm at a loss. Any way you might take a look at these? I would love for my clients to be able to log in to Joomla, and only have to use the username and password I provide them.
Again, thank you!
CAnne
sugar 5.5.0
Bas » 24 February 2010 - 17:10I haven't tried the combination. SugarCRM are constantly changing their soap api. I'm considering abandoning the project all together.
Wishing I was a programmer...
CAnne » 25 February 2010 - 04:56I understand your frustration - if you have one - with the changes. I'm not too familiar with SugarCRM and the backend of it. If you could point me in some sort of direction, I'd like to try to figure it out. But - I'm not a programmer, just wishing I was now... Thanks!
Have the same problem like
OJB » 19 April 2010 - 06:32Have the same problem like CANNE, try to upgrade you authentication plugin to make it work with Sugar 5.5; I will post my result here when I'm done :)
I'll take a look
Bas » 20 April 2010 - 16:45I'm sure this is a minor bug. I'll take a look at it this week.
[edit]26-04-2010: It'll take a couple of more days. Maybe I'll look into it tonight. Hang tight[/edit]
Work-around on SVN
Bas » 3 May 2010 - 17:01I posted a workaround on http://joomlacode.org/gf/project/sugarbridge/scmsvn/ If you don't know how to retrieve the code from there I wouldn't recommend using the plugin anyway. It's a beta. And it needs someone reasonably technically apt to install it.
The authentication now requires 2 plugins: 1 communication plugin and 1 authentication plugin. You also need to specify a blowfish key in the communication plugin. This can be found in: /your-sugarcrm/cache/blowfish/rapelcg_svryq.php
It works, but it's still very buggy. Sometimes it does logon, sometimes it doesn't. Seems related to a time-out issue but I haven't the time to really solve it right now.
File retrieve
Paolo » 4 March 2010 - 20:18Thank you fo rthis important plug-in.
It works very fine, but I have this request to you and I hope that you can help or address me to find a solution.
In SugarCRM I'm using the activity tab to assign a task, call or meeting to a client and attaching a document.
My client doesn't access in SugarCRM, but in a Joomla portal where I show him all the activities he has to realize.
The fact is that I can not retreive and show in Joomla the document attached to that activity without logging in SugarCRM and I was wondering if your plug-in could be useful for my intention.
The problem is that (I understood) your plug-in search the information (username - password) in the contact table: is it possible to have the controll in the log-in table?
Thanks a lot
Paolo
plugin on log
Bas » 5 March 2010 - 05:33Dear Paolo,
my plugin won't do any of the things you want. However, it should be possible to retrieve the data from sugarcrm via the api as long as you hook into the activity module. As for the retrieval of the document itself: you'll have to take into account the public availability of the document. If Joomla is on the same server as sugar it should be easier to retrieve the document itself then on remote systems. It all depends on how sugar handles the attached files' security. I can't tell you anything about that, because I don't have any hands-on experience with it.