Official SuiteCRM Outlook Plugin

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Cancel at any time!

Free Trial

#1802 - SuiteCRM not accepting login credentials.

Closed Bug? created by eskiles 5 years ago

Trying to login from the outlook plugin returns the following: CRM Server error 10 (Invalid Login): Login attempt failed please check the username and password

We've tried it with LDAP Authentication on and off, and still get the same error.

We upgraded all the way to Suite CRM 7.11.2. The password is getting MD5 hashed and then sent to the server. We can see that traffic, but what we bottomed out at is that we don't really know what we need to put into the LDAP "password encryption key" field. We tried an LDAP encryption key on the CRM server and the outlook plugin, but it didn't seem to work.

We are running Outlook Add-In version 3.0.18.0, and .Net version 4.7

SuiteCRM Provider Affiliate
5 years ago

Hi there,

Are you able to see any invalid login attempts on the SuiteCRM logs when it is on DEBUG error level?

Yes, the LDAP encryption key should be the same one used on the SuiteCRM Password Management settings.

Have you got any unique LDAP settings like Group Membership etc?

Thanks

reply
rrogers
5 years ago
As far as encryption key we tried DEADBEEF on the server and the outlook plugin and no dice. It isn't even clear what encryption type is being used. There is no guidance about what key we're supposed to use. Can it be any string? Any hex string? What should we put in the server and outlook settings?

I have DEBUG logs. Just ran again and we're seeing
```
Tue Mar 12 10:11:52 2019 [4242][-none-][INFO] ldapauth: Binding user foo@example.com
Tue Mar 12 10:11:52 2019 [4242][-none-][FATAL] [LDAP ERROR][49]Invalid credentials
Tue Mar 12 10:11:52 2019 [4242][-none-][INFO] ldapauth: Binding user userPrincipalName=foo@example.com,ou=Departments,DC=example,DC=com
```
I don't think it should have the @example.com suffix on the name.
reply
- SuiteCRM Provider Affiliate
  5 years ago
  
  Hi there,
  
  Here is a PR that may help highlight some things for you. https://github.com/salesagility/SuiteCRM/pull/6443/files
  
  The Outlook plugin does work with this encryption as we have a few clients using LDAP. But obviously we can understand people different set ups.
  
  Regards to the the binding user, yes then that certainly shouldn't be the case. Are you able to send us DEBUG logs of the Outlook Plugin (not the above SuiteCRM logs) that can not authenticate the user. You need to set the error log to DEBUG via the Add-in settings and Save before trying to test the connection. Send those logs to outlook[at]salesagility[dot]com and referencing this ticket.
  
  Thanks
  
  reply
- rrogers
  5 years ago
  
  Well, it turns out that the full user name like foo@example.com didn't actually cause the issue, but was instead those padding zeros.
  
  reply
rrogers
5 years ago
So, we hacked the heck out of authenticateUser in LDAPAuthenticateUser.php and found that it was 0-padding the $password parameter out to 16 characters. I wrote the following snippet at the top of authenticateUser to strip any trailing 0's:
```
// strip trailing 0&#039;s:
$prev_c = 42;
$length_of_nonzero_chars = strlen($password);
foreach (str_split($password) as $c) {
  $o = ord($c);
  if (!$o && $prev_c) {
    $length_of_nonzero_chars  = $i;
  }
  $prev_c = $o;
  ++$i;
}
$password = substr($password,0, $length_of_nonzero_chars);
```
Now authentication is working.
reply
- rrogers
  5 years ago
  
  SuiteCRM 7.11.2. Outlook Add-In version 3.0.18.0. .Net version 4.7
  
  reply
SuiteCRM Provider Affiliate
5 years ago

Thanks for your input. As there are two different accounts on this case. Can you confirm the version of SuiteCRM you are using so we can investigate it as a core issue?

Thanks.

reply
SuiteCRM Provider Affiliate
5 years ago

Hi there,

Did you get our last reply?

As there are two different accounts on this case. Can you confirm the version of SuiteCRM you are using so we can investigate it as a core issue?

If you could get back to us that would be great!

Thanks

reply
- rrogers
  5 years ago
  
  Apologies for clicking the wrong reply button, but I did reply. Anyways, here's the info again:
  
  "SuiteCRM 7.11.2. Outlook Add-In version 3.0.18.0. .Net version 4.7"
  
  reply
SuiteCRM Provider Affiliate
5 years ago

Hi there,

This ticket will be closed over due to inactivity.

We recommend upgrading to the latest version of the plugin to ensure you stay up to date with new feature and bug releases, however, if you are still experiencing an issue in the latest version please open a new ticket with reference to this one.

SuiteCRM Outlook Plugin Team

reply

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.

Saving Comment...

Official SuiteCRM Outlook Plugin

#1802 - SuiteCRM not accepting login credentials.

"no funciono no consigo conectar. ni con suitcrm 7 ni 8 me doy de baja por que no es posible." - santiago

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

SuiteCRM Enterprise-Class Outlook Integration

Outlook 365 and SuiteCRM Integration