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 <alopez@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:alopez@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.lamb@hull.ac.uk|| www.hull.ac.uk
>>
>> -----Original Message-----
>> From: Alex Lopez [mailto:alopez@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