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; } } }

Could not determine database type

Mark V.

Can you help me connect the DB? It seems the new install wizard blocks me from moving to MS SQL Server.

I have Jira 6.1 on WinSvr 2008 and am switching DB from HSSQL to a named instance of MS SQL 2008 with NTLM Authentication.

The behavior is

1) that if there's not username & pswd in dbconfig.xml, the initial setup wizard runs in the browser.

2) If the username is added, then the error occurs: HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)

3) The new MS SQL DB instance was setup, and the connection URL was tested with SQuirreL and the ntlmauth.dll file added to the default path.

jdbc:jtds:sqlserver://ab-sqlp01:1433/Jiradb;instance=APPS

It successfully opens the DB if submitted without the username and password when run from the same administrative service account that Jira runs under.

JDBC Driver CLASSNAME net.sourceforge.jtds.jdbc.Driver
JDBC Driver CLASSPATH C:\Program Files\squirrel-sql-3.5.0\jtds-1.2.4.jar
getURL jdbc:jtds:sqlserver://ab-sqlp01:1433/Jiradb;instance=APPS
isReadOnly false
getUserName domain\service name
supportsSchemasInDataManipulation true
getDriverName jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
getCatalogSeparator .
storesMixedCaseIdentifiers true
storesUpperCaseIdentifiers false
supportsCatalogsInTableDefinitions true
supportsSchemasInTableDefinitions true
getDatabaseProductName Microsoft SQL Server
getDatabaseProductVersion 10.50.2550

~~~~~~~~~~~~~~~

The dbconfig.xml is:

<?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>jiraschema</schema-name>
<jdbc-datasource>
<url>jdbc:jtds:sqlserver://ab-sqlp01:1433/Jiradb;instance=APPS</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username> <domain>\<username> </username>
<password></password>
<pool-min-size>15</pool-min-size>
<pool-max-size>15</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>15</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>

~~~~~~~~~~~~~~~

Thejiradb.properites file is still for HSSQL:

#HSQL Database Engine
#Thu Dec 19 13:49:59 PST 2013
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=false

...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error from browser with only username in dbconfig.xml file:

HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user 'ABNOLOGY\SVC_Jira'.)

type Exception report

message org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)

description The server encountered an internal error (org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)) that prevented it from fulfilling this request.

exception

com.atlassian.util.concurrent.LazyReference$InitializationException: org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)
	com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
	com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
	com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
	com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
	com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:50)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:113)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:135)
	com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59)
	com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39)
	com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49)
	com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:78)
	com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
	com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)

root cause

org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)
	org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409)
	org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962)
	org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
	org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
	com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
	com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
	com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
	com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
	com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
	com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
	com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
	com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
	com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
	com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
	com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
	com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
	com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
	com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
	com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
	com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
	com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
	com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
	com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
	com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
	com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
	com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	java.lang.reflect.Constructor.newInstance(Unknown Source)
	java.lang.Class.newInstance(Unknown Source)
	org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	java.util.concurrent.FutureTask.run(Unknown Source)
	java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	java.lang.Thread.run(Unknown Source)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error when restarted with password included in dbconfig.xml:

HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)

type Exception report

message org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.)

exception

com.atlassian.util.concurrent.LazyReference$InitializationException: org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.) com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149) com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112) com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87) com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27) com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:50) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:113) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:135) com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59) com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:78) com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87) com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)

root cause

org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Login failed for user '<domain>\<username>'.) org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409) org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962) org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630) org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766) com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82) com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318) com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785) com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846) com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770) com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58) com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31) com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34) com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26) com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22) com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140) com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321) com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143) com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112) com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87) com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27) com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268) com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60) com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68) com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99) com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40) com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) java.lang.reflect.Constructor.newInstance(Unknown Source) java.lang.Class.newInstance(Unknown Source) org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

When run without username and pswd in dbconfig.xml file, no error occurs. Just forced into setup wizard which will not accept instance name in entry fields and therefore never passes the setup wizard:

http://localhost:8080/secure/SetupDatabase!default.jspa

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The same occurs if the username & pswd tags are removed from the dbconfig.xml too.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Here's the log from the last runs switching for username only, username & pswd, and no username nor password.

Accepted answers

Mark V.

Thank you for the update.

My database expert was able to find the user comment/solution you listed (https://confluence.atlassian.com/display/JIRA/JIRA+and+MS+SQL+Server+2008?focusedCommentId=264045977#comment-264045977). We did have to go through the process of creating a temporary login account in SQL Server in order to bypass the setup wizard and then update the configuration to use the NTLM authentication once we moved the login domain to the URL manually.

Though it's not your fault it works this way, this is an incredibly poor integration with one of Jira's 'production supported DBs'. Both on the technical level and on the documentation level. The NTLM authentication is a security industry best practice and should be addressed in the standard Jira installation documentation.

Do you know if there's a bug/feature request entered for this that I can 'vote' for, etc.

Thanks,

Mark

All comments

Teck-En

Caused by: java.sql.SQLException: Login failed for user 'ABNOLOGY\SVC_Jira'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:357)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

The user unable to login due to the following:

Caused by: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerWithRepository(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source)

Did your username password contained some special characters? If so you might hit into the bug addressed in this KB article: https://confluence.atlassian.com/display/JIRAKB/JIRA+Does+Not+Start+due+to+InstanceAlreadyExistsException

Try use a password without special character and see how it goes?

Mark V.

Thanks for your response, though the password only has letters and numbers mixed case.

I also checked the mutiple usertransaction defines and there's no conf/Catalina/localhost/jira.xml file to duplicate.

In server.xml, it contains:

-<Engine name="Catalina" defaultHost="localhost">-<Host name="localhost" unpackWARs="true" autoDeploy="true" appBase="webapps">-<Context useHttpOnly="true" reloadable="false" path="" docBase="${catalina.home}/atlassian-jira">

<Resource name="UserTransaction" type="javax.transaction.UserTransaction" jotm.timeout="60" factory="org.objectweb.jotm.UserTransactionFactory" auth="Container"/><Manager pathname=""/></Context></Host>

Any other thoughts?

Teck-En

since you using NTLM authentication, try the suggestion to add the domain to the jdbc URL and use the username(without the domain) as suggested by the user comment over here: https://confluence.atlassian.com/display/JIRA/JIRA+and+MS+SQL+Server+2008?focusedCommentId=264045977#comment-264045977

Mark V.

Thank you for the update.

Do you know if there's a bug/feature request entered for this that I can 'vote' for, etc.

Thanks,

Mark

Teck-En

awesome.

I think here's the improvement of the NTLM authentication: https://jira.atlassian.com/browse/JRA-2398

Datepalm

I had the same error screen, but it turned out that postgresql was not starting.

Luckily postgres gave me the information I needed to know when I ran the "sudo service postgresql start" command in ubuntu.

In my case the failure was because of permissions on the postgresql install directory having been changed. Once I ran "chmod 700 the/address/of/postgres -R" and ran "sudo service postgresql start", "sudo service JIRA stop", and "sudo service JIRA stop" everything eventually came back online.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration

ms-sql

administration

database-connection