Getting JIRA — Internal Server Error when I reopen Jira VM

[akrem_sellami]

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.

[Lars Olav Velle]

What does the log say?

-Lars

[akrem_sellami]

You mean access_log files ?

[akrem_sellami]

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

[Lars Olav Velle]

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

[akrem_sellami]

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]

[akrem_sellami]

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

[Nic Brough -Adaptavist-]

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)

[akrem_sellami]

Could I change it now ?

[Lars Olav Velle]

Stop JIRA before changing mysql connection credentials.

[akrem_sellami]

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

[Lars Olav Velle]

http://lmgtfy.com/?q=change+jira+database+settings

[Lars Olav Velle]

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

-Lars

[Lars Olav Velle]

You can test it manually:

mysql -u someuser -H 10.10.10.17 -p

Also, check that mysql is actually running.

[akrem_sellami]

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 ?

[Lars Olav Velle]

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

[akrem_sellami]

Yeah yeah :D