Hi,
I'm trying to run openKM, but...
Plattform: Mac HighSierra, MySQL 8.0.1.1
I've downloaded the jar file, installed everything, wrote "mysql" in the installation process, where the script asks for the db type. I added the SQL-Commands to my phpAdmin and I wanted to login (http://127.0.0.1:8080/OpenKM/login.jsp or http://localhost:8080/OpenKM/login.jsp) - BUT an error came up "javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection". I went thru the whole board here, but....
I've:
- changed hibernate.hbm2ddl=none -> hibernate.hbm2ddl=create in the conf file
- deleted repository directory before starting the server again
openkm.log: shows always the same
works fine with:
/usr/local/mysql-8.0.11-macos10.13-x86_64/bin/mysql -u MyUser -p MyPasswort --host=127.0.0.1 --port=3306 okmdb
and
/usr/local/mysql-8.0.11-macos10.13-x86_64/bin/mysql -u MyUser -p MyPasswort okmdb
Before I edit the files, I stopped the server (sudo shutdown.sh) , emptied therepository directory. After that, I restarted the server again (sudo catalina.sh start or sudo startup.sh)
here are the logfiles:
https://dasat.com/uli/catalina.2018-06-04.log.txt
https://dasat.com/uli/localhost.2018-06-04.log.txt
https://dasat.com/uli/openkm.log.txt
Thanks for help
Uli
I'm trying to run openKM, but...
Plattform: Mac HighSierra, MySQL 8.0.1.1
I've downloaded the jar file, installed everything, wrote "mysql" in the installation process, where the script asks for the db type. I added the SQL-Commands to my phpAdmin and I wanted to login (http://127.0.0.1:8080/OpenKM/login.jsp or http://localhost:8080/OpenKM/login.jsp) - BUT an error came up "javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection". I went thru the whole board here, but....
I've:
- changed hibernate.hbm2ddl=none -> hibernate.hbm2ddl=create in the conf file
- deleted repository directory before starting the server again
openkm.log: shows always the same
Code: Select all
server.xml
2018-06-04 11:38:13,126 [localhost-startStop-1] [] INFO c.o.servlet.RepositoryStartupServlet - *** Initialize language detection engine... ***
2018-06-04 11:38:17,911 [localhost-startStop-1] [] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2018-06-04 11:38:17,912 [localhost-startStop-1] [] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
Code: Select all
or<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
username="MyUser" password="MyPasswort" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/okmdb?useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>
Code: Select all
(MyUser and MyPasswort are just used for this post)<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
username="MyUser" password="MyPasswort" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/okmdb?useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>
works fine with:
/usr/local/mysql-8.0.11-macos10.13-x86_64/bin/mysql -u MyUser -p MyPasswort --host=127.0.0.1 --port=3306 okmdb
and
/usr/local/mysql-8.0.11-macos10.13-x86_64/bin/mysql -u MyUser -p MyPasswort okmdb
Before I edit the files, I stopped the server (sudo shutdown.sh) , emptied therepository directory. After that, I restarted the server again (sudo catalina.sh start or sudo startup.sh)
here are the logfiles:
https://dasat.com/uli/catalina.2018-06-04.log.txt
https://dasat.com/uli/localhost.2018-06-04.log.txt
https://dasat.com/uli/openkm.log.txt
Thanks for help
Uli