Thread:Extension talk:LDAP Authentication/A database query error has occurred

Hell-o!

I'm trying to use LDAP authentication in my wiki in my company.

I think I configured everything right - gets authenticated. But at the end I receive this error page:

" Database error

A database query error has occurred. This may indicate a bug in the software. "

This is LDAP log:

2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering validDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 User is not using a valid domain. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Setting domain as: EUROPE 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering allowPasswordChange 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering modifyUITemplate 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:01 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering validDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 User is using a valid domain (EUROPE). 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Setting domain as: EUROPE 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getCanonicalName 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Username is: Jzc6yq 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Munged username: Jzc6yq 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering authenticate for username Jzc6yq 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering Connect 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Using TLS or not using encryption. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Using servers: ldap://europe.delphiauto.net:389 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 PHP's LDAP connect method returned true (note, this does not imply it connected to the server). 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getSearchString 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Doing a straight bind 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 userdn is: jzc6yq@delphiauto.net 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Binding as the user 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Bound successfully 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getUserDN 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Created a regular filter: (=jzc6yq) 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getBaseDN 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 basedn is not set for this type of entry, trying to get the default basedn. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getBaseDN 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 basedn is not set. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Using base: 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Couldn't find an entry 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Fetched UserDN: 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getGroups 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering checkGroups 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getPreferences 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Authentication passed 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering updateUser 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Entering getDomain 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 Pulling domain from session. 2014-09-22 09:31:09 DL1DKD65J audio-wiki_: 2.1.0 User has a token, setting domain in user options.

what I am missing is line:

"Saving user settings."

So I suppose update of the user in the database fails.

Question is: why?