Deployment of the Archiver Appliance

[LONG FENG via Tech-talk <tech-talk at aps.anl.gov>]

Hi all,

When I use the install_scripts/single_machine_install.sh script to install the Archiver Appliance, it always reports an error. The error message is as follows:  

*** All done ***
Now you can issue "make"
(cd native; make  all)
make[1]: Entering directory '/ics/tools/archiver/tomcat/apache-tomcat-9.0.100/bin/commons-daemon-1.4.1-native-src/unix/native'
gcc   jsvc-unix.o libservice.a -ldl -lpthread -o ../jsvc
make[1]: Leaving directory '/ics/tools/archiver/tomcat/apache-tomcat-9.0.100/bin/commons-daemon-1.4.1-native-src/unix/native'
/ics/tools/archiver/install_scripts
Where's the mysql client jar? - this is named something like mysql-connector-java-5.1.21-bin.jar.
Done copying the mysql client library to /ics/tools/archiver/tomcat/apache-tomcat-9.0.100/lib
I see you have not defined the ARCHAPPL_APPLIANCES environment variable. If we proceed, I'll automatically generate one in /ics/tools/archiver/tomcat. Should we proceed?
Calling ./deployMultipleTomcats.py /ics/tools/archiver/tomcat
Using
tomcat installation at /ics/tools/archiver/tomcat/apache-tomcat-9.0.100
to generate deployments for appliance appliance0
using configuration info from /ics/tools/archiver/tomcat/appliances.xml
into folder /ics/tools/archiver/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
Removing  /ics/tools/archiver/tomcat/mgmt
Generating tomcat folder for  mgmt  in location /ics/tools/archiver/tomcat/mgmt
Removing  /ics/tools/archiver/tomcat/engine
Generating tomcat folder for  engine  in location /ics/tools/archiver/tomcat/engine
Removing  /ics/tools/archiver/tomcat/etl
Generating tomcat folder for  etl  in location /ics/tools/archiver/tomcat/etl
Removing  /ics/tools/archiver/tomcat/retrieval
Generating tomcat folder for  retrieval  in location /ics/tools/archiver/tomcat/retrieval
Please enter a MySQL Connection string to an existing database like so
Setting MYSQL_CONNECTION_STRING to --user=archappl --password=archappl --database=archappl
information_schema
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.
Creating tables in --user=archappl --password=archappl --database=archappl
./single_machine_install.sh: line 247: ./archappl_mysql.sql: No such file or directory
Cannot create the MySQL tables. Do you have the right permissions?

What could be the cause of this issue? I have checked the permissions of the archappl database, and they seem fine. I have successfully installed it this way before, but recently, when I try to install it on a new computer, this problem keeps occurring.

Feng