Unable to log in to OpenKM

[tmbk58]

Hi,
1. I have downloaded and installed OpenKM virtual environment "OpenKM-ComPorDev" and imported into VirtualBox version 6.1.12.
2. Then I tried to run the application from eclipse by first running Maven Build -> OpenKM package and also Maven Build -> clean gmt:compile package.
3. When starting up tomcat, I got this error:

Code: Select all

"com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support."

4. So I modified the jdbc connection URL to include server timezone as follows:

Code: Select all

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxIdle="30" maxTotal="100" maxWaitMillis="10000" name="jdbc/OpenKMDS" password="openkm" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/okmdb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8&amp;serverTimezone=Europe/Madrid" username="openkm" validationQuery="select 1"/>

5. Modified OpenKM.cfg to hibernate.hbm2ddl=create

6. On restarting tomcat, I got the login page. Upon logging in with okmAdmin and admin, I get 404 error for /OpenKM/frontend/index.jsp.

7. I tried building using build.sh and starting tomcat with startup.sh from terminal but I get the same error.

Sorry for the long post but I shall be highly obliged if anybody could help.

Thanks in advance!

[jllort]

In case of MySQL you must set the timezone https://docs.openkm.com/kcenter/view/ok ... QLtimezone

Here you have a list of timezones https://www.php.net/manual/en/timezones.php

[tmbk58]

I followed your advise and finally got it working!
Thanks a lot for your help!!

Best regards.