[SOLVED] LDAP authentication error after mysql->mssql

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

[SOLVED] LDAP authentication error after mysql->mssql

Post by aph »

Today I tested using the MySQL DB for OTRS. On switching back to MSSQL, I get the following error

Code: Select all

[Wed Jul 23 16:51:58 2014][Notice][Kernel::System::Auth::LDAP::Auth] User: xxxx.xxxx@xxxx.local (CN=xxxx xxxx,CN=Users,DC=xxxx,DC=local) authentication failed: '80090308: LdapErr: DSID-0C0903C5, comment: AcceptSecurityContext error, data 532, v2580 ' (REMOTE_ADDR: ::1).
I am able to login with different AD credentials

Code: Select all

[Wed Jul 23 17:06:12 2014][Notice][Kernel::System::Auth::LDAP::Auth] User: xxxx.xxxx@aphajco.local (CN=xxxx xxxx,CN=Users,DC=xxxx,DC=local) authentication ok (REMOTE_ADDR: ::1).
I don't quite understand why this error occurs. Both the users are members of the same LDAP group!!!!

The only thing I changed in config was the database to mysql and then switched back to mssql. The password of the OTRS user is correct and I'm able to connect to the mssql database using otrs.CheckDB.pl.
Here is my config file
For_Forum_Config.pm.txt
What could be causing the error?
You do not have the required permissions to view the files attached to this post.
Last edited by aph on 24 Jul 2014, 08:56, edited 1 time in total.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: LDAP authentication error after switching back to mssql

Post by aph »

Well, the problem is apparently solved. The password of the user had expired and had to be reset! Didn't think of that,My bad! But who knows maybe someone has the same problem.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: LDAP authentication error after switching back to mssql

Post by crythias »

viewtopic.php?f=60&t=16543
http://wiki.servicenow.com/index.php?ti ... rror_Codes
532 PASSWORD_EXPIRED Indicates an Active Directory (AD) AcceptSecurityContext data error that is a logon failure. The specified account password has expired. Returns only when presented with valid username and password credential.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: LDAP authentication error after switching back to mssql

Post by aph »

Thanks crythias!
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked