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
