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

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

[tumi]

Solved. OpenKM was using h2-driver instead of mysql.

[jllort]

We suggest migrating to MySQL or another database rather than H2 with a production repository.