Hi Gierula,
The storage server contains the qmon monitor (rt_qmon) to communicate with the process and operator stations, a database server program (sev_server) to store data, and a mysql database.
You can examine the database with mysql (here with user pwrp witch you should have added). The database is named pwrp__'projectname', here pwrp__pwrtest.
> mysql -u pwrp
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| pwrp__pwrtest |
+--------------------+
3 rows in set (0.00 sec)
mysql> use pwrp__pwrtest;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------------------+
| Tables_in_pwrp__pwrtest |
+------------------------------+
| O000_001_099_071_00001422__1 |
| O000_001_099_071_00001423__8 |
| O000_001_099_071_00001424__9 |
| O000_001_099_071_00001425__2 |
| O000_001_099_071_00001426__7 |
| O000_001_099_071_00001452__3 |
| O000_001_099_071_00001454__6 |
| O000_001_099_071_00001456__4 |
| O000_001_099_071_00001458__5 |
| items |
| objectitemattributes |
| objectitems |
| sev_stat |
| sev_version |
+------------------------------+
14 rows in set (0.00 sec)
mysql> select * from O000_001_099_071_00001458__5 where id % 1000 = 0;
+---------+---------------------+-----------+-----------+------+
| id | time | ntime | value | jump |
+---------+---------------------+-----------+-----------+------+
| 3802000 | 2016-01-18 03:35:25 | 959643525 | -84.1071 | 1 |
...
| 3803000 | 2016-01-18 03:42:25 | 383089462 | 86.3938 | 1 |
+---------+---------------------+-----------+-----------+------+
51 rows in set (0.06 sec)
In the item table you can see the connection between attribute and table.
There is also a browser, sev_xtt, where you can see the stored attributes and display curves.
Configuration and setting are made in /etc/proview.cnf. All configurations of attributes to store are made with the SevHist objects in the process nodes.
There is a database file on $pwrp_db/pwrp__'projectnanme'.db which is created together with the mysql database at the first startup. There is a common problem that if this file is created, but the creation of the database fails, this file has to be deleted before a new database is created. This problem is though fixed in recent versions.
/Claes
