Getting JIRA — Internal Server Error when I reopen Jira VM

Hello!

 

I installed a Jira instance in Redhat/Centos7 server version within VM. Everything is okay, I can access to the web application and configure my projects... I closed the VM and I reopen it,  sadly, I got this error JIRA — Internal Server Error ! Unable to render full error details at this time. Please consult the error logs for more information.

I don't know to fix this error. I will appreciate any help.

Best regards.

2 answers

What does the log say?

 

-Lars

You mean access_log files ?

In logs directory, I have 11 files ! Which one ? 

access_log.2017-08-24 catalina.out localhost.2017-08-25.log
access_log.2017-08-25 host-manager.2017-08-24.log manager.2017-08-24.log
catalina.2017-08-24.log host-manager.2017-08-25.log manager.2017-08-25.log
catalina.2017-08-25.log localhost.2017-08-24.log

catalina.out and atlassian-jira.log


atlassian-jira-software-7.4.3-standalone/logs/catalina.out 
jira_home_7.4.2/log/atlassian-jira.log

calalina.out :

24-Aug-2017 04:02:03.977 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.6
24-Aug-2017 04:02:03.988 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Oct 6 2016 20:15:31 UTC
24-Aug-2017 04:02:03.988 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.6.0
24-Aug-2017 04:02:03.988 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
24-Aug-2017 04:02:03.988 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 3.10.0-514.2.2.el7.x86_64
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /opt/atlassian/jira/jre
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_102-b14
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/atlassian/jira
24-Aug-2017 04:02:03.989 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/atlassian/jira
24-Aug-2017 04:02:03.990 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/atlassian/jira/conf/logging.properties
24-Aug-2017 04:02:03.990 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
24-Aug-2017 04:02:03.990 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms384m
24-Aug-2017 04:02:03.990 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx768m
24-Aug-2017 04:02:03.990 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Datlassian.standalone=JIRA
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dmail.mime.decodeparameters=true
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+PrintGCDateStamps
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:-OmitStackTraceInFastThrow
24-Aug-2017 04:02:03.991 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Datlassian.plugins.startup.options=
24-Aug-2017 04:02:03.992 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
24-Aug-2017 04:02:03.992 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
24-Aug-2017 04:02:03.992 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/atlassian/jira
24-Aug-2017 04:02:03.992 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/atlassian/jira
24-Aug-2017 04:02:03.992 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/atlassian/jira/temp
24-Aug-2017 04:02:04.043 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
24-Aug-2017 04:02:04.567 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
24-Aug-2017 04:02:04.596 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 2400 ms
24-Aug-2017 04:02:04.631 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
24-Aug-2017 04:02:04.631 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.6
24-Aug-2017 04:02:04.671 SEVERE [Catalina-startStop-1] org.apache.catalina.startup.HostConfig.beforeStart Unable to create directory for deployment: /opt/atlassian/jira/conf/Catalina/localhost
log4j:WARN Failed to set property [dataProvider] to value "com.atlassian.jira.logging.log4j.layout.json.JiraJsonDataProvider".
2017-08-24 04:02:30,923 localhost-startStop-1 INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory '/var/atlassian/application-data/jira' is validated and locked for exclusive use by this instance.
2017-08-24 04:02:31,473 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

2017-08-25 03:46:42,530 http-nio-8080-exec-14 ERROR [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://10.10.10.17:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='root', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=false, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedOnBorrow=true, removeAbandonedOnMaintanance=null, removeAbandonedTimeout=300, validationQueryTimeout=3, defaultCatalog=null}}
java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'10.10.10.17' (using password: YES))
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2291)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)
at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)
at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:103)
at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
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)
Caused by: java.sql.SQLException: Access denied for user 'root'@'10.10.10.17' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
... 2 filtered

There's the error - it cannot connect to your database.

Generally, you wouldn't connect "root", it's better to use a dedicated database user (so a database called "jira" with access via a user called "jira" for example)

Could I change it now ?

Stop JIRA before changing mysql connection credentials.

How can I do that ? Please send to me a link I will appreciate that ! :)

(Access denied for user 'root'@'10.10.10.17' (using password: YES)) look like a probable cause.

 

-Lars

You can test it manually:

mysql -u someuser -H 10.10.10.17 -p

Also, check that mysql is actually running.

mysql -u someuser -H 10.10.10.17 -p - > ERROR 1049 (42000): Unknown database '10.10.10.17'

Maybe you mean mysql -u someuser -h 10.10.10.17 -p with small "h"

Dispaly: ERROR 1045 (28000): Access denied for user 'root'@'10.10.10.17' (using password: YES)

What I have to do ?

Yes, you should use -h not -H. Bad bad memory!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,852 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot