Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Error: Queries in your database seem to be case insensitive, this can be a problem for Grouper, if you are using MySQL you should use a bin collation

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Error: Queries in your database seem to be case insensitive, this can be a problem for Grouper, if you are using MySQL you should use a bin collation


Chronological Thread 
    < Chronological >      < Thread >
  • From: Adam Chi-Lun Chang <>
  • To: "Hyzer, Chris" <>, Adam Chang <>, "" <>
  • Subject: RE: [grouper-users] Error: Queries in your database seem to be case insensitive, this can be a problem for Grouper, if you are using MySQL you should use a bin collation
  • Date: Wed, 24 Jul 2019 22:39:55 +0000
  • Arc-authentication-results: i=1; mx.microsoft.com 1;spf=pass smtp.mailfrom=uci.edu;dmarc=pass action=none header.from=uci.edu;dkim=pass header.d=uci.edu;arc=none
  • Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Dvq+RF0L+dpwzbTUKCUyho4JA49cLW7BeXBKMawbRTc=; b=KfYDftFuR1DXp6XZwYFHSOF9sOocSArYw9VLvygEWk6fcE4E51tk/VMtjHWj72wr9rTPpxur4G8kNWr8smGO6ZHQYU5ONBmnDQ45wE9oTAUVXdJ/v7/vuMkQjrQfKeLWAHt8DkCmh/NKHEn8S7hp+AalhLls5ULnDy2Zlcb2IHdM91u4bJ9VTbMTREN2OJKWAHICoQBvia9eakQ0VKN0EI3yDz7iV5+vGPcpAczVejgKjNYuuXapIcrSUYrvuWRCtVp3SGxpH2UTnFFaGhFxwOFQG8WybJzK4/st4LcXs5eLRNkMi8hH2J31KEed0qZFmEWAdd5aimkAB+7CbWOJeQ==
  • Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=NGW2nwhTQYehUeglVnrZDkQyRPj0KeQKUfgSxOsSKJ1QDrMp8JmGSVaKGnb7hBWsyIhe9Dc/pGTO8l7tmo1Ar+v8KjNTgHtdjec6uL/voukIXlfS1w+f1dDJxcQJmublMzhHtAyl47gcvjqGrIJQ6S52bSZGz/4uome6tgjQw/K8oz06PFFVQDq8HqLKqnQ+hnfAYez1gmIk/Czz0+Eq5bfnU/g8K0fSngaGdX7h2/E9icM4/kDtsm7qAAPHbjZfzB8u54EJaYs9SNIgmGN/gaeVe4nxyRKRmDnTjbxwhiJPdsBj7wfzYizpxID3Q8s5VwUfdEYcTgHoQIvFpSgTAQ==
I first tried this
alter database grouper_schema character set utf8mb4 collate utf8mb4_bin;
and got this error when loading the UI.

The page isn't redirecting properly

Firefox has detected that the server is redirecting the request for this
address in a way that will never complete.

This problem can sometimes be caused by disabling or refusing to accept
cookies.

Cleared the cache and still the same thing.

I then dropped the schema, created with utf8 charset & utf8_bin collation,
reran the grouper db script, and still got the same UI error.


I also tried to drop the schema, recreated the schema with default charset &
collation, and still got the same UI error.

* There is no error from apache console though.

-----Original Message-----
From: Hyzer, Chris <>
Sent: Tuesday, July 23, 2019 6:46 AM
To: Adam Chang <>;
Subject: RE: [grouper-users] Error: Queries in your database seem to be case
insensitive, this can be a problem for Grouper, if you are using MySQL you
should use a bin collation

Can you convert your db to bin collation with utf8 or drop it and create it
again?

-----Original Message-----
From:
<> On Behalf Of Adam Chang
Sent: Monday, July 22, 2019 5:45 PM
To:
Subject: [grouper-users] Error: Queries in your database seem to be case
insensitive, this can be a problem for Grouper, if you are using MySQL you
should use a bin collation

Error: Queries in your database seem to be case insensitive, this can be a
problem for Grouper, if you are using MySQL you should use a bin collation

I switched the DB to MySQL 8 and replaced the subject store to CMU example
and got this error when starting tomcat.
Anyone knows what does this mean and how to fix it? Thanks.

~Adam

Archive powered by MHonArc 2.6.19.

Top of Page