Having trooble setting up CSS archive engine with mySQL

[David Michel <dmichel76@googlemail.com>]

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