nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to connect Jira to remote database - PostgreSQL

KL Kumar

Hello,

I have a local Jira (v8.0.2) setup in my machine and I can up the Jira server (using default h2 DB) without any issues. But I want to configure remote PostgreSql and bring the Jira server up. I did the database configuration in dbconfig.xml in jira/home directory, but the jira server is failing to start. The only errors I can see is as below.

[INFO] [talledLocalContainer] 2019-06-21 17:09:27,613 localhost-startStop-1 INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
[INFO] [talledLocalContainer] 2019-06-21 17:09:27,613 localhost-startStop-1 INFO [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
[INFO] [talledLocalContainer] 2019-06-21 17:09:28,528 localhost-startStop-1 INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\D-Drive\Workspace\JiraContextManager\target\jira\home\dbconfig.xml
[DEBUG] [URLDeployableMonitor] URL [http://localhost:2990/cargocpc/index.html] is not responding: -1 java.net.SocketTimeoutException: Read timed out
[DEBUG] [URLDeployableMonitor] Notifying monitor listener [org.codehaus.cargo.container.spi.deployer.DeployerWatchdog@43ef1243]
[INFO] [yer.DeployerWatchdog] Deployable [http://localhost:2990/cargocpc/index.html] failed to finish deploying within the timeout period [600000]. The Deployable state is thus unknown.
[WARNING] [talledLocalContainer] org.codehaus.cargo.container.ContainerException: Deployable [http://localhost:2990/cargocpc/index.html] failed to finish deploying within the timeout period [600000]. The Deployable state is thus unknown.
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 22:25 min
[INFO] Finished at: 2019-06-21T17:15:22+05:30
[INFO] Final Memory: 40M/164M
[INFO] ------------------------------------------------------------------------

I am able to connect to the same remote DB configuration from pgAdmin 4 (vendor software to connect to DB).

Is there any other configuration am I missing ?

Thanks!

Kumar

Accepted answers

KL Kumar

Okay! I found the issue. It is the schema name (public) in dbconfig.xml which was mentioned in uppercase. PostgreSQL is case sensitive and so it caused the issue. Changed the schema name to lowercase and restarted the jira. It works.

Thanks!

Kumar

All comments

Andy Heinzer

Hi Kumar,

It looks like you're using the atlassian SDK in order to try to connect to an external postgresql database and it doesn't look like it is working.

I took a closer look at my own Atlassian SDK and when I'm looking into my folders of both the install and home directories, I'm not seeing the postgres jdbc .jar driver file that Jira needs to be able to connect to that data type. A non- SDK Jira install will always have this in the $JIRAINSTALL/lib/ folder. But the SDK seems to only have the h2sql one here.

I found a related topic to this that I think will help here. Check out Using mysql instead of HSQL db with Atlassian PDK. It is a bit older, and it's dealing with using mysql for the SDK, but I think the steps are still going to be applicable here. My Jira 8.1.0 version appears to be shipping with the Postgres 9.4.1212 jdbc driver. A big list of these files can be found in https://jdbc.postgresql.org/download.html

But I think the driver you likely want for a Java 8 / JDK 8 environment would be. https://jdbc.postgresql.org/download/postgresql-9.4.1212.jar

Try this and see if this helps.

Andy

KL Kumar

Thanks for your reply @Andy Heinzer ,

I downloaded postgresql-9.1-901-1.jdbc4.jar and copied to "target\jira\webapp\WEB-INF\lib" directory and "target\container\tomcat8x\apache-tomcat-8.5.6\lib". None of them worked for me.

I don't think it is a driver issue (though I have the driver jar), because if it is a driver issue, it might have thrown no class found error or similar. All I can see is a timeout warning.

[INFO] [talledLocalContainer] 2019-06-26 22:36:59,860 localhost-startStop-1 INFO [c.a.jira.startup.JiraStartupLogger]
[INFO] [talledLocalContainer]
[INFO] [talledLocalContainer] Database configuration OK
[INFO] [talledLocalContainer]
[INFO] [talledLocalContainer] ___ Database Configuration ________________
[INFO] [talledLocalContainer]
[INFO] [talledLocalContainer] Loading entityengine.xml from : file:/C:/D-Drive/Workspace/JiraContextManager/target/container/tomcat8x/cargo-jira-home/webapps/jira/WEB-INF/classes/entityengine.xml
[INFO] [talledLocalContainer] Entity model field type name : postgres72
[INFO] [talledLocalContainer] Entity model schema name : public
[INFO] [talledLocalContainer] Database Version : PostgreSQL - 9.5.8
[INFO] [talledLocalContainer] Database Driver : PostgreSQL Native Driver - PostgreSQL 9.4.1212
[INFO] [talledLocalContainer] Database URL : jdbc:postgresql://xxx.xx.xx.xxx:5432/devdb
[INFO] [talledLocalContainer] Database JDBC config : postgres72 jdbc:postgresql://xxx.xx.xx.xxx:5432/devdb
[INFO] [talledLocalContainer]
[INFO] [talledLocalContainer] 2019-06-26 22:37:00,226 localhost-startStop-1 INFO [c.a.jira.startup.JiraStartupLogger]
[INFO] [talledLocalContainer]
[INFO] [talledLocalContainer] ___ Starting the JIRA Plugin System _________________
[INFO] [talledLocalContainer]
[INFO] [yer.DeployerWatchdog] Deployable [http://localhost:2990/cargocpc/index.html] failed to finish deploying within the timeout period [600000]. The Deployable state is thus unknown.
[WARNING] [talledLocalContainer] org.codehaus.cargo.container.ContainerException: Deployable [http://localhost:2990/cargocpc/index.html] failed to finish deploying within the timeout period [600000]. The Deployable state is thus unknown.
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------

Andy Heinzer

Thanks for that info. It might not be a driver issue. But if we're seeing a timeout, then Jira is getting hung up somewhere.

I would want to test this database connection outside of the SDK itself. If you were to use a standard Jira server install, you could utilize the Jira config tool as a means to both setup the database connection and test your settings outside of the Java application that actually loads Jira.

I searched on this error some more and came across this page: https://developer.atlassian.com/server/framework/atlassian-sdk/product-fails-to-start-within-timeout-period/

It would seem that there can be lots of general problems that could cause this error. But that antivirus scanning tends to be the most likely cause. Perhaps you can try to disable the antivirus temporarily to see if you can complete this build that way.

KL Kumar

@Andy Heinzer thanks for the information. I am not using a jira server install. I am trying to develop a jira plugin and followed atlas commands to create it and hence it created a tomcat in my target directory. All the changes related to DB (updating dbconfig.xml) was done in the target directory only.

KL Kumar

Thanks!

Kumar

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-administration

jira-server

jira-software-server

atlassian-sdk

database

install

postgres