| 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 2025 | 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 2025 |
| <== 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.
|