EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
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: Having trooble setting up CSS archive engine with mySQL
From: David Michel <[email protected]>
To: EPICS mailing list <[email protected]>
Date: Mon, 12 Dec 2016 11:13:46 +0000
Hi All,

I'm currently trying to setup the CSS archiver engine with MySQL and seeing this error when running the ArchiveConfigTool:


./ArchiveConfigTool -pluginCustomization ~/archiver/ArchiveConfigTool/plugin_customization.ini -replace_engine -engine clf_dipole -config ~/archiver/ArchiveConfigTool/example_engineConfiguration.xml -import
Importing     : /home/swdev/archiver/ArchiveConfigTool/example_engineConfiguration.xml
Engine        : clf_dipole
Description   : Imported
URL           : http://localhost:4812/main
Replace engine: true
Steal channels: false
2016-12-12 10:52:10.473 SEVERE [Thread 1] org.csstudio.archive.config.rdb.ArchiveConfigApplication (start) - Exception
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:187)
        at org.csstudio.platform.utility.rdb.internal.MySQL_RDB.connect(MySQL_RDB.java:55)
        at org.csstudio.platform.utility.rdb.RDBUtil.<init>(RDBUtil.java:179)
        at org.csstudio.platform.utility.rdb.RDBUtil.connect(RDBUtil.java:143)
        at org.csstudio.archive.config.rdb.RDBArchiveConfig.<init>(RDBArchiveConfig.java:80)
        at org.csstudio.archive.config.rdb.XMLImport.<init>(XMLImport.java:123)
        at org.csstudio.archive.config.rdb.ArchiveConfigApplication.start(ArchiveConfigApplication.java:206)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:579)
        at java.net.Socket.connect(Socket.java:528)
        at java.net.Socket.<init>(Socket.java:425)
        at java.net.Socket.<init>(Socket.java:241)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
        ... 33 more


So, looks like it cannot connect to the database.... although it is running:

sudo service mysql start
start: Job is already running: mysql

 
I've just installed mysql (14.14) on my ubuntu machine with apt-get. All I did what set up the root password, create the archive and report user and run the schema with 
mysql> source ./mysql_schema.txt;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| archive            |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

mysql> use archive;
mysql> show tables;
+-------------------+
| Tables_in_archive |
+-------------------+
| array_val         |
| chan_grp          |
| channel           |
| enum_metadata     |
| num_metadata      |
| retent            |
| sample            |
| severity          |
| smpl_eng          |
| smpl_mode         |
| status            |
+-------------------+
11 rows in set (0.00 sec)


I have set the database ip, port and db user/password in the plugin_customization.ini as such:

org.csstudio.archive.rdb/url="" href="http://192.168.41.3:3306/archive">192.168.41.3:3306/archive
org.csstudio.archive.rdb/user=archive
org.csstudio.archive.rdb/password=archive



I'm probably missing an obvious step here.... any help would be greatly appreciated! Thanks!
David

Replies:
Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Navigate by Date:
Prev: CSS Beast mail notification Benjamin Hetz
Next: Re: 答复: 答复: MVME5500 and turbo-pmac-vme-ultralite Ron Sluiter
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 
Navigate by Thread:
Prev: CSS Beast mail notification Benjamin Hetz
Next: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
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 
ANJ, 12 Dec 2016 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·