nuxeo-dm-5.3.2 + postgresql-8.4

[Oliver Rojo]

hi!

I am a beginner when it comes to using nuxeo so I apologize for this
amateurish question.

I already configured nuxeo.config

nuxeo.templates=default,postgresql

nuxeo.db.name=nuxeodm
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20


And basically I followed this documentation:

http://www.tela-web.com/nuxeo-with-postgresql

but I can't find any datasources directory where I can store my database xml
configuration.

My objective is to connect nuxeo-dm into my postgresql database.

Please help.

Oliver

[Florent Guillaume]

The documentation you read predates templates.
With templates and nuxeo.conf configuration, provided the templates
you need are already done (which is the case for Postgres), you don't
need to do anything further than changing nuxeo.conf.

Floretn

Post by Oliver Rojo
hi!
I am a beginner when it comes to using nuxeo so I apologize for this
amateurish question.
I already configured nuxeo.config
nuxeo.templates=default,postgresql
nuxeo.db.name=nuxeodm
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20
http://www.tela-web.com/nuxeo-with-postgresql
but I can't find any datasources directory where I can store my database xml
configuration.
My objective is to connect nuxeo-dm into my postgresql database.
Please help.
Oliver

[Oliver Rojo]

hi florent! thank you for your immediate reply. i'm wondering why i don't
see any tables created inside nuxeo database after doing ./nuxeoctl
console?

Do I need to create my own tables? Or does nuxeo creates it automatically
upon establishing the connection? I'm not too familiar creating schemas and
table structures for databases though.

Regards,

Oliver

Post by Florent Guillaume
The documentation you read predates templates.
With templates and nuxeo.conf configuration, provided the templates
you need are already done (which is the case for Postgres), you don't
need to do anything further than changing nuxeo.conf.
Floretn

Post by Oliver Rojo
hi!
I am a beginner when it comes to using nuxeo so I apologize for this
amateurish question.
I already configured nuxeo.config
nuxeo.templates=default,postgresql
nuxeo.db.name=nuxeodm
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20
http://www.tela-web.com/nuxeo-with-postgresql
but I can't find any datasources directory where I can store my database

xml

Post by Oliver Rojo
configuration.
My objective is to connect nuxeo-dm into my postgresql database.
Please help.
Oliver

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org [phone]

[Florent Guillaume]

Nuxeo creates everything it needs.
If you don't see anything then it means Nuxeo is storing its data
somewhere else.
Please check which template you use, and the end-result file which
lives in $JBOSS/server/default/deploy/nuxeo.ear/config/default-repository-config.xml
for instance.

Florent

Post by Oliver Rojo
hi florent! thank you for your immediate reply. i'm wondering why i don't
see any tables created inside nuxeo database after doing ./nuxeoctl
console?
Do I need to create my own tables? Or does nuxeo creates it automatically
upon establishing the connection? I'm not too familiar creating schemas and
table structures for databases though.
Regards,
Oliver

Post by Florent Guillaume
The documentation you read predates templates.
With templates and nuxeo.conf configuration, provided the templates
you need are already done (which is the case for Postgres), you don't
need to do anything further than changing nuxeo.conf.
Floretn

Post by Oliver Rojo
hi!
I am a beginner when it comes to using nuxeo so I apologize for this
amateurish question.
I already configured nuxeo.config
nuxeo.templates=default,postgresql
nuxeo.db.name=nuxeodm
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20
http://www.tela-web.com/nuxeo-with-postgresql
but I can't find any datasources directory where I can store my database xml
configuration.
My objective is to connect nuxeo-dm into my postgresql database.
Please help.
Oliver

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   [phone]

[Oliver Rojo]

Hi Florent,

Thank you for your reply again.

I did the following:

---- /opt/nuxeo-dm/config/default-repository-config.xml ---

<?xml version="1.0"?>
<component name="org.nuxeo.ecm.core.storage.sql.config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"

factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<indexing>
<!-- configuration for PostgreSQL -->
<fulltext analyzer="english"/>
</indexing>

</repository>
</repository>
</extension>
</component>


--- /opt/nuxeo-dm/config/nxtags-ds.xml ---
<?xml version="1.0"?>
<datasources>
<xa-datasource>
<jndi-name>nxtags</jndi-name>

<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
<xa-datasource-property
name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">5432</xa-datasource-property>
<xa-datasource-property
name="DatabaseName">nuxeo</xa-datasource-property>
<xa-datasource-property name="User">postgres</xa-datasource-property>
<xa-datasource-property name="Password"></xa-datasource-property>
<track-connection-by-tx/>
</xa-datasource>
</datasources>

--- /opt/nuxeo-dm/config/unified-nuxeo-ds.xml ---

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource>
<jndi-name>NuxeoDS</jndi-name>

<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
<xa-datasource-property
name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">5432</xa-datasource-property>
<xa-datasource-property
name="DatabaseName">nuxeo</xa-datasource-property>
<xa-datasource-property name="User">postgres</xa-datasource-property>
<xa-datasource-property name="Password"></xa-datasource-property>
<check-valid-connection-sql>;</check-valid-connection-sql>
<track-connection-by-tx/>
</xa-datasource>
</datasources>


but i got these error messages:

19:36:37,859 INFO [DefaultBinaryManager] Repository 'default' using binary
store: /opt/nuxeo-dm/binaries
19:36:37,868 ERROR [PublisherServiceImpl] Unable to register pending
descriptors
org.nuxeo.ecm.core.api.ClientException: Failed to load repository default
at
org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:102)
at
org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSession.java:154)
at
org.nuxeo.ecm.core.api.AbstractSession.connect(AbstractSession.java:188)
at
org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:149)
at
org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:115)
at
org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:141)
at
org.nuxeo.ecm.platform.publisher.impl.service.DomainsFinder.getDomains(DomainsFinder.java:61)
at
org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.registerPendingDescriptors(PublisherServiceImpl.java:673)
at
org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.frameworkEvent(PublisherServiceImpl.java:659)
at
org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
at
org.nuxeo.osgi.application.StandaloneApplication.start(StandaloneApplication.java:144)
at
org.nuxeo.osgi.application.StandaloneApplication.main(StandaloneApplication.java:338)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nuxeo.osgi.application.Main.main(Main.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nuxeo.runtime.launcher.Main.main(Main.java:88)
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message:
java.lang.NullPointerException
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.createBackend(RepositoryImpl.java:193)
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.<init>(RepositoryImpl.java:121)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepository.<init>(SQLRepository.java:65)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory.createRepository(SQLRepositoryFactory.java:37)
at
org.nuxeo.ecm.core.repository.RepositoryDescriptor.create(RepositoryDescriptor.java:139)
at
org.nuxeo.ecm.core.repository.RepositoryManager$Ref.get(RepositoryManager.java:201)
at
org.nuxeo.ecm.core.repository.RepositoryManager.getRepository(RepositoryManager.java:81)
at
org.nuxeo.ecm.core.api.local.LocalSession.lookupRepository(LocalSession.java:130)
at
org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:98)
... 21 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
java.lang.NullPointerException. message: null
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initialize(JDBCBackend.java:64)
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.createBackend(RepositoryImpl.java:188)

Post by Florent Guillaume
Nuxeo creates everything it needs.
If you don't see anything then it means Nuxeo is storing its data
somewhere else.
Please check which template you use, and the end-result file which
lives in
$JBOSS/server/default/deploy/nuxeo.ear/config/default-repository-config.xml
for instance.
Florent

Post by Oliver Rojo
hi florent! thank you for your immediate reply. i'm wondering why i don't
see any tables created inside nuxeo database after doing ./nuxeoctl
console?
Do I need to create my own tables? Or does nuxeo creates it automatically
upon establishing the connection? I'm not too familiar creating schemas

and

Post by Oliver Rojo
table structures for databases though.
Regards,
Oliver

Post by Florent Guillaume
The documentation you read predates templates.
With templates and nuxeo.conf configuration, provided the templates
you need are already done (which is the case for Postgres), you don't
need to do anything further than changing nuxeo.conf.
Floretn

Post by Oliver Rojo
hi!
I am a beginner when it comes to using nuxeo so I apologize for this
amateurish question.
I already configured nuxeo.config
nuxeo.templates=default,postgresql
nuxeo.db.name=nuxeodm
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20
http://www.tela-web.com/nuxeo-with-postgresql
but I can't find any datasources directory where I can store my

database

Post by Oliver Rojo

Post by Florent Guillaume

Post by Oliver Rojo
xml
configuration.
My objective is to connect nuxeo-dm into my postgresql database.
Please help.
Oliver

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org [phone]

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org [phone]

[Oliver Rojo]

Sorry, please disregard my last post. I forgot that I'm using
nuxeo-dm-5.3.2. Instead, what I did is:

------ nuxeo.conf -----------

# General parameters
nuxeo.force.generation=true
nuxeo.template=postgresql
nuxeo.bind.address=0.0.0.0
nuxeo.url=http://localhost:8080/nuxeo
org.nuxeo.ecm.contextPath=/nuxeo
nuxeo.db.name=nuxeo
nuxeo.db.user=postgres
nuxeo.db.password=
nuxeo.db.host=localhost
nuxeo.db.port=5432
nuxeo.db.min-pool-size=5
nuxeo.db.max-pool-size=20
nuxeo.vcs.min-pool-size=0
nuxeo.vcs.max-pool-size=20


------- config/default-repository-config.xml -------------

<?xml version="1.0"?>
<component name="org.nuxeo.ecm.core.storage.sql.config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"

factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<indexing>
<!-- configuration for PostgreSQL -->
<fulltext analyzer="english"/>
</indexing>

</repository>
</repository>
</extension>
</component>


When I ran nuxeo, the error says:

22:12:01,312 ERROR [OSGiRuntimeService] Nuxeo EP Started
======================================================================
= Nuxeo EP Started
======================================================================
= Component Loading Status: Pending: 1 / Unstarted: 0 / Total: 357
* service:org.nuxeo.ecm.platform.convert.oooDaemon.config.default requires
[service:org.nuxeo.ecm.platform.convert.oooserver.OOoDaemonManagerComponent]
======================================================================
22:12:01,317 INFO [J2EEContainerDescriptor] Detected Jetty host
22:12:05,380 INFO [JettyComponent] jetty-6.1H.7
22:12:05,413 INFO [JettyComponent] Opened
/opt/nuxeo-dm/bin/log/2010_08_31.request.log
22:12:05,526 INFO [JettyComponent] No Transaction manager found - if your
webapp requires one, please configure one.
22:12:10,234 INFO [SeamConfigurator] Deactivate Seam transaction support
(no tx manager)
22:12:10,250 INFO [GuiceContextListener] GuiceContextListener
contextInitialized
22:12:10,270 INFO [GuiceContextListener] GuiceContextListener getModuleList
22:12:10,271 INFO [GuiceContextListener] GuiceContextListener
createInjector
22:12:19,190 INFO [JettyComponent] Started {}
22:12:19,196 INFO [PublisherServiceImpl] Publisher Service initialization
22:12:19,294 INFO [DefaultBinaryManager] Repository 'default' using binary
store: /opt/nuxeo-dm/binaries
22:12:19,302 ERROR [PublisherServiceImpl] Unable to register pending
descriptors
org.nuxeo.ecm.core.api.ClientException: Failed to load repository default
at
org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:102)
at
org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSession.java:154)
at
org.nuxeo.ecm.core.api.AbstractSession.connect(AbstractSession.java:188)
at
org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:149)
at
org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:115)
at
org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:141)
at
org.nuxeo.ecm.platform.publisher.impl.service.DomainsFinder.getDomains(DomainsFinder.java:61)
at
org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.registerPendingDescriptors(PublisherServiceImpl.java:673)
at
org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.frameworkEvent(PublisherServiceImpl.java:659)
at
org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
at
org.nuxeo.osgi.application.StandaloneApplication.start(StandaloneApplication.java:144)
at
org.nuxeo.osgi.application.StandaloneApplication.main(StandaloneApplication.java:338)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nuxeo.osgi.application.Main.main(Main.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nuxeo.runtime.launcher.Main.main(Main.java:88)
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message:
java.lang.NullPointerException
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.createBackend(RepositoryImpl.java:193)
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.<init>(RepositoryImpl.java:121)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepository.<init>(SQLRepository.java:65)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory.createRepository(SQLRepositoryFactory.java:37)
at
org.nuxeo.ecm.core.repository.RepositoryDescriptor.create(RepositoryDescriptor.java:139)
at
org.nuxeo.ecm.core.repository.RepositoryManager$Ref.get(RepositoryManager.java:201)
at
org.nuxeo.ecm.core.repository.RepositoryManager.getRepository(RepositoryManager.java:81)
at
org.nuxeo.ecm.core.api.local.LocalSession.lookupRepository(LocalSession.java:130)
at
org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:98)
... 21 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
java.lang.NullPointerException. message: null
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initialize(JDBCBackend.java:64)
at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.createBackend(RepositoryImpl.java:188)
... 29 more
22:12:19,305 INFO [StandaloneApplication] Framework started in 27 sec.

Please help....


Oliver

[Florent Guillaume]

You seem to be missing the PostgreSQL JDBC driver
(postgresql-8.3-604.jdbc3.jar or more recent JDBC 3 driver). It should
be put in $TOMCAT/lib or $JBOSS/server/default/lib.

Florent

Post by Oliver Rojo
--- /opt/nuxeo-dm/config/unified-nuxeo-ds.xml ---
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <xa-datasource>
    <jndi-name>NuxeoDS</jndi-name>
 <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
    <xa-datasource-property
name="ServerName">localhost</xa-datasource-property>
    <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
    <xa-datasource-property
name="DatabaseName">nuxeo</xa-datasource-property>
    <xa-datasource-property name="User">postgres</xa-datasource-property>
    <xa-datasource-property name="Password"></xa-datasource-property>
    <check-valid-connection-sql>;</check-valid-connection-sql>
    <track-connection-by-tx/>
  </xa-datasource>
</datasources>
java.lang.NullPointerException. message: null
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initialize(JDBCBackend.java:64)
        at
org.nuxeo.ecm.core.storage.sql.RepositoryImpl.createBackend(RepositoryImpl.java:188)

[Oliver Rojo]

hi florent,

I have put the postgresql java connector on the right path (see below) but
to no avail. I am using java 1.6 and postgresql 8.4 on my nuxeo-dm-5.3.2.

java -version
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode)

pwd
/opt/nuxeo-dm/lib

ls -la postgresql-8.4-701.jdbc4.jar
-rw-r--r-- 1 root root 510170 Sep 1 17:48 postgresql-8.4-701.jdbc4.jar

Any thoughts? Thank you!

Oliver

Post by Florent Guillaume
You seem to be missing the PostgreSQL JDBC driver
(postgresql-8.3-604.jdbc3.jar or more recent JDBC 3 driver). It should
be put in $TOMCAT/lib or $JBOSS/server/default/lib.
Florent

[Florent Guillaume]

I believe your nuxeo.conf file is incorrect.
It should not contain:
nuxeo.template=postgresql
but:
nuxeo.templates=default,postgresql

We'll fix the doc.

Can you also paste the content of the file:
$TOMCAT/nxserver/config/default-repository-config.xml
after having tried once to start the server.

Florent

Post by Oliver Rojo
hi florent,
I have put the postgresql java connector on the right path (see below) but
to no avail. I am using java 1.6 and postgresql 8.4 on my nuxeo-dm-5.3.2.
java -version
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode)
pwd
/opt/nuxeo-dm/lib
ls -la postgresql-8.4-701.jdbc4.jar
-rw-r--r-- 1 root root 510170 Sep  1 17:48 postgresql-8.4-701.jdbc4.jar
Any thoughts? Thank you!
Oliver

Post by Florent Guillaume
You seem to be missing the PostgreSQL JDBC driver
(postgresql-8.3-604.jdbc3.jar or more recent JDBC 3 driver). It should
be put in $TOMCAT/lib or $JBOSS/server/default/lib.
Florent

[Oliver Rojo]

hi florent,

I've already changed my nuxeo.conf but to no avail still the same error

from:

nuxeo.templates=default,postgresql

to :

nuxeo.template=postgresql

also my default-repository-config.xml

<?xml version="1.0"?>
<component name="org.nuxeo.ecm.core.storage.sql.config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"

factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<indexing>
<fulltext analyzer="english"/>
</indexing>
</repository>
</repository>
</extension>
</component>


thanks again florent!

Regards,

oliver

[Oliver Rojo]

Hi florent,

How do you find my configuration?

Regards,

Oliver

[Oliver Rojo]

hi florent,

Not using jetty worked for me.

Thanks for your help!

Oliver

Post by Oliver Rojo
Hi florent,
How do you find my configuration?
Regards,
Oliver