Re: Battling to start archive.engine on Postgresql db

[Ivan Kohler <ivan@tlabs.ac.za>]

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 <ivan@tlabs.ac.za> 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