centos 6.7 which database to set up?

[mn]

hi,

I just purchased the license and  installed today jira 8.13

I have the setup running on the H2 DB now.

I need to configure and connect to the external DB - Postgress or MySQL - both would be OK.

On CentOS 6.7 postgresssql is at version 8.4 - you do not support that.

I Installed MySQL and the ODBC java driver in lib directory. The config.sh tool says it has problem with the driver.

I have spent 2h searing net and fighting to connect to the DBs.

Which DB should I use?

regards

mn

[Nic Brough -Adaptavist- · Accepted solution]

If you want this to run on either of those database types, you'll need to upgrade (or parallel install) a supported version of them on your CentOS machine.

See https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html for which versions work for Jira.

For CentOS though, 6 is old.  Obviously the right package for Postgres is not in the CentOS 6 repositories.  I don't know about MySQL either, but I'm not sure why you're installing an ODBC driver when you need the MySQL JDBC driver.

[mn]

Thanks!

sorry, my typo I meant JDBC.  ;-)

MySQL seemed to have the right version buthe connector does not work.

I see... centos 6 is too old.

I am in a supporting some app with centos6 and for now I cannot upgrade that machine.

Maybe I will configure jira to run in VirtualBox then...

thanks!

mn

[Nic Brough -Adaptavist-]

Ah, ok.

Well yes, you will need to be running a supported database.  You can often install later ones on Linux boxes - just because they're not in the repositories for an old version does not mean they do not work on it.

Before looking at virtual machines, I'd take a look at the install docs for Postgres and MySQL and check if they could be installed on CentOS 6. 

However, well before that, I'd strongly recommend looking to upgrade CentOS - you've only got 6ish weeks before that goes "end of life"