hello evry body,
i'm trying to configure nuxeo with mysql 5 using the nuxeo-book:
*1.* i modify the 2 PersistenceManager sections in the *
server\default\deploy\nuxeo.ear\config\default-repository-config.xml* file
as below:
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost/nuxeo"/>
<param name="user" value="mysqluser"/>
<param name="password" value="password"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
<!--
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.MySqlPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost/nuxeo"/>
<param name="user" value="mysqluser"/>
<param name="password" value="root"/>
<param name="schema" value="password"/>
<param name="schemaObjectPrefix" value="jcr_ver_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
*2.* i modify the *
server\default\deploy\nuxeo.ear\datasources\unified-nuxeo-ds.xml* file as
below :
<!-- Configuration for Mysql -->
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:mysql://localhost/nuxeo</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>root</password>
<check-valid-connection-sql>;</check-valid-connection-sql>
</local-tx-datasource>
*3.* i modify the connection section of the *
server\default\deploy\nuxeo.ear\system\nuxeo-platform-search-compass-plugin-5.1.6.jar\compass.cfg.xml
* as below :
<connection>
<!-- IMPORTANT. This connection setting is a sample.
It will be overridden by the compass backend's extension point for
NXRuntime. To avoid overriding it the latest contribution to the
extension point should be:
<extension
target="org.nuxeo.ecm.core.search.backend.compass.CompassBackend"
point="connection">
<default/>
</extension>
-->
<jdbc managed="true"
dialectClass="org.apache.lucene.store.jdbc.dialect.MySQLDialect"
deleteMarkDeletedDelta="60000">
<dataSourceProvider>
<jndi lookup="java:/nxsearch-compass" />
</dataSourceProvider>
</jdbc>
</connection>
*3.* i copy the *mysql-connector-java-5.0.4-bin.jar* in *\server\default\lib
*
**
*4. i created an empty database nuxeo in MySQL database server*
**
But when i start nuxeo , i get this:
**
*2008-10-25 04:45:06,234 WARN [org.hibernate.ejb.Ejb3Configuration]
Persistence provider caller does not implements the EJB3 spec correctly.
PersistenceUnitInfo.getNewTempClassLoader() is null.
2008-10-25 04:45:07,796 WARN
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Destroying connection that is not valid, due to the following exception:
[EMAIL PROTECTED]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Query was empty
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
at com.mysql.jdbc.Statement.execute(Statement.java:695)
at
org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:458)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:491)
at*
**
*--------------------------------*
**
I have somme questions :
How to create nuxeo internal database in mysql ?
Has nuxeo an sql script for its internal database like *liferay and intalio*
?
Thanks you for your help
**
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
