Experimental Physics and
Industrial Control System

Ivan Kohler <[email protected]> · Wed, 05 Mar 2014 10:40:00 +0200

Hi Kay,

Many thanks for the enlightenment, especially on the advice of leaving

the source files intact.

I have created the settings.ini file pointing to the use of the

postgresql db and adding to addr_list for our subnet and it works fine.

There were two things I did wrong:
1. I had commented out the schema line:

 org.csstudio.archive.rdb/schema= from file

plugin_customization.ini of org.csstudio.archive.engine

 I had read this some where, that this needed to be removed as it was

only needed for the oracle db, can't find the article right now!

2. I also didn't spot that the create users archive and report and the

granting of rights is all commented out of the postgres_schema.txt.

    This is a bit different to the mysql_schema.txt.
Thanks for the help,
Ivan

On 04/03/2014 16:14, Kasemir, Kay wrote:

Hi:

On Mar 3, 2014, at 5:17 PM, Ivan Kohler <[email protected]> wrote:

I managed to start CSS archive.engine on a MySQL db,

Good, so at least something is working.

In Eclipse I edited:
org.csstudio.archive.engine
   plugin_customization.ini file
org.csstudio.archive.rdb/url=jdbc:postgresql://localhost:5432/archive
and
org.csstudio.archive.engine.rdb
   preferences.ini file
     # Postgresql example
url=jdbc:postgresql://localhost/archive?rewriteBatchedStatements=true

You should leave the "preferences.ini" files unchanged. They contain the defaults and explanation of available settings.
To specify what you actually want to use, you _could_ edit the plugin_customization.ini in the archive engine sources, but better would be to not edit any sources and instead provide the path to _your_ plugin_customization.ini file on the command-line:

  ArchiveEngine -pluginCustomization /path/to/my/settings.ini -engine Demo ….

See also "Hierarchical Preferences" in the CSS Guide, http://cs-studio.sourceforge.net/docbook/ch06.html

Caused by: java.lang.NullPointerException
     at
org.csstudio.archive.rdb.RDBArchivePreferences.getSchema(RDBArchivePreferences.java:37)

Strange.
For Postgres you should configure the "schema" to be empty, just as you did with MySQL.
So your settings.ini would contain:

# Set schema to empty
org.csstudio.archive.rdb/schema=

The error message suggests that the 'schema' is not defined at all, which could only happen if you deleted it from the org.csstudio.archive.rdb/preferences.ini as well as org.csstudio.archive.engine/plugin_customization.ini.

Thanks,
Kay

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System