Page 1 of 1

Problems running enviroment developer

PostPosted:Fri Sep 03, 2021 12:32 pm
by albertogomez38
I have download de ova file.
Import de virtual machine.
Compile and created war file
Start openkm server.
But i cannot login...

Captura3.JPG
Captura3.JPG (80.07 KiB) Viewed 8541 times
Captura4.JPG
Captura4.JPG (38.56 KiB) Viewed 8541 times
Captura5.JPG
Captura5.JPG (43.62 KiB) Viewed 8541 times
Please, ¿any idea where is the problem?

Re: Problems running enviroment developer

PostPosted:Sat Sep 04, 2021 4:46 pm
by jllort
Seems have created jar file either war file. In the project, you'll see a build.sh -> please execute it. Finally take a look at /home/openkm/development/tomcat/webapps -> should be an alias to openkm.war file

Re: Problems running enviroment developer

PostPosted:Mon Sep 06, 2021 7:45 am
by albertogomez38
Thanks for the answer...

I add new captures..

But not work... then database is empty..

Captura6.JPG
Captura6.JPG (112.49 KiB) Viewed 8507 times
Captura7.JPG
Captura7.JPG (41.14 KiB) Viewed 8507 times
Captura8.JPG
Captura8.JPG (59.31 KiB) Viewed 8507 times

Re: Problems running enviroment developer

PostPosted:Sun Sep 12, 2021 4:31 pm
by jllort
Try starting openkm from terminal:
* delete all files into the folder /home/openkm/Development/tomcat/logs/
* open a terminal and execute the next command line
sudo service openkm start

* take a look at /home/openkm/Development/tomcat/logs/openkm.log for errors in the startup

in case startup failed, please zip all files into logs folder and share here

Re: Problems running enviroment developer

PostPosted:Thu Oct 21, 2021 9:22 pm
by 1smael94
hi i have the same error, i download in the official site and i follow all steps for the implementation of this OVA but all time is the same error.
i think: ¿where i find other version of this ova functional? :cry: :cry: :cry:
pd: sorry for my bad english.

Re: Problems running enviroment developer

PostPosted:Sat Oct 23, 2021 8:10 am
by jllort
Check if at /home/openkm/Development/tomcat/webapp have the the OpenKM.war file or OpenKM folder. In case do not have it, you must build the OpenKM project -> you have build.sh script ( run from terminal ) or build from eclipse.

The latest OVA does not come with OpenKM build, which will solve in the next releases of the OVA ( OVA is shared each time is released a new version of OpenKM, probably until the end of the year ).

Re: Problems running enviroment developer

PostPosted:Sat Oct 23, 2021 11:48 am
by saleem55
Same problem

Re: Problems running enviroment developer

PostPosted:Sat Oct 23, 2021 6:11 pm
by saleem55
Code: Select all
at Oct 23 20:07:58 CEST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2021-10-23 20:08:02,176 [localhost-startStop-1] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2021-10-23 20:08:02,176 [localhost-startStop-1] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2021-10-23 20:08:02,182 [localhost-startStop-1] ERROR com.openkm.core.Config - ** Error reading configuration table **
2021-10-23 20:08:02,183 [localhost-startStop-1] INFO  c.o.servlet.RepositoryStartupServlet - *** Repository initializing... ***
Sat Oct 23 20:08:02 CEST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2021-10-23 20:08:06,321 [localhost-startStop-1] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2021-10-23 20:08:06,321 [localhost-startStop-1] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
Oct 23, 2021 8:08:06 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet [RepositoryStartup] in web application [/OpenKM] threw load() exception
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 specifc time zone value if you want to utilize time zone support.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

Re: Problems running enviroment developer

PostPosted:Sun Oct 24, 2021 12:16 pm
by saleem55
Resolved by changing url in server.xml to
Code: Select all
url="jdbc:mysql://localhost:3306/okmdb?useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=UTF8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC"/>

Re: Problems running enviroment developer

PostPosted:Wed Sep 06, 2023 8:57 pm
by omegaites
Hi,
We faced same issue. So we have downloaded preconfigured tomcat lib from openkm then replaced the old tomcat directory content with the downloaded files.
Then deleted old okmdb and openkm user from MySQL and then created db using script provided with the previously downloaded tomcat lib.
Now it's working fine.