...
- Ensure the following libraries are in the [TOMCAT_HOME]/lib folder:
- mysql-connector-java-5.1.22 (You will need to download latest MySQL Connector/J Jar file from http://dev.mysql.com/downloads/connector/j/)
To download it you will need to make an Oracle account, file.php?id=457911)
Once it's downloaded copy only the MySQL Connector/J jar file then paste that in the to Tomcat>>lib folder. - tomcat-jdbc.jar
If you are missing it use the following link to download: http://www.java2s.com/Code/JarDownload/tomcat-jdbc/tomcat-jdbc.jar.zip
- mysql-connector-java-5.1.22 (You will need to download latest MySQL Connector/J Jar file from http://dev.mysql.com/downloads/connector/j/)
- Generate a new keystore using java keytool (if you havent already done this):
- Create keystore
- for Windows:
Open command prompt
>>Go to the path where your JAVA>>bin folder is located.
>>Run this command to generate the key:- keytool -genkey -alias tomcat -keyalg RSA
>>Then provide the password.
Ex:
Provide input and type in y for the last question to confirm. - for Unix:
- for Windows:
- Update server.xml as in docs with the following command:
- Create keystore
- Update tomcat configuration files for SSL
- Go to [TOMCAT_HOME]/conf and open server.xml with notepad:
- Delete everything in it and copy-paste the following code:
<?xml version='1.0' encoding='utf-8'?> <Server port="8005" shutdown="SHUTDOWN"> <Listener className="org.apache.catalina.core.JasperListener" /> <Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" /> <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /> <Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" /> <GlobalNamingResources> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" pathname="conf/tomcat-users.xml" /> <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/mifosplatform-tenants" username="root" password="[root mysql password]" initialSize="3" maxActive="10" maxIdle="6" minIdle="3" validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" minEvictableIdleTimeMillis="60000" logAbandoned="true" suspectTimeout="60" /> </GlobalNamingResources> <Service name="Catalina"> <Connector protocol="org.apache.coyote.http11.Http11Protocol" port="8443" maxThreads="200" scheme="https" secure="true" SSLEnabled="true" keystoreFile="/home/ubuntu/.keystore" keystorePass="testmifos" clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8" compression="force" compressableMimeType="text/html,text/xml,text/plain,text/javascript,text/css"/> <Engine name="Catalina" defaultHost="localhost"> <Realm className="org.apache.catalina.realm.LockOutRealm"> <Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/> </Realm> <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true"> <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h %l %u %t "%r" %s %b" /> </Host> </Engine> </Service> </Server>
Press Ctrl + S or File>Save.
Close Notepad.
Below mentioned are to be updated in the same server.xml
i - Key store path should be updated like shown in example here:- keystoreFile="C:\Users\conflux9\.keystore"
ii - Key store password (which was provided while creating the key). Should also be updated like shown in example:- keystorePass="mif456"
iii - Provide your mysql user name and password, like in this example:- username="root"
password="mysql"
- Go to [TOMCAT_HOME]/conf and open server.xml with notepad:
- Dropping application into tomcat webapps folder
...