SCSArchiverCSStudio < DaqSlowControl

You are here: Hades Wiki>DaqSlowControl Web>HadesDaqDocumentation>DetectorControlSystem>SCSArchiverCSStudio (26 Apr 2021, PeterZumbruch) (raw view)EditAttach
<!--
   * Set ALLOWTOPICCHANGE = Main.HadesDaqSlowControlGroup
   * Set PLUGIN_CUSTOMIZATION_FILE = settings_hades_scs_css_archive.ini
   * Set NOWYSIWYG = 1
   * Set TINYMCEPLUGIN_DISABLE = 1
-->
---+!! _RDB Archiver based on CS-Studio_
<table>
<tr style="vertical-align:top">
<td style="padding-right:1ex">%TOC{depth="3" title="Table of Content (short)"}%</td>
<td style="border-left:1px solid #D7d7d7;padding-left:2em;margin-left:2em"><div class="foswikiToc"><span class="foswikiTocTitle">Detailed Table of Content</span>%INCLUDE{"ToolsHiddenSection" section="header - blank - no fence"}% %TOC% %INCLUDE{"ToolsHiddenSection" section="trailer - blank - no fence" section_names="Detailed Table of Content"}%</div> </td>
</tr>
</table>
%STARTINCLUDE%
%CALC{"$IF($EXACT(%INCLUDINGTOPIC%,%TOPIC%),,<div style="text-align:right" class='TMLhtml' >%TOPIC% (<a style=\"font-size:smaller\" href="%SCRIPTURLPATH%/edit%SCRIPTSUFFIX%/%WEB%/%TOPIC%\">edit</a>)</div>)"}%
<div style=""> 
%FOREACH{"css-address" in="https://github.com/ControlSystemStudio/cs-studio"}%
---++ Introduction
<img src="http://cs-studio.sourceforge.net/docbook/archive.png" width="600" /> %BR%(from <a href="http://cs-studio.sourceforge.net/docbook/archive.png">http://cs-studio.sourceforge.net/docbook/archive.png</a>)
%BR%
The CS-Studio RDB Archiver Engine 
archives EPICS Process Variables into an RDB (__<nop>PostgreSQL__, !MySQL, Oracle).
Stored data can be retrieved via CS-Studio __RDB Archive Reader__
or any other SQL aware application.
---
---++ Documents
   * [[http://cs-studio.sourceforge.net/docbook/ch11.html][Chapter 11. Archive System - Part I. CS-Studio Guide]], [[http://cs-studio.sourceforge.net/docbook/css_book.pdf][%ICON{"pdf"}%]]
   * [[$css-address/wiki/RDBArchiveEngine][github: RDB Archive Engine]]
---
---++ Setup / Installation
Needs:
   * Database configuration / optional installation
   * Archiver Engine configuration
<div style="margin-left:2em">
---+++ Database
<div style="margin-left:2em">
%FOREACH{"file" in="postgres_schema.txt"}%
%FOREACH{"path" in="master/applications/archive/archive-plugins/org.csstudio.archive.rdb/dbd"}%
%FOREACH{"prefix" in="SCSArchiverCSStudioPostgreSql"}%
---++++ <nop>PostgreSQL hosted by GSI central services

%INCLUDE{"ToolsHiddenSection" section="header - blank"}% 
GSI PostgreSQL administrative contact: T.Badura@gsi.de
---+++++ Role/User/Permissions
<!-- 
   * Set YES=%ICON{choice-yes}%
   * Set NO=%ICON{choice-no}%
-->
| *Hostname Port* ||  ==pgsqltest.gsi.de 6846==  |||||||||
|*Database*                       ||*==hades_scs_css_archive==*      |||| |*==css_ee==*                      |||| 
|  |                              |              |*permissions*       ||| |              |*permissions*       |||  
|  |*user/role*                   |              |*read*|*write*|*admin*| |              |*read*|*write*|*admin*|
|^ |_pzumbruch_                   |              |%YES% |%YES%  |%YES%  | |              |%YES% |%YES%  |%YES%  | 
|^ |_"p.zumbruch"_                |              |%YES% |%YES%  |%YES%  | |              |%YES% |%YES%  |%YES%  | 
|^ |_epics_                       |              |      |       |       | |pw: m7Z6a1B7g2|%YES% |%NO%   |%NO%   |  
|^ |_hades_scs_css_archive_read_  |pw: k2E4g7D1c8|%YES% |%NO%   |%NO%   | |              |      |       |       | 
|^ |_hades_scs_css_archive_       |              |%YES% |%YES%  |%NO%   | |              |      |       |       | 
|^ |_hades_scs_css_archive_admin_ |              |%YES% |%YES%  |%YES%  | |              |      |       |       | 
|^ |_"m.traxler"_                 |              |%YES% |%YES%  |%YES%  | |              |      |       |       | 
|^ |_"j.adamczewski-musch"_       |              |%YES% |%YES%  |%YES%  | |              |      |       |       | 

---
---+++++ Configuration

| *Hostname*   || ==pgsqltest.gsi.de==                     |
| *Port*       || ==6846==                                 |
| *Name*       || ==hades_scs_css_archive== |  ==css_ee==  |
| *SSL*        ||                                          | 
| * based on * || [[$css-address/blob/$path/$file][CS-Studio provided postgres scheme]] [[$css-address/raw/$path/$file][(raw)]] [[%ATTACHURL%/$file][(local)]] and \
                  [[$css-address/blob/$path/$file][CS-Studio provided partitioning]] [[$css-address/raw/$path/postgres_partitioning.txt][(raw)]] [[%ATTACHURL%/postgres_partitioning.txt][(local)]] ||

---
---+++++ Configuration - Load Schema
<div style="margin-left:2em">
---++++++ hades_scs_css_archive
<div style="margin-left:2em">
---
%INCLUDE{"SCSArchiverCSStudioConfigurationScripts" database_host="pgsqltest.gsi.de" port="6846" database="hades_scs_css_archive" url="$css-address/raw/$path/$file" schema="hades_scs_css_archive"}%
---
</div>
---++++++ css_ee
<div style="margin-left:2em">
---
%INCLUDE{"SCSArchiverCSStudioConfigurationScripts" database_host="pgsqltest.gsi.de" port="6846" database="css_ee" url="$css-address/raw/$path/$file" schema="css_ee"}%
---
</div>
%NEXT{"prefix"}%
%NEXT{"path"}%
%NEXT{"file"}%

%INCLUDE{"ToolsHiddenSection" section="trailer - blank"}% 

---
---++++ <nop>PostgreSQL hosted "locally" w/ option for NOSSL

%INCLUDE{"ToolsHiddenSection" section="header - blank"}%
---+++++ Installation
<div style="margin-left:2em">
%INCLUDE{"ToolsHiddenSection" section="header - blank"}%
---++++++ Install
      * Debian 
%CODE{"bash"}% $ apt-get install postgresql postgresql-client %ENDCODE%
      * Suse Leap 42.1 %BR% q.v. https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1

%FOREACH{"version" in="9.6"}%
---++++++ fully prepared: Git Repository 
%FOREACH{"url" in="https://git.gsi.de/HADES/DCS/EPICS/Services/Archiver/Postgres-Server-Configuration"}%
   * $url
%CODE{"bash"}%
   branch=$version && 
   sudo su -c "cp -r /etc/postgresql /tmp/postgresql && 
                    for item in $(ls -A /etc/postgresql/* | xargs); do rm -r /etc/postgresql/$item; done &&
                    git clone --branch ${branch:?} $url /etc/postgresql &&
                    chown postgres:postgres -R /etc/postgresql"
%ENDCODE%
%NEXT{"url"}%

---++++++ by-hand: Server Connectivity
%INCLUDE{"ToolsHiddenSection" section="header - blank"}% 
in: ==/etc/postgresql/$version/main/postgresql.conf== %BR%

change
%CODE%
listen_addresses = 'localhost'          
%ENDCODE%
to  
%CODE%
listen_addresses = '*'          
%ENDCODE%ls 

and add in ==/etc/postgresql/$version/main/pg_hba.conf==
%CODE%
%FOREACH{"ip" in="140.181.75.165/18 140.181.80.125/18 140.181.93.18/18"}%
hostnossl        all               all          $ip     trust
%NEXT{"ip"}%
hostnossl        all               all          140.181.75.165/18     trust
hostnossl        all               all          140.181.80.125/18     trust
hostnossl        all               all          140.181.93.18/18      trust
hostnossl        all               archiver     samehost              trust
hostnossl        all               report       samenet               trust
%ENDCODE%

in: ==/etc/postgresql/$version/main/postgresql.conf== %BR%
the data directory is set to: 
%CODE%
data_directory = '/var/lib/postgresql/$version/main'         # use data in another directory
%ENDCODE%
should be changed to a bigger directory:
%CODE%
data_directory = '/data.postgres/postgresql/$version/main'         # use data in another directory
%ENDCODE%
%NEXT{"version"}%
%INCLUDE{"ToolsHiddenSection" section="trailer - blank"}%

---++++++ start/restart
%CODE{"bash"}%
# service postgresql restart; service postgresql status
%ENDCODE%
</div>
%INCLUDE{"ToolsHiddenSection" section="trailer - blank"}%
---

<!-- ---+++++ Configuration, now via include-->
%INCLUDE{"SCSArchiverCSStudioPostgresDatabaseConfigurationLocal" commentSuffix=" (current)" host="lxhaddcs10" port="5432" database="archive" schema="public" userArchiver="archiver" pwArchiver="$archive" userReport="report" pwReport="$report" pgOwner="archiver" level="+++++"}%
---
%INCLUDE{"SCSArchiverCSStudioPostgresDatabaseConfigurationLocal" commentSuffix=" (future)" host="lxhaddcs10" port="5432" database="archive" schema="archive" userArchiver="archiver" pwArchiver="$archive" userReport="report" pwReport="$report" pgOwner="postgres" level="+++++"}%

---
%INCLUDE{"ToolsHiddenSection" section="trailer - blank"}% 

---
</div>
</div>
---+++ CS-Studio - RDB Archiver 
Currently located at %RED% ==lxhadeb06== %ENDCOLOR%
 
<div style="margin-left:2em">
---++++ Requirements
   * CS-Studio 4 requires at least Java 8 by Oracle. Therefore make sure you have it installed:
      * q.v. https://docs.oracle.com/javase/8/docs/technotes/guides/install/install_overview.html#CJAGAACB

---++++ Sources download
Current versions can be build on its own based on the GIT hub repository of CS-Studio:
Prebuilt binaries can be found at [[https://ics-web.sns.ornl.gov/css/updates/apps/]]
Look for:
   * __archive_config...__
   * __archvie_engine...__
Currently used at HADES are those:
   * __archive-config-4.1.0-linux.gtk.x86_64.zip__ : [[%ATTACHURL%/archive-config-4.1.0-linux.gtk.x86_64.zip][local copy]]
   * __archive-engine-4.1.0-linux.gtk.x86_64.zip__ : [[%ATTACHURL%/archive-engine-4.1.0-linux.gtk.x86_64.zip][local copy]]

</div>
---
<div style="margin-left:2em">
---++++ File locations
<div style="margin-left:2em">
---+++++ Install Area
   * ==/home/epics/EPICS/programs/css/...==
      * directory read-only to group and others
      * modifications on ==&lt;Application&gt;.ini== file to allow multiuser operation "shared configuration"/"shared install"
<div style="margin-left:4em">
<ul>
   <li> ==archive-config-4.1.0==
<ul>
</div>
<div style="margin-left:6em">
            %CODE{"java"}%
              -Dosgi.configuration.area.default=@user.home/.css/ArchiveConfigTool_3.2.15/configuration
              -Dosgi.instance.area.default=@user.home/CSS-Workspaces/ArchiveConfigTool_3.2.15/workspace
            %ENDCODE%
</div>
<div style="margin-left:4em">
<ul>
   <li> ==archive-engine-4.1.0==
<ul>
</div>
<div style="margin-left:6em">
            %CODE{"java"}%
              -Dosgi.configuration.area.default=@user.home/.css/ArchiveEngine_4.0.0/configuration
              -Dosgi.instance.area.default=@user.home/CSS-Workspaces/ArchiveEngine_4.0.0/workspace
            %ENDCODE%
</div> 
   * ==/home/epics/EPICS/bin/==
      * Caller Scripts to provide correct java version of Oracle (java version "1.8.0_66", Sun/Oracle):
<div style="margin-left:6em">
<ul>
   <li> [[%ATTACHURL%/ArchiveConfigTool][ ArchiveConfigTool ]] 
<ul>
</div>
<div style="margin-left:8em">
%CODE{"bash"}%
#!/bin/bash
export JAVA_HOME=/home/epics/EPICS/programs/java/jdk1.8.0_66;
declare -F addToPath && addToPath $JAVA_HOME/bin || PATH=$(echo $JAVA_HOME/bin${PATH:+:$PATH}  | sed -e 's/^://' -e 's/:$//')
export PATH

/home/epics/EPICS/programs/css/archive-config-4.1.0/ArchiveConfigTool $*
%ENDCODE%
</div>
<div style="margin-left:6em">
<ul>
   <li> [[%ATTACHURL%/ArchiveEngineCSS][ ArchiveEngineCSS ]]
<ul>
</div>
<div style="margin-left:8em">
%CODE{"bash"}%
#!/bin/bash
export JAVA_HOME=/home/epics/EPICS/programs/java/jdk1.8.0_66;
declare -F addToPath && addToPath $JAVA_HOME/bin || PATH=$(echo $JAVA_HOME/bin${PATH:+:$PATH}  | sed -e 's/^://' -e 's/:$//')
export PATH

/home/epics/EPICS/programs/css/archive-engine-4.1.0/ArchiveEngine $*
%ENDCODE%

</div>
---
---+++++ Configuration Area
<div style="margin-left:2em">
   $ can be changed by runtime option: ==-configuration &lt;location&gt;==
   $ default : ==~/.css/ArchiveEngine_4.0.0/configuration== %BR% ==~/.css/ArchiveConfigTool_3.2.15/configuration==
</div>
---
---+++++ Instance Area
<div style="margin-left:2em">
   $ can be changed by runtime option: ==-data &lt;location&gt;==
   $ default : ==~/CSS-Workspaces/ArchiveEngine_4.0.0/workspace== %BR% ==~/CSS-Workspaces/ArchiveConfigTool_3.2.15/workspace==
</div>
---
</div>
---
</div>
---
---+++ CS-Studio - Database credentials
<div style="margin-left:2em">   
There are several ways to provide the database passwords (archiving (_write_), retrieving (_read_):
   * *every time* via command line option : %BR% ==-rdb_password &lt;plain text password&gt;==
   * *every time* via pluginCustomization :
      * command line option :%BR% ==-pluginCustomization &lt;file&gt;==
      * where &lt;file&gt; contains the line: %BR%
      ==org.csstudio.archive.rdb/password=&lt;plain text password&gt;==
   * one time command line option : %BR% ==-set_password org.csstudio.archive.rdb/password== %BR%
     setting secure preferences interactively and storing it in ==secure_store.dat== 
     depending on the settings of ==org.csstudio.security/secure_preference_location== in the (pluginCustomization) settings file (c.f [[http://cs-studio.sourceforge.net/docbook/ch13.html#idp851856][Section "Secure Preferences", ]] and [[http://cs-studio.sourceforge.net/docbook/ch13.html#idp876752][Configuring Authentication, Authorization and Secure Preferences]] of _"Chapter 13. Authentication and Authorization Part I. CS-Studio Guide"_ ):
      * "Default": Use the default location, which is typically the user's home directory.
         * Advantage: It's the default
         * Disadvantage: You won't always know where the preferences are.
      * "Instance": Use the Eclipse 'instance', i.e. the workspace. 
         * Advantage: You know where it is, and each workspace
           will have its own settings.
         * Disadvantage: Each workspace has different settings.
      * "Install":  Use the Eclipse 'install' location, i.e. where the product is installed.
         * Advantage: You know where it is, and every workspace for that product will have the same settings. Good for a "global" setup.
         * Disadvantage: Ordinary users cannot (should not) have write permissions.

<div style="margin-left:2em">
---++++ Status
   %FOREACH{"user" in="hades_scs_css_archive"}%
   At the moment the encrypted credentials for ==$user@pgsqltest.gsi.de:6846/hades_scs_css_archive== are stored at the *install* location of the config tool or the engine respectively.
   Logged with installation credentials (e.g. user _epics_), either of these will set it:
   %CODE{"bash"}% 
   $> su - epics 
   $> . epics &&
      ArchiveConfigTool -rdb_user $user  -set_password org.csstudio.archive.rdb/password &&
      ArchiveEngineCSS  -set_password org.csstudio.archive.rdb/password
   %ENDCODE%
   %NEXT{"user"}%
</div>
---   
</div>   
---
---+++ GIT repository
---
</div>

---
---++ Engine Configuration
   1. definitions 
   2. convert old archiver "cfg" into new "XML"
   3. import configuration into configuration database
   4. list/check configurations
   5. goto operations   

<div style="margin-left:2em">
---+++ Code Repositories
<div style="margin-left:2em">
---++++ CVS
   * GSI Linux Cluster
      $ ==CVSROOT: /misc/hadesprojects/slowcontrol/cvsroot==
      $ ==Module: Archiver.css
</div>
---
<div style="margin-left:2em">
---++++ git
</div>
---
</div>
---

<div style="margin-left:2em">
---+++ Directory
%CODE{"bash"}% 
APPS_TOP=~scs/playground/EPICS/apps
#APPS_TOP=~scs/apps
ARCHIVER_CSS_TOP=$APPS_TOP/Archiver.css
cd $ARCHIVER_CSS_TOP/configuration
%ENDCODE%
</div>
---

<div style="margin-left:2em">
---+++ Converting old archiver 'cfg' into new 'xml' configuration files
The ==configuration== directory of the css archiver at ==<nop>$APPS_TOP/Archiver/css/configuration/old== contains as a starting point the copy of the archiver configuration of the old archiver.
By using the ==old/ConvertEngineConfig.pl== script (which is a copy of the latest *old* archiver tool set) you could generate an xml configuration file:

%CODE{"bash"}%
ConvertEngineConfig.pl -v -d old/engineconfig.dtd -o hadesArchive.xml hadesArchive.cfg
%ENDCODE%
or alternatively the wrapper script ==convert.sh== which cares about existing files
%CODE{"bash"}%
old/convert.sh [[input:default=hadesArchive.cfg] output]
%ENDCODE%

</div>
---
<div style="margin-left:2em">
---+++ Import / Modify Engine Configuration Database
The XML output file of the conversion is used by ==ArchiveConfigTool== to generate/modify the configuration of the archive engine, which is also stored in the database.
   $ %T% pluginCustomization : to ease common rdb a _plugin customization settings file_ is used, see [[#pluginCustomization][plugin customization]]

<div style="margin-left:2em">
---++++ hades_scs_css_archive
%INCLUDE{"ToolsHiddenSection" section="header - blank - no fence"}%\
%INCLUDE{"SCSArchiverCSStudioEngineConfiguration" plugin_customization_file="settings_hades_scs_css_archive.ini" engine_configuration_file="hadesArchive_css.xml" engine_name="HadesArchiveEngine"  engine_port="4912"  engine_description="HADES_Archiver"  engine_replace="yes"  engine_steal_channels="yes" }%\
%INCLUDE{"ToolsHiddenSection" section="trailer - blank - no fence"}%\
</div>

<div style="margin-left:2em">
---++++ lxhadeb05_archive
%INCLUDE{"ToolsHiddenSection" section="header - blank - no fence"}%\
%INCLUDE{"SCSArchiverCSStudioEngineConfiguration" plugin_customization_file="settings_lxhadeb05_archive.ini" engine_configuration_file="hadesArchive_css.xml"  engine_name="HadesArchiveEngine" engine_port="4912" engine_description="HADES_Archiver" engine_replace="yes" engine_steal_channels="yes" }%\
%INCLUDE{"ToolsHiddenSection" section="trailer - blank - no fence"}%\
</div>

<div style="margin-left:2em">
---++++ lxhaddcs10_archive
%INCLUDE{"ToolsHiddenSection" section="header - blank - no fence"}%\
%INCLUDE{"SCSArchiverCSStudioEngineConfiguration" plugin_customization_file="settings_lxhaddcs10_archive.ini" engine_configuration_file="hadesArchive_css.xml"  engine_name="HadesArchiveEngine" engine_port="4912" engine_description="HADES_Archiver" engine_replace="yes" engine_steal_channels="yes" }%\
%INCLUDE{"ToolsHiddenSection" section="trailer - blank - no fence"}%\
</div>

</div>
---
<div style="margin-left:2em">
---+++ List existing engine configurations
<div style="margin-left:2em">
%CODE{"bash"}% 
pluginCustomization=$ARCHIVER_CSS_TOP/pluginCustomization/%PLUGIN_CUSTOMIZATION_FILE%
ArchiveConfigTool -pluginCustomization $pluginCustomization -list
%ENDCODE%
---
</div>
---
</div>

---
---++ Operation
<div style="margin-left:2em">
---+++ Start Engine
<div style="margin-left:2em">
---++++ by Hand
%CODE{"perl"}%
engine_name=HadesArchiveEngine
engine_port=4912
pluginCustomization=$ARCHIVER_CSS_TOP/pluginCustomization/%PLUGIN_CUSTOMIZATION_FILE%

ArchiveEngineCSS -port $engine_port -engine $engine_name -data workspace/mdc  -pluginCustomization $pluginCustomization
%ENDCODE%

A running Engine will have an HTTP server at e.g. [[http://localhost:4912/main]] an will look like this: %BR%
<img src="%ATTACHURLPATH%/ArchiveEngineWebInterface.png" alt="ArchiveEngineWebInterface.png" width='573' height='690' />

%X% Make sure the engine port is the same as defined in the configuration, otherwise you might get something like this - (mismatch of defined 4812 (default) and requested 4912):
%CODE{"java"}%
2016-06-02 15:56:51.010 INFO [Thread 1] org.csstudio.archive.engine.Application (start) - Archive Engine 4.0.0.201506301920
2016-06-02 15:56:51.233 INFO [Thread 1] org.csstudio.archive.engine.server.EngineServer (<init>) - Engine HTTP Server on http://localhost:4912/main
2016-06-02 15:56:51.233 INFO [Thread 1] org.csstudio.archive.engine.Application (start) - Reading configuration 'HadesArchiveEngine'
2016-06-02 15:56:51.858 SEVERE [Thread 1] org.csstudio.archive.engine.Application (start) - Cannot read configuration
java.lang.Exception: Engine running on port 4912 while configuration requires http://localhost:4812/main

%ENDCODE%
</div>

<div style="margin-left:2em">
---++++ using crontab / procServ 
On the basis of the [[#by_Hand]["by Hand"]] a suitable cronjob is set up:
At ==~scs/procServ== the file ==archiverCSS.sh== handles the configuration of the start routine.
Its function ==userDefines== holds the important informations, change it if necessary, and update it to the code revision.
%INCLUDE{"ToolsHiddenSection" section="header"}% 
%CODE{"bash"}%
#specific user predefines
#the userDefines function is called within the $startBackgroundEpicsIocScriptName script
userDefines()
{
	userProcServTelnetPort=4853
	userProcServTelnetLogPort=-1
	userIOC=archiverCSS-BEAUTY-$(hostname)
#	userWorkingDir=~/apps/Archiver/css/startup
	userWorkingDir=~/playground/EPICS/apps/Archiver.css/startup
	userCommandExecutable=startEngineCSS.sh
	userCommandArgument=

%ENDCODE%

%INCLUDE{"ToolsHiddenSection" section="trailer"}% 

The command ==crontab -l== should contain the following line of code:
%CODE{"bash"}%
@reboot cd ~scs/procServ && ./archiverCSS.sh > ~/log/archiverCSS.crontab.start 2>&1
%ENDCODE%

With those scripts a ==procServ== session with port ==4853== is created, which can be locally reached and manipulated using ==telnet== (see procServ man pages):
%CODE{"bash"}%
telnet localhost 4813
%ENDCODE%

</div>
</div>

<div style="margin-left:2em">
---+++ Restarting Engine
<div style="margin-left:2em">
---++++ via web browser 
The RDB Channel Archiver offers the opportunity to restart the engine by simple calling its restart web page: ==http://localhost:4912/restart==
</div>
<div style="margin-left:2em">
---++++ script based using ==curl==
Download this small bash script [[https://git.gsi.de/EPICS/Tools/scripts/Archiver/restartChannelArchiverArchiveEngine]]
</div>
<div style="margin-left:2em">
---++++ via procServ - _"brute force"_
Login to the procServ session and kill/restart the child process with =^X=.
</div>
</div>

<div style="margin-left:2em">
---+++ Attach CSS Browser
<div style="margin-left:2em">
---++++ lxhaddcs10
Settings needed in CSS preferences (restart needed)
Just look at the line starting with ==jdbc:==
   * Archiver preference settings 1: <br />
     <img src="%ATTACHURLPATH%/Archiver_preferences_settings_1.png" alt="Archiver_preferences_settings_1.png" width='901' height='501' />
   * <h3> URL: __jdbc:postgresql://lxhaddcs10:5432/archive__ </h3>

You *must* not enter a password:
   * Archiver preference settings 2: <br />
     <img src="%ATTACHURLPATH%/Archiver_preferences_settings_2.png" alt="Archiver_preferences_settings_2.png" width='488' height='351' />
   * User: __report__
Example:
   * Archiver CSS Browser: <br />
     <img src="%ATTACHURLPATH%/Archiver_Example.png" alt="Archiver_Example.png" width='712' height='431' />
</div>
---
</div>
---
---++ Appendix:
<div style="margin-left:2em">
---+++ pluginCustomization
with  e.g. ~scs/playground/EPICS/apps/Archiver/css/pluginCustomization/%PLUGIN_CUSTOMIZATION_FILE%
%CODE{"perl"}%
org.csstudio.archive.rdb/url=jdbc:postgresql://pgsqltest.gsi.de:6846/hades_scs_css_archive
org.csstudio.archive.rdb/user=hades_scs_css_archive
org.csstudio.archive.rdb/schema=
org.csstudio.security/secure_preference_location=Instance
%ENDCODE%

%NEXT{"css-address"}%
</div>
</div>


%STOPINCLUDE%

--- 

-- Main.PeterZumbruch - 16 Jan 2018
---
<div style="text-align:right">%REVINFO{"-- $wikiusername - $date"}%</div>
---
   * [[%ATTACHURL%/cs-studio-sns-css-4.1.1][cs-studio-sns-css-4.1.1]]: caller script for css
Topic attachments
I	Attachment	Action	Size	Date	Who	Comment
txt	postgres_schema.txt	manage	9.2 K	18 Apr 2016 - 14:39	PeterZumbruch	cs-studio postgres archive schema
txt	postgres_partitioning.txt	manage	6.4 K	09 May 2016 - 12:16	PeterZumbruch	postgres_partitioning
png	Archiver_preferences_settings_2.png	manage	29.6 K	06 Jun 2016 - 13:41	PeterZumbruch	Archiver preference settings 2
png	Archiver_Example.png	manage	415.8 K	06 Jun 2016 - 13:54	PeterZumbruch	Archiver CSS Browser
png	ArchiveEngineWebInterface.png	manage	125.2 K	09 Jun 2016 - 14:09	PeterZumbruch	Archive Engine Web Interface
zip	archive-config-4.1.0-linux.gtk.x86_64.zip	manage	24560.6 K	14 Jun 2016 - 08:08	PeterZumbruch	archive-config-4.1.0-linux.gtk.x86_64.zip
zip	archive-engine-4.1.0-linux.gtk.x86_64.zip	manage	27347.2 K	14 Jun 2016 - 08:09	PeterZumbruch	archive-engine-4.1.0-linux.gtk.x86_64.zip
EXT	ArchiveConfigTool	manage	0.3 K	17 Jun 2016 - 11:41	PeterZumbruch	caller script for ArchiveConfig
EXT	ArchiveEngineCSS	manage	0.3 K	17 Jun 2016 - 11:42	PeterZumbruch	caller script for ArchiveEngine
1	cs-studio-sns-css-4.1.1	manage	0.3 K	17 Jun 2016 - 11:43	PeterZumbruch	caller script for css
png	Archiver_preferences_settings_1.png	manage	86.4 K	26 Apr 2021 - 08:42	PeterZumbruch	Archiver preference settings 1
Topic revision: r67 - 26 Apr 2021, PeterZumbruch
DaqSlowControl
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Hades Wiki? Send feedback
Imprint (in German)
Privacy Policy (in German)