Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-31915

MySQL as Confluence database: JDBC driver doesn't work when is linked to system JDBC driver [OS installed]

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Won't Fix
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for Confluence Cloud. Using Confluence Server? See the corresponding suggestion.

      Working on Ubuntu Server latest, I generally install Atlassian applications on home directories of their dedicated users. In this case, I install Confluence under following folder hierarchy:

      /home/confluence
        |_  current/   = INST_DIR
        |_  .home/     = HOME_DIR
        |_  backups/   = Location where old backups are held, everytime I upgrade

      It all works good. When using MySQL as the production RDBMS, I first install libmysql-java library which fetches JDBC drivers:

      sudo apt-get install libmysql-java

      The latest driver is generally linked through /usr/share/java/mysql.jar file. In all my Atlassian product installations, I just link to that file. For example, in the case of Confluence, I link to that location from INST_DIR/confluence/WEB-INF/lib/mysql.jar. Generally it works with other Atlassian software, but for some reasons Confluence doesn't like this method. The error in log file is evidently permission related, although I have target file on 0777:

      Dec 09, 2013 8:34:55 PM org.apache.catalina.startup.Catalina start
      SEVERE: Catalina.start:
      LifecycleException:  start: :  java.io.IOException: Failed to access resource /WEB-INF/lib/mysql.jar
              at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:709)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4575)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
              at org.apache.catalina.core.StandardService.start(StandardService.java:525)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

      Is there any way to fix this behaviour?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              4895e1318250 Shahriyar Imanov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: