[mapguide-users] Can't connect to MySQL

[Ed Jobe]

I've installed mysql 5.0 and reinstalled mapguide 2.1 and copied libmysql.dll to the fdo folder but still, the mysql user is denied access. I'm new to mysql, so perhaps I've missed something. I've set up a user with rights to a db other than the default ones and set the user's resources to values other than 0. I don't know what else to do.
 
Ed Jobe




________________________________
From: Jack Lee <jack.lee at sympatico.ca>
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Sent: Wednesday, October 21, 2009 3:49:41 AM
Subject: Re: [mapguide-users] Can't connect to MySQL

Hi Ed,

depends does not necessary find the crt dlls even if it exists.
I think the MySQL provider was built with 5.0.x which is not compatible with the 5.1.x client.


Ed Jobe wrote: 
Its not directly under winsxs, but in a subdir of that folder.
>%windir%\winsxs\C:\Windows\winsxs\amd64_microsoft.vc90.crt_.....
>
>I'm using mysql 5.1.37
>
>Still though, if I run depends.exe on mysqlprovider.dll, it can't find msvcr90.dll. So I don't think its an issue with the version of mysql because the dll should have shipped with mapguide.
> 
>Ed Jobe
>
>
>
>
>
________________________________
From: Jack Lee <jack.lee at sympatico.ca>
>To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
>Sent: Tuesday, October 20, 2009 6:33:51 PM
>Subject: Re: [mapguide-users] Can't connect to MySQL
>
>Hi Ed,
>
>Did you search for msvcr90.dll under %windir%\winsxs?
> 
>If the file exists, the problem might be that the MySQL provider was built with a version that is incompatible with your version of MySQL. Which version of MySQL are you using?
>
>
>Ed Jobe wrote: 
>I had already tried sp1, the second link and a file search only finds msvcr80.dll. As far as the mg msi goes, I did get prompted, but I did the repair by re-running the msi, not from Control Panel. After that install, ver 9 is still not there. I may have to try again, but this time, in addition to an uninstall, make sure the install dir's are clean.
>> 
>>Ed Jobe
>>
>>
>>
>>
>>
________________________________
From: Jason Birch <jason at jasonbirch.com>
>>To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
>>Sent: Monday, October 19, 2009 8:10:49 PM
>>Subject: Re: [mapguide-users] Can't connect to MySQL
>>
>>Try installing these; see if it makes a difference: 
>>
>>
>>http://www.microsoft.com/downloads/details.aspx?FamilyID=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en
>>
>>
>>http://www.microsoft.com/downloads/details.aspx?familyid=A5C84275-3B97-4AB7-A40D-3802B2AF5FC2&displaylang=en
>>
>>
>>Only the second should be required (because that's what MG was built using) but...
>>
>>
>>As an aside, MG 2.1 will not re-install the runtime in a repair install; it's done during the bootstrap phase and is not part of the MSI.
>>
>>
>>Jason
>>
>>
>>2009/10/19 Ed Jobe <ed57gmc-bus at yahoo.com>
>>
>>I uninstalled the runtime, rebooted, and did a repair of mapguide so it would install the redistributable from the setup package and I depends still show all the provider dll's look for version 9.
>>> 
>>>Ed Jobe
>>>
>>>
>>>
>>>
>>>
________________________________
From: Ed Jobe <ed57gmc-bus at yahoo.com>
>>>To: mapguide-users at lists.osgeo.org
>>>Sent: Monday, October 19, 2009 7:29:16 PM
>>>Subject: Re: [mapguide-users] Can't connect to MySQL
>>>
>>>
>>>
>>>It says that for mysqlprovider.dll, msvcr90.dll is missing. I did a windows 
>>>update and the latest for the c++ runtime is msvcr80.dll.
>>>-- 
>>>View this message in context: http://n2.nabble.com/Can-t-connect-to-MySQL-tp3842847p3856390.html
>>>Sent from the MapGuide Users mailing list archive at Nabble.com.
>>>_______________________________________________
>>>mapguide-users mailing list
>>>mapguide-users at lists.osgeo.org
>>>http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>>_______________________________________________
>>>mapguide-users mailing list
>>>mapguide-users at lists.osgeo.org
>>>http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>>
>>
>>
________________________________

>>_______________________________________________
>>mapguide-users mailing list
>>mapguide-users at lists.osgeo.org
>>http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>  
>
________________________________

>_______________________________________________
>mapguide-users mailing list
>mapguide-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/mapguide-users
>  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091021/93aaa758/attachment.html