MySQL, but still Derby files

[Thomas Schroeder]

Hi,

I configured my Magnolia to run with MySQL and followed the page
http://wiki.magnolia-cms.com/display/WIKI/MySQL+Persistence

After starting Magnolia there were some tables created in MySQL but
there were also the Derby files in the filesystem (in
magnolia-4.1.1/apache-tomcat-5.5.27/webapps/magnoliaAuthor/repositories/magnolia/repository/).

Why are there any Derby files?
Is there something wrong with my config for MySQL?

tschuess
Thomas
--
Thomas Schroeder
Senior Software Developer
www.wotif.com
Thomas.Schroeder@...
Mobile: [phone]


This email (including any attachments) is confidential and may be privileged. If you have received it in error, please notify the sender by return email and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that emails are susceptible to change and we will not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. We do not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[Jan Haderka-2]

> Hi,
>
> I configured my Magnolia to run with MySQL and followed the page
> http://wiki.magnolia-cms.com/display/WIKI/MySQL+Persistence
>

Did you made the configuration changes prior installing the Magnolia
instance first time? If not the derby related files are probably just a
left over from previous (derby based) installation.

> After starting Magnolia there were some tables created in MySQL but
> there were also the Derby files in the filesystem (in
> magnolia-4.1.1/apache-tomcat-5.5.27/webapps/magnoliaAuthor/repositories/magnolia/repository/).
>
> Why are there any Derby files?
How do you know there are derby files? What you see at the path
mentioned above is a repository configuration and lucene indexes, not
necessarily the "derby files". If you were using derby, the "derby
files" would exist in ... repository/workspaces/<workspace_name>/db

> Is there something wrong with my config for MySQL?

Hard to say w/o looking at your config :) But since you claim to have a
tables created in the DB then it is most likely fine.

HTH,
Jan

>
> tschuess
> Thomas
> --
> Thomas Schroeder
> Senior Software Developer
> www.wotif.com
> Thomas.Schroeder@...
> Mobile: [phone]
>
>
> This email (including any attachments) is confidential and may be privileged. If you have received it in error, please notify the sender by return email and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that emails are susceptible to change and we will not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. We do not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[Matteo Pelucco]

Thomas Schroeder ha scritto:

> Hi,
>
> I configured my Magnolia to run with MySQL and followed the page
> http://wiki.magnolia-cms.com/display/WIKI/MySQL+Persistence
>
> After starting Magnolia there were some tables created in MySQL but
> there were also the Derby files in the filesystem (in
> magnolia-4.1.1/apache-tomcat-5.5.27/webapps/magnoliaAuthor/repositories/magnolia/repository/).
>
> Why are there any Derby files?

Are they data files or only indexing files?
In Jackrabbit "common way of doing" the persistence storage is indexed
by Lucene and Lucene indexes are stored on filesystem.

HTH, Matteo


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[Thomas Schroeder]

Hi,

Thanks for the hints.

Yes, I made the config changes before I installed Magnolia.

And I think the files in the repositories directory are index files.

There was also a derby.log file and then I realised that I had only
configured the magnoliaAuthor webapp and not the magnoliaPublic; so the
magnoliaPublic webapp is still running on derby.

Thanks again,
Thomas

On Wed, 2009-10-21 at 17:56 +1000, Jan Haderka wrote:

>
> > Hi,
> >
> > I configured my Magnolia to run with MySQL and followed the page
> > http://wiki.magnolia-cms.com/display/WIKI/MySQL+Persistence
> >
>
> Did you made the configuration changes prior installing the Magnolia
> instance first time? If not the derby related files are probably just a
> left over from previous (derby based) installation.
>
> > After starting Magnolia there were some tables created in MySQL but
> > there were also the Derby files in the filesystem (in
> > magnolia-4.1.1/apache-tomcat-5.5.27/webapps/magnoliaAuthor/repositories/magnolia/repository/).
> >
> > Why are there any Derby files?
> How do you know there are derby files? What you see at the path
> mentioned above is a repository configuration and lucene indexes, not
> necessarily the "derby files". If you were using derby, the "derby
> files" would exist in ... repository/workspaces/<workspace_name>/db
>
> > Is there something wrong with my config for MySQL?
>
> Hard to say w/o looking at your config :) But since you claim to have a
> tables created in the DB then it is most likely fine.
>
> HTH,
> Jan
> >
> > tschuess
> > Thomas
> > --
> > Thomas Schroeder
> > Senior Software Developer
> > www.wotif.com
> > Thomas.Schroeder@...
> > Mobile: [phone]
> >

This email (including any attachments) is confidential and may be privileged. If you have received it in error, please notify the sender by return email and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that emails are susceptible to change and we will not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. We do not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------