HTTP Status 500 – Internal Server Error

Question

Confluence is hosted on an single CentOS VM. VM was shutdown manually. Backup taken from the VM. Restart the VM. Confluence is not reachable. Database MYSQL is running. Different solutions by th comunity didn't help to fix the issues. The report is reading like a development report, but I just would like use it.. HTTP Status 500 – Internal Server Error Type Exception Report Message Beim Verarbeiten von [errors.jsp] ist in Zeile [13] eine Ausnahme erzeugt worden Beschreibung The server encountered an unexpected condition that prevented it from fulfilling the request. Exception org.apache.jasper.JasperException: Beim Verarbeiten von [errors.jsp] ist in Zeile [13] eine Ausnahme erzeugt worden 10: 11: <% 12: JohnsonPageI18NProvider johnsonPageI18NProvider = (JohnsonPageI18NProvider) BootstrapUtils.getBootstrapContext().getBean("johnsonPageI18NProvider"); 13: String translations = johnsonPageI18NProvider.getTranslations().serialize(); 14: %> 15:

Mark Heintze · Accepted Answer

ok, after hours here my result:

- my mySQL server was a fresh installed one - in this case the setup for the time zone was missing

- Some instructions advice to update the my.cnf which is located for linux (in my case CentOS 8) at /etc/ . In my case this file will not be used and it refers to /etc/my.cnf.d .

- At this location you will find the file mysql-server.cnf.

- When you edit it you have to set the parameter 'default-time-zone' into the [mysqld] section. In my case I have to use the time zone of Berlin. Currently it has to set to the UTC +2 hours due summertime. Wintertime you have to use +1 hour. And this was my fault: I had set it at to +1 hour and the Confluence wouldn't like start. The start screen informs me to check if the database is running, the configuration of the confluence.cfg.xml (located at /var/atlassian/application-data/confluence) is correct and firewall settings are ok.

- In my case the firewall works right and the database was running. But how I can prove what should be wrong in the xml file (keep in mind: I had nothing changed before my shutdown and back up)

- The most of instructions advice to restart the mySQL service at once to take the effect. But this doesn't help in my case.

Solution:

1. When you add the default-time-zone into the mysql-server.cnf the error 500 will be gone.

2. When you set the correct time zone then the Confluence can startup again.

-- use for sommer time in germany: default-time-zone='+02:00'

-- use for winter time in germany: default-time-zone='+01:00'

-- restart the complete system (only this helps in my case but I use Confluence at an own VM server)

Hope this helps other guys.