Upgrading from 7.13.5 to 8.5 with a postgres database but not finding a dbconfig.xml file...

[Eric Sebian]

Good morning.

I'm using the postgres database for my jira instance and I am trying to do a new install (from 7.13 to 8.5) but the application that I downloaded is missing a dbconfig.xml file. Is that something I should just move over from the existing production instance? Below is a copy of the file.

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>

  <name>defaultDS</name>

  <delegator-name>default</delegator-name>

  <database-type>postgres72</database-type>

  <schema-name>public</schema-name>

  <jdbc-datasource>

    <url>jdbc:postgresql://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</url>

    <driver-class>org.postgresql.Driver</driver-class>

    <username>xxxxxxx</username>

    <password>xxxxxx</password>

    <pool-min-size>20</pool-min-size>

    <pool-max-size>20</pool-max-size>

    <pool-max-wait>30000</pool-max-wait>

    <validation-query>select 1</validation-query>

    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>

    <time-between-eviction-runs-millis>300000</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>

    <pool-test-on-borrow>false</pool-test-on-borrow>

    <pool-test-while-idle>true</pool-test-while-idle>

  </jdbc-datasource>

</jira-database-config>

Please advise.

[Nic Brough -Adaptavist- · Accepted solution]

The dbconfig file is created when you run through the installer and answer the questions about hooking it up to a database.

Do NOT just copy it from an existing installation, that file is only suitable for that installation.

[Eric Sebian]

Ok. But the documentation states that I should follow the manual process for linux installs (untar files, etc...). So is that how the data directory is created (because I currently don't have one)? Should I start the install over using the installer now? Please advise. thanks. 

[Eric Sebian]

this is the link that I'm using: https://confluence.atlassian.com/adminjiraserver/installing-jira-applications-on-linux-938846841.html

[Eric Sebian]

I chose the manual process but I guess that should start over? 

[Nic Brough -Adaptavist-]

I'd assumed you were using the installer not the archive.  But although these start the process differently, they do converge.

For new installations, the installer unpacks and deploys a confluence installation and runs it.

The archive file upacks to an almost-runable confluence installation, you edit a file to tell it where the home directory is, and then run it.  You'll need to have created the home directory for it as well.

At this point for both types of install, you have an empty, unconfigured Confluence running.  When you visit it, it runs through some config questions, one of which is "database parameters".  After it confirms there's a valid database it can use in there, it creates the dbconfig file for you, amongst other things.

[Andrew Laden]

So the question is are you trying install a new instance, or upgrade an existing one?

If you are trying to upgrade, and you use the installer, it will walk you through the process, archiving the old installation, and copying over any files needed as part of the upgrade.

If you are trying to use the archive/tarball, then you will need to copy those files over yourself. 

I'd recommend using the installer. its pretty good about telling you what files you need to look out for. (ie, if there were any files changed in you current installation that you need to look at and copy over manually.)