Cannot create mysql database

Question

Hi,

I'm not able to create any mysql database for any account on my hosting server with Websitepanel.

Anyway, I can create email account from WSP (which use hmailserver and mysql).

The error I got is:

The operation you requested has failed to complete

We apologize for the inconvenience but your request could not be completed at this time. Please contact us on that matter and our support team will do its best to resolve the issue as soon as possible.

Thank you for your cooperation.

Technical Details

Page URL:	http://panel...../Default.aspx?pid=SpaceMySql5&mid=106&ctl=edit_item&SpaceID=75
Logged User:	serveradmin
Work on Behalf:	........it
Hosting Space:	75
Stack Trace:	System.Exception: Exception of type 'System.Exception' was thrown.

Thankyou very much

Answer 1

Hi,

Could you please check both audit logs and event logs to see if there're any related log entries? These should provide the direct cause of the database creation failure.

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 2

Hi Zhang, the specific error is (sorry it's in Italian):

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="WebsitePanel" />
  <EventID Qualifiers="0">0</EventID>
  <Level>2</Level>
  <Task>0</Task>
  <Keywords>0x80000000000000</Keywords>
  <TimeCreated SystemTime="2012-02-27T16:23:22.000000000Z" />
  <EventRecordID>385</EventRecordID>
  <Channel>WebsitePanel</Channel>
  <Computer>BLUEHOSTWIN1</Computer>
  <Security />
  </System>
- <EventData>
  <Data>[2/27/2012 5:23:22 PM] ERROR: 'MySQL Server 5.1' DatabaseExists System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.3.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. Impossibile trovare il file specificato. File name: 'MySql.Data, Version=6.3.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' at WebsitePanel.Providers.Database.MySqlServer.ExecuteQueryDataSet(String commandText, String connectionString) at WebsitePanel.Providers.Database.MySqlServer.DatabaseExists(String databaseName) at WebsitePanel.Server.DatabaseServer.DatabaseExists(String databaseName) AVV: la registrazione dell'associazione di assembly è disattivata. Per attivare la registrazione degli errori di associazione di assembly, impostare il valore del Registro di sistema [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) su 1. Nota: alcune penalità di prestazione sono associate alla registrazione degli errori di associazione di assembly. Per disattivare la funzionalità, rimuovere il valore del Registro di sistema [HKLM\Software\Microsoft\Fusion!EnableLog].</Data>
  </EventData>
  </Event>

Can you help me on this issue? Thankyou!

Best regards

Answer 3

Hi,

refer to this URL:

http://social.msdn.microsoft.com/Forums/en-US/wspsupport/thread/94e00624-0848-4ad3-a37b-fc48dabde019

I solved by put this on my c:\WebsitePanel\Server\web.config:

<runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> 
    <dependentAssembly> 
      <assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d" />

      <bindingRedirect oldVersion="0.0.0.0-6.3.5.0" newVersion="6.4.4.0" />

    </dependentAssembly> 
  </assemblyBinding> 
</runtime>