It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

@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

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

@Lena Kulkova 

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
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

273 views 1 2
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you