JIRA not able to conenct to database

Hi Team,

 

We have changed password of JIRA database recently , once i try to login through URL, its showing below issue:

Please suggest

HTTP Status 500 - Could not determine database type. (ORA-01017: invalid username/password; logon denied


type Exception report

message Could not determine database type. (ORA-01017: invalid username/password; logon denied

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (ORA-01017: invalid username/password; logon denied
)
	org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409)
	org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831)
	org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730)
	org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879)
	org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:848)
	com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
	com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
	com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:744)
	com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getEntry(BootstrapOfBizPropertyEntryStore.java:62)
	com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:202)
	com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305)
	com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:272)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:57)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:138)
	com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:162)
	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:79)
	com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:41)
	com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
	com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:61)
	com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:121)
	com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92)
	com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:56)

 

root cause




3 answers

This widget could not be displayed.

Hi Nidhi,

 

here you have instruction:

https://confluence.atlassian.com/jira/connecting-jira-to-a-database-185729615.html

remember to put db driver to your JIRA installation

This widget could not be displayed.

The log says that the login fails, so you should verify if you're using the correct password in your dbconfig.xml

Chris Fuller Atlassian Team Apr 07, 2016

This.

You know the password was changed.  You know the error message says the login in failing.  You just need to update the password in JIRA's configuration so that it will use the new password.

This widget could not be displayed.

Hi Nidhi,

      Check the status of your database server to ensure it is running.

    • Check if the database related Service is started and running.
  • If your database server is running, check your network configuration to ensure that it is accessible by JIRA 

    • Use ping from the JIRA server to the database server

    • Use telnet from the JIRA server to the database server for testing port connectivity

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

143 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you