jiangzhaowei@kitking:/kitking/redmineIot$ sudo docker-compose up -d

Creating network "redmineiot_default" with the default driver

Creating redmineiot_mysql_1 ...

Creating redmineiot_web_1 ...

Creating redmineiot_mysql_1

Creating redmineiot_web_1 ... done

docker exec -it redmineiot_web_1 /bin/bash

root@5737a31e5531:/usr/src/redmine# cd /home/git

root@5737a31e5531:/home/git# chown git:git repositories/

root@5737a31e5531:/home/git# su git

git@5737a31e5531:~$ gitolite setup -pk ../redmine/.ssh/id_rsa.pub

Initialized empty Git repository in /home/git/repositories/gitolite-admin.git/

Initialized empty Git repository in /home/git/repositories/testing.git/

WARNING: keydir/id_rsa.pub duplicates keydir/admin.pub, sshd will ignore it

jiangzhaowei@kitking:/kitking/redmineIot$ docker exec -it redmineiot_mysql_1 /bin/bash

root@c5588a506b78:/# mysql -uredmine -py0ur_passw0rd

DELIMITER $$

CREATE PROCEDURE `redmine`.`update_char_set`()

    BEGIN

     DECLARE done INT DEFAULT ;

     DECLARE t_sql VARCHAR();

     DECLARE tableName VARCHAR();

     DECLARE lists CURSOR FOR SELECT table_name FROM `information_schema`.`TABLES` WHERE table_schema = 'redmine';

     DECLARE CONTINUE HANDLER FOR SQLSTATE '' SET done = ;

     OPEN lists;

     FETCH lists INTO tableName;

     REPEAT

        SET @t_sql = CONCAT('ALTER TABLE ', tableName, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci');

        PREPARE stmt FROM @t_sql;

        EXECUTE stmt;

        DEALLOCATE PREPARE stmt;

     FETCH lists INTO tableName;

     UNTIL done END REPEAT;

     CLOSE lists;

    END$$

DELIMITER ;

ALTER DATABASE redmine DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CALL redmine.update_char_set();