Unable to log in to OpenKM
PostPosted:Wed Aug 12, 2020 2:26 pm
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:
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!
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
4. So I modified the jdbc connection URL to include server timezone as follows:"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."Code: Select all
5. Modified OpenKM.cfg to hibernate.hbm2ddl=create<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&useUnicode=true&characterEncoding=UTF8&serverTimezone=Europe/Madrid" username="openkm" validationQuery="select 1"/>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!