A Docx with images is included in zip file. this is text only
Note : this application uses Metronic Theme v5. You must buy a license from metronic developers.
2. Setup MySQL Database
Open MySQL workbench (on Windows MySQL service must be running)
Create Database named ‘sampledb.
Save database username, password, host, port you will need them to connect the application to the database later.
3. Staring the Server
Copy “mysql-connector-java-8.0.19” under “locationofserver\payara201\glassfish\domains\domain1\lib”
Payara201 is the name of the folder your server is at. It could be any name.
Start Glassfish/Payara. (make sure your path environment variable is set to JDK 8.)
Go to http://localhost:4848/
Creating JDBC Connection Pool:
Got to Resources/JDBC/JDBC Connection Pools
Fill in the fields like the followling image
Scroll down to Additional Properties.
Select and remove all properties and enter these ones:
Don’t forget to change user and password values.
Go to Resources/JDBC/JDBC Resources
Enter JNDI Name and pool name:
Setting up Security Realm:
Go to Configurations/server-config/Security/Realms
JAAS Context: jdbcRealm
User Table: sampledb.user
User Name Column: EMAIL
Password Column: PASSWORD
Group Table: sampledb.user_group_join
Group Table User Name Column: USER_ID