CSS Folks,
The SNS CSS MessageRDB has MySQL sample tables found in:
org.csstudio.sns.jms2rdb/dbd/MySQL-Log-DDL.sql
This includes the following text:
# NOTE:
# The msghist tool uses subselect queries as shown below
# to do a full search for properties that are not optimized
# as MESSAGE columns.
# Those subselect statements only work in MySQL 6.x.
# MySQL 5.x will just hang forever in them as soon as there
# are a few rows in the MESSAGE* tables
I am confused about MySQL versions referenced here. The latest stable
version appears to be 5.5? Can you clarify?
BTW: I was able to download and build SNS CSS sources for the purpose of
trying out BEAST. Considering the number of steps involved
1) operational mysql RDB configured with Alarm tables
2) operational Java Message Service
3) working Eclipse installation
4) download Control System Studio source and build
5) configure Alarm RDB using AlarmConfigTool (a CSS product)
6) run AlarmServer (another CSS product)
7) run CSS with AlarmTree and Alarm Table plug-ins
I thought things went remarkably smoothly. So thanks for that!
John Dobbins
Cornell Laboratory for Accelerator Sciences and Education (CLASSE)
Cornell University
- Replies:
- Re: SNS CSS Message RDB Kasemir, Kay
- Navigate by Date:
- Prev:
Chjannel Access Client for Twitter John Quintana
- Next:
RE: EPICS on Delta Tau Power PMAC Mark Rivers
- 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: EPICS on Delta Tau Power PMAC Bill Lavender
- Next:
Re: SNS CSS Message RDB Kasemir, Kay
- 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
|