can't show the tomcat after running the ls -lisa /etc/init.d/

[sandesh12]

I am trying to use this on Ubuntu 20.04 LTS

Unable to find the tomcat after running the ls -lisa /etc/init.d/

any solutions

[jllort]

The script should be named openkm.
what is the result if you execute:
systemctl status openkm

How did you installed openkm? with OKMInstaller.jar tool ? did you executed under root user?

[stony007_de]

Hi there

the same here
Ubuntu 20.04 x64

Installation with root -> #java -jar OKMInstaller.jar
Database -> MariaDB
systemctl status openkm:

Code: Select all

● openkm.service - LSB: Start and stop OpenKM
     Loaded: loaded (/etc/init.d/openkm; generated)
     Active: active (exited) since Mon 2020-10-12 06:48:59 CEST; 10s ago
       Docs: man:systemd-sysv-generator(8)
    Process: 30305 ExecStart=/etc/init.d/openkm start (code=exited, status=0/SUCCESS)

but no Tomcat Service in the init.d

[jllort]

Did you used root user to execute the installer, otherwise is not able to create the files. I suggest delete the installation folder and try again.

Another option is to create the script manually:
https://docs.openkm.com/kcenter/view/ok ... asaservice

[stony007_de]

OK, i Found the issue(s)

[*]first:
i haven't a local user with the name openkm on my ubuntu!
I've created it and the installation runs!

[*]second:
after start of the /etc/init.d/openkm i get the log:

Code: Select all

 ==> /home/openkm/tomcat-8.5.34/logs/localhost.2020-10-18.log <==
18-Oct-2020 13:52:57.032 SCHWERWIEGEND [localhost-startStop-1] org.apache.catalina.core.StandardContext.loadOnStartup Servlet [RepositoryStartup] in web application [/OpenKM] threw load() exception
 java.sql.SQLException: Access denied for user 'openkm'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'

so i Added the 'openkm'@'127.0.0.1' to the mySql

Code: Select all

MariaDB [(none)]> CREATE USER openkm@127.0.0.1 IDENTIFIED BY 'xxxxxxxx';
Query OK, 0 rows affected (0.005 sec)
MariaDB [(none)]> GRANT ALL ON okmdb.* TO openkm@127.0.0.1 WITH GRANT OPTION;
Query OK, 0 rows affected (0.010 sec)

[*]Third
after the next start i get the issue in log:

Code: Select all

java.sql.SQLException: Table 'okmdb.OKM_NODE_BASE' doesn't exist

so i was modified the vi /home/openkm/tomcat-8.5.34/OpenKM.cfg
from hibernate.hbm2ddl=none --> to -->hibernate.hbm2ddl=create

after that the okmdb was filled on start with tables.


now i can go further...