Run the container

docker run --name=mysql8 -d -e MYSQL_ROOT_PASSWORD=pass -p 3306:3306 mysql/mysql-server:8.0

Create a database and user, note you need to put the source IP address in there.  You can see what it is from the error message if you try to connect and you are wrong:

message from server: "Host '' is not allowed to connect to this MySQL server"

Note, if you get a mysql.sock error, wait until the database is started to connect.  i.e. try again.

mchyzer@ISC20-0637-WL:~$ docker exec -it mysql8 mysql -uroot -p
Enter password:
mysql> create database grouper_v2_5 character set UTF8 collate utf8_bin;
mysql> create user 'grouper_v2_5'@'' IDENTIFIED WITH mysql_native_password by 'pass';
mysql> grant all on grouper_v2_5.* to 'grouper_v2_5'@'';
mysql> flush privileges;
mysql> quit

Start a grouper to point to that database.  Note, this works on windows, on non-windows you can adjust the IP address of database

docker run --detach -e GROUPER_RUN_SHIB_SP='false' -e GROUPER_UI_GROUPER_AUTH=true \
-e GROUPER_DATABASE_URL=jdbc:mysql:// \
-e SELF_SIGNED_CERT='true' --name grouper-ui --publish 443:443 i2incommon/grouper:2.5.39 ui

Watch the logs until the database is initialized

docker logs -f grouper-ui

Go in and set a GrouperSystem UI password

mchyzer@ISC20-0637-WL:~$ docker exec -it -u tomcat grouper-ui bash
[tomcat@f6c8e2b68215 WEB-INF]$ cd bin
[tomcat@f6c8e2b68215 bin]$ ./
groovy:000> new GrouperPasswordSave().assignApplication(GrouperPassword.Application.UI).assignUsername("GrouperSystem").assignPassword("pass").save();
groovy:000> :quit
[tomcat@f6c8e2b68215 bin]$ exit

Log in


  • No labels