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

Question

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!

shihenghui · Answer

ok

I'll try it

thank you

Kurt Klinner · Answer

@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 · Answer

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)