Adding a Datasource to JBoss EAP

1. Install MariaDB:

sudo yum install mariadb-server

2. Ensure the MariaDB service has been started and set MariaDB to start at boot:

sudo systemctl start mariadb
sudo systemctl enable mariadb

3. Secure the installation; there is no default password for root. Set a password, remove anonymous users, disallow remote root login, and remove the test database. Reload the privilege tables, following the prompt.

   sudo mysql_secure_installation
   

4. Access the MySQL CLI as the root user, using the password you just provided:

   mysql -u root -p
   

5. Create a new database, users; create the user jboss-eap and grant that user access to the database:

   create database users;
   grant all on users.* to 'jboss-eap' identified by 'pinehead';
   

6. Log out of MySQL:

   exit
   

1. Access the JBoss EAP CLI:

   cd /opt/jboss-eap
   sudo ./bin/jboss-cli.sh
   

2. Connect to the server:

   connect
   

3. Register the MySQL driver:

   /subsystem=datasources/jdbc-driver=mysql:add(driver-name=mysql,driver-module-name=com.mysql)
   

4. Create the datasource:

   data-source add --name=MySQLDS --jndi-name=java:/MySqlDS 
   --driver-name=mysql --connection-url=jdbc:mysql://localhost:3306/users 
   --user-name=jboss-eap --password=pinehead
   

We can test the connection from the CLI with 1/subsystem=datasources/data-source=MySQLDS:test-connection-in-pool.