Kodi Community Forum
MediaFrontPage - Web interface with widget type architecture to control multiple apps - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+--- Thread: MediaFrontPage - Web interface with widget type architecture to control multiple apps (/showthread.php?tid=83304)



- DejaVu - 2011-05-12

Can I sound like a complete n00b for a second and ask for a point in the right direction...

I have MFP installed on my XBMCLive'd Revo that has all my drives either connected to it via USB or Mounted via the network.

How can I find the information (that's simple to follow) to create a MySQL for my setup so that the database from all my other clients (wirelessly connected laptops) around my house can connect to.

I want to set this up so I can get more involved with the development of MFP's MySQL integration.

Guessing here is a good place to start?
http://forum.xbmc.org/showthread.php?tid=85654

Can it be used on a XBMCLive machine?

--EDIT
Looks like it's been done before! Smile
http://forum.xbmc.org/showthread.php?tid=83483

The more I look, the more I find. LOL
http://www.contentwhores.com/wordpress/?page_id=432


- Nick8888 - 2011-05-12

This is a good guide. Though it is general and doesnt cover all os specifics

http://lifehacker.com/5634515/how-to-synchronize-your-xbmc-media-center-across-every-room-in-the-house

Basically setup mysql
add a two new databases (video, music)
add details to your advancedsettings.xml

Code:
<advancedsettings>    
  <videodatabase>        
     <type>mysql</type>        
     <host>***.***.***.***</host>        
    <port>3306</port>        
    <user>xbmc</user>      
    <pass>xbmc</pass>        
    <name>xbmc_video</name>    
  </videodatabase>      
  <musicdatabase>        
    <type>mysql</type>        
    <host>***.***.***.***</host>        
    <port>3306</port>      
    <user>xbmc</user>    
    <pass>xbmc</pass>    
    <name>xbmc_music</name>    
  </musicdatabase>
</advancedsettings>



- Nick8888 - 2011-05-12

Also anyone that wants to be an admin on the lighthouseapp please pm me with an existing email address. This will allow you to set tags on tickets etc so the more the merrier.


- DejaVu - 2011-05-12

Joined and Accepted. Just reading up on using LH now whilst being refused access to my MySQL Database I just created. Sad

Trying to access it with MySQL Workbench it throws a tantrum. Login with commandline in Linux - no problem. Guessing perhaps Windows 7 built in firewall blocking 3306.

--EDIT--
It hasn't populated the Database in XBMC either - I can see this being a permissions thing.

Gonna open a new thread for assistance with this. Smile


- _Mikie_ - 2011-05-12

Stupid Question probably but please explain the following as I just can't get it to work

// enter path to sickbeards's coming episodes page
$sickbeardcomingepisodes = 'http://user: password@computerTongueORT/sickbeard/comingEpisodes/';
$sickbeardurl = "http://user: password@computerTongueORT/sickbeard/";

These are my urls
http://192.168.0.14:8081/comingEpisodes
http://192.168.0.14:8081/


- RaNaMaster - 2011-05-12

_Mikie_ Wrote:Stupid Question probably but please explain the following as I just can't get it to work

// enter path to sickbeards's coming episodes page
$sickbeardcomingepisodes = 'http://user: password@computerTongueORT/sickbeard/comingEpisodes/';
$sickbeardurl = "http://user: password@computerTongueORT/sickbeard/";

These are my urls
http://192.168.0.14:8081/comingEpisodes
http://192.168.0.14:8081/


this is my config and your looks fine to me im on windows xp what os are you on
$sickbeardcomingepisodes = 'http://192.168.1.100:8081/comingEpisodes/';
$sickbeardurl = "http://192.168.1.100:8081";


- SleepyP - 2011-05-12

Mikie, try copying the URL from your config.php into your address bar. If you can open it in a browser then MFP should be able to get to it.


- DejaVu - 2011-05-12

Welcome to XBMC Mikie!Nice to see your first port of call is with us!! Smile

Click this http://192.168.0.14:8081

If Sickbeard loads for you,

Use this -

Code:
// enter path to sickbeards's coming episodes page
$sickbeardcomingepisodes = 'http://192.168.0.14:8081/comingEpisodes/';
$sickbeardurl = "http://192.168.0.14:8081";

You only need to use the User/Pass if you have set it up in Sickbeard (Pointless when on a private network IMO)


- DejaVu - 2011-05-12

Right, I think I've managed to get this MySQL Database lark down. Checkout my waffling thread to get it running it on XBMCLive -

http://forum.xbmc.org/showthread.php?tid=101347

Quite pleased with myself now. Smile


- SleepyP - 2011-05-12

Excellent. The only real "gotcha" I haven't resolved yet is the thumbnails.

You CAN use a SMB share on your server and then make symbolic links in the userdata folder for each XBMC client, so that the client Thumbnails folder is actually linking back to the Thumbnails share on the server. This works, but on my large library, it made my Windows 7 clients take forever and a day to open things like the Movies view. Switching to local thumbnail files got rid of the delay, so I know its the thumbnails.

My plan to "fix" this is to have the thumbnails folder on each client shared to the network and then have a scheduled rsync job on the server to sync everyone's thumbnails folders together. I have done shell scripts and cron jobs and stuff but never messed with rsync yet.

Also, I started writing up a troubleshooting page on Lighthouse so when we can point people there when they post questions, thereby reducing the support workload a bit.


- DejaVu - 2011-05-12

Is it not possible to store the img locations in MySQL? Why would this not work? It only needs to be cached once to the local machine then it's there for good. No?

I am going to enable DDS, but will this not work either?
My network consists of 6 wireless laptops, this could take a while.

What you mean is like a cron job that automatically copies (syncs) the Thumbnail folder to the local machine on boot or similar?

I think you've nailed it with the - http://lifehacker.com/software/rsync/geek-to-live--mirror-files-across-systems-with-rsync-196122.php though. Wink

This all being said - all my clients are Windows 7 anyway and used a lot for other stuff as well as XBMC. I think Sync Toy pulling from my Revo (XBMCLive) when they are surfing Facebook would be sufficient for now. I tried Symblinks and it is SLOOOOOOOOOW!


- hernandito - 2011-05-12

DejaVu Wrote:How can I find the information (that's simple to follow) to create a MySQL for my setup so that the database from all my other clients (wirelessly connected laptops) around my house can connect to.

I want to set this up so I can get more involved with the development of MFP's MySQL integration.

Guessing here is a good place to start?
http://forum.xbmc.org/showthread.php?tid=85654

Can it be used on a XBMCLive machine?

--EDIT
Looks like it's been done before! Smile
http://forum.xbmc.org/showthread.php?tid=83483

The more I look, the more I find. LOL
http://www.contentwhores.com/wordpress/?page_id=432

Lifehacker is a really good start, but it is only half the picture. I wrote a comprehensive way to do it in unRAID, but I think the method is basically the same.

http://lime-technology.com/forum/index.php?topic=11473.0


- DejaVu - 2011-05-12

IF you are ONLY syncing over the network and need folders to remain exactly the same at all times, how about a small program that installs itself as a service and syncs the files from one place to another...?

Sounds good to me with this MySQL Thumbnail business. I'm testing out this little (oldish) gem that still works with Windows 7, but must be Run as an Administrator...

Made by a strange looking Italian by the looks, but so far is doing exactly what I want and am going to load this Freeware program to all my Windows machines.

Take a looky at this DSynchronize @ http://dimio.altervista.org/eng/


- _Mikie_ - 2011-05-12

DejaVu I have authentication enabled because friends over the interwebs view my series to see what I have etc. I managed to get it working for now tho.

Another question. Mediafrontpage uses phpcurl to get the sickbeard pages right? In curl what is the command to fix the relative link problem? I'm busy working on something and it has me stuck. Kinda teaching myself curl as I go. Any help would be appreciated.

Regards


- hernandito - 2011-05-12

Guga did you get my files? I sent you a PM...