Configuring Apache Tomcat for MySQL manually

IBM Worklight V5.0.5. automatically configures your databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process for the Apache Tomcat Server, you must manually set up and configure your MySQL database and then the Apache Tomcat Server for MySQL. Complete the MySQL database setup procedure before continuing.

  1. Copy the Connector/J .jar file into the $TOMCAT_HOME/lib directory.

    For JDBC, modify worklight.properties as follows:

    wl.db.type=MYSQL
    wl.db.url= jdbc:mysql://localhost:3306/WRKLGHT
    wl.reports.db.type=MYSQL
    wl.reports.db.url=jdbc:mysql://localhost:3306/WLREPORT
    wl.db.username=worklight
    wl.db.password=worklight
    reports.exportRawData=true
    

    For JNDI, edit the $TOMCAT_HOME/conf/web.xml file as follows:

    <web-app>
        ....
        ....
    <resource-ref>
    	<res-ref-name>jdbc/WorklightDS</res-ref-name>
    	<res-type>javax.sql.DataSource</res-type>
    	<res-auth>Container</res-auth>
    </resource-ref>
    <resource-ref>
    	<res-ref-name>
    jdbc/WorklightReportsDS</res-ref-name>
    	<res-type>javax.sql.DataSource</res-type>
    	<res-auth>Container</res-auth>
    </resource-ref>
    </web-app> 
    

  2. Update the $TOMCAT_HOME/conf/context.xml file as follows:
    <Context ...>
      ...
    <Resource name="jdbc/WorklightDS" 
    auth="Container" 
    type="javax.sql.DataSource"
          maxActive="100" 
    maxIdle="30" 
    maxWait="10000"
          username="worklight" 
    password="worklight" 
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/WRKLGHT"/>
    <Resource name="jdbc/WorklightReportsDS" auth="Container" 
    type="javax.sql.DataSource"
    maxActive="100" 
    maxIdle="30" 
    maxWait="10000"
    username="worklight" 
    password="worklight"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/WLREPORT"/>
    
     ...
    </Context>
    

  3. In the worklight.properties file, update the following properties:
    wl.db.jndi.name=java:comp/env/jdbc/WorklightDS
    wl.db.reports.jndi.name=java:comp/env/jdbc/WorklightReportsDS
    

    The worklight.properties file is in worklight.war.

  4. Copy the worklight.war file to $TOMCAT_HOME/webapps.

  5. Copy the worklight-jee-library.jar file to $TOMCAT_HOME/lib.


Parent topic Troubleshooting