SQL server access problem: server access prior to WOL (1 Viewer)

Aquarius

MP Donator
  • Premium Supporter
  • November 23, 2004
    347
    7
    NRW
    Home Country
    Germany Germany
    MediaPortal Version: 1.2.0final
    MediaPortal Skin: Default Wide
    Windows Version: XPSP3
    CPU Type: AMD E350
    HDD: SAMSUNG Spinpoint 500GB
    Memory: 4GB Kingston Value
    Motherboard: ASUS E350M1
    Video Card: IGP ATI HD6310
    Video Card Driver: Catalyst 10.2
    Sound Card: onboard ALC
    Sound Card AC3:
    Sound Card Driver:
    1. TV Card: Haupauge PVR 1700
    1. TV Card Type:
    1. TV Card Driver:
    2. TV Card:
    2. TV Card Type:
    2. TV Card Driver:
    3. TV Card:
    3. TV Card Type:
    3. TV Card Driver:
    4. TV Card:
    4. TV Card Type:
    4. TV Card Driver:
    MPEG2 Video Codec: PDVD11
    MPEG2 Audio Codec: PDVD11
    h.264 Video Codec: PDVD11
    Satelite/CableTV Provider:
    HTPC Case: Silverstone LC13
    Cooling:
    Power Supply:
    Remote: Logi ONE, MCE
    TV: Samsung UE32C6700
    TV - HTPC Connection: HDMI

    Hi all,

    I have MP 1.2.0 final running with one server (configured as singleseat) and one client. The server is in suspend (standby) mode. When the client starts from scratch (not from suspend) I often have long delays. When inspecting the logs I found a possible reason: Wake on LAN(WOL) comes AFTER the first access attempt to the servers database. So the server is still sleeping when the servers database is accessed from the client.

    Here’s the log with some comments. See the timestamps

    Startup:
    2011-09-27 20:21:48.296875 [Info.][MPMain(1)]: Main: MediaPortal v1.2.0.0 is starting up on Windows XP ( Service Pack 3 ) [5.1.2600.196608]
    // SQL Server access fails
    2011-09-27 20:23:22.671875 [Info.][MPMain(1)]: Exception while loading GUIWindows instances: TvPlugin.Radio
    2011-09-27 20:23:22.671875 [Info.][MPMain(1)]: The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=10.0.0.102;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;
    2011-09-27 20:23:22.687500 [Info.][MPMain(1)]: bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
    bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)


    // WOL
    2011-09-27 20:23:23.171875 [Debug][MPMain(1)]: Common.IsSingleSeat: checking if '10.0.0.102' is singleseat...
    2011-09-27 20:23:23.171875 [Debug][MPMain(1)]: Common.IsSingleSeat: Checking against localhost - result=False
    2011-09-27 20:23:23.171875 [Debug][MPMain(1)]: Common.IsSingleSeat: Checking against 127.0.0.1 - result=False
    2011-09-27 20:23:23.171875 [Debug][MPMain(1)]: Common.IsSingleSeat: Checking against kec - result=False
    2011-09-27 20:23:23.187500 [Debug][MPMain(1)]: Common.IsSingleSeat: Checking against 10.0.0.107 - result=False
    2011-09-27 20:23:23.203125 [Debug][MPMain(1)]: TVHome: WOL - Use stored MAC address: F4:6D:04:D6:09:10
    2011-09-27 20:23:23.203125 [Info.][MPMain(1)]: TVHome: WOL - Start the TV server
    2011-09-27 20:23:23.203125 [Debug][MPMain(1)]: WOLMgr: Increasing timeout for RemoteControl
    2011-09-27 20:23:23.203125 [Debug][MPMain(1)]: WOLMgr: Ping 10.0.0.102
    2011-09-27 20:23:23.437500 [Debug][MPMain(1)]: WOLMgr: Ping 10.0.0.102
    2011-09-27 20:23:24.937500 [Debug][MPMain(1)]: WOLMgr: System 10.0.0.102 still not reachable, waiting...

    This cannot be intended ?! WOL should be issued before accessing the server and then waited until the server is alive.

    Thanks for any help !

    Regards
    /Gerd
     

    Users who are viewing this thread

    Top Bottom