I have installed confluence and when tried to browse or curl from the server it gives no output

[Munish Saini]

I have installed Confluence trial version and it has started successfully. But when I try to load it via web page it keeps on trying to load and after few mins gives Took too long error. I tried to curl from the server itself and there is no output and the command just hangs there. The server it is deployed on is Centos 7 and attached are logs below.

# curl localhost:8090

^C

# curl 127.0.0.1:8090

^C

# systemctl status confluence

● confluence.service - LSB: Atlassian Confluence

   Loaded: loaded (/etc/rc.d/init.d/confluence; bad; vendor preset: disabled)

   Active: active (running) since Thu 2020-08-06 02:45:41 EDT; 8min ago

     Docs: man:systemd-sysv-generator(8)

  Process: 2913 ExecStop=/etc/rc.d/init.d/confluence stop (code=exited, status=0/SUCCESS)

  Process: 2991 ExecStart=/etc/rc.d/init.d/confluence start (code=exited, status=0/SUCCESS)

   CGroup: /system.slice/confluence.service

           └─3044 /opt/atlassian/confluence/jre//bin/java -Djava.util.logging.config.file=/opt/atlassian/confluence/conf/logging.properties -Djava.util...

[Moses Thomas]

@Munish Saini  There could be several reasons,  could  you please provide logs info in the <jira_home_dir>/log   we could get some information there.

[Munish Saini]

I don't think have that installed. Also tried finding jira-application.properties file however no results.

[Moses Thomas]

@Munish Saini  All installation must have a home directory. look for the file /<jira_home_dir>/log/atlassian-confluence.log

[Munish Saini]

This is all I see in that folder

# pwd
/var/atlassian/application-data/confluence/logs
# ls -lrt
total 27240
-rw-r-----. 1 confluence confluence 0 Jul 8 03:08 atlassian-diagnostics.log
-rw-r-----. 1 confluence confluence 34906 Aug 5 21:10 atlassian-synchrony.log
-rw-r-----. 1 confluence confluence 20971716 Aug 6 01:14 atlassian-confluence.log.1
-rw-r-----. 1 confluence confluence 6510021 Aug 6 03:44 atlassian-confluence.log
#

[Moses Thomas]

@Munish Saini  Yes  i meant  atlassian-confluence.log,  show this file

[Munish Saini]

Adding last 100 lines as the file is too big.

# tail -100 atlassian-confluence.log
2020-08-06 03:36:13,212 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [AO_BAF3AA_AOINLINE_TASK]
2020-08-06 03:36:13,529 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [AO_C3F403_ANNOUNCEMENT_ENTITY]
2020-08-06 03:36:13,689 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [AO_C3F403_ANNOUNCEMENT_ENTITY]
2020-08-06 03:36:14,008 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [AO_DC98AE_AOHELP_TIP]
2020-08-06 03:36:14,487 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [AO_DC98AE_AOHELP_TIP]
2020-08-06 03:36:14,804 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [AO_ED669C_SEEN_ASSERTIONS]
2020-08-06 03:36:14,965 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [AO_ED669C_SEEN_ASSERTIONS]
2020-08-06 03:36:15,283 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ATTACHMENTS]
2020-08-06 03:44:17,673 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ATTACHMENTS]
2020-08-06 03:44:18,000 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [BANDANA]
2020-08-06 03:44:44,269 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [BANDANA]
2020-08-06 03:44:44,587 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [BODYCONTENT]
2020-08-06 04:00:27,108 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.4.1 [build 8401 based on commit hash 758836457240a7983be3b3db3463da30107b780e] - synchrony version 3.1.0-master-022ca438
2020-08-06 04:00:32,541 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2020-08-06 04:00:38,004 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2020-08-06 04:00:56,301 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 23760 ms
2020-08-06 04:01:07,652 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2020-08-06 04:01:11,910 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2020-08-06 04:02:08,474 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.4.1 [build 8401 based on commit hash 758836457240a7983be3b3db3463da30107b780e] - synchrony version 3.1.0-master-022ca438
2020-08-06 04:02:14,053 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2020-08-06 04:02:19,520 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2020-08-06 04:02:37,311 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 23258 ms
2020-08-06 04:02:41,532 ERROR [Catalina-utility-1] [atlassian.confluence.setup.DefaultDatabaseVerifier] verifyCollationOfDatabase The collation of database is not set correctly!
2020-08-06 04:02:45,355 ERROR [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent The database collation 'latin1_swedish_ci' is not supported by Confluence. You need to use 'utf8_bin, utf8mb4_bin'.
2020-08-06 04:02:45,355 ERROR [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent The database collation 'latin1_swedish_ci' is not supported by Confluence. You need to use 'utf8_bin, utf8mb4_bin'.
2020-08-06 04:02:47,277 WARN [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade
2020-08-06 04:02:48,238 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2020-08-06 04:04:28,294 ERROR [Catalina-utility-3] [ContainerBase.[Standalone].[localhost].[/]] log Session event listener threw exception
java.lang.NullPointerException
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.getEventPublisher(UserSessionExpiryListener.java:67)
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.sessionDestroyed(UserSessionExpiryListener.java:46)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:802)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:744)
at org.apache.catalina.session.StandardManager.stopInternal(StandardManager.java:394)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5397)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1400)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1389)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
2020-08-06 04:04:28,294 ERROR [Catalina-utility-3] [ContainerBase.[Standalone].[localhost].[/]] log Session event listener threw exception
java.lang.NullPointerException
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.getEventPublisher(UserSessionExpiryListener.java:67)
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.sessionDestroyed(UserSessionExpiryListener.java:46)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:802)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:744)
at org.apache.catalina.session.StandardManager.stopInternal(StandardManager.java:394)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5397)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1400)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1389)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
2020-08-06 04:04:28,295 ERROR [Catalina-utility-3] [ContainerBase.[Standalone].[localhost].[/]] log Session event listener threw exception
java.lang.NullPointerException
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.getEventPublisher(UserSessionExpiryListener.java:67)
at com.atlassian.confluence.user.listeners.UserSessionExpiryListener.sessionDestroyed(UserSessionExpiryListener.java:46)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:802)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:744)
at org.apache.catalina.session.StandardManager.stopInternal(StandardManager.java:394)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5397)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1400)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1389)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
2020-08-06 04:04:28,299 INFO [Catalina-utility-3] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Preparing to shut down the plugin system
2020-08-06 04:04:28,305 INFO [Catalina-utility-3] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Shutting down the plugin system
2020-08-06 04:04:28,316 WARN [Catalina-utility-3] [atlassian.plugin.servlet.DefaultServletModuleManager] onPluginFrameworkShutdownEvent PluginController passed via the PluginFrameworkShutdownEvent did not match that passed via PluginFrameworkStartedEvent
2020-08-06 04:04:28,323 WARN [Catalina-utility-3] [atlassian.plugin.jmx.JmxUtil] unregister Failed to unregister, instance not found:
2020-08-06 04:04:28,518 INFO [Catalina-utility-3] [com.atlassian.confluence.lifecycle] destroy Shutting down long running task service
2020-08-06 04:04:28,575 INFO [Catalina-utility-3] [com.atlassian.confluence.lifecycle] shutdownCacheManager Shutting down EhCache cache manager
2020-08-06 04:04:28,585 INFO [Catalina-utility-3] [com.atlassian.confluence.lifecycle] contextDestroyed Stopping Confluence
2020-08-06 04:04:36,373 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.4.1 [build 8401 based on commit hash 758836457240a7983be3b3db3463da30107b780e] - synchrony version 3.1.0-master-022ca438
2020-08-06 04:04:41,751 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2020-08-06 04:04:47,080 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2020-08-06 04:05:04,958 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 23207 ms
2020-08-06 04:05:16,878 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2020-08-06 04:05:21,095 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2020-08-06 04:12:38,360 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.4.1 [build 8401 based on commit hash 758836457240a7983be3b3db3463da30107b780e] - synchrony version 3.1.0-master-022ca438
2020-08-06 04:12:44,008 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2020-08-06 04:12:49,523 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2020-08-06 04:13:07,544 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 23535 ms
2020-08-06 04:13:20,116 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2020-08-06 04:13:24,432 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.

[Moses Thomas]

@Munish Saini  After going through the logs  i have found a vital issue

020-08-06 04:02:020-08-06 04:02:41,532 ERROR [Catalina-utility-1] [atlassian.confluence.setup.DefaultDatabaseVerifier] verifyCollationOfDatabase The collation of database is not set correctly!41,532 ERROR [Catalina-utility-1] [atlassian.confluence.setup.DefaultDatabaseVerifier] verifyCollationOfDatabase The collation of database is not set correctly!

Confluence and your database must be configured to use the same character encoding

Please visit  the below to fix collation and character set depending  on the database you are using  Configuring Database Character Encoding 

Kind regards,

Moses