Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Error about MySQL bin collation

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Error about MySQL bin collation


Chronological Thread 
  • From: "Coleman, Erik C" <>
  • To: "" <>
  • Subject: [grouper-users] Error about MySQL bin collation
  • Date: Tue, 22 May 2018 19:56:46 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23:KqTMTRaZxthlRklTuwlt1+P/LSx+4OfEezUN459isYplN5qZr8iybnLW6fgltlLVR4KTs6sC17KN9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCazbL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjmk8qxlSgLniD0fOjA57m/Zl9BwgqxYrhKguxNwzJXZb5uJOPZiZK7RYc8WSXRHU81MVyJBGIS8b44XAuYPI+tYqI39qEULrRSkAwmgHP7kxDBShn/33q0xzvosHQ/b1wEnAd0BrGjboc70NKcWVeC1za/IzTLCb/NNwzvy9pXHcg04rPyKQLl+f83RyUw1GAPEiFWdsZbqPzaP2eUMtGib6fBvVOy0i2I9tw5xpT2vy8ExgYfKnoIY0k3I+CFnzIovONG1SlR3bN26HJdKtiyXM5N6Tt4mTm12oio2178LtYS1cSQU0pgr2gDTZ+SJc4eW4R/vSOOcLDJ8iX9qZL6wnBO//Ea8xeD+SsW51VRHoTZYntTCs30A2RLT5dKbRfZ740yvwyyA1xrJ5eFBOU00lbTUK5omwrMol5oTtUDDHi7wmEXxja+WbV8o9fa15OT6ernmp5mcOJFoigzmL6gjntKzDf4lPgUMRWSW+vqw2Kfi8ED9WLlKi+c5kqjdsJDUP8Qboau5DhdL3Yk/9xmyFDam0NAcnXkGKlJFfxOHj5PzN17QPf/4EO+zg06wnzdz2/DGIrrhD43CLnjZl7fhYK595FBGyAYq0NBf/IxbCqsaIP/oXk/xtcfYDgMiMwCq2ernCdN91p8AVmKVBK+WLr/SvUGS6u0xPuaMedxdhDGoYfc/4OP2gGV8hEQQZ7KB3J0LZWq+E+g8ZUiVfDCk1tgbFnoSsxB7UffnkkaqUDhPamy0Ur5moDw3FdT1I53EQ9Xnq7uF0SKyGNkeS3pHCRinWz+8eo6Pc/YIbCOUJc561DEISO7yGMcayRiyuVqimPJcJe3O93hAuA==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

I have Grouper successfully connecting to an AWS RDS instance, running MariaDB. But at startup, I’m getting this error:

 

[pool-3-thread-1] ERROR GrouperStartup.verifyUtf8andTransactionsHelper(462) - - 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

 

My connection string is as follows:

 

hibernate.connection.url = "jdbc:mysql://xxxx.us-east-2.rds.amazonaws.com:3306/grouper?CharSet=utf8&useUnicode=true&characterEncoding=utf8

 

Any suggestions? I didn’t have any different options when running a local db instance running straight MySQL, so I’m not sure if this is a MariaDB thing?

 

Thanks!

 

Erik Coleman

University of Illinois at Urbana-Champaign

 




Archive powered by MHonArc 2.6.19.

Top of Page