WebSitePanel – MySQL problem fix – UPDATED AGAIN :)

Here you can download the files for fixing mysql issues ( deleting database ) on WSP 1.0.1.0, 1.0.2 , 1.1.0, 1.1.2, 1.2.0 AND 1.2.1

INSTRUCTIONS :

Replace “websitepanel.providers.database.mysql.dll” file in “server\bin” folder with the one you downloaded. These fixes fixed my problem on all servers EXCEPT the one running mysql 5.0.27 version….ones runing 5.1 and 5.0.77 works fine. I Will update if I get this solved too…

Currently I am getting this error on 5.0.27 server: ERROR: ‘MySQL Server 5.0′ DeleteDatabase System.Data.EvaluateException: Cannot perform ‘=’ operation on System.Byte[] and System.String.

FIX for 1.0.1.0 version can be found HERE

FIX for the 1.0.2 version can be found HERE

FIX for the 1.1.0 version can be found HERE

FIX for the 1.1.2 version can be found HERE

FIX for the 1.2.0 version can be found HERE – UPDATED!!

FIX for the 1.2.1 version acan be found HERE – UPDATED!!

FIX for the 1.2.1.6 version acan be found HERE - UPDATED!!

Hope it will be helpfull.

If you have any questions, just let me know.

Ofcourse, these fixes are provided AS-IS . I dont guarantee it will work on your machine, and I cannot take responsibility for any damages cause by it.

43 comments

  1. The same as with 1.0.1 & 1.0.2. Creating the database is nu problem, but deleting it I’m getting errors.

    Thanks,
    Michel

  2. No, not yet. I am trying to reproduce the problem in my test enviroment, but everything works fine. I assume giving me access to your machine is not an option?

  3. Your fix worked for v1.0.2 but now we have the same issue with v1.1. Running v5.0.67 what gives and what exactly is the issue you are fixing.

    Is it the connector version or the version of mysql etc?

  4. Michel, just to tell you that I’m working on a patch at this moment. Will have it out in hour or two if everything goes out smoothly.

  5. Alesandro – what exactly are you fixing to make this work. I am trying to understand if this is an issue with the version of mysql we are running and if we need to upgrade to resolve or if this is just something stupid in the wsp code?

  6. I will be testing it later today, as i am offsite right now. I will let you know.

    Would you mind posting or emailing me what the fix is and why hasnt the main code been updated with the fix?

    Lastly do newer versions of mysql need this fix?

  7. that version doesnt work…

    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Could not load file or assembly ‘WebsitePanel.Providers.Base, Version=1.0.0.0, Culture=neutral, PublicKeyToken=da8782a6fc4d0081′ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0×80131040)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at WebsitePanel.Providers.Database.DatabaseServer.GetDatabase(String databaseName)
    at WebsitePanel.EnterpriseServer.DatabaseServerController.GetSqlDatabase(Int32 itemId)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at WebsitePanel.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId)
    at WebsitePanel.Portal.SqlEditDatabase.BindItem()

  8. Alesandro – have you created a new version yet?

    it would really help if you also posted what the actual fix is. I am amazed that the wsp team has not resolved this in the code.

  9. Same here:

    System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Could not load file or assembly ‘WebsitePanel.Providers.Base, Version=1.0.0.0, Culture=neutral, PublicKeyToken=da8782a6fc4d0081′ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0×80131040)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at WebsitePanel.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId)
    at WebsitePanel.Portal.SqlEditDatabase.BindItem()

    Any update yet?

  10. just a note to anyone still using v5.0.x – if you upgrade to v5.1 this issue goes away… so i am not sure wtf WSP team is doing…. or what has changed between the two versions.

  11. Hi, I got the working version of the dll. I have upgraded all my servers and applied the patch and everything works without any problems. The download link is updated in the post.

  12. Hello, not yet, but give me a day or two and I will have it fixed. Will give my best to fix it tommorow.

  13. That is great, I will send an email to Pavel and ask what’s going on 3 versions released since then and none yet fixed this issue.

  14. Hello, Tried your fix on WSP 1.1.2 & MySQL 5.0.51a with no luck. Any idea how I can fix this issue? Thanks!

  15. Hello guys, I’m starting to work on this now. Will have more info in hour or so…

  16. Hi, post is updated with the new fix. It works fine in my test enviroment.

  17. Could not load file or assembly ‘MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ or one of its dependencies.

    Uh at least it’s an upgrade

  18. Using 6.3.5.0 now. working… still unable to delete databases… But I am using the 5.5.11 version of mysql.

    System.Exception: Exception of type ‘System.Exception’ was thrown.

  19. heh..this is not for 5.5 version. Will try to install it in my test enviroment and see if I can get the issue too. Can you just send me the exact mysql and .net connector version.

  20. Thank you for patches. I used the fixes for previous versions (1.0.2, 1.1.0). WSP has worked

    WSP 1.1.2

    [5/25/2011 10:48:19 AM] ERROR: ‘MySQL Server 5.1′ DeleteDatabase
    System.NullReferenceException: Object reference not set to an instance of an object.
    at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
    at WebsitePanel.Providers.Database.MySqlServer.ExecuteNonQuery(String commandText, String connectionString)
    at WebsitePanel.Providers.Database.MySqlServer.CloseDatabaseConnections(String database)
    at WebsitePanel.Providers.Database.MySqlServer.DeleteDatabase(String databaseName)
    at WebsitePanel.Server.DatabaseServer.DeleteDatabase(String databaseName)

    I replaced the dll. no effect. what am I doing wrong? Thank you

  21. I have version 1.2.1 of the website panel.
    Currently I have a database mysql 5.1.55 with mysql connector net 6.5.4
    The database server is external to the webserver and the server control panel, but database ms-sql I can create without problems.
    Until recently I worked perfect, but now when I create a mysql database I get this error:

    System.Exception: Exception of type ‘System.Exception’ was thrown.

    And when I go to the servers option in the Control Panel and select the database server and review the settings and put save I get the following error:

    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Could not load file or assembly ‘MySql.Data, Version=6.3.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ or one of its dependencies. The system cannot find the file specified.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at WebsitePanel.Providers.ServiceProvider.Install()
    at WebsitePanel.EnterpriseServer.ServerController.InstallService(Int32 serviceId)
    at WebsitePanel.EnterpriseServer.esServers.InstallService(Int32 serviceId)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at WebsitePanel.EnterpriseServer.esServers.InstallService(Int32 serviceId)
    at WebsitePanel.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)

    I wanted to know if anyone knows what may be the problem and fix it.
    I hope to help
    regards

    Gonzalo

  22. Gonzalo, can you try to install mysql connector 6.2.5 instead of 6.5.4 ?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>