WinBlogs

Some techy stuff and occasional verbose ramblings :D

WebSitePanel Fixes

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. chris

    This was even part of DotNetPanel… Still not fixed, thank god for open source!!!

    Thank you!

  2. Alesandro Slepčević

    You’re welcome, I hope it solved your issue!

  3. Michel

    Is there a fix for the 1.1 version?

  4. Alesandro Slepčević

    What exact issue do you have?

  5. Michel

    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

  6. Alesandro Slepčević

    Okay, I can create a patch for you on monday. Is that fast enough?

  7. Michel

    ok thanks!

  8. Michel

    Alesandro, any progress?

  9. Alesandro Slepčević

    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?

  10. Michel

    That’s not an option at this moment 🙂

    Which version of MySQL do you have?

  11. pod

    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?

  12. Alesandro Slepčević

    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.

  13. Alesandro Slepčević

    Working on a patch at this moment.

  14. pod

    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?

  15. Alesandro Slepčević

    No, its an issue in the WSP code. Did the fix work for you?

  16. pod

    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?

  17. pod

    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: 0x80131040)
    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()

  18. oh…I see the problem…sry..my bad. Will fix it asap.

  19. pod

    is there a new version up yet?

  20. pod

    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.

  21. Michel

    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: 0x80131040)
    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?

  22. pod

    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.

  23. Alesandro Slepčević

    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.

  24. paul roland

    hello, any fix rot 1.1.2 version yet?

  25. Alesandro Slepčević

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

  26. Paul Roland

    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.

  27. Dean

    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!

  28. Paul Roland

    Also can you build it against latest mysql connector?

  29. Alesandro Slepčević

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

  30. Alesandro Slepčević

    Hello, try to use the new fix. Link is in the post above. TNX

  31. Alesandro Slepčević

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

  32. paul roland

    Ok testing…

  33. paul roland

    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

  34. Alesandro Slepčević

    What .net connector are you using? Try it with http://dev.mysql.com/downloads/connector/net/6.2.html#downloads

  35. paul roland

    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.

  36. Alesandro Slepčević

    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.

  37. paul roland

    mysql server lastest 5.5.11 and connector is 6.3.5.0 now. thank you

  38. paul roland

    Hey, any luck on mysql 5.5 ? 🙂

  39. Seva

    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

  40. DejanCG

    Are there any news about MySQL 5.5.x on WSP 1.1.2 ?

  41. Raymond

    Hello,

    Are you able to update the fix for websitepanel version 1.2.0?

    Thank you.

  42. Gonzalo

    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

  43. Alesandro Slepčević

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Theme by Anders Norén