Shared SQL-Database for XBMC4XBOX n other XBMC poss?

[XBMC_Fan]

Hello everyone,

since my XBOX I days I am a fan of XBMC and therefore have installed XBMC v11.0 clients also on my WIN7 n WINXP Desktop/Laptop with its sources pointing to my NAS, a shared Thumbnail folder on my NAS and a shared Music n Video MySQL-Database on my NAS.

Now I want to integrate my good old XBOX I in there.

Is it possible with the latest stable XBMC4XBOX 3.2 on my XBOX I to
1. use the same shared Thumbnail folder on my NAS as the other XBMC clients?
2. share the MySQL-Databases (for instance myVideo60.db)?

If so, what will I have to do to realise that?

Thank you very much for your support!!!
Looking forward to your replies.

[professor_jonny]

I think the databases are in different formats also i dont think you can have a remote db from the xbox.

Thumbnalis will work tho if they are in the same directory as the content and named properly.

[skatulskijean]

I think the databases are in different formats also i dont think you can have a remote db from the xbox.

Thumbnalis will work tho if they are in the same directory as the content and named properly.

i think that to !
but is it the issue thats the database is make with sqlite3 or the database strucktur is not the same!
With next release froso its more different as before!

regards jan!

BuzZ can you help to give a clear answher!

[BuZz]

H
Is it possible with the latest stable XBMC4XBOX 3.2 on my XBOX I to
1. use the same shared Thumbnail folder on my NAS as the other XBMC clients?
2. share the MySQL-Databases (for instance myVideo60.db)?

1. no
2. no - we have no mysql support and the database structure is different anyway

[rob]

Hi.

I've currently got four Xboxen set up, and really want to get a shared library working between then, if only to keep track of what's watched and not. Is there any hope that this can be made to work, even if it's not compatible with non-xbox xmbc installs? If not via mysql, can the database be stored on a shared folder somewhere?

Thanks

[BuZz]

Nope and nope. If still unsure see my previous reply!

[rob]

Hmm. Just saying no doesn't really help much - can you give any details on why it cannot be done, such that a solution can be made or a workaround found?

http://www.xbmc4xbox.org.uk/wiki/Database says

By default, the database files (*.db) are stored in The UserData Folder, specifically in userdata/Database.

which seems to imply that it can be moved elsewhere, but I cannot find where that can be done.

I did try moving the entire UserData folder to an smb:// path via profiles.xml, but that stopped it booting. (According to the log, it successfully mapped special://masterprofile/ to the share, but mapping drive T screwed up totally, ("Mapping drive T to Harddisk0\Partition9b:\\LUGGAGE\xbmc\UserData") and there were unsupported protocol errors later on.

This was on the lesser-used box, which is probably not up to date (SVN:30962) - is anything likely to have changed since then in this area?

I appreciate you say there is no MySql support; this would obviously be the best solution though - what would be involved in porting this over? I've not yet delved into the source of either xbmc/xbmc4xbox but am not afraid to do so - it might just take me a while to get the build environments set up.

[BuZz]

sqlite3 on xbox won't run from a samba share.

porting across mysql support is a bunch of work. source is there should you want to have a go. someone tried before but didn't complete - their work is unfortunately lost with the old forum. you will want to dllify mysql also, so that it doesnt need to be statically linked. good luck!

you can check xbmc mainline git history for mysql support stuff, but it doesnt include mysql porting for xbox etc.

[rob]

Well I'm still working on bringing everything together to a point I can compile things - It's been a while since I worked in VC - but hunting around has turned up some code on pastebin, ( http://pastebin.com/b7qfpZN3 ) which certainly looks promising. How close did they get to it working?

[BuZz]

I think they got stuck with the mysql dll stuff . not sure though as I never tested it as it was a work in progress.