empty errors.jsp

[Deleted user]

Hello,

I installed jira and setup my database. But now I got an empty errors.jsp site.
Can you help me?

Logfiles: https://drive.google.com/drive/folders/1o675pwdGdo7rjxq10v4o-y4ozMnGak3f?usp=sharing

[Andy Heinzer]

Hi Jan-Philip,

From looking at your log I found this error:

2018-10-04 19:25:54,741 http-nio-8080-exec-20 ERROR anonymous 1165x11x1 1nzwwqt fe80:0:0:0:619a:d24d:122b:9625%2 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
    CREATE TABLE cwd_application_address (application_id DECIMAL(18,0) NOT NULL, remote_address VARCHAR(255) NOT NULL, encoded_address_binary VARCHAR(255), remote_address_mask DECIMAL(9,0), CONSTRAINT PK_cwd_application_address PRIMARY KEY (application_id, remote_address))
    Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

I found this error appeared on the following KB on our site: MySQL Table Creation Fails With Error 'specified key was too long'

From that page, it appears that this error can happen when the MySQL database has been setup to use MyISAM instead of InnoDB for the storage engine:

Cause

There is a known bug with MySQL related to MyISAM, the UTF8 character set and indexes:

• http://bugs.mysql.com/bug.php?id=4541

Resolution

1. Before starting the application installation, make sure that you've followed the instructions provided in Connecting JIRA to MySQL
2. Make sure that the InnoDB Dialect is installed in your MySQL server.

3. Change the storage engine used by default so that new tables will always be created appropriately, you can use a query like:

   set GLOBAL storage_engine='InnoDb';