TV-Service starts before SQL-Server | Page 3

Discussion in 'fixed TV-Server / Client Bugs' started by Patric, November 1, 2006.

  1. patrick

    patrick Portal Pro

    Joined:
    April 20, 2005
    Messages:
    608
    Likes Received:
    45
    Location:
    Southeast
    Ratings:
    +45 / 0
    Home Country:
    United States of America United States of America
    Patric,



    You may want to test again, just saw this in the SVN log 12Nov2006:

    Code (Text):
    1.  
    2. when service starts and sql server is not running yet, wait 5 seconds before trying to access the database
    3.  
    patrick
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Hi patrick,

    I already compiled and tried that version directly after frodo had submitted that patch. It now works about 1 out of 3 times. I asked frodo by PM if he could possibly expand that 5 second delay for a second connection try to 10 seconds or insert a thrid connection try after another 5 seconds.

    But I doubt he has time to read his PMs. Hopefully he has a lot work to do with the more serious problems.

    Nevertheless I still hope that there'll be a solution for my problem.

    And thanks for thinking about me :)
     
  4. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Finally :)

    frodo
    Thanks alot for inserting the third connection attempt into the init routine!
    That solved my problem.

    Now I only have to delay the start of MP because the TV-Server needs really some time before accepting the client connection even though it's a single seat config.

    Just for info:

    TV-Server - tv.log
    Code (Text):
    1. 14.11.2006 22:24:43 TV service started
    2. 14.11.2006 22:24:45 C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\MediaPortal TV Server\gentle.config
    3. 14.11.2006 22:24:51 ----------------------------
    4. 14.11.2006 22:24:51 Detected analog card:hauppauge wintv pvr pci ii tvtuner
    5. 14.11.2006 22:24:56 PluginManager: TvEngine.ConflictsManager is incompatible with the current tvserver version and won't be loaded!
    6. 14.11.2006 22:24:57 PluginManager: Loaded TV Movie Clickfinder Import version:0.2 author:mPod
    7. 14.11.2006 22:24:57 PluginManager: Loaded XmlTv version:1.0.0.0 author:Frodo
    8. 14.11.2006 22:24:57 Controller: Started at dign
    9. 14.11.2006 22:24:57 Controller: local ip adress:192.168.100.13
    10. 14.11.2006 22:25:02 C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\MediaPortal TV Server\gentle.config
    11. 14.11.2006 22:25:02 ----------------------------
    12. 14.11.2006 22:25:02 Detected analog card:hauppauge wintv pvr pci ii tvtuner
    13. 14.11.2006 22:25:02 PluginManager: TvEngine.ConflictsManager is incompatible with the current tvserver version and won't be loaded!
    14. 14.11.2006 22:25:02 PluginManager: Loaded TV Movie Clickfinder Import version:0.2 author:mPod
    15. 14.11.2006 22:25:02 PluginManager: Loaded XmlTv version:1.0.0.0 author:Frodo
    16. 14.11.2006 22:25:02 Controller: Started at dign
    17. 14.11.2006 22:25:02 Controller: local ip adress:192.168.100.13
    18. 14.11.2006 22:25:07 C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\MediaPortal TV Server\gentle.config
    19. 14.11.2006 22:25:07 ----------------------------
    20. 14.11.2006 22:25:07 Detected analog card:hauppauge wintv pvr pci ii tvtuner
    21. 14.11.2006 22:25:58 PluginManager: Loaded ConflictsManager version:1.0.0.0 author:Broceliande
    22. 14.11.2006 22:25:58 PluginManager: Loaded TV Movie Clickfinder Import version:0.2 author:mPod
    23. 14.11.2006 22:25:58 PluginManager: Loaded XmlTv version:1.0.0.0 author:Frodo
    24. 14.11.2006 22:25:58 Controller: Started at dign
    25. 14.11.2006 22:25:58 Controller: local ip adress:192.168.100.13
    26. 14.11.2006 22:25:58 Controller: server running on 192.168.100.13
    27. 14.11.2006 22:25:59 Controller: setup streaming
    28. 14.11.2006 22:26:00 dbs:36 channels
    29. 14.11.2006 22:26:00 EPG: grabber started..
    30. 14.11.2006 22:26:00 Scheduler: started
    31. 14.11.2006 22:26:03 Scheduler: loaded 0 schedules
    32. 14.11.2006 22:26:03 plugin: ConflictsManager stopped
    33. 14.11.2006 22:26:03 plugin: xmltv started
    34. 14.11.2006 22:26:03 Controller: initalized
    35.  
    TV-Server - error.log:
    Code (Text):
    1. 14.11.2006 22:24:57 !!!Controller:Unable to connect to database!!!
    2. 14.11.2006 22:24:57 Controller: database connection string:Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    3. 14.11.2006 22:24:57 Sql error:The database backend (provider SQLServer) could not be reached.
    4. Check the connection string: Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    5. 14.11.2006 22:25:02 !!!Controller:Unable to connect to database!!!
    6. 14.11.2006 22:25:02 Controller: database connection string:Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    7. 14.11.2006 22:25:02 Sql error:The database backend (provider SQLServer) could not be reached.
    8. Check the connection string: Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    9.  
    MP - MediaPortal.log (excerpt):
    Code (Text):
    1. 2006-11-14 22:25:15.978745 [Info.][MPMain]: TvCropManager: Started
    2. 2006-11-14 22:25:15.978745 [Info.][MPMain]: TVHome:ctor
    3. 2006-11-14 22:25:16.259237 [Info.][MPMain]: ChannelNavigator::ctor()
    4. 2006-11-14 22:25:16.446232 [Info.][MPMain]: Remote control:master server :192.168.100.13
    5. 2006-11-14 22:25:16.570895 [Info.][MPMain]: ChannelNavigator::Reload()
    6. 2006-11-14 22:25:21.791167 [Info.][MPMain]: Exception   :System.Net.Sockets.SocketException: Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte
    7.  
    8. Server stack trace:
    9.    bei System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
    10.    bei System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
    11.    bei System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
    12.    bei System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
    13.    bei System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
    14.    bei System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
    15.    bei System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
    16.    bei System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)
    17.  
    18. Exception rethrown at [0]:
    19.    bei System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    20.    bei System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    21.    bei TvControl.IController.get_DatabaseConnectionString()
    22.    bei TvPlugin.ChannelNavigator.ReLoad()
    23. 2006-11-14 22:25:21.791167 [Info.][MPMain]: Exception   :Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte
    24. 2006-11-14 22:25:21.791167 [Info.][MPMain]:   site      :Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
    25. 2006-11-14 22:25:21.837915 [Info.][MPMain]:   source    :mscorlib
    26. 2006-11-14 22:25:21.837915 [Info.][MPMain]:   stacktrace:
    27. Server stack trace:
    28.    bei System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
    29.    bei System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
    30.    bei System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)
    31.    bei System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
    32.    bei System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
    33.    bei System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
    34.    bei System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
    35.    bei System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)
    36.  
    37. Exception rethrown at [0]:
    38.    bei System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    39.    bei System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    40.    bei TvControl.IController.get_DatabaseConnectionString()
    41.    bei TvPlugin.ChannelNavigator.ReLoad()
    42. 2006-11-14 22:25:21.884664 [Info.][MPMain]: TVHome:Init
    43. 2006-11-14 22:25:22.102825 [Info.][MPMain]: TVHome:OnAdded
    44.  
    Thanks for your great work!
     
  5. infinite.loop
    • Team MediaPortal

    infinite.loop Retired Team Member

    Joined:
    December 26, 2004
    Messages:
    16,163
    Likes Received:
    3,861
    Gender:
    Male
    Location:
    127.0.0.1
    Ratings:
    +4,154 / 7
    Home Country:
    Austria Austria
    Show System Specs
    i am bumping this old thread because i am interested in a few things

    when you start your singleseat config, and then enter MyTV, then you get "No TV-Server found".
    have i got that right?

    if so, then if you wait a few seconds and try again (after TV-Service has started) it should work (without restarting MediaPortal) right?

    :)
     
  6. mrkaras

    mrkaras Portal Pro

    Joined:
    December 9, 2006
    Messages:
    541
    Likes Received:
    3
    Ratings:
    +7 / 3
    Home Country:
    Show System Specs
    No, I don't think the my TV part will ever reconnect after it has failed initially. I think the EPG is the same, it never shows if it didn't work first time unless you restart mediaportal.
     
  7. PsyDuck

    PsyDuck Portal Member

    Joined:
    January 22, 2007
    Messages:
    17
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Sweden Sweden
    Any news on this....Tried to check the TVPlugin-code in order to find a fix...but I am to stupid to find the "initializing part" in the code.
     
  8. mrkaras

    mrkaras Portal Pro

    Joined:
    December 9, 2006
    Messages:
    541
    Likes Received:
    3
    Ratings:
    +7 / 3
    Home Country:
    Show System Specs
  9. mrkaras

    mrkaras Portal Pro

    Joined:
    December 9, 2006
    Messages:
    541
    Likes Received:
    3
    Ratings:
    +7 / 3
    Home Country:
    Show System Specs
    there now seemes to be several options relating to this but they do not fix it. possably if I set a long wait time it might, I have it set to 2 seconds, so now when MP starts it briefly says "waiting for 2 seconds" (that takes a bit less than 1 second to move on).

    the TV service never connects and must be restarted, config will say it can not connect to the service.
     
  10. Hetfield

    Hetfield Portal Pro

    Joined:
    March 3, 2007
    Messages:
    69
    Likes Received:
    9
    Ratings:
    +9 / 0
    Home Country:
    Finland Finland
    Yes!!! So also many others have the same problem as I do. Let's hope this gets fixed some day. For me the batch file has been 100% stable for over half years. Any other time out settings in MediaPortal don't help at all (or helps if I put over 60 - 120 seconds). This batch file is anyway much better: it doesn't cause you to wait too long just to be sure. It starts MediaPortal immediately when everything is ready, and it works always.
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!