Version: kiwitcms-3.41-ee Released on: 2017-10-10 Severity: High URL: http://MrSenko.com/kiwi/

Details

KiwiTCMS is the leading open source test plan, test run and test case management system! It has a lot of great features, such as Bugzilla, JIRA and GitHub integration, fast test plan and test runs search, powerful access control for each plan, run and case, and XML-RPC APIs.

This release removes some unused code, introduces a few bug-fixes and most importantly updates the MariaDB docker image to take full advantage of UTF8 strings!

Changes since KiwiTCMS 3.39

WARNING

MariaDB defaults are to use latin1 as the default character set and collation. This will lead to 500 internal server errors when trying to save data which does not use ASCII characters. This is a limitation with the underlying CentOS/MariaDB docker image and has been fixed upstream. Update your docker image by running:

docker pull centos/mariadb

You need to manually update your existing databases by using the following instructions:

bash-4.2$ mysql -u root -p
Enter password:

MariaDB [(none)]> ALTER DATABASE kiwi CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 1 row affected (0.00 sec)

bash-4.2$ mysql -D kiwi -u root -p -B -N -e "SHOW TABLES" | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' > /tmp/alter_charset.txt
Enter password:

bash-4.2$ cat /tmp/alter_charset.txt | mysql -D kiwi -u root -p
Enter password:

You can use the SHOW TABLE STATUS; query to see the current settings for your tables!

IMPORTANT: this release introduces new database migrations!

How to upgrade

Subscribe to Mr. Senko and configure your private PyPI repositories before upgrading!

pip install --upgrade kiwitcms

If you are using KiwiTCMS as a Docker container then

docker-compose down
docker pull mrsenko/kiwi
docker-compose up -d
docker exec -it kiwi_web /Kiwi/manage.py migrate

NOTE you will need the appropriate version of docker-compose.yml and the mrsenko/kiwi Docker image for the above commands to work!

tags: Python, errata,

Comments !