Experimental Physics and
Industrial Control System

Hi all

 

Attempted to build a single machine installation of an EPICS archiver appliance using the install_scripts/single_machine_install.sh script.  Everything seemed to go OK with the install and the management URL displays correctly, except there are errors as below, which also show when you attempt to add a PV.  The MySQL daemon is running and I have added a connection pool to conf/contect.xml as per https://slacmshankar.github.io/epicsarchiver_docs/installguide.html (although the error is identical without it).

 

mysql-connector-java-8.0.19.jar is installed under /opt/archappl/tomcatinstances/apache-tomcat-9.0.31/lib/

 

 

…/mgmt/logs/arch.log

 

0    [main] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  - Archiver Appliance Version 0.0.1_SNAPSHOT_13-November-2019T15-45-42

1    [main] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  -

28   [main] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  - My identity is appliance0 and my mgmt URL is http://nucserver4:17665/mgmt/bpl

29   [main] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  - Loading archappl.properties from the webapp classpath /opt/archappl/tomcatinstances/mgmt/webapps/mgmt/WEB-INF/classes/archappl.properties

30   [main] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  - Done loading installation specific properties file from /opt/archappl/tomcatinstances/mgmt/webapps/mgmt/WEB-INF/classes/archappl.properties

…

11333 [Startup executor] INFO  config.org.epics.archiverappliance.config.persistence.MySQLPersistence  - Looking up datasource called jdbc/archappl in the java:/comp/env namespace using JDNI

11334 [Startup executor] INFO  config.org.epics.archiverappliance.config.persistence.MySQLPersistence  - Found datasource called jdbc/archappl in the java:/comp/env namespace using JDNI

11335 [Startup executor] INFO  config.org.epics.archiverappliance.config.DefaultConfigService  - Loading PVTypeInfo from persistence

11347 [Startup executor] ERROR config.org.epics.archiverappliance.config.DefaultConfigService  - Exception loading PVs from persistence java.io.IOException: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'

        at org.epics.archiverappliance.config.persistence.MySQLPersistence.getKeys(MySQLPersistence.java:145)

        at org.epics.archiverappliance.config.persistence.MySQLPersistence.getTypeInfoKeys(MySQLPersistence.java:51)

…

 

 

Relevant lines form the startup file are:

 

export JAVA_HOME=/usr/lib/jvm/jdk-13.0.2

…

export TOMCAT_HOME=/opt/archappl/tomcatinstances/apache-tomcat-9.0.31

…

export ARCHAPPL_DEPLOY_DIR=/opt/archappl/tomcatinstances

…

export ARCHAPPL_APPLIANCES=/opt/archappl/tomcatinstances/appliances.xml

export ARCHAPPL_MYIDENTITY="appliance0"

 

Am I missing something basic?

 

Regards

Peter

 

--

Dr Peter Linardakis

Senior Accelerator R&D Engineer

Nuclear Physics | Research School of Physics

Australian National University