MySQL & WOL (wake on lan)

All,

Just thought I would add my .02 ...

I went through this process today, independent of the notes in this thread.


In general, if your MYSQL is on a home server that sleeps, YOU MUST wake that server before XBMC can begin to run on your HTPC.


So... that is why the Wake-On-Lan plug-ins that are available in XBMC won't do the trick: The plug-in will never run if XBMC does not start, and XBMC will not start if it can't ping the MYSQL database.

Simple enough, right?


So, for me, running win7 64bit, I built a simple .bat file for a free WOL program available at:

http://www.gammadyne.com/cmdline.htm#wol

I put the WOL.EXE program into c:\program files\WOL (which I created on the HTPC).

And then I created a .bat file (that I chose to call "An XBMC WOL.bat") that contains:

C:\PROGRA~1\WOL\WOL 00235400c245

(where that last string of info is the MAC of your NIC in the server. Yours WILL be different.)


Then I placed that .bat file in startup of HTPC

... walla-walla washington, it works.


The way that my HTPC behaves is that windows boots, The WOL .bat runs in the background, XBMC starts, and there is a pause at the XBMC Boot screen while my MYSQL starts up.

Once it does, then it moves forward to display my profile choices. (if you have not enabled profiles, you won't see that).


In effect, it accomplishes that same effect that castortray did when he included a "timeout 10" command in his WOL program of choice.

(... but I get to look at the AWESOME XBMC 11 / Eden boot screen while waiting.)


Best regards,

v.


(Disclaimers: This assumes that your home server with MYSQL sleeps, and that you have S3 sleep and MYSQL set up correctly. The bat file discussed here would need to be loaded on every HTPC in your home environment. WOL usually only works via wired ethernet. I have not tested this wirelessly. This is WOL only, not wake over internet. Flying Monkeys may slow your progress, however you will likely still succeed.)