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: [email protected] <[email protected]> on behalf of Vishnu Patel <[email protected]>
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