Experimental Physics and Industrial Control System
|
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":
-
the connection issue: Cannot connect to jdbc://mysql://192.168.1.230/archive as root
-
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.
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 |
·
Home
·
News
·
About
·
Base
·
Modules
·
Extensions
·
Distributions
·
Download
·
·
Search
·
EPICS V4
·
IRMIS
·
Talk
·
Bugs
·
Documents
·
Links
·
Licensing
·
|