orbeon [NethServer Wiki]

Placeholder and WIP

Orbeon Forms is a solution to build and deploy web forms. It handles large forms with complex validation and extensive collections of forms. It implements the W3C XForms standard and is available in an open source Community Edition (Github), as well as a commercially supported Professional Edition. Orbeon Forms is used around the world in a number of industries, including governments, banking, healthcare, telecom, and education.

Installation:

Create a service in web UI of Nethserver called 'tomcat' with TCP port 8080 and Access 'Green'.

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

Create 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

yum -y install wget unzip tomcat8 mysql-connector-java
wget https://github.com/orbeon/orbeon-forms/releases/download/tag-release-2020.1.2-ce/orbeon-2020.1.2.202103050030-CE.zip
mkdir /opt/tomcat8/webapps/orbeon
unzip orbeon-2020.1.2.202103050030-CE.zip
unzip orbeon-2020.1.2.202103050030-CE/orbeon.war -d /opt/tomcat8/webapps/orbeon
systemctl enable tomcat8 --now

Link mysql-connector to tomcat8:

ln -s /usr/share/java/mysql-connector-java.jar /opt/tomcat8/lib/

Add the following to the <Host> context, line 167, in /opt/tomcat8/conf/server.xml

<Context path="/orbeon"
         docBase="/opt/tomcat8/webapps/orbeon"
         reloadable="false"
         override="true" allowLinking="true">
         <Resource name="jdbc/mysql"
            driverClassName="com.mysql.jdbc.Driver"
            auth="Container"
            type="javax.sql.DataSource"
            initialSize="3"
            maxActive="10"
            maxIdle="10"
            maxWait="30000"
            poolPreparedStatements="true"
            testOnBorrow="true"
            validationQuery="select 1"
            username="orbeon"
            password="SECRET"
            url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8">
         </Resource>
</Context>

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
chmod 777 /var/log/orbeon.log #This is highly insecure and just for testing

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&amp;characterEncoding=UTF8">

systemctl restart tomcat8

Then go to: http://yourip:8080/orbeon