[bertybassett]

here is my setup.

Device 1 in Frontroom
e-Machine er1401 k325, 2Gb, Nvidia card, etc running xbmclive 10.1 with Eden beta2.

Device 2 in Bedroom
e-Machine er1401 k325, 2Gb, Nvidia card, etc running XBMCbuntu edition 31 with Eden beta2.

All hardwired together via a 100Mb lan and working fine until I add a MySQL database running on a Synology NAS.

I have added a sources.xml

Code:

- <sources>
- <programs>
  <default pathversion="1" />
  </programs>
- <video>
  <default pathversion="1" />
- <source>
  <name>Movies</name>
  <path pathversion="1">smb://192.168.1.100/media/Movies/</path>
  </source>
- <source>
  <name>TV Shows</name>
  <path pathversion="1">smb://192.168.1.100/media/TV Shows/</path>
  </source>
  </video>
- <music>
  <default pathversion="1" />
- <source>
  <name>Music</name>
  <path pathversion="1">/home/xbmc/Music/</path>
  </source>
  </music>
- <pictures>
  <default pathversion="1" />
- <source>
  <name>Pictures</name>
  <path pathversion="1">/home/xbmc/Pictures/</path>
  </source>
  </pictures>
- <files>
  <default pathversion="1" />
- <source>
  <name>LocalHome</name>
  <path pathversion="1">/home/xbmc/</path>
  </source>
- <source>
  <name>NasMedia</name>
  <path pathversion="1">smb://192.168.1.100/media/</path>
  </source>
  </files>
  </sources>

and I then added an advancedsettings.xml

Code:

- <advancedsettings>
- <videodatabase>
  <type>mysql</type>
  <host>192.168.1.100</host>
  <port>3306</port>
  <user>xbmc</user>
  <pass>xbmc</pass>
  </videodatabase>
- <musicdatabase>
  <type>mysql</type>
  <host>192.168.1.100</host>
  <port>3306</port>
  <user>xbmc</user>
  <pass>xbmc</pass>
  </musicdatabase>
- <pathsubstitution>
- <substitute>
  <from>special://Thumbnails</from>
  <to>smb://192.168.1.100/media/Thumbnails/</to>
  </substitute>
  </pathsubstitution>
  </advancedsettings>

Once I rebooted and everything works fine, well until I try and resume for sleep. Device 1 will take 45 seconds to resume (you just get a black screen) and device 2 will resume almost instantly but if I try and access the Movies or TV Shows screens then XBMC will pause for about 35 seconds.

I have granted XBMC complete rights to the MySQL database but now I am stuck. Can anyone shed any light on this problem?

Please note I will upload two debug log files tonight if that helps identify the problem at work at present.

[.:B:.]

I'd say Samba and/or MySQL might be playing up. Make sure the clients are both up and running before Xbmc starts. The fact they are not might explain the delays.

[bertybassett]

thanks for the speedy reply but I wonder how I check that? Guess I look in the debug log.

Might try moving over to NFS to see if that helps any.

[bertybassett]

here is a log file from device 2

http://pastebin.com/0KR0p3vQ

[bertybassett]

database: MyVideos57 [2003](Can't connect to MySQL server on '192.168.1.100' (113))
20:14:22 T:8984880 ERROR: Unable to open database: MyVideos56 [1049](Unknown database 'MyVideos56')
20:14:22 T:2975824752 ERROR: Unable to open database: MyMusic16 [1049](Unknown database 'MyMusic16')
20:14:22 T:8984880 ERROR: Unable to open database: MyVideos55 [1049](Unknown database 'MyVideos55')
20:14:22 T:2975824752 ERROR: Unable to open database: MyMusic15 [1049](Unknown database 'MyMusic15')
20:14:22 T:8984880 ERROR: Unable to open database: MyVideos54 [1049](Unknown database 'MyVideos54')
20:14:22 T:2975824752 ERROR: Unable to open database: MyMusic14 [1049](Unknown database 'MyMusic14')
20:14:22 T:8984880 ERROR: Unable to open database: MyVideos53 [1049](Unknown database 'MyVideos53')
20:14:23 T:2975824752 ERROR: Unable to open database: MyMusic13 [1049](Unknown database 'MyMusic13')
20:14:23 T:8984880 ERROR: Unable to open database: MyVideos52 [1049](Unknown database 'MyVideos52')
20:14:23 T:2975824752 ERROR: Unable to open database: MyMusic12 [1049](Unknown database 'MyMusic12')
20:14:23 T:8984880 ERROR: Unable to open database: MyVideos51 [1049](Unknown database 'MyVideos51')
20:14:23 T:2975824752 ERROR: Unable to open database: MyMusic11 [1049](Unknown database 'MyMusic11')
20:14:23 T:8984880 ERROR: Unable to open database: MyVideos50 [1049](Unknown database 'MyVideos50')


Could this be the problem? why is it trying to find lots of MyVideo and MyMusic databases that don't exisit on the MySQL server

Just checked MySQL and the database names are:-


MyMusic18 (19)
MyVideos58 (41)
information_schema (28)
mysql (23)

Is there anything wrong with those database names? or should they be called just MyMusic and MyVideo?

[bertybassett]

turns out that when I resume from sleep I have no IP Address for about 30 seconds, after which the IP address returns and I can access MySQL fine. I am hard wired through a few switches and running a static IP.

Would changing network manager to WICD help any?

Anyone know why this might be? or should I be asking the question in a more general Ubuntu forum.

[MaxCore]

i have the same problem i use openelec and my mysql server is on win7 and when i resume from sleep my openelec i have a black screen for 30-45sec and after my library is load it.

[bertybassett]

my problem was due to using cat 5 cables. The nic was trying to do a 1000mb connection and then dropping back to a 100Mb or 10Mb connection. It took me forever to figure this out but once I replaced all the network cables for new ones then it works like a dream.

So my suggestion is replace your network cables to cat 5e or cat 6

[MaxCore]

@bertybassett thx i will change my cable !

[MaxCore]

@bertybassett i not clue mine ... My router is a 10/100 and my switch is gigabit and all my cable is cat 6. You thing will be the router the problem ...?