Problems running enviroment developer

[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 (80.07 KiB) Viewed 17624 times

Captura4.JPG (38.56 KiB) Viewed 17624 times

Captura5.JPG (43.62 KiB) Viewed 17624 times

Please, ¿any idea where is the problem?

[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

[albertogomez38]

Thanks for the answer...

I add new captures..

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

Captura6.JPG (112.49 KiB) Viewed 17590 times

Captura7.JPG (41.14 KiB) Viewed 17590 times

Captura8.JPG (59.31 KiB) Viewed 17590 times

[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

[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?
pd: sorry for my bad english.

[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 ).

[saleem55]

Same problem

[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)

[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"/>

[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.