Re: [Ecm] Document link dissapear afetr migration.

[Nicolas SARMIR]

 I confirm that the domain/workspace structure have been created before 
the migration. Only few documents have been created since the migration.
Here are the file you asked:
For 5.3.2
Nuxeo.conf (it's the same file for both nuxeo version)
# Configuration file for Nuxeo
# Java ---------------------------------------------------
#JAVA_HOME=/usr/lib/jvm/java-6-sun
#JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Versions/1.6/Home
JAVA_OPTS=-Xms512m -Xmx1024m -XX:MaxPermSize=512m 
-Dsun.rmi.dgc.client.gcInterval=3600000 
-Dsun.rmi.dgc.server.gcInterval=3600000 -Dfile.encoding=UTF-8


# Nuxeo layout -------------------------------------------
# Relative paths will be anchored at NUXEO_HOME
nuxeo.log.dir=/tech_datas/nuxeo/log
nuxeo.pid.dir=/tech_datas/nuxeo/bin
nuxeo.data.dir=/tech_datas/nuxeo/data


# Runtime options ----------------------------------------
nuxeo.force.generation=false

# See templates/README.txt for customization parameters.
#nuxeo.templates=default
#nuxeo.bind.address=0.0.0.0


## More options ------------------------------------------
# Enable jconsole
#JAVA_OPTS=$JAVA_OPTS -Dcom.sun.management.jmxremote=true

# Log Garbage Collector informations into a file
#JAVA_OPTS=$JAVA_OPTS -Xloggc:$DIRNAME/../log/gc.log  -verbose:gc 
-XX:+PrintGCDetails -XX:+PrintGCTimeStamps

# BEA JROCKIT
#JAVA_HOME=/usr/local/jrockit-R27.4.0-jdk1.5.0_12
#JAVA_OPTS=-server -Xms$HEAP_SIZE -Xmx$HEAP_SIZE 
-Dsun.rmi.dgc.client.gcInterval=3600000 
-Dsun.rmi.dgc.server.gcInterval=3600000
# Enable Jrockit Mission control
#JAVA_OPTS=$JAVA_OPTS -Xmanagement

# DEBUGGING ----------------------------------------------
# Sample JPDA settings for remote socket debugging
#JAVA_OPTS=$JAVA_OPTS -Xdebug 
-Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n

# Sample JPDA settings for shared memory debugging
#JAVA_OPTS=$JAVA_OPTS -Xdebug -Xnoagent -Djava.compiler=NONE 
-Xrunjdwp:transport=dt_shmem,server=y,suspend=n,address=jboss


# pgsql information
nuxeo.templates=postgresql

nuxeo.db.name=nuxeo
nuxeo.db.user=nuxeo
nuxeo.db.password=nuxeo
nuxeo.db.host=localhost
nuxeo.db.port=5432

# conf mail
mail.smtp.host=
mail.smtp.port=25
mail.from=nore...@nuxeo.tech-advantage.com
nuxeo.url=http://nuxeo:8080/nuxeo/

# cat server/default/deploy/nuxeo.ear/datasources/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">nuxeo</xa-datasource-property>
<xa-datasource-property name="Password">nuxeo</xa-datasource-property>
<max-pool-size>20</max-pool-size>
<track-connection-by-tx/>
</xa-datasource>
</datasources>

# cat server/default/deploy/nuxeo.ear/datasources/default-repository-ds.xml
<?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.6.2.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<max-pool-size>20</max-pool-size>

<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=nuxeo</config-property>
<config-property name="property" 
type="java.lang.String">Password=nuxeo</config-property>
</tx-connection-factory>
</connection-factories>

and now for 5.4 version:
# cat /opt/nuxeo-dm/nxserver/config/default-repository-config.xml
<?xml version="1.0"?>
<component name="default-repository-config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
    point="repository">
<repository name="default"
      factory="org.nuxeo.ecm.core.storage.sql.ra.PoolingRepositoryFactory">
<repository name="default">
<clustering enabled="false" delay="1000" />
<binaryStore path="" />
<schema>
<field type="largetext">note</field>
<field type="largetext">webp:content</field>
<field type="largetext">webc:welcomeText</field>
<field type="largetext">comment:comment</field>
<field type="largetext">post</field>
<field type="largetext">mail:mail</field>
</schema>
<indexing>
<fulltext analyzer="english"/>
</indexing>
<xa-datasource>org.postgresql.xa.PGXADataSource</xa-datasource>
<property name="ServerName">localhost</property>
<property name="PortNumber">5432</property>
<property name="DatabaseName">nuxeo</property>
<property name="User">nuxeo</property>
<property name="Password">*nuxeo</property>
</repository>
</repository>
</extension>
</component>


# cat /opt/nuxeo-dm/conf/Catalina/localhost/nuxeo.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
    Licensed to the Apache Software Foundation (ASF) under one or more
    contributor license agreements. See the NOTICE file distributed 
with this
    work for additional information regarding copyright ownership. The ASF
    licenses this file to You under the Apache License, Version 2.0 (the
    "License"); you may not use this file except in compliance with the 
License.
    You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0 Unless required by 
applicable law
    or agreed to in writing, software distributed under the License is
    distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS 
OF ANY
    KIND, either express or implied. See the License for the specific 
language
    governing permissions and limitations under the License.
  -->
<Context antiResourceLocking="false" privileged="true" path="/nuxeo"
  docBase="../nxserver/nuxeo.war">

<!--
    Disable HTTP Session persistence between restart since webengine 
session
    objects are not serializable
  -->
<Manager pathname="" />

<!--
    define custom loader that is responsible to start nuxeo runtime (it 
extends
    the default one)
  -->
<Loader className="org.nuxeo.runtime.tomcat.NuxeoWebappLoader"
    loaderClass="org.nuxeo.runtime.tomcat.NuxeoWebappClassLoader" />

<Listener className="org.nuxeo.runtime.tomcat.NuxeoLauncher" 
home="${catalina.base}/nxserver" />

<!--
    Define JDBC datasources: the JNDI names will be:
    java:comp/env/jdbc/DATABASE_NAME. For example
    java:comp/env/jdbc/nxsqldirectory This means you need to update
    corresponding JNDI bindings in nuxeo data source definitions in the 
config
    directory
  -->
<Resource name="jdbc/nxsqldirectory" auth="Container" 
type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/nxrelations-default-jena" auth="Container"
    type="javax.sql.DataSource" maxActive="100" maxIdle="30" 
maxWait="10000"
    driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/comment-relations" auth="Container" 
type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/nxaudit-logs" auth="Container" 
type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/nxjbpm" auth="Container" type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/placeful_service_ds" auth="Container" 
type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="jdbc/nxwebwidgets" auth="Container" 
type="javax.sql.DataSource"
    maxActive="100" maxIdle="30" maxWait="10000" 
driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/nuxeo"
    username="nuxeo" password="nuxeo" />

<Resource name="TransactionManager" auth="Container"
    type="javax.transaction.TransactionManager" 
factory="org.nuxeo.runtime.jtajca.NuxeoTransactionManagerFactory"
    transactionTimeoutSeconds="300" />
<Transaction 
factory="org.nuxeo.runtime.jtajca.NuxeoUserTransactionFactory" />
<Resource name="NuxeoConnectionManager" auth="Container"
    type="javax.resource.spi.ConnectionManager" 
factory="org.nuxeo.runtime.jtajca.NuxeoConnectionManagerFactory"
    minPoolSize="0" maxPoolSize="20"
    idleTimeoutMinutes="0" />
</Context>


I check the database and when i created a document after the migration, 
the entry is created in the content table in the database.

Regards, Nicolas.

On 26.11.2010 11:56, Julien CARSIQUE wrote:
Hello,

Configuration files have slightly changed between 5.3.2 and 5.4, and 
between JBoss and Tomcat.
Maybe it could be easier to upgrade from JBoss 5.3.2 to JBoss 5.4.0, 
then migrate from JBoss 5.4.0 to Tomcat 5.4.0. But let's first check 
your configuration files.
Since Nuxeo 5.3.2, we use templates configuration files so the first 
thing to check is your nuxeo.conf.

Could you paste content of the following old and new files:

    * 5.3.2
          o bin/nuxeo.conf
          o server/default/deploy/nuxeo.ear/datasources/unified-nuxeo-ds.xml
          o 
server/default/deploy/nuxeo.ear/datasources/default-repository-ds.xml
    * 5.4.0
          o bin/nuxeo.conf
          o nxserver/config/default-repository-config.xml
          o conf/Catalina/localhost/nuxeo.xml

Answering Thierry's question about creation date of domain/workspace 
structure, can you confirm those appear as being created when you 
installed Nuxeo 5.3.2, not when you upgraded to 5.4.0 ?

Julien


Le 26/11/10 11:37, Nicolas SARMIR a écrit :
That's the problem: i've nothing on the log file.
I check the creation date and it's the right date.

Error with the repo db could be possible: i would use my 
default-repository-config.xml from my nuxeo 5.3.2 but it wouldn't work.
Here are my two default-repository-config.xml files:
From nuxeo 5.3.2
<?xml version="1.0"?>
<component name="default-repository-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">
<schema>
<field type="largetext">note</field>
<field type="largetext">webp:content</field>
<field type="largetext">webc:welcomeText</field>
<field type="largetext">comment:comment</field>
<field type="largetext">post</field>
<field type="largetext">mail:mail</field>
</schema>
<indexing>
<fulltext analyzer="english">
<index name="default">
<!-- all props implied -->
</index>
<index name="title">
<field>dc:title</field>
</index>
<index name="description">
<field>dc:description</field>
</index>
</fulltext>
</indexing>
</repository>
</repository>
</extension>
</component>



From 5.4.0.1
<?xml version="1.0"?>
<component name="default-repository-config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
    point="repository">
<repository name="default"
      
factory="org.nuxeo.ecm.core.storage.sql.ra.PoolingRepositoryFactory">
<repository name="default">
<clustering enabled="false" delay="1000" />
<binaryStore path="" />
<schema>
<field type="largetext">note</field>
<field type="largetext">webp:content</field>
<field type="largetext">webc:welcomeText</field>
<field type="largetext">comment:comment</field>
<field type="largetext">post</field>
<field type="largetext">mail:mail</field>
</schema>
<indexing>
<fulltext analyzer="english"/>
</indexing>
<xa-datasource>org.postgresql.xa.PGXADataSource</xa-datasource>
<property name="ServerName">localhost</property>
<property name="PortNumber">5432</property>
<property name="DatabaseName">nuxeo</property>
<property name="User">nuxeo</property>
<property name="Password">nuxeo</property>
</repository>
</repository>
</extension>
</component>


Thanks for you help.

Regards, Nicolas.

On 25.11.2010 18:35, Thierry Delprat wrote:

Do you have anything interesting in the logs ?
Do you have domain/workspace structure ? If yes, check the creation 
date.

May be there is something wrong with repo db config and your repo is 
running against the embeded db.

Tiry

Le 25 nov. 2010 11:35, "Nicolas SARMIR" 
<nicolas.sar...@tech-advantage.com 
<mailto:nicolas.sar...@tech-advantage.com>> a écrit :
> Hi all,
>
> I'm experiencing a problem after nuxeo migration from jboss 5.3.2 to
> tomcat 5.4. I'm using postgresql. Everything look working fine but my
> documents created before the migration are all unavailable on the
> interface. There are no error message.
>
> Is it a know problem?
>
> Thanks and regards, Nicolas.
> _______________________________________________
> ECM mailing list
> ECM@lists.nuxeo.com <mailto:ECM@lists.nuxeo.com>
> http://lists.nuxeo.com/mailman/listinfo/ecm
> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm


_______________________________________________
ECM mailing list
ECM@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go tohttp://lists.nuxeo.com/mailman/options/ecm

--
Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com  - The Open Source ECM Platform -www.nuxeo.org
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM Platform

_______________________________________________
ECM mailing list
ECM@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm