We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

WebMatrix problem with MySql connection [Answered]RSS

2 replies

Last post Dec 20, 2010 02:36 PM by panic_at_the_disco

  • WebMatrix problem with MySql connection

    Dec 20, 2010 08:22 AM|mscalabrino|LINK


    I have a problem with mysql applications in webmatrix. When I try to publish the site, importing a file.publishsettings, where there are the connections string to database "SQL" and "MYSQL", and click on "Validate Connection", I receive an error "Remote server contacted. Cannot access database". Is very strange, because if I publish an application that not needed mysql database work regularly. The connection string is right, because if I use "msdeploy" string below, work ( the C:\Temp\Test.sql contain a simple CREATE TABLE).

    C:\Program Files\IIS\Microsoft Web Deploy V2>msdeploy -verb:sync -source:dbMySql
    =C:\Temp\Test.sql -dest:dbMySql="server=MySql159.domain.com;uid

    If I publish an application that use SQL database, the validate and the publish work.
    The Mysql platform is an external linux environment, but I don't believe that this is a problem, because him should be use connection string information.




  • Re: WebMatrix problem with MySql connection

    Dec 20, 2010 09:11 AM|mscalabrino|LINK

    <div class=ForumPostContentText>


    I have solved the problem. Even if the MySQL envirnoment is external, the machine that start msdeploy, in my case the remote administration server, needed to:

    1. Copy mysqldump.exe (typically from C:\Program Files\MySQL\MySQL Server 5.1\bin) to your web server in c:\mysqldump\mysqldump.exe

    2. On the web server, set a registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\1\mysqldumppath) to string value == “c:\mysqldump\mysqldump.exe”)

    In this way the connection validate pass. ;-.)



  • Re: WebMatrix problem with MySql connection

    Dec 20, 2010 02:36 PM|panic_at_the_disco|LINK

    One quick note: for Web Deploy v2, the key path has to be HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\2\mysqldumppath (i.e. I replaced 1 with 2)