Issue Summary
Crowd logs are showing the following error for OpenID after a fresh install.
Caused by: java.sql.SQLException: File input/output error /opt/atlassian/crowd/apache-tomcat/../database/crowdopenidserverdb.properties java.io.FileNotFoundException: /opt/atlassian/crowd/apache-tomcat/../database/crowdopenidserverdb.properties.new (No such file or directory)
Steps to Reproduce
- Install Crowd 4.1.0 via Docker.
- Use our official repo.
- Inspect Tomcat logs (usually localhost.* file).
- Check if the OpenID Server is accessible via <base-url>/openidserver (e.g. http://localhost:8095/openidserver).
Expected Results
There should be no errors in the logs out of the box and OpenID should work fine.
Actual Results
The below exception is thrown in the localhost.<date>.log file:
21-Jul-2020 01:18:48.730 SEVERE [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
.
Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution
.
Caused by: java.sql.SQLException: File input/output error /opt/atlassian/crowd/apache-tomcat/../database/crowdopenidserverdb.properties java.io.FileNotFoundException: /opt/atlassian/crowd/apache-tomcat/../database/crowdopenidserverdb.properties.new (No such file or directory)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55)
at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)
When trying to access OpenID using <base-url>/openidserver, we see a 404 - Not Found Tomcat error instead.

Note
This only occurs when Crowd is installed in Docker. When Crowd is locally hosted and installed in a server, OpenID works fine and there are no errors.
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available.