LDAP is not working for User

Roshanpanji

Hi all,
I have upgraded from 1.14.2 to latest one 1.18.1 but it seems like the LDAP is only working for agent, when we try to login as user it says access denied.

KevinTheJedi

Roshanpanji

You need to restore from backup, upgrade any installed plugins First, then upgrade codebase, login, and run the upgrader. Once you do this the backend values for Users should be appropriately migrated.

Cheers.

Roshanpanji

KevinTheJedi
I have migrated the DB, When I'm login as an agent everything fine only problem with user. I also installed the latest LDAP plugin from osTicket official website

KevinTheJedi

Roshanpanji

You upgraded the plugin you upgraded osTicket? If not, that's your issue and you need to follow the steps above.

Cheers.

Roshanpanji

KevinTheJedi
I upgraded osticket and plugin to the latest versions

KevinTheJedi

Roshanpanji

Login as a completely new User via LDAP (that does not exist in osTicket), this should create a User Account for them in osTicket, go to the database, go to the _user_account table, copy the backend value for the new working User (value should look like ldap.client.p123i123), update all _user_account records where backend = 'ldap.client' to the working value, visit the Client Portal in an Incognito window, and retest.

Cheers.

Roshanpanji

KevinTheJedi
Thanks for this replay. I will try and get back to you but before that each time for the new staff do I need to follow the same. Like each time for the new staff do I need to create them manually?

Roshanpanji

KevinTheJedi
So I have created a new User on osTicket, But it seems like same as last time "Access denied".

KevinTheJedi

Roshanpanji

Agents always have to be created manually as you have to configure department access, etc. Users on the other hand will be auto-created if they login via LDAP and they don’t already have an account in osTicket.

Cheers.

KevinTheJedi

Roshanpanji

Can you show a screenshot of that User's _user_account record from the database?

Cheers.

Roshanpanji

KevinTheJedi
I can't see that account details under _user_account but I can see on _user

KevinTheJedi

Roshanpanji

That doesn't make sense if they are able to login then they have an account. Look for where _user_account.user_id equals the ID of the User.

Cheers.

alepensato

@Roshanpanji
I have the same problem,

@KevinTheJedi
As you can see, I am not the only one with alla these problems

KevinTheJedi

alepensato

I asked you to please start your own thread. You are just hijacking other people’s threads.

Cheers.

alepensato

KevinTheJedi
but if my problem is the same, does not have any sense open a new thread for the same issue

KevinTheJedi

alepensato

You don’t want to blow up another person's thread when you don't know for certain that your issue is due to the same root cause. We don’t know what your issue is so how do you know you have the same issue? You may not be able to login like them but that doesn’t mean you are both facing the same issue.

Cheers.

Roshanpanji

Hi Kevin, I have been trying to get OS-Ticket to work again, and following what you said I have decided to try using a new LDAP user, however, when I try to log in I am asked to create an account and when I try to do so filling the form including email address I get this error message "Unable to register account. See messages below." error" It does not show any error so I am unable to proceed

KevinTheJedi

Roshanpanji

You’ll have to debug the code to see what it’s getting stuck on.

Cheers.

Roshanpanji

Hi, There is no error message so could you please explain how I can debug the code?

KevinTheJedi

Roshanpanji

There are 4 different places we return that error when creating a User account:

You can debug at each point to see where the error is being returned. Then, from there you can debug what is causing the failure.

Cheers.