Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error connecting to database

Ajay Dham September 18, 2018

I am trying to install JIRA for the first time and am unable to connect to the database.  I keep getting the error message ' Error connecting to database.  No suitable driver found for jdbc:postgresql://http://xx:5432/jiradb'  

I am not a professional user when it comes to Linux.  I would really need step by step directions to resolve the issue here.  

I am running Cent OS 7 and as a database I opted to use Postgresql.  From my understanding and following the instructions, I thought the JDBC drivers for Postgres would be part of the install, but that doesn't seem like to be the case.

I went over to Jira website and downloaded the 'postgresql-9.4-1202.jdbc41.jar' JDBC driver, but I'm not 'exactly' which directory to upload it into.  I have created the users and db as indicated in the docs, but still no luck here.  What do i need to do to get to the next steps here.   Here are some images, not sure if they help, but here they are:

Image 10.pngImage 11.pngImage 12.pngImage 13.png

 

Image 14.png

 

Any help here would be appreciated.  

 

1 answer

2 votes
Christos Moysiadis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 18, 2018

@Ajay Dham Although i'm using MySql Db i think the place for the driver is the same ....

"C:\Atlassian\JIRA\lib" <--- This is my path where i have my "mysql-connector-java-5.1.46-bin.jar ".... 

Find where is this folder in your system and copy it inside the lib folder... 

 

Give it a shot and I hope i'm not answering wrong!

Best,

Ajay Dham September 19, 2018

I'm on linux cent os, not windows.  Thanks for your help, i'll try to find this path on the linux side.

Keri
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 20, 2018

The default path for Linux installations is /opt/atlassian/jira/ so the drivers would be under /opt/atlassian/jira/lib

Christos Moysiadis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2018

Thank you @Keri !

It is good to know although i use Windows, in case i have to use Linux sometime ;).

 

Kind Regards

Christos

Suggest an answer

Log in or Sign up to answer