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: Question about fetching history data from MySQL by using phoebus
From: neu lzf via Tech-talk <tech-talk at aps.anl.gov>
To: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Wed, 28 Jun 2023 02:39:14 +0000
Hi,

I am using epics 3.15.9 on CentOS 7 OS and recently from using Control system studio (CSS) to phoebus, in order to fetch history data from MySQL, I config the settings.ini file for phoebus just like the configuration in CSS as follows:

org.phoebus.archive.reader.rdb/user=My_username
org.phoebus.archive.reader.rdb/password=My_password
org.phoebus.archive.reader.rdb/prefix=
org.phoebus.archive.reader.rdb/stored_procedure=
#org.phoebus.archive.reader.rdb/starttime_function=
#org.csstudio.trends.databrowser3/concurrent_requests=4
org.csstudio.trends.databrowser3/urls=jdbc:mysql://192.168.1.230/archive
org.csstudio.trends.databrowser3/archives=jdbc:mysql://192.168.1.230/archive
org.csstudio.trends.databrowser3/use_default_archives=true
org.csstudio.trends.databrowser3/drop_failed_archives=false

however, after runing "sh phoebus.sh", the Error is:
Cannot connect to jdbc:mysql://192.168.1.230/archive as My_username
......
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive
......

I wonder if I miss some configuration for phoebus, while the configuration for CSS is working.
Any help will be appreciated and thanks in advance.


Replies:
Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Navigate by Date:
Prev: Use phoebus toggle to adjust sign for ao record? Leblanc, Gregory via Tech-talk
Next: Re: Question about fetching history data from MySQL by using phoebus Han Lee 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: Use phoebus toggle to adjust sign for ao record? Leblanc, Gregory via Tech-talk
Next: Re: Question about fetching history data from MySQL by using phoebus Han Lee 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 ·