Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-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
    • None
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? 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:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: