ah yes, we now have mariadb-5.5.68-1.el7.x86_64
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…
Yep, so I got it runing om mariadb 103 as per instructions above. I get a lot of errors in various logs so I wonder if I have a mix of MySQL and MariaDB e.g. connector-java etc
I’m going to test more later. I think the DB is ok because the schema worked without issues.
Sure!
This is my orbeon.log for trying to save a form https://pastebin.com/rKEHpCYF
The root cause seems to be a ‘permission denied’ somewhere…
I get the same errors, I tried it with Tomcat 7 but no luck so far…
The answer could well be in doing:
chown -R tomcat:tomcat /opt/tomcat8/webapps/orbeon/
systemctl restart tomcat8
A first small test with both MariaDB 10.3 as well as the internal Orbeon DB looks good so far. So basically all your instructions based on MariaDB103 and setting correct tomcat permissions.
Can you try please?
I’ll try it later to confirm but I think that was the issue.
If so:
- we need to set back permissions on the logfile.
- Make sure it runs via HTTPS only
- Nicer URL?
- RTFM
Confirmed.
chown tomcat:tomcat /var/log/orbeon.log
chmod 600 /var/log/orbeon.log
Create a reverse proxy to http://localhost:8080
to use https://reverseproxydomainname/orbeon
To change the path /orbeon
, just edit the context line added previously to /opt/tomcat8/conf/server.xml
i.e. <Context path="/whatever"
or <Context path="/"
.
Note to self, I did something that changed the ownership of /opt/tomcat8/webapps/orbeon back to apache. Needed to set permissions back to tomcat
I added the chown lines to my posts…
For accuracy, does the your posting need to be adjusted for using Maridb103 instead of the default MySQL?
You’re right, I linked the mariadb103 part to the first post.
Using the internal DB of Orbeon (eXist-db) is deprecated and NOT recommended of supported any longer. (been there, done that…)
Please see: https://doc.orbeon.com/configuration/advanced/exist-db
@mrmarkuz is the create command correct please for it gives me an error:
MariaDB [(none)]> CREATE USER ‘orbeon’@‘%’ IDENTIFIED BY ‘SECRET’;
ERROR 1396 (HY000): Operation CREATE USER failed for ‘orbeon’@‘%’
MariaDB [(none)]>
Thanks
Actually I don;t know what is wrong. It is not working with MariaDB (time out). Followed all the directions above, double checked server.xml, ports, hosts etc etc. No luck
Really need some help for I am staring blind at stuff by now
- Followed everything again, based on using MariaDB. Still get a time-out when accessing http://myserver.tld:8080/orbeon
- Ok, not working yet, but found a possible issue. Since we initially started with mysql and are now using MariaDB, MariaDB will not start due to the fact that there is already /var/lib/mysql/mysql.sock file from MySQL. So when trying to start MariaDB the status says fails due to the .sock file already exists.
FYI, still working on this with Markus. We have taken this off-line before the thread get’s too long and clogged. Results will be posted again of course!
“Ladies and gentlemen, we got it”… At least it looks like it
We are now able to run Orbeon Forms with MariaDB103 from SCL (from @stephdl . A how-to will follow soonish on the wiki for those interested. We just want to re-test the steps taken.
Many thanks for @mrmarkuz for time, patience and expertise!! It was a fun ride!
so seems we have a new feature, cool. ok lets get the wiki.
Also sounds like this will be cooler with its own sub domain
Using a subdomain is possible with reverse proxy and path config: