[muggi]

Hi,


first here is my setup:

XBMC Live (pre Eden 20 May Build from Git)- Mysql Database server
Enigma2 Satelite Reciever

ATV2 (Nightly 16 May) for streaming TV from tuxbox source and
share mysql Libary from server.....

It works proper when my server is online.

But if the server is offline (because i want only to stream TV with ATV2) XBMC slow´s down or freeze.

I check the log files. The Problem is XBMC tries to connect to the mysql server for a lot of times..... and this is the performace eater......


is there a possibility to define a timeout if there is no server avaiable?

[stevenD]

I can confirm that I have the same issue with the latest official on iOS 4.1. At home I'm using a MySQL-server and stream movies over SMB. But I also have added a local folder on my iPad with some movies I want to bring on a trip. XBMC won't start without me removing the mysqö-settings in the advanced settings xml file.

[Sindawi]

I might be about to make n ass of myself but let me see if I understand the question. You set xbmc up to connect to an external database and your wondering why if you then turn that database off your xbmc doesn't work? If that is your question I would then have to ask if you remove the power plug from the atv2 your running xbmc on does it resolve the issue?

[muggi]

I might be about to make n ass of myself but let me see if I understand the question. You set xbmc up to connect to an external database and your wondering why if you then turn that database off your xbmc doesn't work? If that is your question I would then have to ask if you remove the power plug from the atv2 your running xbmc on does it resolve the issue?

Nice joke.....


I am Not wondering about this... But maybe there is a solution( without unklug ATV.....)


I think, this is a interesting question how to solve this(special for iPad)

And this is also a Problem with a xbmc Home Network like Mine...... Xbmc live Server and atv2 Client

[Krazypoloc]

I would suggest changing the timeout period for your iPad. I'm not sure how to do this though but I'm sure there is info in the WIKI.

[muggi]

I would suggest changing the timeout period for your iPad. I'm not sure how to do this though but I'm sure there is info in the WIKI.

there is no mysql timeout in the wiki

[Krazypoloc]

there is no mysql timeout in the wiki

In that case I am really not sure then...I'm not at home now and I don't have time to look into this...maybe do some more digging?

[amet]

there is no way to set a time-out for mysql DB, and I think there never will be

[Ned Scott]

Set two different profiles, one with mysql DB and one without. Set XBMC to open log-in screen by default. Just find a skin were you can do all these options, since no one wants to restore the shutdown menu for the iOS builds even though everything is now untethered, thus no log-off button.

However, the long freeze should be treated as a bug IMO. Having to ssh in and force quit or unplug the unit is a silly way to deal with a disconnected mysql server.

For iPhones and iPads this is an even bigger problem, since they will be going in and out of their local network often.

[Numus]

One way around this would be to code in a backup database. Attempt to ping the mysql server (before connection attempts) and if it comes back refused on unable to connect, default back to local database instead of just going right for a connection and waiting for a time out... Granted this is probably very specialized and wont get developer consideration without a greater demand.

[muggi]

Hi


but my opinion is, when a application has a function to connect to network ports, there must be also a function wich handle if the connection isn´t available!

[muggi]

HI

i solved this by creating 2 profiles.
You have to remove the advancedsettings entries of mysql in the userdata folder (because if you work with profiles, this settings will loaded with every
profile---> see below, i moved it in the profile TV &Video)


Fist profile: TV
/private/var/mobile/Library/Preferences/XBMC/userdata/profiles/TV

in the tv folder i placed my favorites.xml with my tuxbox source

Second Profile: TV & Video
/private/var/mobile/Library/Preferences/XBMC/userdata/profiles/TV &VIDEO

here i add my sources.xml with my smb paths and
my advancedsettings.xml
to get the thumbnails work i edited the path to:

Code:

<pathsubstitution>
   <substitute>
      <from>special://masterprofile/profiles/TV &VIDEO/Thumbnails</from>
      <to>smb://xbmc:[email protected]/xbmcthumbs/</to>
   </substitute>
</pathsubstitution>

Special Thanks to Ned Scott with his idea....great.....

Now i can choose by start to watch TV over tuxbox or
TV an Video....

[gravyflex]

HI

i solved this by creating 2 profiles.
You have to remove the advancedsettings entries of mysql in the userdata folder (because if you work with profiles, this settings will loaded with every
profile---> see below, i moved it in the profile TV &Video)


Fist profile: TV
/private/var/mobile/Library/Preferences/XBMC/userdata/profiles/TV

in the tv folder i placed my favorites.xml with my tuxbox source

Second Profile: TV & Video
/private/var/mobile/Library/Preferences/XBMC/userdata/profiles/TV &VIDEO

here i add my sources.xml with my smb paths and
my advancedsettings.xml
to get the thumbnails work i edited the path to:

Code:

<pathsubstitution>
   <substitute>
      <from>special://masterprofile/profiles/TV &VIDEO/Thumbnails</from>
      <to>smb://xbmc:[email protected]/xbmcthumbs/</to>
   </substitute>
</pathsubstitution>

Special Thanks to Ned Scott with his idea....great.....

Now i can choose by start to watch TV over tuxbox or
TV an Video....

Thanks! I have been looking for a solution for this problem for awhile now.

Although IMHO, on start up xbmc should be able to timeout connecting to MYSQL and then startup instead of hanging. Seems like a bug to me.