Dotnetpanel Forums

Hello!

There is something strange going on with MySQL databases. Few days after creating MySQL DB I'm getting error:

Error reading SQL Server database information

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidCastException: Specified cast is not valid. at DotNetPanel.Providers.Database.MySqlServer.GetDatabase(String databaseName) at DotNetPanel.Server.DatabaseServer.GetDatabase(String databaseName) --- End of inner exception stack trace --- 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 DotNetPanel.Providers.Database.DatabaseServer.GetDatabase(String databaseName) at DotNetPanel.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 DotNetPanel.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId) at DotNetPanel.Portal.SqlEditDatabase.BindItem()

There is problem only with databases (I can read/edit users). I created one database few days ago and almost didnt do anything with it (I was only entering database with Browse database option which redirects me to phpMyAdmin) and now suddenly when I'm trying to edit this database I'm getting mentioned error.

Regards 

EDIT: database is not corrupted. When I log in to this database from phpMyAdmin everything is ok. 

Hi.

There must be something wrong with the database. Check to see if some table in that database is corrupted.

Use MySQL Administrator GUI Tool to check that database.

http://dev.mysql.com/downloads/gui-tools/5.0.html

I think with DB is everyting allright. I can log in and view tables using phpmyadmin and MySQL Administrator

EDIT:

When I try to enter Browse database link I'm even not beeing redirected to phpMyAdmin. URL is changing to:

http://DNPdomain/Default.aspx?pid=SpaceMySql5&mid=63&ctl=edit_item&ItemID=29&SpaceID=2&Mode=View 

I'm still having this problem. When I try to edit / browse database in DNP I receive this error:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidCastException: Specified cast is not valid.
at DotNetPanel.Providers.Database.MySqlServer.GetDatabase(String databaseName)
at DotNetPanel.Server.DatabaseServer.GetDatabase(String databaseName)
--- End of inner exception stack trace ---
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 DotNetPanel.Providers.Database.DatabaseServer.GetDatabase(String databaseName)
at DotNetPanel.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 DotNetPanel.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId)
at DotNetPanel.Portal.SqlEditDatabase.BindItem() 

 and in Windows logs:

[6/1/2008 12:32:31 PM] ERROR: 'MySQL Server 5.x' GetDatabase
System.InvalidCastException: Specified cast is not valid.
   at DotNetPanel.Providers.Database.MySqlServer.GetDatabase(String databaseName)
   at DotNetPanel.Server.DatabaseServer.GetDatabase(String databaseName)

With database everything is allright. There is another interesting thing. Header of DNP errors tells me that there is

"Error reading SQL Server user account information"

instead of

"Error reading MySQL Server database information"

EDIT:

I've checked EnterpriseServer DB and database name located in ServiceItems is correctly connected with MySQL5 Service and ServiceItemTypes tables. So I dont know why there is header telling me that there is something wrong with SQL Server instead of MySQL Server.

Hello GrZeCh,

 Just wondering if you ever found a fix for this one as I am having what sounds like a very similar problem :

Error reading SQL Server database information

Technical Details

Page URL: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Logged User: serveradmin Work on Behalf: harrisys Hosting Space: 78 Stack Trace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Specified cast is not valid. 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 DotNetPanel.Providers.Database.DatabaseServer.GetDatabase(String databaseName) at DotNetPanel.EnterpriseServer.DatabaseServerController.GetSqlDatabase(Int32 itemId) at DotNetPanel.EnterpriseServer.esDatabaseServers.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 DotNetPanel.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId) at DotNetPanel.Portal.SqlEditDatabase.BindItem()  As in your case, the actual DB to be administrated checks fine via MySQL can be run via phpMyAdmin, etc..

 Nope. When I try to edit some databasesI'm still getting this error in event log:

[9/6/2008 9:31:40 AM] ERROR: 'MySQL Server 5.0' GetDatabase
System.InvalidCastException: Specified cast is not valid.
   at DotNetPanel.Providers.Database.MySqlServer.GetDatabase(String databaseName)
   at DotNetPanel.Server.DatabaseServer.GetDatabase(String databaseName)

Database exists of course.