host JIRA on my ubuntuserver with mariaDB

[Yunfei Ma]

I have got my ubuntu server setup, and wish to have it run as our JIRA server, but as my server only installed with MariaDB, I am stuck here now... 

I want run JIRA on my server which is running with MariaDB, I am completely fine to connect JIRA with whatever database, I don't insist MariaDB at all. Here is possible solutions I accept:

1. Run MySQL together with MariaDB, connect JIRA with MySQL

2. Run JIRA with MariaDB, now it seems impossible

[Nic Brough -Adaptavist-]

You don't really tell us where you are stuck - what is wrong with the install?

I would take one guess though.  MariaDB is not a supported database for Atlassian stuff (yet).  So whatever the problem you are seeing is, the very first suggestion we have to make is "use a supported database".

Now, a couple of weeks ago, I upgraded a massive system that had used MariaDB in test.  The test systems worked fine with it, and yours may well too.  But we moved back to MySQL because Maria is not supported.  I very strongly recommend that you go to a supported database first.  Whilst we can try to help you on Maria, we can't tell you it is supported or fix everything you may run into.

[Yunfei Ma]

Thanks Nic,

I am trying to install JIRA runs on MariaDB ubuntu server, not sure if your "upgrading" case is the same. 

I am fine to use mysql, or any other supported database, I dont know how to do it, and the side impact to the system:

Does MySQL requires uninstall MairaDB? I am afraid I can't uninstall it, or if it is possible to run both MySQL and MariaDB? 

I searched google and see a lot of articals but I don't see a clear guidance on how to run JIRA on an MariaDB existing ubuntu server.

Regards,

Yunfei

[Nic Brough -Adaptavist-]

I don't know if it is possible to run both on the same machine.  If it is not, then you are a bit stuck, as you'll need to be running MySQL to get Jira to work.

You should not try to run Jira on MariaDB - it's not supported and that's why you're not finding docs on doing it.

[Yunfei Ma]

Yes, and thanks for you understand why I am stuck...

It is strange I don't see clear guidance on my case, it should be very common, as MariaDB is default configuration in ubuntu release.

[Nic Brough -Adaptavist-]

You are right, it is not uncommon, when we take an off-the-shelf Ubuntu. Ubuntu is very generalised, it aims (and, in my opinion, succeeds) to be a good platform for most stuff, and it is heavily aimed at the desktop user.  Atlassian however trips out of the comfort zone for it and is expected to be installed more on server systems, not desktops.  They've simply not got around to making it work with other database systems.

[Yunfei Ma]

Do you mean I am running ubuntu-desktop rather than ubuntu-server?  I think I am running ubuntu-server, not desktop.  But it was installed by someone else, ... so maybe I am wrong, not sure how to check it.

[Nic Brough -Adaptavist-]

No, the sub-type of Ubuntu you are running is not the problem.  You'll need to get a supported database installed, I can't really help you with that.