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

[CAOUEN Loic via Tech-talk <tech-talk at aps.anl.gov>]

I can see you’re using a “LAN IP” (192.168.1.230)

Does it mean Phoebus and Mysql are not on the same server ?

If it’s the case, did you grant the privileges in mysql ?

You must allow the connection from the server where your phoebus runs.

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'your_phoebus_server_ip' IDENTIFIED BY 'your_root_password'

 

Regards

 

 

De : Tech-talk <tech-talk-bounces at aps.anl.gov> De la part de neu lzf via Tech-talk
Envoyé : jeudi 29 juin 2023 05:10
À : Kasemir, Kay <kasemirk at ornl.gov>
Cc : tech-talk at aps.anl.gov
Objet : Re: Question about fetching history data from MySQL by using phoebus

 

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