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

[Lena Kulkova]

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)

[Kurt Klinner]

@Lena Kulkova 

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

[Lena Kulkova]

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

[Kurt Klinner]

@Lena Kulkova 

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

Cheers

Kurt