[Opensim-users] OpenSim 1.7.0.2 and MySQL Versions

[Diva Canto]

Indeed, there is an issue with the MySql connector (MySql.Data.dll) and 
the version of the MySql server that you are using.

The official OpenSim tagged releases all use version 5.2.5.0 of the 
connector. Developer's code uses 6.2.4.0.

It turns out that 5.2.5.0 does not work with the newer versions of the 
MySql server (5.1.55 and above). 6.2.4.0 works well.

(The newer connector has some other issues, but hopefully people won't 
bump into those as often.)


On 3/9/2011 11:29 PM, Clive Gould wrote:
> Hi Justin
> I used git to fetch the latest master and a fresh install worked 
> faultlessly with Mono 142439 and mysql-5.1.56
> Thanks :D
> Clive
> Message: 6
> Date: Wed, 09 Mar 2011 21:40:09 +0000
> From: Justin Clark-Casey <jjustincc at googlemail.com 
> <mailto:jjustincc at googlemail.com>>
> To: opensim-users at lists.berlios.de <mailto:opensim-users at lists.berlios.de>
> Subject: Re: [Opensim-users] OpenSim 1.7.0.2 and MySQL Versions
> Message-ID: <4D77F3B9.8070007 at googlemail.com 
> <mailto:4D77F3B9.8070007 at googlemail.com>>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Funnily enough, I just updated Git master to use the newest MySQL 
> connector (6.3.6) in commit 3e5b1a1 so you might also
> want to try copying it from there.
>
> This dll might also solve the problem where some long-running 
> migrations fail.
>
> On 09/03/11 21:25, Sean Hennessee wrote:
> > I don't know all the details, but I have heard there are different 
> versions of MySql.Data.dll. If you get the newer
> > version, it should work with the newer versions of MySQL. We are 
> running MySQL 5.1.55-1 which was not working until we
> > got the newer dll. You might try here:
> > http://dev.mysql.com/downloads/connector/net/
> >
> > Peace,
> > Sean
> >
> > On 03/09/2011 11:17 AM, Clive Gould wrote:
> >> Hi everyone
> >> It has become clear that OpenSim 1.7.0.2 using Mono 142439 under Centos
> >> 5 will simply not work with mysql-5.1.55 or mysql-5.1.56
> >> It does however work fine with mysql-5.1.50
> >> Good luck
> >> Clive
> >
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110310/a539b5eb/attachment.html>