[Microsaft]

Hey there,

I am running XBMC on Mac OS X 10.7.2. I am using yesterday's build (1b2b245) but I also tried some older builds.

I am using a shared library, my advanced settings.xml looks as follows:

<advancedsettings>
<useddsfanart>true</useddsfanart>

<videolibrary>
<cleanonupdate>true</cleanonupdate>
</videolibrary>

<gui>
<algorithmdirtyregions>1</algorithmdirtyregions>
</gui>

<videodatabase>
<type>mysql</type>
<host>10.0.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>10.0.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>

<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://user:pass@10.0.1.10/Video/XBMC/Thumbnails/</to>
</substitute>
</pathsubstitution>

</advancedsettings>

I did a complete new setup yesterday because I switched to a bigger NAS. I created a new database and copied the advancedsettings.xml to all clients. However, the machines do not share the library - when I mark a video as watched it does not marked "watched" on the other xbmc-clients.

The xbmc.log states this:

02:27:06 T:2904744640 INFO: Loading skin file: Home.xml
02:27:06 T:2904744640 DEBUG: Connecting to mysql:10.0.1.10:xbmc_video57
02:27:06 T:2904744640 ERROR: Unable to open database: xbmc_video57 [1040](Too many connections)
02:27:06 T:2904744640 DEBUG: Connecting to mysql:10.0.1.10:xbmc_video56
02:27:06 T:2904744640 ERROR: Unable to open database: xbmc_video56 [1040](Too many connections)
02:27:06 T:2904744640 DEBUG: Connecting to mysql:10.0.1.10:xbmc_video55
02:27:06 T:2904744640 ERROR: Unable to open database: xbmc_video55 [1040](Too many connections)
02:27:06 T:2904744640 DEBUG: Connecting to mysql:10.0.1.10:xbmc_video54
02:27:06 T:2904744640 ERROR: Unable to open database: xbmc_video54 [1040](Too many connections)
02:27:06 T:2904744640 DEBUG: Connecting to mysql:10.0.1.10:xbmc_video53

I guess it is a problem with the nightlies as I did not have this issue before (using a build that was a few weeks old)
Which build do I have to use without having this issue?

[r4nd0m]

same here with the Nov 5th, unfortunately I cant recall from which release this started to happen as I didnt notice it ... though I believe not having the issue with the Oct 15th nightly if I remember correctly - the issue however isnt Mac specific ...

this fixes it though: http://forum.xbmc.org/showthread.php?p=9...post923607, just tested ... works

I exported the movie database, then uncommented the database <!-- --> and connected to mysql, database was created, imported all data ... - hope this works for you

greet
r4n

[Microsaft]

thx for the reply!

I use phpMyAdmin.
When I try to export the database it say "no tables".
Is this because I created the database myself and did not let XBMC do it?

So what to do?
Just delete the databases, start XBMC and thats it?

[r4nd0m]

uhm, I meant you export on the "old" working environment, else you lose everything thats in your database, via xbmc settings, video, export ...

when you got a recent database export, you just delete all xbmc_ databases

then do an SQL: grant all on *.* to xbmc - allows xbmc to create databases and it will create new ones when first connecting, then in xbmc import your database via video settings and import everything back to the SQL

so basically export from SQL to XML, then reimport after creation ...

maybe renaming the database to MyVideos57 for video and MyMusic18 for music will also work if you grant permissions , havent tried that ...

[BDPNA]

I noticed you were using an SMB path in your share for your Thumbnails. Does SMB work in 10.7.2 now?

[Microsaft]

@r4nd0m
THX. Seems to work.
The databases were created and I am importing my stuff now

@BDPNA
I cannot help you with that as my smb share is my NAS.
Sorry.



edit:
One question left:
I have an ATV 1 (Crystalbuntu) client as well. Do I have to edit the advancedsettings.xml because of the new database names?