nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Java Melody Data base monitoring help

Fabio Manzoni

Hi Guys,

I'm traying to configure Java Melody dabatase monitoring without sucesss. I followed the instructions of Java melody wiki https://github.com/javamelody/javamelody/wiki/AtlassianPlugin.

Also I found this question https://community.atlassian.com/t5/Jira-questions/How-to-configure-Java-Melody-in-JIRA-5-or-6-so-it-does-monitor/qaq-p/7319 without success again.

Can someone help me?

This is a Jira 7.1 and MySQL, its a test envinronment.

server.xml

</Host>

dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql</database-type>

<jdbc-datasource>
<url>jdbc:mysql://localhost:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>xxxx</username>
<password>xxxx</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
<validation-query-timeout>3</validation-query-timeout>
<schema-name>public</schema-name>

<jndi-datasource>
<jndi-datasource><jndi-name>java:comp/env/jdbc/jiradb</jndi-name></jndi-datasource>
</jndi-datasource>

</jdbc-datasource>
</jira-database-config>

Accepted answers

Fabio Manzoni

Hi everyone,

For configure your Java Melody database monitoring in a SQL Server, take a look on this example.

Dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>Jira_Schema</schema-name>

<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>

<jndi-datasource><jndi-name>java:comp/env/jdbc/JiraDS</jndi-name></jndi-datasource>

</jira-database-config>

server.xml

All comments

Shannon S

Fabio,

Can you tell us exactly what is not working and error messages that you see?

Regards,

Shannon

Fabio Manzoni

Hi Shannon,

Thank you for your attention. It's a test environment and I solved the problem in MySQL database with this information below. But now I try to use the same configuration to Microsoft SQL, but doesn't work. This configurarion enable the data base monitoring on Java Melody. And I will apply this in our costumer.

This Work in MY SQL

Server.xml

dbconfig.xml

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql</database-type>

<url>jdbc:mysql://localhost:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>xxxxx</username>
<password>xxxxxx</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
<validation-query-timeout>3</validation-query-timeout>

<jndi-datasource><jndi-name>java:comp/env/jdbc/JiraDS</jndi-name></jndi-datasource>

</jira-database-config>

This Doesn't work on Microsoft SQL

Server.xml

dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>Jira_Schema</schema-name>

<url>jdbc:sqlserver://localhost:1433;databaseName=jiradb</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<username>xxxxxx</username>
<password>xxxxxx</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>

<jndi-datasource><jndi-name>java:comp/env/jdbc/JiraDS</jndi-name></jndi-datasource>

</jira-database-config>

Best Regards,

Fabio

Fabio Manzoni

This is the message error.

If I remove the java melody information, this instance works very well.

mensagem de erro sql.PNG

Microsoft SQL - Doesn't Work

SQL monitoring Microsoft SQL.PNG

My SQL - Working.

SQL monitoring MY SQL.PNG

Fabio Manzoni

It Works...

I did a mistake and put the mssql-jdbc-6.4.0.jre8 file on Jira. It's wrong!

The dbconfig.xml is correctly and the server.xml I did some adjust, see below.

I hope this information can now help other people...

server.xml
<Context path="" docBase="${catalina.home}/atlassian-jira" reloadable="false" useHttpOnly="true">

Microsoft SQL monitoring working.PNG

Fabio Manzoni

Hi everyone,

For configure your Java Melody database monitoring in a SQL Server, take a look on this example.

Dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>Jira_Schema</schema-name>

<jndi-datasource><jndi-name>java:comp/env/jdbc/JiraDS</jndi-name></jndi-datasource>

</jira-database-config>

server.xml

Sylvain Leduc

Hello @Fabio Manzoni

So you need to keep both <jdbc-datasource> and <jndi-datasource> in the dbconfig.xml + add the resource in server.xml ?

https://github.com/javamelody/javamelody/wiki/AtlassianPlugin says to replace it : "To configure JIRA with a datasource, replace in the jira-home/dbconfig.xml file "<jdbc-datasource>...</jdbc-datasource>" with "<jndi-datasource>"

Thanks.

Sylvain

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

database

ms-sql

jdbc

monitor

javamelody

jndi