Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can not connect to the mysql: serverAccess denied for user 'jirauser'@'localhost'

JConstantine September 5, 2019

I have jira 6.4.9 and after update to 7.2.0 I can not connect to the mysql server

2019-09-05 18:34:59,475 http-nio-8080-exec-1 ERROR [NoModule] Could not determine database type.
java.sql.SQLException: Access denied for user 'jirauser'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87)
at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:164)
at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
at org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:903)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:881)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:850)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
at com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:566)
at com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getType(BootstrapOfBizPropertyEntryStore.java:67)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139)
at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:157)
at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:85)
... 22 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.forward.request_uri'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.forward.context_path'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.forward.servlet_path'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.error.status_code'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'jira.request.start.millis'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.error.servlet_name'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.error.message'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'jira.webwork.cleanup'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'com.atlassian.gzipfilter.GzipFilter_already_filtered'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'com.atlassian.jira.web.filters.JiraFirstFilter_alreadyfiltered'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.error.request_uri'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'jira.request.id'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'javax.servlet.error.exception'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'com.atlassian.jira.web.filters.JiraPostEncodingFilter_alreadyfiltered'
2019-09-05 18:34:59,709 http-nio-8080-exec-1 WARN - [c.a.jira.i18n.BootstrapTranslationStore] No bootstrap translation available for 'com.atlassian.jira.web.filters.accesslog.AccessLogRequestInfoexit.called'
2019-09-05 18:41:53,286 localhost-startStop-2 INFO [c.a.jira.startup.DefaultJiraLauncher] Stopping launchers
2019-09-05 18:41:53,296 localhost-startStop-2 ERROR [o.a.c.c.C.[Catalina].[localhost].[/]] Exception sending context destroyed event to listener instance of class com.atlassian.jira.startup.LauncherContextListener
java.lang.NullPointerException
at com.atlassian.jira.startup.ClusteringLauncher.stop(ClusteringLauncher.java:25)
at com.atlassian.jira.startup.DefaultJiraLauncher.stop(DefaultJiraLauncher.java:203)
at com.atlassian.jira.startup.LauncherContextListener.contextDestroyed(LauncherContextListener.java:195)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4858)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5474)
... 3 filtered
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

1 answer

0 votes
Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2019

@JConstantine 

Hi Lena

can you check the stored settings in the dbconfig.xml file. I assume that the mysql server is running on the same machine jira runs at - correct

(especially if you are able to login with the stored credentials 'jirauser'@'localhost + password)

Cheers

Kurt

JConstantine September 5, 2019

I check settings in the dbconfig.xml file. It`s ok. MySQL server is running on the same machine

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 12, 2019

@JConstantine 

Did you try to login as jirauser on that machine with the specified password?

 

Cheers

Kurt

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events