Database monitoring Connection Pool graph no values

[Holger Niehaus]

Our connection pool graph does not show any values.

The resource is configured via server.xml

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
username=""
password=""
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/jira"
maxTotal="20"
maxIdle="20"
validationQuery="select 1"
removeAbandoned="true"
removeAbandonedTimeout="300" />

We are running Jira Server (NOT cloud) 8.13.1.

Read / Write shows data

What can we do to see the correct data in graph?

[Andy Heinzer · Accepted solution]

Hi Holger,

I see that you are looking to see database connections within Jira, but none of these appear to show on that graph.  It appears that your configuration though is unusual.  What I mean by that is we are not expecting that Jira will define the database connection in the server.xml file anymore.

It is true that very old versions of Jira, such as Jira 4 and earlier if memory serves, would use the server.xml file to define the database connection, such as using a JNDI.  However Jira deprecated this method of connecting to a database way back in Jira 5.  Since that time the database connection is expected to be defined in the $JIRAHOME/dbconfig.xml and in a different format than the JNDI one we see here.

The use of a JNDI connector for connecting to Jira's database is not supported by Atlassian and in turn we instead recommend using the dbconfig.xml to define these settings.  If you're not sure about how to do that, I would recommend trying to follow the appropriate guide over in Connecting Jira applications to a database as this page links to the various supported databases for Jira 8.13.x, and provides you steps to follow to configure Jira to work with them.

Try configuring Jira in this manner, and then see if this graph populates data in the way we expect it to.

Cheers,

Andy

[Holger Niehaus]

Hi Andy,

thanks for your answer.

We are using JavaMelody Plugin for monitoring our JIRA instance. To get information abount database in Melody you have to configure it this way :-(

For now its good to know that this configuration is deprecated

By

Holger