EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

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  <20202021  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  <20202021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Re: EPICS Archiver appliance MySQL Persistence error
From: Heinz Junkes via Tech-talk <tech-talk at aps.anl.gov>
To: Peter Linardakis <peter.linardakis at anu.edu.au>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Thu, 20 Feb 2020 09:33:19 +0100
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

Attachment: smime.p7s
Description: S/MIME cryptographic signature


Replies:
RE: EPICS Archiver appliance MySQL Persistence error Peter Linardakis via Tech-talk
References:
EPICS Archiver appliance MySQL Persistence error Peter Linardakis via Tech-talk

Navigate by Date:
Prev: Galil new "all in one" multi-axis amplifier [DLM=For-Official-Use-Only] CLIFT, Mark via Tech-talk
Next: Re: MRF Delay Compensation Function Javier Cereijo García via Tech-talk
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  <20202021  2022  2023  2024 
Navigate by Thread:
Prev: EPICS Archiver appliance MySQL Persistence error Peter Linardakis via Tech-talk
Next: RE: EPICS Archiver appliance MySQL Persistence error Peter Linardakis via Tech-talk
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  <20202021  2022  2023  2024 
ANJ, 20 Feb 2020 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·