【Setup error】When I setup users on initialization，an error has occurred

[shihenghui]

step1，install confluence in CentOS

step2，startup confluence url and initialization

step3，configure database

step4,   choose "create user" or "import jira"

expect: open new page and success

actual：Error

So, I was looking forward to a good solution.

Thanks for your support

Best regards!

[Kurt Klinner]

@shihenghui 

Two things to be checked, does the user confluence runs with have the needed permissions and did you verifiy that the connections ou specified for the db connection are the right ones

Cheers

Kurt

[shihenghui]

ok

I'll try it

thank you

[Kurt Klinner]

@shihenghui 

Hi and welcome to the Atlassian community

Could you check the confluence logfile to see if you find additional exceptions.

There were some issues discussed in the forum in the past, most of them related to issues with the database setup

https://community.atlassian.com/t5/Confluence-questions/Cannot-call-sendError-after-the-response-has-been-committed/qaq-p/933173

Which database system are you using?

https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html?&_ga=2.38224163.1662637765.1589745316-2005217296.1589745316#DatabaseSetupforSQLServer-2.Createadatabaseanddatabaseuser holds the relevant information for the db setup

Cheers

Kurt

[shihenghui]

Hello Kurt,

Thanks for your reply.

I used CentOS 7.3 + MySql.

And I tried to find soluntion in that links,but still failed. :(

So, I input log,please check it.

Thank you again!

_________________________________________

Part1

19-May-2020 19:47:04.648 SEVERE [http-nio-8082-exec-10] org.apache.catalina.core.StandardHostValve.custom Exception Processing ErrorPage[errorCode=500, location=/500page.jsp]
org.apache.jasper.JasperException: An exception occurred processing JSP page /500page.jsp at line 119

116:
117: if (sysInfoService != null)
118: {
119: confluenceInfo = sysInfoService.getConfluenceInfo();
120: memoryInfo = sysInfoService.getMemoryInfo();
121: dbInfo = sysInfoService.getSafeDatabaseInfo();
122: sysinfo = GeneralUtil.convertBeanToMap(sysInfoService.getSystemProperties());

Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:579)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

Part2

Tue May 19 19:47:40 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
19-May-2020 19:47:48.943 SEVERE [http-nio-8082-exec-1] org.apache.catalina.core.StandardHostValve.custom Exception Processing ErrorPage[errorCode=500, location=/500page.jsp]
org.apache.jasper.JasperException: An exception occurred processing JSP page /500page.jsp at line 119

116:
117: if (sysInfoService != null)
118: {
119: confluenceInfo = sysInfoService.getConfluenceInfo();
120: memoryInfo = sysInfoService.getMemoryInfo();
121: dbInfo = sysInfoService.getSafeDatabaseInfo();
122: sysinfo = GeneralUtil.convertBeanToMap(sysInfoService.getSystemProperties());

Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:579)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)