Advertisement
Guest User

Untitled

a guest
Feb 1st, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. **** I strongly recommend you to backup your database ***
  2.  
  3. 1. Run bellow sentences. You only need to replace the schema name.
  4.  
  5. ALTER DATABASE rundeck CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  6. ALTER TABLE storage CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  7. ALTER TABLE auth_token CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  8. ALTER TABLE base_report CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  9. ALTER TABLE execution CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  10. ALTER TABLE job_file_record CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  11. ALTER TABLE log_file_storage_request CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  12. ALTER TABLE messaging CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  13. ALTER TABLE node_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  14. ALTER TABLE notification CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  15. ALTER TABLE orchestrator CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  16. ALTER TABLE plugin_meta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  17. ALTER TABLE project CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  18. ALTER TABLE rdoption CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  19. ALTER TABLE rdoption_values CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  20. ALTER TABLE rduser CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  21. ALTER TABLE report_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  22. ALTER TABLE scheduled_execution CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  23. ALTER TABLE scheduled_execution_filter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  24. ALTER TABLE workflow CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  25. ALTER TABLE workflow_step CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  26. ALTER TABLE workflow_workflow_step CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  27.  
  28. 2. Add "useUnicode=yes" to your db connection in the rundeck-config-properties file. Example:
  29.  
  30. dataSource.url = jdbc:mysql://localhost:3306/rundeck?autoReconnect=true&useUnicode=yes
  31.  
  32. 3. Add this line to the mysql.cnf file:
  33.  
  34. [mysqld]
  35.  
  36. character_set_server=utf8mb4
  37.  
  38. 4. Restart rundeck and MySQL service
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement