[
https://issues.apache.org/jira/browse/CAUSEWAY-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andi Huber resolved CAUSEWAY-4009.
----------------------------------
Resolution: Workaround
Deleting the browser cookie for the application in question solved the issue.
However, this is very inconvenient. A proper fix would be to detect this issue
and either instruct the user to clear associated browser cookies or just do
this automatically.
> [SecMan] Potential Collation Clash on Login
> -------------------------------------------
>
> Key: CAUSEWAY-4009
> URL: https://issues.apache.org/jira/browse/CAUSEWAY-4009
> Project: Causeway
> Issue Type: Bug
> Components: Viewer Wicket
> Reporter: Andi Huber
> Assignee: Andi Huber
> Priority: Major
> Fix For: 4.0.0
>
>
> Login potentially fails:
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 5.0.0.v202603230926-bc4f4eb36eb1dcce223533d87890ba458628a2f9):
> org.eclipse.persistence.exceptions.DatabaseException
>
> Internal Exception: java.sql.SQLException: (conn=17888) Illegal mix of
> collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_uca1400_ai_ci,COERCIBLE)
> for operation '='
>
> Error Code: 1267
>
> Call: SELECT ID, ACCOUNTTYPE, ATPATH, EMAILADDRESS, ENCRYPTEDPASSWORD,
> FAMILYNAME, FAXNUMBER, GIVENNAME, KNOWNAS, LANGUAGE, NUMBERFORMAT,
> PHONENUMBER, STATUS, TIMEFORMAT, USERNAME, VERSION FROM ApplicationUser WHERE
> (USERNAME = ?)
>
> bind => [1 parameter bound]
>
> Query: ReadAllQuery(name="causeway.ext.secman.ApplicationUser.findByUsername"
> referenceClass=ApplicationUser sql="SELECT ID, ACCOUNTTYPE, ATPATH,
> EMAILADDRESS, ENCRYPTEDPASSWORD, FAMILYNAME, FAXNUMBER, GIVENNAME, KNOWNAS,
> LANGUAGE, NUMBERFORMAT, PHONENUMBER, STATUS, TIMEFORMAT, USERNAME, VERSION
> FROM ApplicationUser WHERE (USERNAME = ?)")
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
