Tomcat server says started, but confluence won't load in browser

[anshu02]

Tomcat is running fine but i am unable to access confluence application through browser. 

Any idea what is causing the issue ?

[Bill Bailey]

Three questions:

1. Are you trying to access Confluence locally or remotely?
2. Are you using port 8090? Or are you behind a reverse proxy?
3. If on a remote server, is it Linux based? If so, have you opened the firewall for the required ports?

[anshu02]

Hi Bill, 

Thanks for your input !

I have figured out the issue, it was due to firewall  configuration from network team. 

[Sid]

Hi @anshu02 ,

Can you post the logs? <home directory>/logs/atlassian-confluence.log

[anshu02]

Please have a look on below logs, 

2019-02-18 14:11:01,852 WARN [http-nio-8443-exec-3] [runner.rest.common.UserScriptEndpoint] exec Script console script failed:
-- referer: https://illincontest01:8443/plugins/servlet/scriptrunner/admin/console | url: /rest/scriptrunner/latest/user/exec/ | traceId: 297ea50cac72e046 | userName: dark | sr.execution.id: ef97d0fb-6b04-4193-850c-bae299da80ac
com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : space='snp' and type=page and ((ancestor="38984902" and label="show_in_control_table") or (parent="38984902")) order by name
at com.atlassian.confluence.plugins.cql.impl.DefaultCQLSearchService.performV2Search(DefaultCQLSearchService.java:329)
at com.atlassian.confluence.plugins.cql.impl.DefaultCQLSearchService.searchContent(DefaultCQLSearchService.java:195)
at com.atlassian.confluence.plugins.cql.impl.DefaultCQLSearchService.searchContent(DefaultCQLSearchService.java:143)
at Script687.run(Script687.groovy:35)
Caused by: org.antlr.v4.runtime.misc.ParseCancellationException
at org.antlr.v4.runtime.BailErrorStrategy.recover(BailErrorStrategy.java:75)
at com.atlassian.querylang.antlrgen.AqlParser.orderbyField(AqlParser.java:582)
at com.atlassian.querylang.antlrgen.AqlParser.orderbyClause(AqlParser.java:765)
at com.atlassian.querylang.antlrgen.AqlParser.orderby(AqlParser.java:694)
at com.atlassian.querylang.antlrgen.AqlParser.aqlStatement(AqlParser.java:629)
at com.atlassian.querylang.lib.parserfactory.DefaultParserFactory.createParser(DefaultParserFactory.java:36)
at com.atlassian.confluence.plugins.cql.impl.DefaultCQLSearchService.createParserForInput(DefaultCQLSearchService.java:390)
at com.atlassian.confluence.plugins.cql.impl.DefaultCQLSearchService.performV2Search(DefaultCQLSearchService.java:275)
... 3 more
Caused by: org.antlr.v4.runtime.FailedPredicateException: failed predicate: {fieldRegistry.isRegisteredOrderByField(getCurrentToken().getText())}?
at com.atlassian.querylang.antlrgen.AqlParser.orderbyField(AqlParser.java:575)
... 9 more
2019-02-18 14:11:05,922 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.BaseLoginFilter] doFilter doFilter : ____ Attempting login for : '/rest/scriptrunner/latest/canned/com.onresolve.scriptrunner.canned.common.StaticCompilationChecker'
2019-02-18 14:11:05,923 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.PasswordBasedLoginFilter] login login : No user name or password was returned. No authentication attempt will be made. User may still be found via a SecurityFilter later.
2019-02-18 14:11:05,923 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.BaseLoginFilter] doFilter doFilter : Login completed for 'null' - os_authstatus = 'null'
2019-02-18 14:11:05,924 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.SecurityFilter] doFilter doFilter : Storing the originally requested URL (atlassian.core.seraph.original.url=/rest/scriptrunner/latest/canned/com.onresolve.scriptrunner.canned.common.StaticCompilationChecker)
2019-02-18 14:11:05,924 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.SecurityFilter] doFilter doFilter : requiredRoles = []
2019-02-18 14:11:05,924 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.auth.DefaultAuthenticator] getUserFromSession getUserFromSession : Session found; 'dark' is present
2019-02-18 14:11:05,926 DEBUG [http-nio-8443-exec-2] [atlassian.seraph.filter.SecurityFilter] doFilter doFilter : Setting Auth Context to be 'dark'
2019-02-18 14:11:06,598 DEBUG [http-nio-8443-exec-5] [atlassian.seraph.filter.BaseLoginFilter] doFilter doFilter : ____ Attempting login for : '/rest/scriptrunner/latest/user/exec/'
2019-02-18 14:11:06,599 DEBUG [http-nio-8443-exec-5] [atlassian.seraph.filter.PasswordBasedLoginFilter] login login : No user name or password was returned. No authentication attempt will be made. User may still be found via a SecurityFilter later.
2019-02-18 14:11:06,599 DEBUG [http-nio-8443-exec-5] [atlassian.seraph.filter.BaseLoginFilter] doFilter doFilter : Login completed for 'null' - os_authstatus = 'null'
2019-02-18 14:11:06,599 DEBUG [http-nio-8443-exec-5] [atlassian.seraph.filter.SecurityFilter] doFilter doFilter : Storing the originally requested URL (atlassian.core.seraph.original.url=/rest/scriptrunner/latest/user/exec/)
2019-02-18 14:11:06,600 DEBUG [http-nio-8443-exec-5] [atlassian.seraph.filter.SecurityFilter] doFilter doFilter : requiredRoles = []
"atlassian-confluence.log" [readonly] 168902L, 20839460C

[Sid]

Hi @anshu02 ,

What is the error you are getting when trying to load? From the logs you have given above there are no errors messages.

[anshu02]

Hi @Sid 

The page cannot be reached. 

This site can’t be reached

confpbgtest refused to connect.

Try:

• Checking the connection
• Checking the proxy and the firewall

ERR_CONNECTION_REFUSED