Setting up Mariadb with wso2 ESB in RHEL 6

First of all you need to download wso2 Enterprise service bus from www.wso2.com site.

Then you have to setup your java environment. 

After that check whether correctly set JAVA_HOME and also in PATH.

Now you are ready to start wso2 ESB with inbuilt settings.

Go to <ESB home>/bin

Then run,

> bash ./wso2server.sh

Now you can log in to the started ESB server. But in here there is inbuilt h2 database connected for data savings.

Now lets setup mariadb to wso2 ESB.

First go the mariadb.org site.

Then download mariadb 5.5 stable version rpm files from the site and follow below link,

https://mariadb.com/kb/en/mariadb/documentation/getting-started/binary-packages/rpm/installing-mariadb-with-the-rpm-tool/

after running installation start mysql using

service mysql start

after starting the server, you can run below command to create security constraints in the server,

/usr/bin/mysql_secure_installation

After create root user credentials, you can log in the mariadb using,

Mysql –u root –p

>give your password

Now you can create user for esb,

Create user ‘username’@’localhost’ identified by ‘password’;

Then follow same below url and please consider mysql as mariadb,

https://docs.wso2.com/display/ESB481/Setting+up+MySQL

After all these settings, you are completely set mariadb with wso2ESB.

Now you can restart your server and keep work.

******** Please remember that if you are going to upgrade from previous mysql installation. You better remove mysql file in /var/libs/mysql by using ,

>rm –r –f /var/libs/mysql

**onlyn if mysql not working after changing to the mariadb.**********

*****next thing is check in /usr/local/mysql folder. If it is existing in before install new version, remember to delete is like previous one. ********