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: Re: CS-Studio Archive engine data base connection error
From: "Kasemir, Kay" <[email protected]>
To: Vishnu Patel <[email protected]>, techtalk <[email protected]>
Date: Thu, 16 Aug 2018 13:00:46 +0000

We'll need to update the MySQL connector version, or you need to use an older version of MySQL.


https://github.com/ControlSystemStudio/cs-studio/issues/2491​


-Kay


From: [email protected] <[email protected]> on behalf of Vishnu Patel <[email protected]>
Sent: Thursday, August 16, 2018 1:50 AM
To: techtalk
Subject: CS-Studio Archive engine data base connection error
 
Hi,
   I tried to configure CS-Studio Archive engine on Windows 10 system with MySQL.
Configure with "ArchiveConfigTool.exe  -pluginCustomization setting.ini -import -engine WIN218 -config ls218arch.xml" command
While running archive engine getting below error.
 
2018-08-16 11:11:19.182 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix pva provided by pva in org.csstudio.vtype.pv
2018-08-16 11:11:19.202 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix ca provided by ca in org.csstudio.vtype.pv
2018-08-16 11:11:19.202 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix ca provided by epics in org.csstudio.vtype.pv
2018-08-16 11:11:19.202 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix loc provided by loc in org.csstudio.vtype.pv
2018-08-16 11:11:19.202 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix sim provided by sim in org.csstudio.vtype.pv
2018-08-16 11:11:19.202 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - PV prefix mqtt provided by mqtt in org.csstudio.vtype.pv
2018-08-16 11:11:19.212 CONFIG [Thread 1] org.csstudio.vtype.pv.PVPlugin (start) - Default PV type ca
2018-08-16 11:11:19.212 INFO [Thread 1] org.csstudio.archive.engine.Application (start) - Archive Engine 4.0.0.201808101709
2018-08-16 11:11:19.412 INFO [Thread 1] org.csstudio.archive.engine.server.EngineServer (<init>) - Engine HTTP Server on http://localhost:4812/main
2018-08-16 11:11:19.412 INFO [Thread 1] org.csstudio.archive.engine.Application (start) - Reading configuration 'WIN218'
2018-08-16 11:11:19.732 SEVERE [Thread 1] org.csstudio.archive.engine.Application (start) - Cannot read configuration
org.eclipse.core.runtime.CoreException: Plug-in "org.csstudio.archive.config.rdb" was unable to instantiate class "org.csstudio.archive.config.rdb.RDBArchiveConfig".
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.throwException(RegistryStrategyOSGI.java:194)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:186)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:905)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at org.csstudio.archive.config.ArchiveConfigFactory.getArchiveConfig(ArchiveConfigFactory.java:37)
at org.csstudio.archive.engine.Application.start(Application.java:220)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2326)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.csstudio.platform.utility.rdb.internal.MySQL_RDB.connect(MySQL_RDB.java:56)
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:82)
at org.csstudio.archive.config.rdb.RDBArchiveConfig.<init>(RDBArchiveConfig.java:68)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)
... 17 more
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:2999)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1885)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1814)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2249)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2280)
... 40 more



Thanks
Vishnu
References:
CS-Studio Archive engine data base connection error Vishnu Patel
Navigate by Date:
Prev: CS-Studio Archive engine data base connection error Vishnu Patel
Next: Build "std" against base 3.14.12.3 Hu, Yong
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: CS-Studio Archive engine data base connection error Vishnu Patel
Next: Build "std" against base 3.14.12.3 Hu, Yong
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, 16 Aug 2018 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·