by SuiteCRM

The Ultimate Outlook Plugin Has Arrived - In response to user requests, SuiteCRM have created the ultimate Outlook plugin which is maintained by SuiteCRM developers. Our plugin supports Outlook 2010 upwards and includes two way synchronisation with CRM, Calender, Calls, Meeting, Tasks and Email Archiving.

Cancel at any time!
Free Trial

#1802 - SuiteCRM not accepting login credentials.

Closed Bug? created by eskiles Verified Purchase 6 months 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

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 months 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

  2. rrogers member avatar

    rrogers

    6 months 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.

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      6 months 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

    • rrogers member avatar

      rrogers

      6 months 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.

  3. rrogers member avatar

    rrogers

    6 months 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'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.

    • rrogers member avatar

      rrogers

      6 months ago

      SuiteCRM 7.11.2. Outlook Add-In version 3.0.18.0. .Net version 4.7

  4. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 months 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.

  5. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 months 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

    • rrogers member avatar

      rrogers

      5 months 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"

  6. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 months 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

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