1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 <2020> 2021 2022 2023 2024 | Index | 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 <2020> 2021 2022 2023 2024 |
<== Date ==> | <== Thread ==> |
---|
Subject: | EPICS Archiver appliance MySQL Persistence error |
From: | Peter Linardakis via Tech-talk <tech-talk at aps.anl.gov> |
To: | "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov> |
Date: | Thu, 20 Feb 2020 05:14:53 +0000 |
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 |