Hi,
I recently built Nuxeo 5.2 from source
(http://doc.nuxeo.org/xwiki/bin/view/FAQ/DownloadingNuxeoSources). I can
successfully deploy it using the default database configuration. I
followed instructions in Nuxeo Book (ch: 40) to change the database to
MySQL 5.1.31 (Connector/J 5.1). However, I am getting the error
described below. My unified-nuxeo-ds.xml (not mentioned in seemingly
outdated Ch:40) looks as follows:
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>
jdbc:mysql://localhost/nuxeo?relaxAutoCommit=true&emulateLocators=true
</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>test</user-name>
<password>test</password>
<check-valid-connection-sql>select count(*) from
dual</check-valid-connection-sql>
</local-tx-datasource>
I have given proper privileges to the test user to access nuxeo database.
I have already changed datasource config for JBoss (default and mq) as
per instructions from JBoss. I have looked at
http://jena.sourceforge.net/DB/mysql-howto.html but can't find any
relevant instructions. What am I missing?
thanks,
sanjay
CollectionSpace - UCB
2009-02-24 09:54:35,676 INFO
[org.nuxeo.runtime.osgi.OSGiRuntimeService] Nuxeo EP Started
======================================================================
= Nuxeo EP Started
======================================================================
= Component Loading Status: Pending: 0 / Unstarted: 0 / Total: 229
======================================================================
2009-02-24 09:54:35,676 INFO
[org.nuxeo.ecm.platform.relations.services.RelationService] Relation
Service initialization
2009-02-24 09:54:35,676 INFO
[org.nuxeo.ecm.platform.relations.services.RelationService] create RDF
Graph wiki
2009-02-24 09:54:35,958 WARN [com.hp.hpl.jena.db.impl.DriverRDB]
Problem formatting database
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'nuxeo.jena_prefix' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:91)
at com.hp.hpl.jena.db.impl.SQLCache.runSQLGroup(SQLCache.java:560)
at
com.hp.hpl.jena.db.impl.DriverRDB.formatAndConstructSystemSpecializedGraph(DriverRDB.java:427)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:305)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:835)
at
com.hp.hpl.jena.db.DBConnection.getDefaultModelProperties(DBConnection.java:195)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.consGraph(GraphRDBMaker.java:123)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.createGraph(GraphRDBMaker.java:107)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl.java:47)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl.java:50)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:288)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:187)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:828)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent(RelationService.java:514)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:200)
at
org.nuxeo.osgi.jboss.JBossOSGiAdapter.handleNotification2(JBossOSGiAdapter.java:219)
at
org.jboss.system.ListenerServiceMBeanSupport.handleNotification(ListenerServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationListenerProxy.java:153)
at $Proxy63.handleNotification(Unknown Source)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification(JBossNotificationBroadcasterSupport.java:127)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(JBossNotificationBroadcasterSupport.java:110)
at
org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:916)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:497)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:619)
2009-02-24 09:55:00,958 ERROR
[org.nuxeo.ecm.platform.relations.services.RelationService] Error while
initializing graph wiki
Caused by: com.hp.hpl.jena.db.RDFRDBException: Failed to unlock database
after 5 attempts -
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
'jena_mutex'
at com.hp.hpl.jena.db.impl.DriverRDB.unlockDB(DriverRDB.java:949)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:307)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:835)
at
com.hp.hpl.jena.db.DBConnection.getDefaultModelProperties(DBConnection.java:195)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.consGraph(GraphRDBMaker.java:123)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.createGraph(GraphRDBMaker.java:107)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl.java:47)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl.java:50)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:288)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:187)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:828)
... 17 more
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
