Hi,

We're using too Mysql 5.1 for the data storage. We would like to have the "Compass Search Service backend" working with it.

thx, Olivier Adam

Service Informatique
Rectorat de l'académie de Rennes



Georges Racinet a écrit :

On Jun 5, 2007, at 9:53 AM, Vincent Dutat wrote:

Hi,

I am in the exact same situation, with the same exceptions, I even changed/removed the dialectClass attribute in nuxeo.ear/platform/nuxeo-platform-search-compass-plugin-5.1-SNAPSHOT.jar/compass.cfg.xml but it did not solve the problem. (FYI I posted a message yesterday).


Hi there:

About the Compass Search Service backend, I've so far tested it successfully with PostgreSQL(besides HSQL). I'll have to make it work with MySQL for 5.1, but it's not on top of my todo list right now, although I'd appreciate if you created the corresponding ticket in the jira tracker ;-)

Greetings,

GR


Regards.

Sean Radford wrote:
Hi,
Has anyone got Nuxeo to fully use MySQL?
I have got the head to successfully use MySQL for the main repository, but have problems with the other services. For these I have:
1. configured my MySQL server for default engine of InnoDB
2. created the database with correct user access.
3. amended the datasources/***.xml files
4. amended config/comment-relations-bundle.xml to databaseType MySQL (also tried MYSQL 5. amended config/nxrelations-default-jena-bundle.xml to databaseType MySQL (also tried MYSQL All seems to go ok on boot-up but when I try to create a document I get set of stacktrace in the log. Afraid I haven't fully had time yet to investigate yet, but:
1. I have no tables in: NXRELATIONS_DEFAULT_JENA or NXSEARCH_COMPASS
2. On going to the 'New Workspace' form I get:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.
3. On saving my 'new workspace' I get:
Failed to create dir [index_nxdocs]; nested exception is org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute [create table index_nxdocs (name_ varchar(50) , value_ longvarbinary , size_ integer , lf_ timestamp , deleted_ bit, primary key (name_) ) ];
The workspace saves, but I'm guessing is not being indexed.
Any ideas? (sorry if there is an obvious problem, and I'm a little premature in my posting)
Thanks and regards,
Sean
---
Dr. Sean Radford, MBBS, MSc
http://www.tacola.com

_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm


---------
Georges Racinet,   Nuxeo SAS
Open Source Enterprise Content Management (ECM)
Web: http://www.nuxeo.com/ and http://www.nuxeo.org/ - Tel: +33 1 40 33 79 87



_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

begin:vcard
fn:Olivier Adam
n:Adam;Olivier
org;quoted-printable:Rectorat de Rennes;SERvice Informatique Acad=C3=A9mique (SERIA)
email;internet:[EMAIL PROTECTED]
title;quoted-printable:SERIA-T : D=C3=A9partement "D=C3=A9veloppements des TIC en =C3=A9tablisse=
	ments et services"
tel;work:02 23 21 75 84
version:2.1
end:vcard

_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

Reply via email to