Yet Another Unable to Connect Error (1 Viewer)

[bangboss]

I have the same problem here. I am using SQLExpress, MP is on XP MCE and Engine is on a Vista Ultimate. I can connect to the SQL over the network using SQLCMD.

I am new to MP and would love to make this work, any help would be greatly appreciated.

 

[frippe75]

ANY SUGGESTIONS???

Checked your firewall?

ehhh.... have you been reading this thread at all ???

I have submited ethereal network traffic analyzer data from the server and my client is talking to the MySQL server ...... so this could not be the problem...

Portal Developers please???

 

[bangboss]

Firewalls are disabled on both systems.

As a little note, note sure where else to post this, and maybe it was an oversight on my end but for SQLExpress nowhere did I see in the DOC that we had to turn the SQLBrowser service on for it to work. Not being an expert with SQL it took some digging to find that.

 

[frippe75]

OK So i have "solved" this myself.

I think it seems to be important to have the same version of the TVserver and the TVplugin. I had installed TVServer+plugin on my regular computer attached to the plasma tv a few days before even trying the Tvplugin from my laptop.

So the lesson learned is USE THE SAME VERSION... which should seem obvious right??.

But It was actually easier download the latest than going to the tv-room computer to check which version and downloading that version

Will this solve the other reported problems in this thread i wonder???

Otherwise please download ethereal+winpcap and setup network tracing on tvserver computer and select the used nic. then setup a filter (mysql tcp.port==3306)


Happy hunting!

 

[frippe75]

OK So i have "solved" this myself.

I think it seems to be important to have the same version of the TVserver and the TVplugin. I had installed TVServer+plugin on my regular computer attached to the plasma tv a few days before even trying the Tvplugin from my laptop.

So the lesson learned is USE THE SAME VERSION... which should seem obvious right??.

But It was actually easier download the latest than going to the tv-room computer to check which version and downloading that version

Will this solve the other reported problems in this thread i wonder???

Otherwise please download ethereal+winpcap and setup network tracing on tvserver computer and select the used nic. then setup a filter (mysql tcp.port==3306)


Happy hunting!

WHAT THE FUCK!!

Stopped mediaportal on the laptop .. Restarted it ..... Now i Have the same problem again!!!

Whats up with media portal and MySQL??????

 

[frippe75]

OK So i have "solved" this myself.

I think it seems to be important to have the same version of the TVserver and the TVplugin. I had installed TVServer+plugin on my regular computer attached to the plasma tv a few days before even trying the Tvplugin from my laptop.

So the lesson learned is USE THE SAME VERSION... which should seem obvious right??.

But It was actually easier download the latest than going to the tv-room computer to check which version and downloading that version

Will this solve the other reported problems in this thread i wonder???

Otherwise please download ethereal+winpcap and setup network tracing on tvserver computer and select the used nic. then setup a filter (mysql tcp.port==3306)


Happy hunting!

WHAT THE FUCK!!

Stopped mediaportal on the laptop .. Restarted it ..... Now i Have the same problem again!!!

Whats up with media portal and MySQL??????

This is from the error.log

2007-02-23 20:26:42.911460 [ERROR][MPMain]: Exception ystem.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Server stack trace:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at TvControl.IController.GetDatabaseConnectionString(String& connectionString, String& provider)
at TvPlugin.ChannelNavigator.ReLoad()
2007-02-23 20:26:42.921475 [ERROR][MPMain]: Exception :No connection could be made because the target machine actively refused it
2007-02-23 20:26:42.921475 [ERROR][MPMain]: site :Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
2007-02-23 20:26:42.931489 [ERROR][MPMain]: source :mscorlib
2007-02-23 20:26:42.931489 [ERROR][MPMain]: stacktrace:
Server stack trace:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at TvControl.IController.GetDatabaseConnectionString(String& connectionString, String& provider)
at TvPlugin.ChannelNavigator.ReLoad()
2007-02-23 20:28:22.574769 [ERROR][MPMain]: Exception :Error in the application.
-2005530520 (D3DERR_DEVICELOST)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, IntPtr overrideWindow)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, Control overrideWindow)
at Microsoft.DirectX.Direct3D.Device.Present()
at MediaPortalApp.Render(Single timePassed)
2007-02-23 20:28:22.624841 [ERROR][MPMain]: Exception :Error in the application.
2007-02-23 20:28:22.624841 [ERROR][MPMain]: site :Void PresentInternal(Microsoft.DirectX.PrivateImplementationDetails.tagRECT*, Microsoft.DirectX.PrivateImplementationDetails.tagRECT*, IntPtr)
2007-02-23 20:28:22.634856 [ERROR][MPMain]: source :Microsoft.DirectX.Direct3D
2007-02-23 20:28:22.634856 [ERROR][MPMain]: stacktrace: at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, IntPtr overrideWindow)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, Control overrideWindow)
at Microsoft.DirectX.Direct3D.Device.Present()
at MediaPortalApp.Render(Single timePassed)





So this is whats happening at the Mediaportal layer "No connection could be made because the target machine actively refused it"
Still my traces shows ongoing Mysql communicaton!!

 

[Noelix]

Hmm I'll do what you did and install the same version on both machines... I'll let you know what I find.

 

[frippe75]

OK So i have "solved" this myself.

I think it seems to be important to have the same version of the TVserver and the TVplugin. I had installed TVServer+plugin on my regular computer attached to the plasma tv a few days before even trying the Tvplugin from my laptop.

So the lesson learned is USE THE SAME VERSION... which should seem obvious right??.

But It was actually easier download the latest than going to the tv-room computer to check which version and downloading that version

Will this solve the other reported problems in this thread i wonder???

Otherwise please download ethereal+winpcap and setup network tracing on tvserver computer and select the used nic. then setup a filter (mysql tcp.port==3306)


Happy hunting!

WHAT THE FUCK!!

Stopped mediaportal on the laptop .. Restarted it ..... Now i Have the same problem again!!!

Whats up with media portal and MySQL??????

This is from the error.log

2007-02-23 20:26:42.911460 [ERROR][MPMain]: Exception ystem.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Server stack trace:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at TvControl.IController.GetDatabaseConnectionString(String& connectionString, String& provider)
at TvPlugin.ChannelNavigator.ReLoad()
2007-02-23 20:26:42.921475 [ERROR][MPMain]: Exception :No connection could be made because the target machine actively refused it
2007-02-23 20:26:42.921475 [ERROR][MPMain]: site :Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
2007-02-23 20:26:42.931489 [ERROR][MPMain]: source :mscorlib
2007-02-23 20:26:42.931489 [ERROR][MPMain]: stacktrace:
Server stack trace:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at TvControl.IController.GetDatabaseConnectionString(String& connectionString, String& provider)
at TvPlugin.ChannelNavigator.ReLoad()
2007-02-23 20:28:22.574769 [ERROR][MPMain]: Exception :Error in the application.
-2005530520 (D3DERR_DEVICELOST)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, IntPtr overrideWindow)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, Control overrideWindow)
at Microsoft.DirectX.Direct3D.Device.Present()
at MediaPortalApp.Render(Single timePassed)
2007-02-23 20:28:22.624841 [ERROR][MPMain]: Exception :Error in the application.
2007-02-23 20:28:22.624841 [ERROR][MPMain]: site :Void PresentInternal(Microsoft.DirectX.PrivateImplementationDetails.tagRECT*, Microsoft.DirectX.PrivateImplementationDetails.tagRECT*, IntPtr)
2007-02-23 20:28:22.634856 [ERROR][MPMain]: source :Microsoft.DirectX.Direct3D
2007-02-23 20:28:22.634856 [ERROR][MPMain]: stacktrace: at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, IntPtr overrideWindow)
at Microsoft.DirectX.Direct3D.Device.PresentInternal(tagRECT* sourceRectangle, tagRECT* destRectangle, Control overrideWindow)
at Microsoft.DirectX.Direct3D.Device.Present()
at MediaPortalApp.Render(Single timePassed)





So this is whats happening at the Mediaportal layer "No connection could be made because the target machine actively refused it"
Still my traces shows ongoing Mysql communicaton!!

My misstake. the tvserver was in config mode which means the tvserver services is stoped... this has not been the case erlier... but it NOW works!!

 

[scythelt]

ehhh.... have you been reading this thread at all ???

Sorry mate but a few different ppl in this thread suffering the same problem so didn't realise you'd already sent logs of successful connects to mysql from your MP client.

Just trying to help

 

[Noelix]

My misstake. the tvserver was in config mode which means the tvserver services is stoped... this has not been the case erlier... but it NOW works!!

Config mode... what do you mean by this exactly?