JIRA and MYSQL

Added by Rosie Jameson, last edited by Michelle de Guzman on Jan 11, 2007 (view change)

JIRA Documentation

This page has general notes on connecting JIRA to MYSQL. It supplements the official MYSQL installation documentation.

Add your notes

Labels:

Children (5)

Hide Children | View in Hierarchy

Configuring MySQL 4.1 to store non-ASCII characters

Data Access Exception - Errcode - 17

JIRA can't connect to MYSQL with Named Pipes enabled

MYSQL Administrator and Data Truncation Errors

Setting up JIRA Standalone and MySQL on Linux

Comments (1)

Hide Comments Show Comments
Collapse All Collapsing… Expanding… Expand All

Mar 03, 2007

Doods Perea says:
Greetings\! I was trying to get the user details of my our JIRA users from the M...
Greetings!

I was trying to get the user details of my our JIRA users from the MySQL database. Reading your documentation I found that the user-related table schemas in MySQL is different from those in HSQLDB. One example is the 'propertysets' table, it does not exist in MySQL. While in MySQL there is 'userbase' (id, username, password_hash fields) and 'propertystring' (id, propertyvalue fields) I don't know how the username is linked/related to the 'propertystring' table.

Am i missing something here?

Thanks
- Permalink