Trying to keep our test and production servers in sync :) -----Original Message----- From: Jari Häkkinen [mailto:j...@thep.lu.se] Sent: 08 May 2009 22:10 To: BASE ML Subject: Re: [base] Installation error messages
And why not use the latest BASE 2.11? Jari Nicklas Nordborg wrote: > It doesn't seem related to the Java version. If I remember correctly > there has been users with similar problems before and I think the > problem was a mismatch of the character encoding used by the MySQL > server and the character encoding used by the JDBC driver. > > I recommend that you use the UTF-8 character set since from BASE 2.9 > this is required for BASE to work. I can see that you connection url is > missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see > if it helps. > > /Nicklas > > michael watson (IAH-C) wrote: >> Dear List >> >> >> >> I'm trying to install BASE 2.8.4 on a new server. >> >> >> >> We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also >> have MySQL 5.0.45 >> >> >> >> Any clues appreciated! >> >> >> >> When I run initdb.sh I get: >> >> >> >> --System information----------------------------- >> >> BASE : 2.8.4 >> >> Database : >> jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true >> >> Dialect : org.hibernate.dialect.MySQLInnoDBDialect >> >> JDBC : com.mysql.jdbc.Driver; version 5.1 >> >> Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. >> >> OS : Linux; amd64; 2.6.18-92.el5 >> >> ------------------------------------------------- >> >> Building database.......... >> >> Database built successfully. >> >> Initialising database... >> >> --Creating quota types... >> >> --Creating quota... >> >> --Creating roles... >> >> --Creating users... >> >> --Creating groups... >> >> --Creating keys... >> >> --Creating protocol types... >> >> --Creating hardware types... >> >> --Creating hardware... >> >> --Creating software types... >> >> --Creating software... >> >> --Creating directories... >> >> --Creating file types... >> >> --Creating MIME types... >> >> --Creating plate geometries... >> >> --Creating plate mappings... >> >> --Creating labels... >> >> --Creating annotation types... >> >> --Creating clients... >> >> --Creating news... >> >> --Creating plugin definitions... >> >> --Creating example plugin configurations... >> >> --Creating formulas... >> >> --Creating job agents... >> >> --Creating data file types... >> >> --Creating platforms... >> >> Database initialised successfully. >> >> Updating database... >> >> Database updated successfully. >> >> Installing web application... >> >> >> >> net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) >> >> at >> net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:478) >> >> at >> net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) >> >> at net.sf.basedb.install.Webclient.install(Webclient.java:155) >> >> at net.sf.basedb.install.InitDB.main(InitDB.java:81) >> >> Caused by: net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) >> >> at net.sf.basedb.core.DbControl.commit(DbControl.java:381) >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) >> >> ... 4 more >> >> Caused by: org.hibernate.exception.GenericJDBCException: could not >> insert: [net.sf.basedb.core.data.HelpData] >> >> at >> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) >> >> at >> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) >> >> at >> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) >> >> at >> org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40) >> >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) >> >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) >> >> at >> org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) >> >> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) >> >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) >> >> at >> org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) >> >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) >> >> at >> org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) >> >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) >> >> at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) >> >> at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) >> >> at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) >> >> at >> net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1056) >> >> ... 6 more >> >> Caused by: java.sql.SQLException: Incorrect string value: '\xD7</lbl...' >> for column 'description' at row 1 >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) >> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) >> >> at >> com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1328) >> >> at >> com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:838) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922) >> >> at >> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) >> >> at >> org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73) >> >> at >> org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33) >> >> ... 22 more >> >> >> >> Head of Bioinformatics >> Institute for Animal Health >> Compton >> Berks >> RG20 7NN >> 01635 578411 >> >> * * >> >> *Please consider the environment and don't print this e-mail unless you >> really need to.* >> >> The information contained in this message may be confidential or legally >> privileged and is intended solely for the addressee. If you have >> received this message in error please delete it & notify the originator >> immediately. Unauthorised use, disclosure, copying or alteration of >> this message is forbidden & may be unlawful. The contents of this >> e-mail are the views of the sender and do not necessarily represent the >> views of the Institute. This email, and associated attachments, has >> been checked locally for viruses but we can accept no responsibility >> once it has left our systems. Communications on Institute computers are >> monitored to secure the effective operation of the systems and for other >> lawful purposes. >> >> >> >> The Institute for Animal Health is a company limited by guarantee, >> registered in England no. 559784. >> >> The Institute is also a registered charity, Charity Commissioners >> Reference No. 228824 >> >> >> >> >> ------------------------------------------------------------------------ >> >> ------------------------------------------------------------------------------ >> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your >> production scanning environment may not be a perfect world - but thanks to >> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 >> Series Scanner you'll get full speed at 300 dpi even with all image >> processing features enabled. http://p.sf.net/sfu/kodak-com >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> The BASE general discussion mailing list >> basedb-users@lists.sourceforge.net >> unsubscribe: send a mail with subject "unsubscribe" to >> basedb-users-requ...@lists.sourceforge.net > > > ------------------------------------------------------------------------------ > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your > production scanning environment may not be a perfect world - but thanks to > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 > Series Scanner you'll get full speed at 300 dpi even with all image > processing features enabled. http://p.sf.net/sfu/kodak-com > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > basedb-users-requ...@lists.sourceforge.net ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net