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: CSS data browser to MySQL connection
From: "Vishnu Patel" <vishnu.patel@rediffmail.com>
To: "techtalk" <tech-talk@aps.anl.gov>
Date: 9 Oct 2018 10:59:38 -0000
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
 

Attachment: Screenshot_from_2018-10-09_16-22-52.png
Description: PNG image


Replies:
Re: CSS data browser to MySQL connection Kasemir, Kay via Tech-talk

Navigate by Date:
Prev: Git vulnerability: update your clients! Ralph Lange
Next: Re: CSS data browser to MySQL connection Kasemir, Kay 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  <20182019 
Navigate by Thread:
Prev: Git vulnerability: update your clients! Ralph Lange
Next: Re: CSS data browser to MySQL connection Kasemir, Kay 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  <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 ·