install_scripts missing files and wrong permissions

[prichards-wmko]

I encountered two distinct problems with the install_scripts directory during my latest install.

First, the Python scripts are not initially set executable so the installer fails:
./single_machine_install.sh: line 187: ./deployMultipleTomcats.py: Permission denied

Second, the installation tarball is missing files in the install_scripts directory:
./single_machine_install.sh: line 247: ./archappl_mysql.sql: No such file or directory

I unpacked the mgmt.war file to find the needed file and placed it where the install script could find it. This worked.

Full detail below. Disregard the Tomcat 9 mentioned here, I tried to follow the instructions in the documentation site which still calls for Tomcat 9. I see the release notes recently changed that to Tomcat 11. A subsequent install with the right version fixed that for me.

k1obstcs@HQ-SW-Arch1:/usr/local/archive/install/archappl/install_scripts$ ./single_machine_install.sh
This script runs thru a typical install scenario for a single machine
You can use this to create a standard multi-instance (one Tomcat for ear WAR) tomcat deployment in a multi machine cluster by setting the ARCHAPPL_APPLIANCES and the ARCHAPPL_MYIDENTITY
For installations in a cluster, please do create a valid appliances.xml and export ARCHAPPL_APPLIANCES and ARCHAPPL_MYIDENTITY
openjdk version "25.0.2" 2026-01-20
0
Pick a folder (preferably empty) where you'd like to create the Tomcat instances.
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Gtk-Message: 09:52:44.539: GtkDialog mapped without a transient parent. This is discouraged.
Setting DEPLOY_DIR to /usr/local/archive/tomcat
Where's the Tomcat distribution (tar.gz)?
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Gtk-Message: 09:52:51.462: GtkDialog mapped without a transient parent. This is discouraged.
/usr/local/archive/tomcat /usr/local/archive/install/archappl/install_scripts
/usr/local/archive/install/archappl/install_scripts
Setting TOMCAT_HOME to /usr/local/archive/tomcat/apache-tomcat-9.0.115
/usr/local/archive/tomcat/apache-tomcat-9.0.115/bin /usr/local/archive/install/archappl/install_scripts
/usr/local/archive/install/archappl/install_scripts
/usr/local/archive/tomcat/apache-tomcat-9.0.115/bin/commons-daemon-1.5.1-native-src/unix /usr/local/archive/install/archappl/install_scripts
*** Current host ***
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking cached host system type... ok
*** C-Language compilation tools ***
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables... 
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether the compiler supports GNU C... yes
checking whether gcc accepts -g... yes
checking for gcc option to enable C11 features... none needed
checking for ranlib... ranlib
checking for strip... strip
*** Host support ***
checking C flags dependant on host system type... ok
*** Java compilation tools ***
checking for JDK os include directory...  linux
gcc flags added
checking for stdio.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for strings.h... yes
checking for sys/stat.h... yes
checking for sys/types.h... yes
checking for unistd.h... yes
checking for sys/capability.h... no
configure: WARNING: cannot find headers for libcap
*** Writing output files ***
configure: creating ./config.status
config.status: creating Makefile
config.status: creating Makedefs
config.status: creating native/Makefile
*** All done ***
Now you can issue "make"
(cd native; make  all)
make[1]: Entering directory '/usr/local/archive/tomcat/apache-tomcat-9.0.115/bin/commons-daemon-1.5.1-native-src/unix/native'
gcc   jsvc-unix.o libservice.a -ldl -lpthread -o ../jsvc
make[1]: Leaving directory '/usr/local/archive/tomcat/apache-tomcat-9.0.115/bin/commons-daemon-1.5.1-native-src/unix/native'
/usr/local/archive/install/archappl/install_scripts
Where's the mysql client jar? - this is named something like mysql-connector-java-5.1.21-bin.jar.
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Gtk-Message: 09:53:04.035: GtkDialog mapped without a transient parent. This is discouraged.
Done copying the mysql client library to /usr/local/archive/tomcat/apache-tomcat-9.0.115/lib
I see you have not defined the ARCHAPPL_APPLIANCES environment variable. If we proceed, I'll automatically generate one in /usr/local/archive/tomcat. Should we proceed?
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Calling ./deployMultipleTomcats.py /usr/local/archive/tomcat
Using
	tomcat installation at /usr/local/archive/tomcat/apache-tomcat-9.0.115 
	to generate deployments for appliance appliance0 
	using configuration info from /usr/local/archive/tomcat/appliances.xml 
	into folder /usr/local/archive/tomcat
The start/stop port is the standard Tomcat start/stop port. Changing it to something else random - 16000
The stop/start ports for the new instance will being at  16001
Generating tomcat folder for  mgmt  in location /usr/local/archive/tomcat/mgmt
Generating tomcat folder for  engine  in location /usr/local/archive/tomcat/engine
Generating tomcat folder for  etl  in location /usr/local/archive/tomcat/etl
Generating tomcat folder for  retrieval  in location /usr/local/archive/tomcat/retrieval
Please enter a MySQL Connection string to an existing database like so
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Setting MYSQL_CONNECTION_STRING to --user=archappl --password=archappl --database=archappl
mysql: [Warning] Using a password on the command line interface can be insecure.
information_schema
mysql: [Warning] Using a password on the command line interface can be insecure.
I do not see the PVTypeInfo table in --user=archappl --password=archappl --database=archappl? Should we go ahead and create the tables? This step will delete any old data that you have.
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
Creating tables in --user=archappl --password=archappl --database=archappl
./single_machine_install.sh: line 247: ./archappl_mysql.sql: No such file or directory
mysql: [Warning] Using a password on the command line interface can be insecure.
Cannot create the MySQL tables. Do you have the right permissions?
libEGL warning: DRI3 error: Could not get DRI3 device
libEGL warning: Ensure your X server supports DRI3 to get accelerated rendering
k1obstcs@HQ-SW-Arch1:/usr/local/archive/install/archappl/install_scripts$ ls
addMysqlConnPool.py  deployMultipleTomcats.py  sampleStartup.sh  single_machine_install.sh