Web Hosting Gallery
WebMatrix problem with MySql connection
Last post Dec 20, 2010 02:36 PM by panic_at_the_disco
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
C:\Program Files\IIS\Microsoft Web Deploy V2>msdeploy -verb:sync -source:dbMySql
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.
Dec 20, 2010 09:11 AM|mscalabrino|LINK
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:
Copy mysqldump.exe (typically from C:\Program Files\MySQL\MySQL Server 5.1\bin) to your
web server in c:\mysqldump\mysqldump.exe
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. ;-.)
Dec 20, 2010 02:36 PM|panic_at_the_disco|LINK