For Video guide - Click on the below link
|
|
...
Prerequisite SoftwareNOTE: the software and versions included below are a mandatory prerequisite
|
---|
| |
---|---|
1) Before beginning, uninstall any existing versions of Java currently on your computer. | 2) In your web browser, go to http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html, to download JAVA 1.8. |
3) Oracle requires that you read the license agreement, then click the button labeled Accept License Agreement. | 4) Click the link to download the version for your system architecture i.e. Windows x86 for 32bit or Windows x64 for 64bit. |
5) Save the Java installation file to your computer | 6) Run and install the Java file. |
...
| |
---|---|
1) Download HEIDISQL from http://www.heidisql.com/download.php and save the installation file to your computer. | 2) Run the Heidisql installation file and setup Heidisql: i) Click on local and enter the MySQL password (mysql) in the Password field. ii) Click on the Save button. iii) Click on the Open button. |
4) Copy the following database command and paste it into the large white box titled Query | 5) Click on the Run button to execute the query. |
6) In the heidisql menu bar, click on File>>Load SQL file... | 7) In the Load SQL file window:
Run the first-time-install script, by clicking Run Query button. Once it's successful close the heidisql application. |
| |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1) Setting up the Lib folder a) Download the mysql jdbc 5.1.27 jar file from http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.27/mysql-connector-java-5.1.27.jar b) Once it's downloaded, copy the file and paste it to the Tomcat>>lib folder.
| 2) Generate keystore Generate a new keystore using the Java keytool : i) Open Command Prompt
| ||||||||||
3) Configure server.xml page, a) Go to tomcat>>conf, then right click on the server.xml file and select Open with>>Notepad: to reflect your system and settings: reflect the username and password used in step 4 of the Install MySQL section above (for e | <?xml version='1.0' encoding='utf-8'?> <GlobalNamingResources> <Resource type="javax.sql.DataSource" <Service name="Catalina"> <Connector protocol="org.apache.coyote.http11.Http11Protocol" <Engine name="Catalina" defaultHost="localhost"> <Realm className="org.apache.catalina.realm.LockOutRealm"> <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true"> <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
| ||||||||||
4) Save the modified server.xml page Press Ctrl + S or File>>Save. | 5) Close Notepad. |
...