[opencms-dev] OpenCms 6 with MySQL 5: You may try this...

[Alexander Kandzior]

> > By the way, some guys have reported that they have got it 
> > installed on 
> > 5.0, but as I know it is not yet officially supported 
> > through Alkacon 
> > Software, so what's wrong with 4.1?

Compatibility with MySQL 5.0 hopefully is not really a major issue. I assume
it's a matter of changing the BLOB fields used for the RESOURCE_PATH in some
tables to TEXT BINARY (which is not compatible with MySQL 4.0 and earlier). 

If anyone wants to try, edit the "create_tables.sql" and exchange the lines 

RESOURCE_PATH BLOB NOT NULL,

With 

RESOURCE_PATH TEXT BINARY NOT NULL,

This should work with MySQL 4.1 and 5.0, and may also fix the issues with
the latest version of MySQL Connector/J. 

If anyone tries this, please let me know if it works...

BTW it's BLOB and not TEXT since it has to be case sensitive.

Kind Regards,
Alex.

-------------------
Alexander Kandzior

Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of 
> Christoph P. Kukulies
> Sent: Wednesday, January 25, 2006 8:29 PM
> To: Arash Kaffamanesh
> Cc: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] need urgent help - 6.0.4 
> installation asROOTfailsalways
> 
> Rats! I deinstalled MySql 5.0 and installed MySql 4.1 and the 
> ROOT app installation runs through without errors (!)
> 
> On Wed, Jan 25, 2006 at 07:10:25PM +0100, Arash Kaffamanesh wrote:
> > Ok. I asked you before about mysql version, anyway, I think 
> you have 
> > to install first on 4.1 and then dump and reimport the stuff to 5.0 
> > and reconnect your jdbc url to 5.0.
> > 
> > By the way, some guys have reported that they have got it 
> installed on 
> > 5.0, but as I know it is not yet officially supported 
> through Alkacon 
> > Software, so what's wrong with 4.1?
> 
> Nothing :-) I just was encouraged by the positive reports and 
> thought "so what's wrong with MySql 5.0?" :-)
> 
> Thanks.  It wednesday evening and I have it running as ROOT app.
> 
> --
> Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list To 
> change your list options, or to unsubscribe from the list, 
> please visit http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
>