Dear Mr Guillaume
thanks for your interest
Let me explain the steps I followed:
- I've copyed the file postgresql-8.2-505.jdbc2ee.jar into server
\default\lib directory (I'm using postgre 8.2)
- I've added to \server\default\deploy
postgres-ds.xml
----------------------------------------------------------------------
-------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!--
=====================================================================
-->
<!--
-->
<!-- JBoss Server
Configuration -->
<!--
-->
<!--
=====================================================================
-->
<!-- $Id: postgres-ds.xml,v 1.3.2.1 2006/02/07 14:23:00 acoliver
Exp $ -->
<!--
==================================================================== -
->
<!-- Datasource config for
Postgres -->
<!--
==================================================================== -
->
<datasources>
<local-tx-datasource>
<jndi-name>PostgresDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/postgres</
connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>postgres</password>
<!-- sql to call when connection is created. Can be
anything, select 1 is valid for PostgreSQL
<new-connection-sql>select 1</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it
is obtained from pool. Can be anything, select 1 is valid for
PostgreSQL
<check-valid-connection-sql>select 1</check-valid-
connection-sql>
-->
<!-- corresponding type-mapping in the standardjbosscmp-
jdbc.xml (optional) -->
<metadata>
<type-mapping>PostgreSQL 7.2</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
----------------------------------------------------------------------
--------------------------------
- I've added to \server\default\deploy\jms
postgres-jdbc2-service.xml
- I've added to \server\default\deploy\nuxeo.ear\conf the two files
as suggested in the directory 5.1 administration document (on your
site)
MyPlatform-Layout-config.xml
----------------------------------------------------------------------
--------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<component name="MyPlatformLayout">
<require>org.nuxeo.ecm.platform.api.DefaultPlatform</require>
<extension
target="org.nuxeo.ecm.platform.util.LocationManagerService"
point="location">
<locationManagerPlugin> <!-- This disable the default (demo)
repository -->
<locationEnabled>false</locationEnabled>
<locationName>demo</locationName>
</locationManagerPlugin>
<locationManagerPlugin> <!-- This enable your new repository -->
<locationEnabled>true</locationEnabled>
<locationName>MyRepo</locationName> <!-- Use the name of your
repository -->
</locationManagerPlugin>
</extension>
<extension
target="org.nuxeo.ecm.core.api.repository.RepositoryManager"
point="repositories">
<documentation>The default repository</documentation>
<repository name="MyRepo" label="My Repository"/>
</extension>
<extension target="org.nuxeo.runtime.api.ServiceManagement"
point="services">
<service class="org.nuxeo.ecm.core.api.CoreSession"
name="MyRepo" group="core">
<locator>%DocumentManagerBean</locator>
</service>
</extension>
</component>
----------------------------------------------------------------------
------------------------------
and
MyRepo-repositoy-config.xml
----------------------------------------------------------------------
------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<component name="org.nuxeo.project.sample.repository.MyRepo">
<extension
target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="MyRepo"
factory="org.nuxeo.ecm.core.repository.jcr.JCRRepositoryFactory"
securityManager="org.nuxeo.ecm.core.repository.jcr.JCRSecurityManager"
forceReloadTypes="false">
<Repository>
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
<Security appName="Jackrabbit">
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<param name="anonymousId" value="anonymous"/>
</LoginModule>
</Security>
<!-- Workspaces configuration. Nuxeo only uses the default
workspace. -->
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="DefaultDS"/>
<Workspace name="${wsp.name}">
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"
>
<param name="driver" value="org.postgresql.Driver"/>
<param name="url" value="jdbc:postgresql://localhost/
nuxeo"/>
<param name="user" value="postgres"/>
<param name="password" value="postgres"/>
<param name="schema" value="postgresql"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}
_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
</SearchIndex>
</Workspace>
<!-- Versioning configuration. -->
<Versioning rootPath="${rep.home}/version">
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"
>
<param name="driver" value="org.postgresql.Driver"/>
<param name="url" value="jdbc:postgresql://localhost/
nuxeo"/>
<param name="user" value="postgres"/>
<param name="password" value="postgres"/>
<param name="schema" value="postgresql"/>
<param name="schemaObjectPrefix" value="jcr_ver_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
</Versioning>
<!-- Index for repository-wide information, mainly
versions. -->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index"/>
</SearchIndex>
</Repository>
</repository>
</extension>
</component>
----------------------------------------------------------------------
-------------------------
- I've created a DefaultDS database into the postgres server just
to be sure there's one
- I've created a logs database into postgres
- I've added in
nxaudit-logs-ds.xml
----------------------------------------------------------------------
-------------------------
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>nxaudit-logs</jndi-name>
<connection-url>jdbc:postgresql://localhost/logs</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>postgres</password>
</local-tx-datasource>
</datasources>
----------------------------------------------------------------------
-------------------------
when I log in nuxeo I always see my default workspaces and I don't
seem to be able to enter the postgresQL database
Where am I mistaking
thanks very much for your help
Gianpaolo Dettoma
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
