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: neu lzf via Tech-talk <tech-talk at aps.anl.gov>
To: "Kasemir, Kay" <kasemirk at ornl.gov>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Thu, 29 Jun 2023 03:10:15 +0000
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

 

 

 

 

Replies:
RE: Question about fetching history data from MySQL by using phoebus CAOUEN Loic 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
Navigate by Date:
Prev: Senior Controls Engineer Position at Sigray Ernesto Paiser via Tech-talk
Next: RE: Question about fetching history data from MySQL by using phoebus CAOUEN Loic 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: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Next: RE: Question about fetching history data from MySQL by using phoebus CAOUEN Loic 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 ·