RE: Battling to start archive.engine on Postgresql db

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

Hi All,
I seem to have found the problem.
It is related to user rights, when I changed
from
org.csstudio.archive.rdb/user=archive
org.csstudio.archive.rdb/password=$archive
to
org.csstudio.archive.rdb/user=postgres
org.csstudio.archive.rdb/password=<my_password>
in
org.csstudio.archive.engine ,    'plugin_customization.ini'  file
then the archive.engine started

I was a little surprised as I thought user archive was created in the postgres_schema.txt.
I am a bit new to postgresql to know what I should do about it.
Regards,
Ivan Kohler,
iThemba Labs, South Africa

-------- Original Message --------

Subject:	Battling to start archive.engine on Postgresql db
Date:	Tue, 04 Mar 2014 00:17:19 +0200
From:	Ivan Kohler <ivan@tlabs.ac.za>
To:	tech-talk <tech-talk@aps.anl.gov>

Hi All,
I managed to start CSS archive.engine on a MySQL db, now I am trying to 
get it started on a Postgresql db.
I am on a PC running Ubuntu 1204 using:
Java: JDK SE Dev Kit 7.51
Eclipse fro RCP and RAP Developers ver 1.4.2
SNS Sources 3.2.14
I installed postgresql 9.1 and loaded the schema with:
   sudo -u postgres psql < 
~/css/sources/org.csstudio.archive.rdb/dbd/postgres_schema.txt
So smpl_eng has the Demo engine in it:
1, Demo, Demo Engine, http://localhost:4812
I edited postgresql's pg_hba.conf file
      host    all             all 127.0.0.1/32            md5
      host    all             all             10.0.0.1/24     md5  # 
Added this line

In Eclipse I edited:
org.csstudio.archive.engine
  plugin_customization.ini file
org.csstudio.archive.rdb/url=""
and
org.csstudio.archive.engine.rdb
  preferences.ini file
    # Postgresql example
url=""

Before Launching the ArchiveEngine.product I added
Program Arguments using the 'Launching' tab
        -engine Demo
        -port 4812

On Launching I got the following in the Eclipse Console:
2014-03-03 23:11:01.753 INFO [Thread 1] 
org.csstudio.archive.engine.Application (start) - Archive Engine 
3.2.14.qualifier
2014-03-03 23:11:01.896 INFO [Thread 1] 
org.csstudio.archive.engine.server.EngineServer (<init>) - Engine HTTP 
Server on http://localhost:4812/main
2014-03-03 23:11:01.897 INFO [Thread 1] 
org.csstudio.archive.engine.Application (start) - Reading configuration 
'Demo'
2014-03-03 23:11:01.939 SEVERE [Thread 1] 
org.csstudio.archive.engine.Application (start) - Cannot read configuration
org.eclipse.core.runtime.CoreException: Plug-in 
"org.csstudio.archive.config.rdb" was unable to instantiate class 
"org.csstudio.archive.config.rdb.RDBArchiveConfig".
    at 
org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.throwException(RegistryStrategyOSGI.java:194)
    at 
org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:186)
    at 
org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:905)
    at 
org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
    at 
org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
    at 
org.csstudio.archive.config.ArchiveConfigFactory.getArchiveConfig(ArchiveConfigFactory.java:37)
    at org.csstudio.archive.engine.Application.start(Application.java:164)
    at 
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at 
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
    at 
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
    at 
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
    at 
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: java.lang.NullPointerException
    at 
org.csstudio.archive.rdb.RDBArchivePreferences.getSchema(RDBArchivePreferences.java:37)
    at 
org.csstudio.archive.config.rdb.RDBArchiveConfig.<init>(RDBArchiveConfig.java:66)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
Method)
    at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at java.lang.Class.newInstance(Class.java:374)
    at 
org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)
    ... 18 more

Any comments would be greatly appreciated.
Best Regards,
Ivan Kohler
iThemba LABS,
South Africa