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:
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.