Turn Your Vehicle Into a Smart Earning Asset

While you’re not driving your car or bike, it can still be working for you. MOTOSHARE helps you earn passive income by connecting your vehicle with trusted renters in your city.

🚗 You set the rental price
🔐 Secure bookings with verified renters
📍 Track your vehicle with GPS integration
💰 Start earning within 48 hours

Join as a Partner Today

It’s simple, safe, and rewarding. Your vehicle. Your rules. Your earnings.

Rundeck Database Migration From H2 to MySql and postgresql

Rundeck Database Migration From H2 to MySql

Step 1 – Install mySql Server

Step 2 – Create rundeck db and rundeckuser and set their permissing


$ mysql -u root -p
mysql> create database rundeck;
mysql> grant ALL on rundeck.* to 'rundeckuser'@'localhost' identified by 'rundeckpassword';
$ mysql -u rundeckuser -p
mysql> show databases;Code language: JavaScript (javascript)

Step 3 – Configuring Rundeck to connect to mysql DB

Update your rundeck-config.properties file with settings from the following database list and restart Rundeck. This file is located in different locations depending on your installation method:

  • RPM/DEB/etc/rundeck/rundeck-config.properties
  • WAR/Custom$RDECK_BASE/server/config/rundeck-config.properties

Step 4 – Change Server URL of grails.serverUrl

The configuration option grails.serverUrl must be set properly. The value should match the URL users would use to access Rundeck(ie the URL they would enter into the browser).

For Docker this should be configured with the RUNDECK_GRAILS_URL environment variable.
For deb, rpm, and war this will be set as grails.serverUrl= in the rundeck-config.properties file

Step 5 – Copy MySQL JDBC Driver

To use the Oracle MySQL driver download it and copy it to the $RDECK_BASE/server/lib for war launcher or in /var/lib/rundeck/lib (create it) for RPM and DEB installations.


$ mkdir /var/lib/rundeck/lib
$ MYSQLJ_VERS=8.0.21
$ curl -L -o https://repo1.maven.org/maven2/mysql/mysql-connector-java/${MYSQLJ_VERS}/mysql-connector-java-${MYSQLJ_VERS}.jar
Code language: JavaScript (javascript)

Step 6 – restart Rundeck

$ sudo service rundeckd restart
Subscribe
Notify of
guest
1 Comment
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
GaryG
GaryG
2 years ago

That is not a migration, My data in the H2 did not migrate to the mysql database.
Gary

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.

1
0
Would love your thoughts, please comment.x
()
x