Just a quick note for those trying to use MySQL/Derby on large flat structures: you may hit (sooner
or later depending on how many children you have under a single node) a problem with the default
size of a field in MySQL/Derby. This has been discussed on Jackrabbit ML and there is a quick fix
for it (modifying the size of the field in the initial SQL files used by SimpleDbPersistenceManager).
./alex
--
.w( the_mindstorm )p.
---
(http://themindstorms.blogspot.com)
#: Nicolas Modrzyk changed the world a bit at a time by saying (astral date:
6/20/2006 5:11 AM) :#
Hey Claudio,
I don't really have any other valid answer than "It works here" and if the
mysql server is turned off it did not work.
We also tried with Postgresql and h2, each using the proper storage
backend.
We had some access permission problem on the mysql backend, which proved
that it was indeed used.
Can you send the config files you are using ? So I can have a quick look.
Hope we can get your mysql running quickly.
Nicolas,
On Mon, 19 Jun 2006 21:59:01 +0900, Claudio Greuter
<[email protected]> wrote:
Hello everyone
Today I tried to set up Jackrabbit to use mySQl to store the data of
magnolia. I used the XMl configurazion files mentioned in the mail from
Nicolas' mail below. And at first it seemed to work.
However I noticed that the MYSQL database do not contain any data, and
even if I turn off mySQL, Magnolia runs just fine... This clearly points
out that mysql is not used at all.
The config file of the repository (in repositiories.xml) is correctly
configured to point to the jackrabbit-mysql-search.xml. However if I
misconfigured the xml I would at least expect that some error appears.
For me it seems as if the content is still served from the filesystem,
as it still works even if I turned mysql off.
Any ideas?
***********************************************
IPH Informatik AG
Herr Claudio Greuter
Lagerhausstrasse 9
8400 Winterthur
Tel: +41 (052) 233 94 72
Fax: +41 (052) 233 94 71
[EMAIL PROTECTED]
***********************************************
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 24. Mai 2006 10:38
To: [email protected]
Subject: Re: [magnolia-user] magnolia on mysql or other databases
The mysql config file is in the svn:
http://svn.magnolia.info/svn/magnolia/trunk/magnolia/src/main/webapp/
WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
You need to change the parameter config file in the repositories.xml:
...
<param name="configFile" value="WEB-INF/config/repo-conf/jackrabbit-
mysql-search.xml" />
...
And to include the jar file with the url I've pointed before:
http://www.ibiblio.org/maven/wadi/dependencies/maven2/mysql/mysql-
connector-java/3.1.11-bin/
If you can, let me know if/when you have this working.
Regards,
Nicolas,
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
