#74 MySQL support is not working

[Satish Nikam]

MySQL support is not working. I created a web role with MySQL support and ran it in dev fabric. Web role started successfully, but following errors were shown in MySQL worker role. It seems WorkerRole1.dll file is missing from the plugin.

[runtime] Role entrypoint could not be created:
System.IO.FileNotFoundException: Could not load file or assembly 'file:///C:\Users\v-sanika\workspace\p1\ServiceDefinition.csx\roles\r2\approot\WorkerRole1.dll' or one of its dependencies. The system cannot find the file specified.
File name: 'file:///C:\Users\v-sanika\workspace\p1\ServiceDefinition.csx\roles\r2\approot\WorkerRole1.dll'
at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.LoadFrom(String assemblyFile)
at Microsoft.WindowsAzure.ServiceRuntime.RoleEnvironment.CreateRoleEntryPoint(RoleType roleTypeEnum)
at Microsoft.WindowsAzure.ServiceRuntime.RoleEnvironment.InitializeRoleInternal(RoleType roleTypeEnum)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

[Chris Koenig]

I found a workaround, but not a fix:

After your Database project is created, and before you package, rename the Mysql_WorkerRole.* files to WorkerRole1.*. Then the packaging works.

Now I am at a spot where I don't know how to connect to my MySql instance. I see in the my.ini file that there is a port specified, but it doesn't seem to work. Are there any tips out there showing how to connect to the database once you have it created?!?!