From: firstname.lastname@example.org <email@example.com> on behalf of 梁雅翔 <firstname.lastname@example.org>
> 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
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".
- help for RDB of CSS 梁雅翔
- Navigate by Date:
Re: CA monitoring weirdness for status/severity Hogben, Colin H
Re: CA monitoring weirdness for status/severity Pete Jemian
- Navigate by Thread:
help for RDB of CSS 梁雅翔
agilent 34972a Pierrick Hanlet