Stand alone tool for data gathering

Chat
42

I used mariadb103 by @stephdl and the schema import worked without errors:

yum -y install http://mirror.de-labrusse.fr/NethServer/7/x86_64/nethserver-stephdl-1.1.7-1.ns7.sdl.noarch.rpm
yum install nethserver-rh-mariadb103 --enablerepo=stephdl -y

Config DB:

mysql103
CREATE USER 'orbeon'@'%' IDENTIFIED BY 'SECRET';
CREATE schema orbeon;
GRANT ALL PRIVILEGES ON *.* TO 'orbeon'@'%' WITH GRANT OPTION;
exit;
wget https://raw.githubusercontent.com/orbeon/orbeon-forms/master/form-runner/jvm/src/main/resources/apps/fr/persistence/relational/ddl/mysql-2019_1.sql
cat mysql-2019_1.sql | mysql103 orbeon

Enable logging, see https://doc.orbeon.com/installation/logging

Edit /opt/tomcat8/webapps/orbeon/WEB-INF/resources/config/log4j.xml, search for orbeon.log and change the path to /var/log/orbeon.log

touch /var/log/orbeon.log
chown tomcat:tomcat /var/log/orbeon.log
chmod 600 /var/log/orbeon.log

Change the url in /opt/tomcat8/conf/server.xml to fit the newer mariadb and restart tomcat, for mariadb103 you need to use 127.0.0.1 and port 3313 instead of localhost.

url="jdbc:mysql://127.0.0.1:3313/orbeon?useUnicode=true&characterEncoding=UTF8">

Tomcat8 is working without complaining about a missing database but orbeon still does.

From orbeon.log: javax.servlet.ServletException: No database instance available

I think we are missing some additional component config…

1 Like