Grouper Users - Open Discussion List

[Scott Koranda <>]

Hi,

I use this in my grouper.hibernate.properties:

hibernate.connection.driver_class = org.mariadb.jdbc.Driver

hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

hibernate.connection.url = "jdbc:mysql://my.host:3306/grouper?autoReconnect=true&CharSet=utf8&useUnicode=true&characterEncoding=utf8&sessionVariables=wait_timeout=1209600

hibernate.connection.username = grouper

hibernate.connection.password = MY_PASSWORD

Scott K

On Tue, Sep 6, 2016 at 7:22 AM, Keith Hazelton <> wrote:

When I start up the Grouper 2.3.0 Tomcat instance with a MariaDB 5.5.50 database, I get the following in logs/grouperUi/grouper_error.log:

 

2016-09-06 08:03:10,089: [pool-2-thread-1] ERROR GrouperStartup.verifyUtf8andTransactionsHelper(407) -  - 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’ve done all the steps I can find to make Mariadb use utf8 by default. There must be something I’m missing.

 

          --Keith

 

https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/#example-changing-the-default-character-set-to-utf-8

 

To change the default character set from latin1 to UTF-8, the following settings should be specified in the my.cnf configuration file.

 

[client]

...

default-character-set=utf8

...

[mysql]

...

default-character-set=utf8

...

[mysqld]

...

collation-server = utf8_unicode_ci

init-connect='SET NAMES utf8'

character-set-server = utf8

...

 

- changes

 

midpoint#>cat /etc/my.cnf

 

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

collation-server = utf8_unicode_ci

init-connect='SET NAMES utf8'

character-set-server = utf8

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

 

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

 

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

 

midpoint#>cat /etc/my.cnf.d/client.cnf

 

#

# These two groups are read by the client library

# Use it for options that affect all clients, but not the server

#

 

[client]

 

# This group is not read by mysql client library,

# If you use the same .cnf file for MySQL and MariaDB,

# use it for MariaDB-only client options

 

default-character-set=utf8

 

[client-mariadb]

 

default-character-set=utf8

 

midpoint#>cat /etc/my.cnf.d/mysql-clients.cnf

 

#

# These groups are read by MariaDB command-line tools

# Use it for options that affect only one utility

#

 

[mysql]

 

default-character-set=utf8

 

[mysql_upgrade]

 

[mysqladmin]

 

[mysqlbinlog]

 

[mysqlcheck]

 

[mysqldump]

 

[mysqlimport]

 

[mysqlshow]

 

[mysqlslap]

 

- restart mariadb.service to pick up new character sets

 

___________________________________

email & jabber:

calendar: http://go.wisc.edu/i6zxx0