unable to connect to database

Question

Hello Support,

While opening the Jira URL I am getting the below error:

Database: JIRA couldn't connect to your database

JIRA failed to establish a connection to your database.
This could be because:

* Your database isn't running
* The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
* There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

Please help to resolve the issue.

Thanks,

Shyam Surapaneni.

Nic Brough -Adaptavist- · Answer

If you've not changed your server.xml AND you had Jira running before, then it's the database or the connection.

We can't tell you much about how to check that, it's your system and we don't know what it is.

The easiest diagnostic would be to log into your Jira server and see what errors you get back from trying a command-line connection to it.  But without knowing your network, database, operating system or security settings, we cannot tell you more.

If you are not the server admin on your systems, you'll need to find and talk to one of them

Shyam_Surapaneni · Answer

Hello Tansu,
Thanks for your support,

Everything was working fine couple of days back, suddenly the issue is came up.
You don't have a database running - How to check database is running or not
The configuration in your dbconfig.xml is incorrect -  I didn't change any thing in the configuration
Username/Password for your database are incorrect - I didn't change any thing in the configuration
Your database user doesn't have the correct permissions to connect to the database - I didn't change any thing
You're trying to use an incorrect port - I didn't make any changes on the server.
General network issues that prevent JIRA from connecting to your database - I turnoff my windows firewall also.

Please look into the issue.

Thanks,
Shyam Surapaneni.

Tansu Akdeniz · Answer

Hi @Shyam_Surapaneni ,

So, did you check all items which you listed?

* You don't have a database running
* The configuration in your dbconfig.xml is incorrect
* Username/Password for your database are incorrect
* Your database user doesn't have the correct permissions to connect to the database
* The database specified is not the JIRA database
* You're trying to use an incorrect port
* General network issues that prevent JIRA from connecting to your database.

Please check this link.

Regards