Installing Jira along with Confluence

[Frank Høvin]

I've got Confluence installed on a Ubuntu server. I'm using MySQL for the confluence database, installed on the same server as Confluence.

Now I'd like Jira as well, and I'm wondering if there are any specific concerns, pitfalls etc. I need to be aware of. Is it straigh-forward to install Jira alongside Confluence, on the same server and same database server?

[Alexis Robert]

Hello, 

you should not have any issues running both Confluence and Jira on the same server, just make sure that you have enough ressources for both, especially memory-wise.

Confluence runs on 8090 port and Jira on 8080 port so you should not have any conflict here.

Both will use difference databases on your MySQL DB, you should create two different users for accessing it though.

Let me know if you have any more questions, 

--Alexis

[Frank Høvin]

Thanks for the answer :-)

Now I'm just back to the usual, never-ending headaches related to installing and configuring atlassian products...

Since the "advanced" installer never gave me the option to chose database, even though the site states that it should, I have to set up the MySQL db connection manually afterwards. And that's not going to be easy, of course.

I've copied the mysql connector file to the installation /lib folder.

When I'm trying to run the /bin/config.sh tool, I get this lovely error:

No JRE_HOME or JAVA_HOME environment variable is set - attempting to just run java command
*************************************************************************************************************************************
**********     Wrong JVM version! You are running with .. but JIRA requires at least 1.8 to run.      **********
*************************************************************************************************************************************

Jira is up and running, and apparently working fine, but this config tool states that that cannot be the case, because it's the wrong version of the JVM. Logical...

[Alexis Robert]

Hi Frank,

I think this is because the version you're using is not officially supported but will probably work fine. You'll only have an issue if you try to get support from Atlassian because they will then ask you first to get a supported version to run Jira :)

For the JRE_HOME/JAVA_HOME error, this is because Jira doesn't find the variable, you can set here using this guide

By the way if it answers your question, please accept the answer with the check marker. It will help other users with similar questions find it :)

--Alexis

[Frank Høvin]

So...I went around this idiotic issue by setting the expected JVM version to "0" in the script.

But, as expected, it doesn't work...

I've placed the mysql driver in the /lib folder, and this is the info I'm entering when running the config.sh tool:

Hostname: localhost
Port: 3306 (default)
Database: jiradb
Username: jirauser@localhost
Password: <the password>
Test connection? Y

Attempting to connect to localhost:3306/jiradb
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
*** Connection failed: Could not connect to the DB: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=InnoDB'.

I'd think that the database server is set up correctly, seeing as Confluence already runs on it?

*SIGH*

[Alexis Robert]

Hi, 

why don't you manually configure the database ? if Jira is already running you should be able to edit the dbconfig.xml file in your JIRA_HOME as described in this guide.

Let me know if it works, 

--Alexis

[Frank Høvin]

It doesn't. Here's the dbconfig.xml file:

<jira-database-config>
  <name>jiradb</name>
  <delegator-name>default</delegator-name>
  <database-type>mysql</database-type>
  <jdbc-datasource>
    <url>jdbc:mysql://localhost:3306/jiradb?useUnicode=true&amp;characterEncoding=UTF8&amp;sessionVariables=default_storage_engine=InnoDB</url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <username>jirauser</username>
    <password>REMOVED IN PASTE</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
  </jdbc-datasource>
</jira-database-config>

The logs don't really say anything, I think. Nothing about the DB connection, at least.

I'm using the default suggested names for user and database: jirauser and jiradb.

I an log in to the mysql server using jirauser and access jiradb. So what the heck is wrong here? I'd sort of understand it if it was complaining about some database server setting - although that would be stange too, since confluence is already running problem-free on the same database - but a complete unability to connect, when the credentials are clarly correct and the database is on localhost, that I don't understand.

Can someone tell me how I can get support on this? I want to purchase Jira, but if Atlassian isn't offering enough support to get me past a seemingly idiotic technical installation problem, it's not going to happen. I'm a paying Confluence customer, but I won't get any help getting Jira to work before bying it??

[Frank Høvin]

While troubleshooting this, I removed the dbconfix.xml file, stopped the server - and was forced to kill the Tomcat process manually - and started it again.

I was now taken to the initial Jira installation page, where I could select to set it up myself, and use my own database.

Naturally, this solved nothing. Jira is still unable to connect to the same database as Conflucence is currently connected to!!!

And the log basically says the same thing:

2018-04-23 12:54:43,851 http-nio-8080-exec-1 ERROR anonymous 774x284x1 1klynuu 95.128.111.111 /secure/SetupDatabase!connectionCheck.jspa [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=InnoDB'.
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:108)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:79)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:131)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:231)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:347)
        at com.atlassian.jira.config.database.JdbcDatasource.getConnection(JdbcDatasource.java:211)
        at com.atlassian.jira.config.database.DatabaseConfig.testConnection(DatabaseConfig.java:88)
        at com.atlassian.jira.web.action.setup.SetupDatabase.testConnection(SetupDatabase.java:225)
        at com.atlassian.jira.web.action.setup.SetupDatabase.doValidation(SetupDatabase.java:189)
        at com.atlassian.jira.web.action.setup.SetupDatabase.doConnectionCheck(SetupDatabase.java:121)
        ... 3 filtered
        at java.lang.reflect.Method.invoke(Method.java:498)
        at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)
        at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)
        ... 2 filtered
        at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
        ... 7 filtered
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        ... 45 filtered
        at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
        ... 1 filtered
        at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
        ... 28 filtered
        at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
        ... 24 filtered
        at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
        ... 23 filtered
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=InnoDB'.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
        ... 155 more
Caused by: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=InnoDB'.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
        at com.mysql.cj.conf.ConnectionUrlParser.parseQuerySection(ConnectionUrlParser.java:496)
        at com.mysql.cj.conf.ConnectionUrlParser.getProperties(ConnectionUrlParser.java:621)
        at com.mysql.cj.conf.ConnectionUrl.collectProperties(ConnectionUrl.java:302)
        at com.mysql.cj.conf.ConnectionUrl.<init>(ConnectionUrl.java:287)
        at com.mysql.cj.conf.url.SingleConnectionUrl.<init>(SingleConnectionUrl.java:47)
        ... 3 filtered
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.cj.util.Util.handleNewInstance(Util.java:210)
        at com.mysql.cj.util.Util.getInstance(Util.java:185)
        at com.mysql.cj.util.Util.getInstance(Util.java:192)
        at com.mysql.cj.conf.ConnectionUrl.getConnectionUrlInstance(ConnectionUrl.java:189)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:201)
        ... 154 more