LoginShare issues?

[threeyears]

I'm using the ActiveDirectory/LDAP loginshare with my OpenLDAP server. From the logs, it shows that Kayako authenticates to the LDAP server with no error, so I know that part is working.

However I keep getting "Invalid Username or Password" errors from Kayako and no user gets added to the local database.


These are the steps I took to turn on the LDAP LoginShare:

1) Templates > LoginShare > ActiveDirectory/LDAP > Filled out info
2) Templates > Manage Groups > Default > Settings > LoginShare = ActiveDirectory/LDAP


What could be the issue??

[threeyears]

After further investigation it appears to be getting all the way into where it calls insertUser() to insert the user into the kayako db, but this function returns null.

Can someone help?

[Varun Shoor]

Hi,
Please email me at varun AT kayako.com, I have a special debug plugin with me which prints out exact steps of authentication. It should help you in pinpointing where the issue is.

Regards,

Varun Shoor

[sureshkumar.mr]

This is a long pending bug which they are not interested to fix and no one can question them. The below solution should solve your problem.

Whenever users sends an email to support, user account is created in table "swusers" .
This happens when we enable email queue. The email id is updated in "swuseremails" table.

If the same user tries to login to eSupport or SupportSuite the login fails with message "Invalid Username or Password"

There are two ways to solve this problem:
1. Clear all the records in "swusers" and "swuseremails" table (Take a backup if you need, but I didn't take) or
2. Open "swusers" table, select a record, find the full name, if you know the login id for that name, then update the same in "loginapi_userid" column. Then try to login, it will work.

This is the work around for Active Directory Login share (LDAP) till they fix this bug.

[threeyears]

This is not the case for me. I'm creating a brand new test account on the LDAP server and it just isn't creating the user in the Kayako Database. the function insertUser() in /includes/LoginShare/activedirectory.login.php returns null.

I'm using a non existant test login/email that doesn't exist in the swuseremails table.

mysql> select * from swuseremails where email = 'test14@test14.com';
Empty set (0.00 sec)
mysql> select * from swusers where 'fullname' like '%test%';
Empty set (0.00 sec)


Varun -- I've emailed you for that debug script. Thanks for your help on this matter.

[threeyears]

Ah, nevermind -- I have fixed it. The LoginShare was working all along, I had my attributes out of order when I converted the activedirectory.login.php from ActiveDirectory attributes to the LDAP attributes in my OpenLDAP server.

All is working now.

Thanks