Re: Question about fetching history data from MySQL by using phoebus

[neu lzf via Tech-talk <tech-talk at aps.anl.gov>]

Hi Kay,

Thanks for your reply.

I try to use binary SNS version of Phoebus and I checked the product/lib folder and found that the file mysql-connector-java-8.0.30.jar is present.

However, both problems are still exists when I run "sh phoebus.sh":

1. the connection issue: Cannot connect to jdbc://mysql://192.168.1.230/archive as root
   
   
2. Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive

The user name "root" and password are the same as CSS, which is successful to connect to MySQL.

The rdb channel archiver I used is for CSS version: archive-engine-4.5.0-linux.gtk.x86_64.zip and archive-config-4.5.0-linux.gtk.x86_64.zip

I have no idea what the problem is and I wonder if I should change my rdb channel archiver version from for CSS to for phoebus (https://controlssoftware.sns.ornl.gov/css_phoebus/nightly/) : archive-engine.zip.

Is that the issue?

Thanks you very much in advance.

---

From: Kasemir, Kay <kasemirk at ornl.gov>
Sent: 28 June 2023 13:09
To: neu lzf <lzfneu at live.com>; tech-talk at aps.anl.gov <tech-talk at aps.anl.gov>
Subject: Re: Question about fetching history data from MySQL by using phoebus

 

> org.csstudio.trends.databrowser3/urls=jdbc:mysql://192.168.1.230/archive

> org.csstudio.trends.databrowser3/archives=jdbc:mysql://192.168.1.230/archive

> …

> Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive

 

If there was a connection issue, you’d see an error like

 

        Cannot connect to jdbc:mysql://192.168.1.230/archive

 

“No suitable driver found”  suggests that your product simply doesn’t include the MySQL library.

In your_product/lib, there should be a file mysql-connector-java-8.0.30.jar

Is that not present?

Try a binary like the one from https://controlssoftware.sns.ornl.gov/css_phoebus/ which should include it.

 

-Kay