JIRA and Sybase

Added by Michelle de Guzman, last edited by Rosie Jameson on Nov 14, 2006  (view change)
JIRA Documentation

Index

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

Add your notes

Labels

 

Comments (1)

 

  1. Nov 09, 2007

    Sander Stokman says:

    Sybase, and several other databases like Oracle and UDB/DB2, support using Kerbe...

    Sybase, and several other databases like Oracle and UDB/DB2, support using Kerberos to authenticate the connection to the database. This avoids having to hardcode the password in the server.xml file, which is a Security concern and is also a hassle to update when the database password is changed.

    These steps explain how to configure jira to connect to a Sybase database using Kerberos authentication.

    • Configure Tomcat and Sybase to run with Kerberos. (Our Tomcat and Sybase instances are configured with Kerberos by default, so I cannot provide details on this.)
    • Ask your DBA for the principal name of your database server.
    • Modify the server.xml file. Remove the username and password from the datasource specification, and add a connectionProperties entry as shown below. Replace with the principal name from the previous step.

    (Tried three times to include example XML code, but after saving and re-editing the code it gets messed up every time, even when marked as code.)

    • Create a jaas.conf file.

    (I would include an example, but again sample code gets messed up during re-edit.)

    • Set the java.security.auth.login.config property to the location of the jaas.conf file.
    • Restart the container.