Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  <2017 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
<== Date ==> <== Thread ==>

Subject: Re: help for RDB of CSS
From: "Kasemir, Kay" <kasemirk@ornl.gov>
To: 梁雅翔 <liangyx@ihep.ac.cn>, tech-talk <tech-talk@aps.anl.gov>
Date: Tue, 8 Aug 2017 14:36:47 +0000
Hi:

From: tech-talk-bounces@aps.anl.gov <tech-talk-bounces@aps.anl.gov> on behalf of 梁雅翔 <liangyx@ihep.ac.cn>
>  Hi everyone,
>  I am studying the database of CSS.
>  I created a database named "test" and tables named "collmn" in mysql,adding some value myself.
>  I had connected the database(the test database I created) with eclipse successfully.
>  Then I tried to use it in CSS.
>  After I type the URL "jdbc:mysql://localhost:3306/test?user=root&passowrd=123" in CSS preference, I got the message "Error connecting to archiver server......Detail:Table 'test.status' doesn't exist".
>  I am not good at the database. And it took me several weeks to connected the mysql with eclipse.
>
>  I want some help.
> Could someone please tell me how to do it next? It is better that you have some example.
Right, there better be examples.
Check the CSS docbook, http://cs-studio.sourceforge.net/docbook/css_book.pdf, especially the chapters "10 Relational Database" and "11 Archive System".

To elaborate, from what you write I understand that you created a database named "test" and tables named "collmn" in mysql.
You can create many databases: A database with tables for names and addresses, flowers, your CD or MP3 collection.
CSS does not include tools to browse just any generic database.
The CSS Data Browser supports a very specific database with archived control system data.
The schema is described in the docbook.
The actual MySQL schema can be found in
https://github.com/ControlSystemStudio/cs-studio/blob/master/applications/archive/archive-plugins/org.csstudio.archive.rdb/dbd/mysql_schema.txt

As you can see in the schema, there needs to be a table named 'status':

# ----------------------
# Status mapping of status ID to string
DROP TABLE IF EXISTS status;
CREATE TABLE IF NOT EXISTS status
(
   status_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
   name VARCHAR(100) NOT NULL UNIQUE
);
INSERT INTO status (name) VALUES ('OK'), ('disconnected');
SELECT * FROM status;

The CSS code for reading archived data expects to find such a "status" table, but your database doesn't include one, so you get the error message
"Error connecting to archiver server......Detail:Table 'test.status' doesn't exist".

Thanks,
Kay

References:
help for RDB of CSS 梁雅翔

Navigate by Date:
Prev: Re: CA monitoring weirdness for status/severity Hogben, Colin H
Next: Re: CA monitoring weirdness for status/severity Pete Jemian
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
Navigate by Thread:
Prev: help for RDB of CSS 梁雅翔
Next: agilent 34972a Pierrick Hanlet
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
ANJ, 09 Aug 2017 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·