RE: EPICS Archiver appliance MySQL Persistence error

[Peter Linardakis via Tech-talk <tech-talk at aps.anl.gov>]

Hi Heinz

Thank you for the reply.  I cleaned my /conf/context.xml file to match the default upon install and ran install_scripts/addMysqlConnPool.py.  This inserts a "Resource" section as expect.  I still get the same error.  I have also confirmed that the MySQL daemon is running and listening on the correct port via netstat.

Regards
Peter

-----Original Message-----
From: Heinz Junkes [mailto:junkes at fhi-berlin.mpg.de] 
Sent: Thursday, 20 February 2020 7:33 PM
To: Peter Linardakis <peter.linardakis at anu.edu.au>
Cc: tech-talk at aps.anl.gov
Subject: Re: EPICS Archiver appliance MySQL Persistence error

Dear Peter,

in my installation i have a file context.xml, it includes an url to the database:

...
<Resource   name="jdbc/archappl"
      auth="Container"
      type="javax.sql.DataSource"
      factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
      username="archappl"
      password="archappl"
      testWhileIdle="true"
      testOnBorrow="true"
      testOnReturn="false"
      validationQuery="SELECT 1"
      validationInterval="30000"
      timeBetweenEvictionRunsMillis="30000"
      maxActive="10"
      minIdle="2"
      maxWait="10000"
      initialSize="2"
      removeAbandonedTimeout="60"
      removeAbandoned="true"
      logAbandoned="true"
      minEvictableIdleTimeMillis="30000"
      jmxEnabled="true"
      driverClassName="com.mysql.jdbc.Driver"
      url="jdbc:mysql://localhost:3306/archappl"
 />

</Context>

To be honest, I don't know exactly where the file came from, but here I found a reference to it:

install_scripts/addMysqlConnPool.py


Viele Grüße
Heinz Junkes
--
Experience directly varies with equipment ruined.



> On 20. Feb 2020, at 06:14, Peter Linardakis via Tech-talk <tech-talk at aps.anl.gov> wrote:
> 
> 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