+1 vote


I installed Collaboration Server 1.2.1 on Ubuntu 20.04 successfully.
However, I get a 500 error after a user, team, or group creation command.

The error message indicates that access to the database is read-only.

extract of the error message:
Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.

How to check the database access rights?
How to change access rights?

Thank you for your help.



Installed versions:

  • Ubuntu Server 20.04 LTS
  • open-jdk8
  • Tomcat9
  • elasticsearch 6
in LCA Collaboration Server by (360 points)

1 Answer

0 votes
by (6.7k points)
selected by
Best answer
The tomcat user must own the collaboration server directory (e.g. /opt/collab) and all its child directories. Maybe that is the issue?
by (360 points)
The problem comes from the Ubuntu and Tomcat versions.
I retested with Ubuntu 18.04 and Tomcat8, everything is OK.
Thanks for everything