Invite user and get error page - unknown reason

[modefair]

I need some help. I have setup SMTP successfully with Gmail. I can send out test email.

But when I invite an user, it redirect to this page

Any idea what's the issue? I am not seeing any errors in catalina.out log file.

[JP _AC Bielefeld Leader_]

Hi,

are you running Jira behind a proxy server (Apache/Nginx)? Which version of Jira are you running? You might want to check the security settings for CSRF / XSFR.

Best

JP

[modefair]

yes, I am running behind apache 2.4.18 reverse proxy and SSL

Jira v8.5.1 (downloaded yesterday)

Any idea where to fix this issue?

[modefair]

I noticed these errors in atlassion-jira.log, any idea?

2019-11-19 07:45:47,740 http-nio-8080-exec-25 ERROR [o.a.c.c.C.[.[localhost].[/].[action]] Servlet.service() for servlet [action] in context with path [] threw exception [java.lang.reflect.UndeclaredThrowableException] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
...
...
2019-11-19 07:45:47,958 http-nio-8080-exec-25 ERROR [c.a.j.web.servlet.InternalServerErrorServlet] {errorId=a4ddea97-7a8d-4085-b77e-e22a2f09296d, interpretedMsg=, cause=java.lang.reflect.UndeclaredThrowableException, stacktrace=java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy1802.addInvitation(Unknown Source) [?:?]
...
...
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.7.28
- minor version:7
- major version:5
Driver:
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.48 ( Revision: 29734982609c32d3ab7e5cac2e6acee69ff6b4aa )

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'PRIMARY'
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:94) [?:?]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:266) [?:?]
...
...
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:92) [?:?]
... 299 more
, referer=https://mysubdomain/secure/admin/user/InviteUser!default.jspa, servletErrorMessage=}

Can't show the full message as it's too long.

This is a new install with 1 user (admin) and 1 scrum project (nothing in there yet). I want to invite user, but failed.

[modefair]

Okay I found the issue

I need to disable this in /etc/my.cnf

#sql_mode = NO_AUTO_VALUE_ON_ZERO

 it seems working now