Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Many errors appear in the XWiki console when login with a user from AD #32

Closed
ane-gabriela opened this issue Apr 9, 2020 · 1 comment
Assignees
Milestone

Comments

@ane-gabriela
Copy link

ane-gabriela commented Apr 9, 2020

Preconditions: Have a user already created in AD and a proper connection to XWiki.

Steps to reproduce:

  1. Login on XWiki with the user created in AD
  2. Make some actions in XWiki (create/edit pages)
  3. Observe the XWiki console

Expected results: The user is able to login and make actions in XWiki.

Actual results: The user is able to login and make actions in XWiki but in the XWiki console, many error messages appear.

Environment: Windows 10, XWiki 11.10.4 with MySQL 5.7 and Chrome 80, Active Directory Application 1.8.1

2020-04-09 15:39:20,524 [http://localhost:8080/xwiki/bin/admin/XWiki/XWikiPreferences?category=1] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 15:39:20,549 [http://localhost:8080/xwiki/bin/admin/XWiki/XWikiPreferences?category=1] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 15:39:20,550 [http://localhost:8080/xwiki/bin/admin/XWiki/XWikiPreferences?category=1] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 15:58:33,401 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 15:58:33,406 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 15:58:33,406 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 16:01:01,526 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 16:01:01,529 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 16:01:01,529 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 16:02:14,989 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 16:02:14,993 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 16:02:14,993 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 16:13:01,425 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 16:13:01,434 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 16:13:01,435 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 17:27:55,901 [http://localhost:8080/xwiki/bin/get/ActiveDirectory/Code/SuggestLists?outputSyntax=plain&list=xwiki-field&q=test1] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 17:27:55,906 [http://localhost:8080/xwiki/bin/get/ActiveDirectory/Code/SuggestLists?outputSyntax=plain&list=xwiki-field&q=test1] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 17:27:55,907 [http://localhost:8080/xwiki/bin/get/ActiveDirectory/Code/SuggestLists?outputSyntax=plain&list=xwiki-field&q=test1] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 18:07:53,907 [http://localhost:8080/xwiki/bin/view/Main/] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 18:07:53,910 [http://localhost:8080/xwiki/bin/view/Main/] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 18:07:53,910 [http://localhost:8080/xwiki/bin/view/Main/] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 18:08:24,388 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.name=? and lower(prop.value)=?] has been converted to [select distinct doc.fullName from XWikiDocument as doc , BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className=?1 and obj.id=prop.id.id and prop.name=?2 and lower(prop.value)=?3] 2020-04-09 18:08:24,390 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 18:08:24,391 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 18:08:24,531 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [] 2020-04-09 18:08:24,532 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 18:08:24,536 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing ldap_group_mapping attribute []

@ane-gabriela ane-gabriela added this to the 1.9 milestone Apr 9, 2020
acotiuga added a commit that referenced this issue Jul 2, 2020
…#32

* make sure the half mappings are not accepted to prevent ldap error regarding invalid mapping
@acotiuga
Copy link
Contributor

acotiuga commented Jul 2, 2020

Only the following logs are cleared for this issue, rest of them being part of XWiki Standard and not AD app:
2020-04-09 18:08:24,532 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [test=] 2020-04-09 18:08:24,536 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.x.c.l.XWikiLDAPConfig - Error parsing ldap_group_mapping attribute []

@acotiuga acotiuga self-assigned this Jul 2, 2020
@acotiuga acotiuga modified the milestones: 1.9, 1.8.2 Jul 2, 2020
@acotiuga acotiuga closed this as completed Jul 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants