upgrading from 4.0.1 to 4.4 can't get connection to work.
I have two JIRA services running as ants\svc_cc_jira_dev
Version 4.0.1 uses standard tomcat configs to set up a connection and it works
<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver" domain="ants"
url="jdbc:jtds:sqlserver://gblondb018:1513/ccjiradb;tds=8.0;lastupdatecount=true;integratedSecurity=true" />
Version 4.4 uses its own config and I get the error
“The login is from an untrusted domain and cannot be used with Windows authentication.”
<jira-database-config>
<name>JiraDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>ccjiradb</schema-name>
<jdbc-datasource>
<url>jdbc:jtds:sqlserver://gblondb018:1513/ccjiradb;tds=8.0;lastupdatecount=true;integratedSecurity=true;domain=ants</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username>blah</username>
<password></password>
<pool-size>15</pool-size>
</jdbc-datasource>
</jira-database-config>
I got integrated security working with JIRA v5.17 with a domain user.
I had to switch to MS JDBC:
<jira-database-config> <name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>mssql</database-type> <schema-name>jira</schema-name> <jdbc-datasource> <url>jdbc:sqlserver://server:1439;databaseName=APP_JIRA;integratedSecurity=true;domain=MYDOMAIN;</url> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> <username>MYDOMAIN\user</username> <password>P@$$w0rD</password> <pool-size>15</pool-size> <validation-query>select 1</validation-query> </jdbc-datasource> </jira-database-config>
The extra paths I copied the jars/dlls to may be redundant, as too with the user/pass in the XML.
This looks promising
https://confluence.atlassian.com/pages/viewpage.action?pageId=262471708
it seems to have connected according to the logs
:-)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.