If you follow Setup Option B, you will need to download a few third-party libraries before you can compile the Rule Game Server from source. During the build, these libraries will be packed into the WAR file.
<property name="openjpa" location="/opt/apache-openjpa"/>
$ cd w2020/ $ unzip ~/sys/commons-math3-3.6.1-bin.zip $ ln -s commons-math3-3.6.1/ commons-math3 $ ls -l .... lrwxrwxrwx 1 vmenkov domain users 20 Jul 28 13:13 commons-math3 -> commons-math3-3.6.1/ drwxr-xr-x 3 vmenkov domain users 4096 Mar 17 2016 commons-math3-3.6.1
$ cd ~/w2020 $ unzip jaxrs-ri-3.1.0-M2.zipThis will create the directory ~/w2020/jaxrs-ri, with the JAX-RS stuff in it.
cd ~/w2020 unzip jaxb-ri-3.0.2.zipThis will create the directory ~/w2020/jaxb-ri, with the JAXB-RI stuff in it.
Prior to ver. 6.023, we would put that file into the Tomcat's lib directory; but on Plesk systems, this is not recommended, therefore now we place it into ~/w2020/other-lib as well, so that it gets packed into the application WAR file along with all other JAR files.
(The historic reason while it was handled in that special way was that we wanted Tomcat's own authentication system to access the MySQL server, where passwords etc would be stored. But that was given up early on).
If your database server is the MySQL server, then the necessary JAR file can be downloaded from the Connector/J site. At that site, choose the appropriate version for your OS.
On our system, we have put that JAR file into /opt/w2020/lib (earlier, in /usr/share/java), and sym-linked it to w2020/other-lib.
cd cd w2020/other-lib sudo ln -s /opt/w2020/lib/mysql-connector-java-8.0.20.jar
As of 2023, the above web site offers you downloading in the form a *.deb file, e.g. mysql-connector-j_8.1.0-1ubuntu22.04_all.deb . Once downloaded, you can install it with
dpkg -i mysql-connector-j_8.1.0-1ubuntu22.04_all.debTo find out what files you have actually downloaded by doing this, try
$ dpkg-deb -c mysql-connector-j_8.1.0-1ubuntu22.04_all.deb drwxr-xr-x root/root 0 2023-06-26 12:10 ./ drwxr-xr-x root/root 0 2023-06-26 12:10 ./usr/ drwxr-xr-x root/root 0 2023-06-26 12:10 ./usr/share/ drwxr-xr-x root/root 0 2023-06-26 12:10 ./usr/share/doc/ ... drwxr-xr-x root/root 0 2023-06-26 12:10 ./usr/share/java/ -rw-r--r-- root/root 2485886 2023-06-26 12:10 ./usr/share/java/mysql-connector-j-8.1.0.jar lrwxrwxrwx root/root 0 2023-06-26 12:10 ./usr/share/java/mysql-connector-java-8.1.0.jar -> mysql-connector-j-8.1.0.jarSo this tells you where the JAR file gets installed, and you can simply sym-link it into w2020/other-lib directory, instead of copying it.