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  <20182019  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  <20182019 
<== Date ==> <== Thread ==>

Subject: Re: CSS data browser to MySQL connection
From: "Kasemir, Kay via Tech-talk" <tech-talk@aps.anl.gov>
To: Vishnu Patel <vishnu.patel@rediffmail.com>, techtalk <tech-talk@aps.anl.gov>
Date: Tue, 9 Oct 2018 12:38:36 +0000

Hi:


Your stack trace doesn't match up with the current version of the sources.

In the middle of August, the MySQL driver was updated to support newer versions of the MySQL server, see

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

Comparing your stack trace for MySQL_RDB.java:50 against the current sources,

https://github.com/ControlSystemStudio/cs-studio/blob/master/core/platform/platform-plugins/org.csstudio.platform.utility.rdb/src/org/csstudio/platform/utility/rdb/internal/MySQL_RDB.java​,

it's not 100% clear what's null, but I assume it's the password.


-> Try starting CSS with a new workspace (or delete the .metadata folder in your existing workspace),

and set the password in the -pluginCustomization file passed on the command line.


-Kay


From: tech-talk-bounces@aps.anl.gov <tech-talk-bounces@aps.anl.gov> on behalf of Vishnu Patel <vishnu.patel@rediffmail.com>
Sent: Tuesday, October 09, 2018 6:59 AM
To: techtalk
Subject: CSS data browser to MySQL connection
 
Hi,
   Recently, the CSS stop connecting to MySQL data base. It gives an error,
 
2018-10-09 16:18:24.264 WARNING [Thread 48] org.csstudio.trends.databrowser3.archive.ConnectJob (run) - Cannot connect to archive jdbc:mysql://localhost/archive
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:460)
at org.csstudio.platform.utility.rdb.internal.MySQL_RDB.connect(MySQL_RDB.java:50)
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.reader.rdb.ConnectionCache.get(ConnectionCache.java:130)
at org.csstudio.archive.reader.rdb.RDBArchiveReader.<init>(RDBArchiveReader.java:108)
at org.csstudio.archive.reader.rdb.RDBArchiveReader.<init>(RDBArchiveReader.java:85)
at org.csstudio.archive.reader.rdb.RDBArchiveReaderFactory.getArchiveReader(RDBArchiveReaderFactory.java:48)
at org.csstudio.archive.reader.ArchiveRepository.getArchiveReader(ArchiveRepository.java:111)
at org.csstudio.trends.databrowser3.archive.ConnectJob.run(ConnectJob.java:46)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)



The same error window is displayed on the CSS as per attachment.

It was working fine but suddenly stop working.


I am not even able to set database password in CSS Applications->Trends->RDBArchive.


Thanks
Vishnu
 

Replies:
Re: CSS data browser to MySQL connection Vishnu Patel
References:
CSS data browser to MySQL connection Vishnu Patel

Navigate by Date:
Prev: CSS data browser to MySQL connection Vishnu Patel
Next: Re: Base R3.15.6-rc1 Published Jeong Han Lee
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  <20182019 
Navigate by Thread:
Prev: CSS data browser to MySQL connection Vishnu Patel
Next: Re: CSS data browser to MySQL connection Vishnu Patel
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  <20182019 
ANJ, 09 Oct 2018 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·