EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024  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  2018  2019  2020  2021  2022  <2023>  2024 
<== Date ==> <== Thread ==>
Subject: RE: Question about fetching history data from MySQL by using phoebus
From: CAOUEN Loic via Tech-talk <tech-talk at aps.anl.gov>
To: neu lzf <lzfneu at live.com>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Thu, 29 Jun 2023 11:53:47 +0000

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

 

  1. 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

 

 

 

 

Replies:
Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
References:
Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Navigate by Date:
Prev: Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Next: Re: Question about fetching history data from MySQL by using phoebus 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  2018  2019  2020  2021  2022  <2023>  2024 
Navigate by Thread:
Prev: Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Next: Re: Question about fetching history data from MySQL by using phoebus 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  2018  2019  2020  2021  2022  <2023>  2024 
ANJ, 29 Jun 2023 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·