server error - application message (1 Viewer)

[staticx]

Hi

I've tried many times, but I'm about to give up... I cannot get this to work.
The plugin is installed on th main computer with MP1.1B and TVSERVER beta + latest SVN.
some bugs:

--- I get this error message when trying to enter TV/RECORDING/RADIO/SCHEDULES/TV SERVER STATUS.

Server Error in '/' Application.
--------------------------------------------------------------------------------

No such host is known 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Net.Sockets.SocketException: No such host is known

Source Error: 


Line 204:      if (!ConnectToDatabase())
Line 205:        return ret;
Line 206:      IList<ChannelGroup> groups=ChannelGroup.ListAll();
Line 207:      foreach (ChannelGroup group in groups)
Line 208:        ret.Add(new WebChannelGroup(group.IdGroup,group.GroupName));
 

Source File: c:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs    Line: 206 

Stack Trace: 


[SocketException (0x2af9): No such host is known]
   System.Net.Dns.GetAddrInfo(String name) +414
   System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6) +97
   System.Net.Dns.GetHostEntry(String hostNameOrAddress) +174
   MySql.Data.Common.StreamCreator.GetHostEntry(String hostname) +98
   MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut) +345
   MySql.Data.MySqlClient.NativeDriver.Open() +219

[MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.]
   MySql.Data.MySqlClient.NativeDriver.Open() +305
   MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +89
   MySql.Data.MySqlClient.MySqlPool.GetConnection() +160
   MySql.Data.MySqlClient.MySqlConnection.Open() +212
   Gentle.Provider.MySQL.MySQLProvider.GetConnection() +63

[GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=HTPC-1\SQLEXPRESS;Connection Timeout=300;]
   Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) +89
   Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) +42
   Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName) +515
   Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) +155
   Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) +1519
   Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) +114
   Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) +204
   Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) +13
   TvDatabase.ChannelGroup.ListAll() +39
   MediaPortal.TvServer.WebServices.ServiceInterface.GetTvChannelGroups() in c:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:206
   Default.RefreshTv() in c:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:163
   Default.btnTv_Click(Object sender, EventArgs e) in c:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:112
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +78
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +100
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2863

--- I cannot see any video or music files, I don't know where can I find the VLC browser patch - can't it be in asx format for media player? it's more versatile player than VLC...
--- I can't see any photos, all I see is blank squares with the file name.
--- I cannot see anything in "Movies"
--- When I try to search for an album I also get the error message above

please help me make this plugin work.

thanks

 

[DieBagger]

The problems seems to be that the webservice cannot access the database.

1. Do you use MySQL?
2. Is your computers' name "HTPC-1"?
3. Is the username "sa" and password "mediaportal" correct?

 

[staticx]

I think I'm using Microsoft SQL , not mysql
the user/pass is root and mediaportal

my htpc name is HTPC-1

 

[DieBagger]

That is most likely the problem but you'll have to wait for gemx to comment on whether or not it's even possible to use ms-sql.

 

[Oxan]

WebServices isn't changing the DefaultProviderName when opening the database connection. It seems that de default provider is always mysql, also if you're using MySQL. A quick hack is to add on line 91 of App_Code/TvServiceWebServices.asmx.cs this:

        Gentle.Framework.GentleSettings.DefaultProviderName = provider;

(just above Gentle.Framework.ProviderFactory.SetDefaultProviderConnectionString(connStr))

 

[Jay_UK]

Hi there,

I am running with MS SQL 2008 Express.

Works fine (regarding DB connectivity) - I can't remember if I ad to change anything to get it working though

J.

 

[Wappy]

WebServices isn't changing the DefaultProviderName when opening the database connection. It seems that de default provider is always mysql, also if you're using MySQL. A quick hack is to add on line 91 of App_Code/TvServiceWebServices.asmx.cs this:

        Gentle.Framework.GentleSettings.DefaultProviderName = provider;

(just above Gentle.Framework.ProviderFactory.SetDefaultProviderConnectionString(connStr))

Sorry for jumping on this thread but i have the exact same problem i've added the line but with no luck except the error is now on Line: 207 lol

staticx did you ever find a solution to this problem?

regards

Wappy

 

[staticx]

nope. I'm working now with MySql and mp1.1rc