Request -  Request: Enable Wake on Lan (WOL) before MySQL and Path substitution
#1
I am using MySQL together with Kodi and it works just fine.

Apparently, WOL only works when kodi is up and running.
However, I use Mysql and Path substitution in the advancedsettings.xml
I need to use a WOL-Script before Kodi start in order to have everything working correctly.

Works well with Windows, Ubuntu and OpenElec
For Android: I need to use a separate app for WOL first before running Kodi.

Request: Enable Wake on Lan before MySQL and Path substitution
Reply
#2
Hi,
seeing your thread and having a similar setup (multiple kodis, one machine with mysql and file server. no path sub though) i was wondering if you are talking about the advanced wake on lan addon or the build in feature (enable in power saving setting). Because the build in feature does for me exactly what you want. The moment i start kodi (on the splash not in home yet) on one machine it sends the wol packet and wakes up the mysql machine. I think my setup has maybe one difference which is i added all the source network folders on all the clients so that they can all update the db consistently. But i would think that shouldnt make a difference.

Regards
Reply
#3
Hi,

thank you for your reply. So i guess you mean the wakeonlan.xml file which is configured for me like this.

<onaccesswakeup>
   <netinittimeout>60</netinittimeout>
   <netsettletime>500</netsettletime>
   <wakeup>
       <host>192.168.0.10</host>
       <mac>XX:XX:XX:XX:XX:XX</mac>
       <pingport>7</pingport>
       <pingmode>1</pingmode>
       <timeout>600</timeout>
       <waitonline>38</waitonline>
       <waitonline2>40</waitonline2>
       <waitservices>0</waitservices>
   </wakeup>
</onaccesswakeup>

However either the MySQL Connection or the Path substitution wasn't working using the WOL for me.
I will evalute this over the weekend to get some more information.
Reply
#4
to be honest i didnt do any manual config on this. i just enabled the feature and magic... unfortunatly im not at home at the moment but on the weekend i can send you the xml file
Reply
#5
You are right ; built in WOL is made to kick in before MySQL , this is correct and very deliberate. It is also made to kick in after pathsubstitution and so try to wake only the final target host
Reply
#6
Thanks for the confirmation. So the path substitution might be the problem I couldn't solve with the WOL.
Let me tell you what I get out of the path substitution.

My advancedsettings.xml file looks like this.

<advancedsettings>
    <video>
        <timeseekforwardbig>270</timeseekforwardbig>
        <timeseekbackwardbig>-270</timeseekbackwardbig>    
    </video>
    
    <videolibrary>
        <cleanonupdate>true</cleanonupdate>
        <importwatchedstate>true</importwatchedstate>
    </videolibrary>
    <videoscanner>
        <ignoreerrors>true</ignoreerrors>
    </videoscanner>
    
    <videodatabase>
        <type>mysql</type>
        <host>192.168.0.10</host>
        <port>3306</port>
        <user>...</user>
        <pass>...</pass>
        <name>kodi_video</name>
    </videodatabase>
    <musicdatabase>
        <type>mysql</type>
        <host>192.168.0.10</host>
        <port>3306</port>
        <user>...</user>
        <pass>...</pass>
        <name>kodi_music</name>
    </musicdatabase>
    
    <pathsubstitution>
      <substitute>
        <from>/media/data/</from>
        <to>smb://192.168.0.10/data/</to>
      </substitute>     
      <substitute>
        <from>special://profile/profiles/Kids</from>
        <to>smb://192.168.0.10/data/kodi/userdata/profiles/Kids</to>
      </substitute>
      
      <substitute>
        <from>special://profile/profiles.xml</from>
        <to>smb://192.168.0.10/data/kodi/userdata/profiles.xml</to>
      </substitute>
      <substitute>
        <from>special://profile/sources.xml</from>
        <to>smb://192.168.0.10/data/kodi/userdata/sources.xml</to>
      </substitute>
      <substitute>
        <from>special://profile/playlists</from>
        <to>smb://192.168.0.10/data/kodi/userdata/playlists</to>
      </substitute>
      <substitute>
        <from>special://profile/mediasources.xml</from>
        <to>smb://192.168.0.10/data/kodi/userdata/mediasources.xml</to>
      </substitute>
      <substitute>
        <from>special://profile/favourites.xml</from>
        <to>smb://192.168.0.10/data/kodi/userdata/favourites.xml</to>
      </substitute>
      <substitute>
        <from>special://profile/RssFeeds.xml</from>
        <to>smb://192.168.0.10/data/kodi/userdata/RssFeeds.xml</to>
      </substitute>
      <substitute>
        <from>special://profile/addon_data/pvr.hts/</from>
        <to>smb://192.168.0.10/data/kodi/userdata/addon_data/pvr.hts/</to>
      </substitute>
      <substitute>
        <from>special://profile/addon_data/weather.yahoo/</from>
        <to>smb://192.168.0.10/data/kodi/userdata/addon_data/weather.yahoo/</to>
      </substitute>
    </pathsubstitution>
</advancedsettings>

I use the following devices.
- 1 ubuntu server (192.168.0.10)
  - holds some user data for kodi
- 3 Android devices
- 2 Windows devices
- 2 Raspberry PI devices

By installing a new version of kodi on a new device, mostly I need to add the advancesettings.xml file.
The benefit I get is:
- Shared profiles
- Shared favorites
- Shared rss feeds
- Shared sources
- Playlists
- Shared login settings for PVR Settings
- ...
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
Request: Enable Wake on Lan (WOL) before MySQL and Path substitution00