Hi Simon and Alex,
Thanks for the suggested change. Proai has been modified accordingly:
https://github.com/fcrepo/proai/commit/ecdfdd4ea2b9bbad4b96d0df40c70e23ecb2b6ca
..and a new version of oaiprovider has been released with the new proai
library:
http://downloads.sourceforge.net/fedora-commons/oaiprovider-1.2.2.zip
- Chris
On Wed, Dec 7, 2011 at 5:51 AM, Alex Lopez <alo...@flordeutopia.pt> wrote:
> Well I saw that already, its just one line... I was willing to file a
> bug ticket and submit a patch but as I'm not a commiter I wanted to
> check with the list first and get approval or someone else to do it.
>
> I do think "ENGINE" is a better and more general solution than "TYPE",
> after reading MySQL documentation regarding this (don't you think 4.x is
> early enough for MySQL nowadays?). From MySQL 4.1 ref manual:
>
> The ENGINE and TYPE options specify the storage engine for the table.
> ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is
> the preferred option name as of those versions, and TYPE has become
> deprecated. TYPE is supported throughout the 4.x series, but likely will
> be removed in the future.
>
> [ http://dev.mysql.com/doc/refman/4.1/en/create-table.html ]
>
> Basically the change would shift MySQL support from (3.23.x <-> 5.0.x)
> to (4.0.18/4.1.2 <-> 5.5.x).
>
> Best,
> Alex
>
> Em 06-12-2011 16:37, Simon W Lamb escreveu:
> > Glad to hear :-)
> >
> > Just for interest, the change I made was to:-
> >
> > https://github.com/fcrepo/proai/blob/master/src/java/proai/util/MySQLDDL
> > Converter.java#L112
> >
> > (Line 112)
> > From:-
> > out.append(" TYPE=" + spec.getType());
> > To:-
> > out.append(" ENGINE=" + spec.getType());
> >
> > It's probably not ideal as a general solution (i.e. might not work in
> > earlier versions of MySQL), however for yours and my scenarios it does
> > the job.
> >
> > Cheers,
> > Simon
> >
> >
> > -----Original Message-----
> > From: Alex Lopez [mailto:alo...@flordeutopia.pt]
> > Sent: 06 December 2011 15:20
> > To: Support and info exchange list for Fedora users.
> > Cc: Simon W Lamb
> > Subject: Re: [fcrepo-user] Fedora OAI provider errors
> >
> > Hi Simon,
> >
> > I replaced the lib with the one you provided and that did it :)
> >
> > Thanks and kind regards,
> > Alex
> >
> > Em 06-12-2011 09:50, Simon W Lamb escreveu:
> >> Hi Alex,
> >>
> >> Although I'm not sure if this will fix your second issue, attached is
> >> an updated 'proai-1.1.2.jar' which contains modified code to stop the
> >> issue with 'type=InnoDB', the code now uses 'engine=InnoDB'. I
> >> modified the code locally, therefore this code change will not be
> >> reflected on the Fedora-commons GitHub/SourceForge. You just need
> > to
> >> copy the file to - $CATALINA_HOME/webapps/oaiprovider/WEB-INF/lib .
> >>
> >> If this is a fresh install, it's probably worth deleting all the
> >> Cache/sessions folders, SQL Tables before starting Tomcat. This
> > should
> >> create all the necessary tables without your previous issue on
> > startup.
> >>
> >>
> >> Regards,
> >>
> >> Simon Lamb
> >> Software Developer
> >> Information and Communication Technology Department (ICTD) || The
> >> University of Hull s.l...@hull.ac.uk|| www.hull.ac.uk
> >>
> >> -----Original Message-----
> >> From: Alex Lopez [mailto:alo...@flordeutopia.pt]
> >> Sent: 28 November 2011 16:29
> >> To: Support and info exchange list for Fedora users.
> >> Subject: [fcrepo-user] Fedora OAI provider errors
> >>
> >> Hi!
> >>
> >> I'm trying to install OAI provider (
> >> http://sourceforge.net/projects/fedora-commons/files/services/3.4/ )
> >> as explained here (
> >> https://wiki.duraspace.org/display/FCSVCS/OAI+Provider+Service+1.2.1 )
> >
> >> into an existing 3.5 FCRepo.
> >>
> >> Now the thing is we upgraded to MySQL 5.5 recently and proai tries to
> >> issue a CREATE TABLE with "type=InnoDB" which, as I discovered today,
> >> is deprecated since MySQL 5.0 and not supported since 5.1. Manually
> >> creating the table rcAdmin makes the webapp start, but each time it
> >> tries to update itself it gives error:
> >>
> >> Table 'proai.rcQueue' doesn't exist
> >>
> >> So I guess there really might be issues with MySQL 5.5.
> >>
> >> Am I using the right version of OAI provider?
> >> Is there something I can configure in proai.properties to make it work
> >
> >> with MySQL 5.5 database?
> >>
> >> Thanks!
> >>
> >> Kind regards,
> >> Alex
> >>
> >> ----------------------------------------------------------------------
> >> --
> >> ------
> >> All the data continuously generated in your IT infrastructure contains
> >
> >> a definitive record of customers, application performance, security
> >> threats, fraudulent activity, and more. Splunk takes this data and
> >> makes sense of it. IT sense. And common sense.
> >> http://p.sf.net/sfu/splunk-novd2d
> >> _______________________________________________
> >> Fedora-commons-users mailing list
> >> Fedora-commons-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
> >
> > ------------------------------------------------------------------------
> > ------
> > Cloud Services Checklist: Pricing and Packaging Optimization This white
> > paper is intended to serve as a reference, checklist and point of
> > discussion for anyone considering optimizing the pricing and packaging
> > model of a cloud services business. Read Now!
> > http://www.accelacomm.com/jaw/sfnl/114/51491232/
> > _______________________________________________
> > Fedora-commons-users mailing list
> > Fedora-commons-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
> >
> >
> ------------------------------------------------------------------------------
> > Cloud Services Checklist: Pricing and Packaging Optimization
> > This white paper is intended to serve as a reference, checklist and
> point of
> > discussion for anyone considering optimizing the pricing and packaging
> model
> > of a cloud services business. Read Now!
> > http://www.accelacomm.com/jaw/sfnl/114/51491232/
> > _______________________________________________
> > Fedora-commons-users mailing list
> > Fedora-commons-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
>
>
> ------------------------------------------------------------------------------
> Cloud Services Checklist: Pricing and Packaging Optimization
> This white paper is intended to serve as a reference, checklist and point
> of
> discussion for anyone considering optimizing the pricing and packaging
> model
> of a cloud services business. Read Now!
> http://www.accelacomm.com/jaw/sfnl/114/51491232/
> _______________________________________________
> Fedora-commons-users mailing list
> Fedora-commons-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
>
------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
Fedora-commons-users mailing list
Fedora-commons-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
