Page 1 of 1

Can't see all data with root or openkm user in okmdb

PostPosted:Thu May 03, 2018 11:49 am
by tumi
I thought OpenKM uses mariadb with openkm-user which I created like said in the guide https://docs.openkm.com/kcenter/view/ok ... entos.html

But e.g I can't see any data with this:
MariaDB [okmdb]> select * from OKM_NODE_NOTE;
Empty set (0.00 sec)

But when I use Database Query from the OpenKM it shows the data. And it apparently uses "SA"-user, but I don't know what that is. Because there's no "SA" in the mariadb user-table.

Re: Can't see all data with root or openkm user in okmdb

PostPosted:Fri May 04, 2018 12:25 pm
by tumi
Solved. OpenKM was using h2-driver instead of mysql.

Re: Can't see all data with root or openkm user in okmdb

PostPosted:Sat May 05, 2018 8:08 am
by jllort
We suggest migrating to MySQL or another database rather than H2 with a production repository.