Re: Question about fetching history data from MySQL by using phoebus

[Han Lee via Tech-talk <tech-talk@aps.anl.gov>]

The correct, for example, configurations are, 

---- snip snip ---

org.csstudio.trends.databrowser3/archives=Current|0|pbraw\://your_host_name\:17668/retrieval

org.csstudio.trends.databrowser3/urls=pbraw\://your_host_name\:17668/retrieval
---- snip snip ---

HTH,

Han

On Tue, Jun 27, 2023 at 7:39 PM neu lzf via Tech-talk <tech-talk@aps.anl.gov> wrote:

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.

--

Jeong Han Lee, Dr.rer.nat.

Staff Scientist and Engineer

Cell: +1 510 384 3868

https://orcid.org/0000-0002-1699-2660