Hello! Running Nuxeo DM 5.2.0 official build, i'm doing some customizing like login page, theme, live edit, Ooo daemon to pdf converter, etc, everything has been running fine, until i tried to integrate posgreSQL 8.3, i downloaded and installed the appropriate JDBC and edit the next files:
1. nuxeo-dm-5.2.0/server/default/deploy/nuxeo.ear/config/sql.properties 2. nuxeo-dm-5.2.0/server/default/deploy/nuxeo.ear/datasources/unified-nuxeo-ds.xml 3. nuxeo-dm-5.2.0/server/default/deploy/nuxeo.ear/config/default-repository-config.xml 4. nuxeo-dm-5.2.0/server/default/deploy/nuxeo.ear/datasources/default-repository-ds.xml after editing the first 3 files (see attached files) and having "default-repository-ds.xml" intact, the server run fine and connect successful with postgreSQL even create 59 tables and 5 sequences (see nuxeoTabList.html, nuxeoSeqList.html and nuxeoDBproperties.html attached) and i login to Nuxeo fine, but after editing the last one (see default-repository-ds.mod.xml attached) to comment out "H2"conf. and uncomment posgreSQL conf. and restart the server again, the server run fine but when i try to login i receive the next error: "If you can read this in your browser, this probably because of a configuration problem of your nuxeo.war/WEB-INF/pages.xml. To change this, edit the OSGI-INF/deployment-fragment.xml of your project at extension pages#PAGES." could someone help me on this, pls.? Thks. in advanced -- JesusTitle: Nuxeo-PostgreSQL Tables list
Nuxeo-PostgreSQL Tables list
Generated: Thu May 21 15:45:24 2009Server: PostgreSQL 8.3 (localhost:5432)
Database: nuxeo
Schema: public
Tables
| Table | Comment |
|---|---|
| continent | |
| country | |
| documentsLists | |
| group2group | |
| groups | |
| jbpm_action | |
| jbpm_bytearray | |
| jbpm_byteblock | |
| jbpm_comment | |
| jbpm_decisionconditions | |
| jbpm_delegation | |
| jbpm_event | |
| jbpm_exceptionhandler | |
| jbpm_job | |
| jbpm_log | |
| jbpm_moduledefinition | |
| jbpm_moduleinstance | |
| jbpm_node | |
| jbpm_pooledactor | |
| jbpm_processdefinition | |
| jbpm_processinstance | |
| jbpm_runtimeaction | |
| jbpm_swimlane | |
| jbpm_swimlaneinstance | |
| jbpm_task | |
| jbpm_taskactorpool | |
| jbpm_taskcontroller | |
| jbpm_taskinstance | |
| jbpm_token | |
| jbpm_tokenvariablemap | |
| jbpm_transition | |
| jbpm_variableaccess | |
| jbpm_variableinstance | |
| jena_g1t0_reif | |
| jena_g1t1_stmt | |
| jena_g2t0_reif | |
| jena_g2t1_stmt | |
| jena_g3t0_reif | |
| jena_g3t1_stmt | |
| jena_g4t0_reif | |
| jena_g4t1_stmt | |
| jena_graph | |
| jena_long_lit | |
| jena_long_uri | |
| jena_prefix | |
| jena_sys_stmt | |
| localthemeconfig | |
| nxp_logs | |
| nxp_logs_extinfo | |
| nxp_logs_mapextinfos | |
| nxp_webwidgets_data | |
| nxp_webwidgets_widget | |
| nxp_webwidgets_widget_preferences | |
| subtopic | |
| topic | |
| uid_sequence | |
| user2group | |
| users | |
| usersubscription |
sql.properties
Description: Binary data
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!-- DEFAULT UNIFIED DATASOURCE CONFIGURATION -->
<!--
This is the default unified datasource configuration. All datasources from nuxeo
points to this datasource so it will use only 1 database.
To use another database than Derby, comment out the following section and uncomment
your database configuration or add it if not present.
If you wish to use a different database for a service, comment out the link in the relevant
xxx-ds.xml file and add a datasource configuration.
-->
<!-- nuxeo datasource -->
<!--
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>
jdbc:derby:${jboss.server.data.dir}/derby/nuxeo;create=true
</connection-url>
<driver-class>org.apache.derby.jdbc.EmbeddedDriver</driver-class>
<user-name>sa</user-name>
<password></password>
</local-tx-datasource>
-->
<!-- Configuration for Postgres -->
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/nuxeo</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>postgres</password>
<check-valid-connection-sql>;</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
<?xml version="1.0"?>
<component name="default-repository-config">
<documentation>
Defines the default JackRabbit repository used for development and
testing.
</documentation>
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<documentation>
Declare a JackRabbit repository to be used for development and
tests. The extension content is the jackrabbit XML configuration
of the repository.
</documentation>
<repository name="default"
factory="org.nuxeo.ecm.core.repository.jcr.JCRRepositoryFactory"
securityManager="org.nuxeo.ecm.core.repository.jcr.JCRSecurityManager"
forceReloadTypes="false">
<Repository>
<!--
virtual file system where the repository stores global state (e.g.
registered namespaces, custom node types, etc.)
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository" />
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager: class: FQN of class implementing the AccessManager
interface
-->
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- <param name="config" value="${rep.home}/access.xml"/> -->
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value) -->
<param name="anonymousId" value="anonymous" />
<!--
default user name to be used instead of the anonymous user when no
login credentials are provided (unset by default)
-->
<!-- <param name="defaultUserId" value="superuser"/> -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default workspace
-->
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default" />
<!--
workspace configuration template: used to create the initial workspace
if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace: class: FQN of class
implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}" />
</FileSystem>
<!--
persistence manager of the workspace: class: FQN of class
implementing the PersistenceManager interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
<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>
<!--
Search index and the file system it uses. class: FQN of class
implementing the QueryHandler interface
-->
<SearchIndex
class="org.nuxeo.ecm.core.repository.jcr.jackrabbit.SearchIndex">
<param name="path" value="${wsp.home}/index" />
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the respective
persistence manager
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version" />
</FileSystem>
<!--
Configures the persistence manager to be used for persisting version
state. Please note that the current versioning implementation is
based on a 'normal' persistence manager, but this could change in
future implementations.
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
<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>
<!--
Search index for content that is shared repository wide (/jcr:system
tree, contains mainly versions)
-->
<SearchIndex
class="org.nuxeo.ecm.core.repository.jcr.jackrabbit.SearchIndex">
<param name="path" value="${rep.home}/repository/index" />
</SearchIndex>
</Repository>
</repository>
</extension>
<!-- Versioning -->
<implementation class="org.nuxeo.ecm.core.repository.jcr.versioning.Versioning" />
<property name="versioningService" value="org.nuxeo.ecm.core.versioning.custom.CustomVersioningService" />
</component><?xml version="1.0"?>
<connection-factories>
<tx-connection-factory>
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.5.0.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<config-property name="xaDataSource" type="java.lang.String">org.h2.jdbcx.JdbcDataSource</config-property>
<config-property name="property" type="java.lang.String">URL=jdbc:h2:${jboss.server.data.dir}/h2/nuxeo</config-property>
<config-property name="property" type="java.lang.String">User=sa</config-property>
<config-property name="property" type="java.lang.String">Password=</config-property>
<max-pool-size>20</max-pool-size>
<!-- Configuration for PostgreSQL:
<config-property name="xaDataSource" type="java.lang.String">org.postgresql.xa.PGXADataSource</config-property>
<config-property name="property" type="java.lang.String">ServerName=localhost</config-property>
<config-property name="property" type="java.lang.String">PortNumber/Integer=5432</config-property>
<config-property name="property" type="java.lang.String">DatabaseName=nuxeo</config-property>
<config-property name="property" type="java.lang.String">User=postgres</config-property>
<config-property name="property" type="java.lang.String">Password=</config-property>
-->
<!-- Configuration for Derby:
<config-property name="xaDataSource" type="java.lang.String">org.apache.derby.jdbc.EmbeddedXADataSource</config-property>
<config-property name="property" type="java.lang.String">createDatabase=create</config-property>
<config-property name="property" type="java.lang.String">databaseName=${jboss.server.data.dir}/derby/nuxeo</config-property>
<config-property name="property" type="java.lang.String">user=sa</config-property>
<config-property name="property" type="java.lang.String">password=</config-property>
-->
</tx-connection-factory>
</connection-factories>
<?xml version="1.0"?>
<connection-factories>
<tx-connection-factory>
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.5.0.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<!--
<config-property name="xaDataSource" type="java.lang.String">org.h2.jdbcx.JdbcDataSource</config-property>
<config-property name="property" type="java.lang.String">URL=jdbc:h2:${jboss.server.data.dir}/h2/nuxeo</config-property>
<config-property name="property" type="java.lang.String">User=sa</config-property>
<config-property name="property" type="java.lang.String">Password=</config-property>
<max-pool-size>20</max-pool-size>-->
<!-- Configuration for PostgreSQL:-->
<config-property name="xaDataSource" type="java.lang.String">org.postgresql.xa.PGXADataSource</config-property>
<config-property name="property" type="java.lang.String">ServerName=localhost</config-property>
<config-property name="property" type="java.lang.String">PortNumber/Integer=5432</config-property>
<config-property name="property" type="java.lang.String">DatabaseName=nuxeo</config-property>
<config-property name="property" type="java.lang.String">User=postgres</config-property>
<config-property name="property" type="java.lang.String">Password=</config-property>
<!-- Configuration for Derby:
<config-property name="xaDataSource" type="java.lang.String">org.apache.derby.jdbc.EmbeddedXADataSource</config-property>
<config-property name="property" type="java.lang.String">createDatabase=create</config-property>
<config-property name="property" type="java.lang.String">databaseName=${jboss.server.data.dir}/derby/nuxeo</config-property>
<config-property name="property" type="java.lang.String">user=sa</config-property>
<config-property name="property" type="java.lang.String">password=</config-property>
-->
</tx-connection-factory>
</connection-factories>
Title: Nuxeo- PostgreSQL Sequences list
Nuxeo- PostgreSQL Sequences list
Generated: Thu May 21 15:46:38 2009Server: PostgreSQL 8.3 (localhost:5432)
Database: nuxeo
Schema: public
Sequences
| Sequence | Comment |
|---|---|
| hibernate_sequence | |
| jena_graph_id_seq | |
| jena_long_lit_id_seq | |
| jena_long_uri_id_seq | |
| jena_prefix_id_seq |
Title: Database properties report - nuxeo
Database properties report - nuxeo
Generated: Thu May 21 15:44:25 2009Server: PostgreSQL 8.3 (localhost:5432)
Database: nuxeo
Database properties
| Property | Value |
|---|---|
| Name | nuxeo |
| OID | 19130 |
| Owner | postgres |
| ACL | |
| Tablespace | pg_default |
| Default tablespace | pg_default |
| Encoding | UTF8 |
| Default schema | public |
| Allow connections? | Yes |
| Connected? | Yes |
| System database? | No |
| Comment |
-- Database: nuxeo
-- DROP DATABASE nuxeo;
CREATE DATABASE nuxeo
WITH OWNER = postgres
ENCODING = 'UTF8';
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
