Details

      Description

      Description:
      Clustering no longer works with JDBC_PING after patching to DE-34.

      Steps To Reproduce:

      1. Download and unzip Liferay DXP SP6
      2. Prepare a MySQL database
      3. Configure JDBC PING Unicast Cluster using the following steps (more information available here):
        • Acquire a tcp.xml file and rename it to "jdbc_ping_config.xml"
        • Replace the "<TCPPING" tag information with the following in the jdbc_ping_config.xml file:
          <JDBC_PING
              connection_url="jdbc:mysql://ipaddress/databaseName?useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false"
              connection_username="yourusername"
              connection_password="yourpassword"
              connection_driver="com.mysql.jdbc.Driver"/>
        • Add the following properties to the portal-ext.properties file to point to the jdbc_ping_config.xml file:
          cluster.link.channel.properties.control=pathToXml/jdbc_ping_config.xml
          cluster.link.channel.properties.transport.0=pathToXml/jdbc_ping_config.xml
        • Add the following to the portal-ext.properties file:
          cluster.link.enabled=true
        • Add the following to the JVM parameters in the setenv.sh/bat file for each node:
          -Djgroups.bind_addr=<node_address>
      1. Startup Liferay and confirm that the no errors occur
      2. Shut down Liferay and patch to DE34
      3. Clear temp and work and osgi/state
      4. Restart Liferay

      Expected Results:
      Liferay starts up normally and the cluster works as expected (you can see the cluster section in the log)

      Actual Results:
      The following appears in the logs:

      Caused by: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver'
      at org.jgroups.protocols.JDBC_PING.loadDriver(JDBC_PING.java:327)
      at org.jgroups.protocols.JDBC_PING.init(JDBC_PING.java:127)
      at org.jgroups.stack.ProtocolStack.initProtocolStack(ProtocolStack.java:860)
      at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:481)
      at org.jgroups.JChannel.init(JChannel.java:854)
      at org.jgroups.JChannel.<init>(JChannel.java:159)
      at org.jgroups.JChannel.<init>(JChannel.java:139)
      at com.liferay.portal.cluster.multiple.internal.jgroups.JGroupsClusterChannel.<init>(JGroupsClusterChannel.java:62)
      ... 145 more

       

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 19 weeks, 6 days ago