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)
On Wed, Aug 25, 2010 at 1:33 AM, Florent Guillaume <[email protected]> wrote:
> 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
>
> On Tue, Aug 24, 2010 at 5:21 AM, Oliver Rojo <[email protected]>
> wrote:
> > 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
> >
> > On Mon, Aug 23, 2010 at 5:28 AM, Florent Guillaume <[email protected]> wrote:
> >>
> >> 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
> >>
> >> On Mon, Aug 23, 2010 at 9:13 AM, Oliver Rojo <[email protected]>
> >> wrote:
> >> > 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, Director of R&D, Nuxeo
> >> Open Source, Java EE based, Enterprise Content Management (ECM)
> >> http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
> >
> >
>
>
>
> --
> Florent Guillaume, Director of R&D, Nuxeo
> Open Source, Java EE based, Enterprise Content Management (ECM)
> http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
