When you install Rundeck on your server ,H2 database is configured by default. I prepared a video to guide you for migrating this database in Mysql.
Rundeck version: 2.11
Mysql version: 5.5
This procedure is applicable to all Rundeck versions.
Rundeck’s administration document:
https://docs.rundeck.com/docs/administration/configuration/database/mysql.html#install-mysql
After migration, if you encounter some errors like ‘Service unavailable’ or ‘problem to connect mysql database’, apply following procedure:
Check logs under /var/log/rundeck/service.log
- Connect to your mysql database with root user and type commands below.
mysql -u root -p
GRANT ALL ON rundeck.* to rundeck;
- Check permissions with,
SHOW GRANTS FOR rundeck;
Then restart rundeck service.
Leave A Comment