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