XWiki - Install
This is to create a installation of XWiki on a installation of Rocky Linux already installed
Configuration
Linux configuration
Disable selinux
Run the following or you can modify the file here, “/etc/sysconfig/selinux”. If you modify the file make sure you still run the “setenforce 0” or just simply reboot after modification.
setenforce 0
sed -i 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/configDisable firewall
systemctl disable firewalld.serviceEpel Release
dnf install epel-release -yAfter Epel install
dnf upgrade -yServer Software Configuration
Install MySQL on the server
Install Java
dnf install java-11-openjdk -y
dnf install java-11-openjdk-devel -yVerify the Viserion after install
java -versionResults
openjdk version "11.0.24" 2024-07-16 LTS
OpenJDK Runtime Environment (Red_Hat-11.0.24.0.8-2) (build 11.0.24+8-LTS)
OpenJDK 64-Bit Server VM (Red_Hat-11.0.24.0.8-2) (build 11.0.24+8-LTS, mixed mode, sharing)Install MariaDB
Install the server
sudo dnf install mariadb-server -yModify the my.cnf server file
sudo vi /etc/my.cnf.d/mariadb-server.cnfMake modifications the file and append under the current settings in the [mysql] section
#Custom Entries
performance_schema = ON
tmpdir = /run/mariadb
thread_cache_size = 4
table_open_cache = 16384
table_definition_cache = 8384
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
query_cache_type = 0
query_cache_size = 0
query_cache_limit = 128M
query_cache_strip_comments = 1
tmp_table_size = 512M
max_heap_table_size = 512M
max_connections = 512
max_allowed_packet = 24M
sort_buffer_size = 24M
join_buffer_size = 48M
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 4
innodb_use_native_aio = 1
innodb_flush_log_at_trx_commit = 0
innodb_file_per_table
innodb_log_file_size = 512M
#Optional config if using transaction log.
log_bin = /var/log/mariadb/mariadb.log
expire_logs_days = 2Reload for changes
sudo systemctl daemon-reloadStart and enable on boot
systemctl enable --now mariadb.serviceAdd the XWiki user to access the database
mysql
create database xwiki default character set utf8mb4 collate utf8mb4_bin;
grant all privileges on xwiki.* to 'xwiki'@'localhost' identified by 'xwiki_password';
grant all privileges on xwiki.* to 'xwiki'@'%' identified by 'xwiki_password';
FLUSH PRIVILEGES;
exit;
Tomcat Configuration
Verify which version you want to install, we will be using “v9.0.63”
http://dlcdn.apache.org/tomcat/tomcat-9Create folder for Tomcat
sudo mkdir /opt/tomcat
sudo cd /opt/tomcatReplace the version within the following link
wget https://dlcdn.apache.org/tomcat/tomcat-9/v9.0.93/bin/apache-tomcat-9.0.93.tar.gzExtract the file you downloaded in you current folder
sudo tar xvf apache-tomcat-*.tar.gz -C /opt/tomcat --strip-components=1Create the tomcat user
sudo groupadd tomcat
sudo useradd -s /bin/false -g tomcat -d /opt/tomcat tomcatChange the permissions on the tomcat folder
sudo chown -R tomcat: /opt/tomcatConfiguring Systemd Service
sudo vi /etc/systemd/system/tomcat.serviceAdd the following content to the file
[Unit]
Description=Tomcat 9 servlet container
After=network.target
[Service]
Type=forking
User=tomcat
Group=tomcat
Environment="JAVA_HOME=/usr/lib/jvm/jre"
Environment="CATALINA_PID=/opt/tomcat/temp/tomcat.pid"
Environment="CATALINA_HOME=/opt/tomcat"
Environment="CATALINA_BASE=/opt/tomcat"
Environment="CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC"
Environment="JAVA_OPTS=-Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom"
ExecStart=/opt/tomcat/bin/startup.sh
ExecStop=/opt/tomcat/bin/shutdown.sh
[Install]
WantedBy=multi-user.targetEnable and start the Tomcat service:
sudo systemctl daemon-reload
sudo systemctl enable tomcat
sudo systemctl start tomcatAdjusting the Firewall and you did not run the firewall disabling command above, allow traffic to Tomcat's default port 8080
sudo firewall-cmd --permanent --zone=public --add-port=8080/tcp
sudo firewall-cmd --reloadSecuring Tomcat
Edit the web.xml file to disable directory listing and add security constraints to the manager and host-manager applications. It's also advisable to change the default shutdown port and command in server.xml.
Add access from another host if needed
vi /opt/tomcat/webapps/manager/META-INF/context.xml Add the IP or IPs you are accessing from to allow access to the main tomcat page. you will need to change this entry from this “allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1” />" to something like this
allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1|192.168.253.100|192.168.252.2" />Configure XWiki
Download the war file
cd /opt/tomcat/webapps
wget -O wiki.war https://nexus.xwiki.org/nexus/content/groups/public/org/xwiki/platform/xwiki-platform-distribution-war/15.10.11/xwiki-platform-distribution-war-15.10.11.war
systemctl restart tomcatReverse Proxy
Change for reverse proxy settings
sudo vi /opt/tomcat/webapps/wiki/WEB-INF/xwiki.cfgChange the following in the file
To point to a specific domain
xwiki.home=http://wiki.sflservicesllc.comChange to use https
xwiki.url.protocol=httpsMySQL Setup
After the Tomcat service is restarted move to the XWiki’s WEB-INF/lib directory and download the MySQL JDBC Driver JAR:
su - tomcat
cd /opt/tomcat/webapps/wiki/WEB-INF/lib/
wget https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.49/mysql-connector-java-5.1.49.jar
chown tomcat:tomcat mysql-connector-java-5.1.49.jarMariaDB Setup
After the Tomcat service is restarted move to the XWiki’s WEB-INF/lib directory and download the MariaDB JDBC Driver JAR:
su - tomcat
cd /opt/tomcat/webapps/wiki/WEB-INF/lib/
wget https://dlm.mariadb.com/3852266/Connectors/java/connector-java-3.4.1/mariadb-java-client-3.4.1.jar
chown tomcat:tomcat mariadb-java-client-3.4.1.jarOpen the WEB-INF/hibernate.cfg.xml file and configure XWiki to use MySQL:
vi /opt/tomcat/webapps/wiki/WEB-INF/hibernate.cfg.xmlComment out the default hsqldb database section and uncomment and edit the MySQL database section as shown below:
<!-- Configuration for the default database.
Comment out this section and uncomment other sections below if you want to use another database.
Note that the database tables will be created automatically if they don't already exist.
If you want the main wiki database to be different than "xwiki" (or the default schema for schema based engines)
you will also have to set the property xwiki.db in xwiki.cfg file
-->
<!--
<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="hibernate.connection.charSet">UTF-8</property>
<property name="hibernate.connection.useUnicode">true</property>
<property name="hibernate.connection.characterEncoding">utf8</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="notification-filter-preferences.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
-->Uncomment wither the MySQL Section or the MariaDB section and change the password
    <property name="hibernate.connection.username">xwiki</property>
    <property name="hibernate.connection.password">xwiki_password</property>Restart the Tomcat service
sudo systemctl restart tomcatAccessing Tomcat
Open your web browser and navigate to the following below. You should see the default Tomcat landing page.
http://[your_server_ip]:8080/wikihttps://linuxhostsupport.com/blog/how-to-install-xwiki-on-centos-7/
https://reintech.io/blog/installing-configuring-tomcat-rocky-linux-9
 
