Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **** I strongly recommend you to backup your database ***
- 1. Run bellow sentences. You only need to replace the schema name.
- ALTER DATABASE rundeck CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
- ALTER TABLE storage CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE auth_token CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE base_report CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE execution CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE job_file_record CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE log_file_storage_request CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE messaging CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE node_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE notification CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE orchestrator CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE plugin_meta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE project CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE rdoption CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE rdoption_values CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE rduser CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE report_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE scheduled_execution CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE scheduled_execution_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE workflow CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE workflow_step CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- ALTER TABLE workflow_workflow_step CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- 2. Add "useUnicode=yes" to your db connection in the rundeck-config-properties file. Example:
- dataSource.url = jdbc:mysql://localhost:3306/rundeck?autoReconnect=true&useUnicode=yes
- 3. Add this line to the mysql.cnf file:
- [mysqld]
- character_set_server=utf8mb4
- 4. Restart rundeck and MySQL service
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement