MySQL & WOL (wake on lan)

castortray · 2011-01-29 11:58

Hi,

I use MySQL (to share and synchronize XBMC userdata profiles between multiple machines) which is installed on my Asrock 330HT on Windows 7 in living room.
I don't use it all the time, so it automatically go to "sleep".

But when is in "sleep" mode I can't (not able to connect to MySQL) run xbmc client on other laptop before I turn on Asrock. How I can send command "wake on lan" to my Asrock before or during start client on another PC/laptop ?
I can't launch addon from programs section of XBMC before Asrock (with MySQL) start before wake up from sleep mode.

[Image: 45YbA.png]

WOL has benn downloaded from official repository version 1.0.0

many thanks for any tips,
Regards

**jhsrennie** · 2011-01-30 10:55

XBMC has a wake on lan function built in. See http://wiki.xbmc.org/?title=List_of_Built_In_Functions

If you create a Python script called default.py and put it in your userdata folder XBMC will execute this script when it starts, and you can have this script send a WOL signal.

JR

castortray · 2011-01-30 22:30

wow, nice

I did not know about this earlier
I need to check it.

Many thanks.
Regards

castortray · 2011-02-01 00:03

jhsrennie Wrote:XBMC has a wake on lan function built in. See http://wiki.xbmc.org/?title=List_of_Built_In_Functions

If you create a Python script called default.py and put it in your userdata folder XBMC will execute this script when it starts, and you can have this script send a WOL signal.

JR

unfortunatelly it's not working Sad

I've created default.py in C:\Users\%username%\AppData\Roaming\XBMC\userdata

Code:

# Wake-On-LAN

#

# Copyright (C) 2002 by Micro Systems Marc Balmer

# Written by Marc Balmer, marc@msys.ch, http://www.msys.ch/

# This code is free software under the GPL

import struct, socket

def WakeOnLan(ethernet_address):

  # Construct a six-byte hardware address

  addr_byte = ethernet_address.split(':')

  hw_addr = struct.pack('BBBBBB', int(addr_byte[0], 16),

    int(addr_byte[1], 16),

    int(addr_byte[2], 16),

    int(addr_byte[3], 16),

    int(addr_byte[4], 16),

    int(addr_byte[5], 16))

  # Build the Wake-On-LAN "Magic Packet"...

  msg = '\xff' * 6 + hw_addr * 16

  # ...and send it to the broadcast address using UDP

  s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)

  s.setsockopt(socket.SOL_SOCKET, socket.SO_BROADCAST, 1)

  s.sendto(msg, ('<broadcast>', 9))

  s.close()

# Example use

WakeOnLan('aa:bb:cc:dd:ee:ff')    # Asrock

of course I replace aa:bb:cc Big Grin

d:ee:ff with my Asrock MAC address

do you know what could be wrong ?

**jhsrennie** · 2011-02-01 12:44

When you're trying to work out what's going wrong the first step is always to enable debug logging then look at xbmc.log to see if there are any clues. In this case you will see something like:

DEBUG: XBPython::Process - no profile autoexec.py (C:\Users\renniej\AppData\Roaming\XBMC\userdata\autoexec.py) found, skipping

which means that I gave you the wrong filename (oops, sorry) it should be autoexec.py.

Also you're doing things the hard way. The autoexec.py just needs to contain:

Code:

import xbmc

xbmc.executebuiltin("WakeOnLan(00-13-72-26-4d-cf)")

I've put in the MAC address of the PC I tested the script on. Obviously replace this with your own MAC address.

JR

castortray · 2011-02-01 21:15

jhsrennie Wrote:When you're trying to work out what's going wrong the first step is always to enable debug logging then look at xbmc.log to see if there are any clues.

Also you're doing things the hard way. The autoexec.py just needs to contain:

Code:

import xbmc xbmc.executebuiltin("WakeOnLan(00-13-72-26-4d-cf)")

I've put in the MAC address of the PC I tested the script on. Obviously replace this with your own MAC address.

JR

thanks for another tip,
but still not working, below my debug logs

Code:

59:20 T:5236 M:2161758208   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:21 T:5236 M:2167185408   ERROR: CRemoteControl::Connect - failed to connect

59:22 T:1500 M:2167332864   ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.2.3' (10060))

59:22 T:1500 M:2167332864   ERROR: Unable to open database at host: 192.168.2.3 db: xbmc_video (old version?)

59:24 T:5236 M:2167246848   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:25 T:5236 M:2167373824   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:26 T:5236 M:2167390208   ERROR: CRemoteControl::Connect - failed to connect

59:29 T:5236 M:2167382016   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:30 T:5236 M:2167402496   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:31 T:5236 M:2167148544   ERROR: CRemoteControl::Connect - failed to connect

59:34 T:5236 M:2167238656   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:35 T:5236 M:2167218176   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:36 T:5236 M:2167496704   ERROR: CRemoteControl::Connect - failed to connect

59:39 T:5236 M:2167742464   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:40 T:5236 M:2167758848   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:41 T:5236 M:2167934976   ERROR: CRemoteControl::Connect - failed to connect

59:43 T:1500 M:2166685696   ERROR: Unable to open database: xbmc_music [2003](Can't connect to MySQL server on '192.168.2.3' (10060))

59:43 T:1500 M:2166685696   ERROR: Unable to open database at host: 192.168.2.3 db: xbmc_music (old version?)

59:44 T:5236 M:2166157312   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:45 T:5236 M:2166730752   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:46 T:5236 M:2166747136   ERROR: CRemoteControl::Connect - failed to connect

59:49 T:5236 M:2167652352   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...

59:50 T:5236 M:2167644160   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...

59:51 T:5236 M:2167652352   ERROR: CRemoteControl::Connect - failed to connect

WakeOnLan - Magic packet from autoexec.py has been send after I turn on
manually my Asrock (with MySQL database)

Code:

59:53 T:1500 M:2166919168    INFO: Loading user windows, path C:\Users\Mario\AppData\Roaming\XBMC\addons\skin.customizableconfluence\720p

59:53 T:1500 M:2166222848   DEBUG: Load Skin XML: 72304.43ms

59:53 T:1500 M:2166222848    INFO:   initialize new skin...

59:53 T:1500 M:2166222848    INFO: Loading skin file: Pointer.xml

59:53 T:1500 M:2166099968    INFO: Loading skin file: DialogVolumeBar.xml

59:53 T:1500 M:2166079488    INFO: Loading skin file: DialogSeekBar.xml

59:53 T:1500 M:2166165504    INFO: Loading skin file: DialogKaiToast.xml

59:53 T:1500 M:2166161408    INFO: Loading skin file: DialogMuteBug.xml

59:53 T:1500 M:2166124544   DEBUG: CGUIAudioManager::Initialize

59:53 T:1500 M:2166120448   DEBUG: CAudioContext::SetActiveDevice - SetActiveDevice from 1 to 2

59:53 T:1500 M:2166120448   DEBUG: CAudioContext::RemoveActiveDevice - Removing device 1

59:53 T:1500 M:2165776384   DEBUG: CWDSound::direct_sound_enumerator_member_callback - found Device: Primary Sound Driver

59:53 T:1500 M:2165776384   DEBUG: CWDSound::direct_sound_enumerator_member_callback - found Device: Speakers (High Definition Audio Device)

59:53 T:1500 M:2165776384   DEBUG: CWDSound::direct_sound_enumerator_member_callback - found Device: Digital Audio (S/PDIF) (High Definition Audio Device)

59:53 T:1500 M:2165776384   DEBUG: CAudioContext::SetActiveDevice - (default playback device).

59:53 T:1500 M:2165563392    INFO: Loading C:\Users\Mario\AppData\Roaming\XBMC\addons\skin.customizableconfluence\sounds\so​unds.xml

59:53 T:1500 M:2165559296    INFO:   skin loaded...

59:53 T:1500 M:2165559296   DEBUG: Activating window ID: 12999

59:53 T:1500 M:2165555200   DEBUG: Checking if window ID 12999 is locked.

59:53 T:1500 M:2165555200   DEBUG: ------ Window Init (Startup.xml) ------

59:53 T:1500 M:2165555200    INFO: Loading skin file: Startup.xml

59:53 T:1500 M:2165547008    INFO: removing tempfiles

59:53 T:1500 M:2165542912   DEBUG: ADDON: Starting service addons.

59:53 T:1500 M:2165542912  NOTICE: initialize done

59:53 T:1500 M:2165542912  NOTICE: Running the application...

59:53 T:1500 M:2165534720   DEBUG: CApplication::ExecuteXBMCAction : Translating SetFocus(10)

59:53 T:1500 M:2165534720   DEBUG: CApplication::ExecuteXBMCAction : To SetFocus(10)

59:53 T:1500 M:2165522432    INFO: initializing python engine.

59:53 T:1500 M:2165522432   DEBUG: Win32DllLoader::Load(special://xbmcbin/system/python/python24.dll)

59:53 T:1500 M:2164027392   DEBUG: new python thread created. id=1

59:53 T:1500 M:2164019200   DEBUG: CNetwork::NetworkMessage - Starting network services

59:53 T:1500 M:2164011008  NOTICE: ES: Starting event server

59:53 T:6072 M:2164006912   DEBUG: thread start, auto delete: 0

59:53 T:6072 M:2164006912   DEBUG: Python thread: start processing

59:53 T:1500 M:2163998720    INFO: JSONRPC Server: Successfully initialized

59:53 T:1500 M:2163978240   DEBUG: CLastfmScrobbler: Clearing session.

59:53 T:1500 M:2163978240   DEBUG: CLibrefmScrobbler: Clearing session.

59:53 T:3564 M:2163970048   DEBUG: thread start, auto delete: 0

59:53 T:3564 M:2163970048  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777

59:53 T:3564 M:2163965952  NOTICE: UDP: Listening on port 9777

59:53 T:1500 M:2165309440 WARNING: CRenderSystemDX::BuildPresentParameters - xbmc compiled with an d3d sdk not supporting D3DSWAPEFFECT_FLIPEX

59:53 T:6956 M:2164617216   DEBUG: thread start, auto delete: 0

59:53 T:6072 M:2164609024  NOTICE: -->Python Interpreter Initialized<--

59:53 T:6072 M:2164609024   DEBUG: XBPyThread::Process - The source file to load is C:\Users\Mario\AppData\Roaming\XBMC\userdata\autoexec.py

59:53 T:6072 M:2164604928   DEBUG: XBPyThread::Process - Setting the Python path to C:\Users\Mario\AppData\Roaming\XBMC\userdata;C:\Users\Mario\AppData\Roaming\XBMC​\addons\script.module.simplejson\lib;C:\Users\Mario\AppData\Roaming\XBMC\addons\​script.module.beautifulsoup\lib;C:\Program Files (x86)\XBMC\addons\script.module.pil\lib;C:\Users\Mario\AppData\Roaming\XBMC\addo​ns\script.module.elementtree\lib;C:\Program Files (x86)\XBMC\addons\script.module.pysqlite\lib;C:\Program Files (x86)\XBMC\system\python\DLLs;C:\Program Files (x86)\XBMC\system\python\Lib;special://xbmcbin/system/python/python24.zip;C:\Program Files (x86)\XBMC\system\python\DLLs;C:\Program Files (x86)\XBMC\system\python\lib;C:\Program Files (x86)\XBMC\system\python\lib\plat-win;C:\Program Files (x86)\XBMC\system\python\lib\lib-tk;C:\Program Files (x86)\XBMC

59:53 T:6072 M:2164604928   DEBUG: XBPyThread::Process - Entering source directory C:\Users\Mario\AppData\Roaming\XBMC\userdata

59:53 T:6780 M:2163982336   DEBUG: thread start, auto delete: 1

59:53 T:1500 M:2156740608   DEBUG: CApplication::ExecuteXBMCAction : Translating ReplaceWindow(Home)

59:53 T:1500 M:2156740608   DEBUG: CApplication::ExecuteXBMCAction : To ReplaceWindow(Home)

59:53 T:1500 M:2156740608   DEBUG: Activating window ID: 10000

59:53 T:1500 M:2156740608   DEBUG: Checking if window ID 10000 is locked.

59:53 T:1500 M:2156740608   DEBUG: ------ Window Deinit (Startup.xml) ------

59:53 T:1500 M:2156740608   DEBUG: ------ Window Init (Home.xml) ------

59:53 T:3944 M:2155458560   DEBUG: thread start, auto delete: 1

59:53 T:3944 M:2155446272    INFO: WEATHER: Downloading weather

59:53 T:3944 M:2155433984   DEBUG: Win32DllLoader::Load(special://xbmcbin/system/libcurl.dll)

59:53 T:3944 M:2155175936   DEBUG: Win32DllLoader::Load(special://xbmcbin/system/libidn-11.dll)

59:53 T:3944 M:2155171840   DEBUG: Win32DllLoader::Load(special://xbmcbin/system/libeay32.dll)

59:53 T:3944 M:2155089920   DEBUG: Win32DllLoader::Load(special://xbmcbin/system/libssl32.dll)

59:53 T:3944 M:2154201088   DEBUG: Win32DllLoader::Load(ADVAPI32.DLL)

59:53 T:3944 M:2154192896   DEBUG: Win32DllLoader::Load(KERNEL32.DLL)

59:53 T:3944 M:2154184704   DEBUG: Win32DllLoader::Load(NETAPI32.DLL)

59:53 T:3944 M:2154024960   DEBUG: FreeLibrary(NETAPI32.DLL) -> 07145C90

59:53 T:3944 M:2154024960   DEBUG: Win32DllLoader::Unload NETAPI32.DLL

[b]19:59:53 T:1500 M:2153938944    INFO: CNetwork::WakeOnLan - Magic packet send to 'e0-cb-4e-65-21-8d'[/b]

59:53 T:4172 M:2153476096   DEBUG: thread start, auto delete: 1

My auteoxec.py file content:

Code:

import time, os 

import xbmc

xbmc.executebuiltin("WakeOnLan(e0-cb-4e-65-21-8d)")

time.sleep(5) 

xbmc.executebuiltin("XBMC.RunScript(%s/default.py,-startup)" % ( os.path.join( os.getcwd(), "../addons/script.autoupdate/" )))

maybe you know how to send WOL packet, before XBMC will try to connect with database ?

**jhsrennie** · 2011-02-02 11:34

I don't know whether autoexec.py is executed before or after XBMC connects to the MySQL server; actually I suspect it may run simultaneously in a separate thread.

You might be better off writing a batch file to send a WOL then pause then start XBMC. If you want to do this there are loads of command line WOL apps for Windows. I use wolcmd.exe, which I think is from Depicus.

JR

castortray · 2011-02-02 12:17

ok,
I will try and let you know.

thanks

castortray · 2011-02-04 22:49

it's working !! Smile

I'm using http://www.mediafire.com/?5n7vprm2d07b3pc

wol.bat

Code:

mc-wol.exe aa:bb:cc:dd:ee:ff

timeout 10

start xbmc.exe

thanks again for help

t4_ravenbird · 2012-03-01 15:15

Have a look at my post here, maybe this would be what you are looking for ? ; http://forum.xbmc.org/showthread.php?tid=124340

jhsrennie Team-XBMC Developer Posts: 7,237 Joined: Nov 2008 Reputation: 117 Location: Chester, UK	2011-01-30 10:55 Post: #2 XBMC has a wake on lan function built in. See http://wiki.xbmc.org/?title=List_of_Built_In_Functions If you create a Python script called default.py and put it in your userdata folder XBMC will execute this script when it starts, and you can have this script send a WOL signal. JR
	find quote

castortray Fan Posts: 503 Joined: May 2009 Reputation: 0	2011-01-30 22:30 Post: #3 wow, nice I did not know about this earlier I need to check it. Many thanks. Regards
	find quote

castortray Fan Posts: 503 Joined: May 2009 Reputation: 0	2011-02-02 12:17 Post: #8 ok, I will try and let you know. thanks
	find quote

castortray Fan Posts: 503 Joined: May 2009 Reputation: 0	2011-02-04 22:49 Post: #9 it's working !! I'm using http://www.mediafire.com/?5n7vprm2d07b3pc wol.bat Code: `mc-wol.exe aa:bb:cc:dd:ee:ff timeout 10 start xbmc.exe` thanks again for help
	find quote

t4_ravenbird Member Posts: 90 Joined: Mar 2012 Reputation: 2	2012-03-01 15:15 Post: #10 Have a look at my post here, maybe this would be what you are looking for ? ; http://forum.xbmc.org/showthread.php?tid=124340
	find quote