XBMC Community Forum
2 XBMC PCs and 1 Database on the shared NAS - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

- albaranov - 2010-09-06 04:02

Mitch23 Wrote:@albaranov

Thanks. After the modifications the same query takes only 1 second.

Mitch23

Great! Good luck with 100,000 files. Alex

- charrua - 2010-09-06 12:47

albaranov Wrote:Hi Charrua,
I've completed testing the music database with several amendments.
There were three issues:
1. Delay of 3 minutes when you click on an Artist in Library mode.
Fixed by adding index as per http://forum.xbmc.org/showthread.php?tid=78425
2. Delay of 20 seconds when you click on "Artists"
Fixed by: alter table song add index idArtist(idArtist);
3. Delay of 10 seconds when you click on "Genres"
Fixed by: alter table song add index idGenre(idGenre);
Now, in my case, everything opens momentarily on the main machine. Alex
Very good tips! Thanks.

- Talguy - 2010-09-10 21:40

So I am about to build my first XBMC HTPC and would like to go with a centrailized DB and have lite frontend clients. My question is when I add new content to XBMC i.e. a movie how does it get added to the mysql database. Also how would I be able to add the scraped data for that file to the database.

- pregi - 2010-09-12 18:24

hi
is there an Option to set timeout for MySQL DB?
sometimes my MySQL Server is down, because of this xbmc hangs and is nearly unusable

Unable to open database: xbmc_video (0) - dora - 2010-09-18 22:36

I'm trying to use the MySql external db feature but unfortunately, I can't make it work.
I'm using MySql server 5.5 and XBMC Dharma beta 2, both running on the same machine (Windows 7).
Looking in XBMC logfile, I can see the following error:
Code:
22:22:19 T:3268 M:1636188160  NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
22:22:19 T:3268 M:1636184064  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>localhost</host>
                                                <port>3306</port>
                                                <name>xbmc_video</name>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>localhost</host>
                                                <port>3306</port>
                                                <name>xbmc_music</name>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </musicdatabase>
                                            </advancedsettings>
22:22:19 T:3268 M:1636167680 WARNING: VIDEO database configuration is experimental.
22:22:19 T:3268 M:1636167680  NOTICE: Getting hardware information now...
22:22:19 T:3268 M:1636167680  NOTICE: Checking resolution 12
22:22:19 T:3268 M:1636167680  NOTICE: Default DVD Player: dvdplayer
22:22:19 T:3268 M:1636167680  NOTICE: Default Video Player: dvdplayer
22:22:19 T:3268 M:1636167680  NOTICE: Default Audio Player: paplayer
22:22:19 T:3268 M:1636265984  NOTICE: Loading media sources from special://masterprofile/sources.xml
22:22:20 T:3268 M:1621999616  NOTICE: initializing playlistplayer
22:22:20 T:3268 M:1621999616  NOTICE: DONE initializing playlistplayer
22:22:20 T:3268 M:1611956224   ERROR: Unable to open database: xbmc_video (0)
22:22:20 T:3268 M:1611952128   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:20 T:3268 M:1611857920   ERROR: Unable to open database: xbmc_video (0)
22:22:20 T:3268 M:1611849728   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:20 T:3268 M:1611841536   ERROR: Unable to open database: xbmc_video (0)
22:22:20 T:3268 M:1611841536   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:20 T:3268 M:1611841536   ERROR: Unable to open database: xbmc_video (0)
22:22:20 T:3268 M:1611841536   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:20 T:3268 M:1610698752  NOTICE: initialize done
22:22:20 T:3268 M:1610686464  NOTICE: Running the application...
22:22:20 T:3268 M:1610665984  NOTICE: ES: Starting event server
22:22:20 T:5732 M:1610633216  NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
22:22:20 T:5732 M:1610563584  NOTICE: UDP: Listening on port 9777
22:22:21 T:3268 M:1604685824   ERROR: Unable to open database: xbmc_video (0)
22:22:21 T:3268 M:1604677632   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:21 T:3268 M:1601159168   ERROR: Unable to open database: xbmc_video (0)
22:22:21 T:3268 M:1601695744   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
22:22:21 T:3268 M:1607045120   ERROR: Unable to open database: xbmc_video (0)
22:22:21 T:3268 M:1607581696   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
and my advancedsettings goes like that:
Code:
<videodatabase>
    <type>mysql</type>
    <host>localhost</host>
    <port>3306</port>
    <name>xbmc_video</name>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
I already added xbmc user with full permision granted plus DBDesigner.
I also tried to use latin1 as server character set and collation.
Any help?
Thanks
Dora

- Soul - 2010-09-18 22:40

Have you actually created the databases, and not just the user?

Just checking - you might be expecting XBMC to create the dbs on first run or something. Smile

- dora - 2010-09-18 23:10

Soul Wrote:Just checking - you might be expecting XBMC to create the dbs on first run or something. Smile

Actually, I did expected XBMC to create the dbs on the first run, shouldn't I?
If I do need to create them by myself, can you give me a hint how to do it?
I already spent more than 5 hours to make it work before I decided to ask for help.
:confused2:

Dora.

- craigd - 2010-09-19 00:31

Soul Wrote:Have you actually created the databases, and not just the user?

Just checking - you might be expecting XBMC to create the dbs on first run or something. Smile

xbmc does create the databases on first run.

it looks like you've had the db created with an old xbmc build and the database has changed. try dropping the schemas from your sql server and restart xbmc

- dora - 2010-09-19 09:29

craigd Wrote:it looks like you've had the db created with an old xbmc build and the database has changed. try dropping the schemas from your sql server and restart xbmc
I think that I did more than that. I completely unintalled MySql 5.1 and installed MySql 5.5. I thought that the problem might be that I'm not using the last version of MySql but that didn't help.
I don't know anything about schemas, what do you mean by dropping them? how do I do that?
Since I'm using XBMC in portable mode (-p switch), I also tried to delete XBMC\portable_data\userdata folder but that didn't help either.

Dora.

UPDATE:
It looks like you do have to create the databases by yourself.
I followed the instructions on: http://lifehacker.com/5634515/how-to-synchronize-your-xbmc-media-center-across-every-room-in-the-house and the errors on the log disappeared.

- avus m3 - 2010-09-20 06:29

I have a quick question about using the centralized DB setup. I have it working on my machines being able to resume paused play in another room etc. One problem I have is I added a few episodes of different shows and it's not adding them?? I selected to update library (have it update on startup as well) but it doesn't add the show episodes. Everything works besides not able to add episodes. Any ideas?