Experimental Physics and
Industrial Control System

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.