XBMC Central Server MySQL

[hooger]

So i used the latest mysql addon through unmenu, configured it the way the guide told me to.  Then set up my XBMC the way ive done it in the past, and followed some guides on the internet.  However nothing seems to be working.

 

XBMC can create the database, as when i run the SQL commands it shows up with the appropriate tables.  However when it comes to populating it, it doesnt seem to work.  I opened up xbmc's log and discovered it tries to access the database starting at 68 all the way down to 1.  It just says "unknown database unable to open".  So how can It create the database but not open it? any ideas or should i take this to the xbmc forums?

[BetaQuasi]

Is this what you did?

 

http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

 

Ignore the mentions of OpenELEC, it's still relevant to any version of XBMC (except the location of advancedsettings.xml)

[Joe L.]

likely all permissions issues.

[hooger]

Is this what you did?

 

http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

 

Ignore the mentions of OpenELEC, it's still relevant to any version of XBMC (except the location of advancedsettings.xml)

 

I followed that and http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/ and it still doesn't work.  I've tried the GRANT ALL ON *.* to 'xbmc'; and it still doesn't work.  I even tried changed the user and pass to my root account in the advancedsettings and it still doesn't work.

 

Interesting though, I used the <name> tag and named it videos, and xbmc created a database called videos68.  And everything seemed to be working, then when I copied the same advancedsettings over to my raspberry pi installation im stuck with the same error, and it creates another database.

 

This is the error: ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'MyVideos68')

[BetaQuasi]

MyVideos68?  So you're using a nightly build of some description.  Are you using the same build across both XBMC's? 

 

Eden's DB version is MyVideos60.  I'd suggest you stop using a nightly and go back to Eden, as there is a great deal of work being done on the DB at the moment by the XBMC devs and tracking down an issue would be difficult to say the least.

[sacretagent]

new nightly builds include the fanarts/thumbnails into the mysql database

it should also improve the db setup....

but too many changes are being made for the moment to run a nightly as "production xbmc"

so betaquasi is right if you want to run this for daily shows view better download eden stable

[BetaQuasi]

Yeah, I'm looking forward to that feature the most!  Well, that and AudioEngine.  Bring on Frodo!

[Influencer]

Not to hijack a thread, but let me hijack this thread.

 

Do any of you use the library watchdog? I know I have to mount the samba share, but does using drive polling keep your discs spun up? I'm setting everything up and having the library update automatically is a big plus.

[DoeBoye]

Not to hijack a thread, but let me hijack this thread.

 

Do any of you use the library watchdog? I know I have to mount the samba share, but does using drive polling keep your discs spun up? I'm setting everything up and having the library update automatically is a big plus.

 

First, thanks for bringing that plugin to my attention!! Sounds extremely handy! I'll be installing that after work today .

 

After reading your post, I checked out the thread on XBMC, and the dev isn't entirely clear about whether disks remain spun up continuously. He *does* mentions that it is much more resource intensive (and choosing the option to only scan root directories apparently helps that)...

 

As far as OP, I'd second going back to Eden. I found the setup using mySql (on Eden), to be extremely quick and easy. I followed the steps in the official XBMC wiki

[aptalca]

Is this what you did?

 

http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

 

Ignore the mentions of OpenELEC, it's still relevant to any version of XBMC (except the location of advancedsettings.xml)

 

I followed that and http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/ and it still doesn't work.  I've tried the GRANT ALL ON *.* to 'xbmc'; and it still doesn't work.  I even tried changed the user and pass to my root account in the advancedsettings and it still doesn't work.

 

Interesting though, I used the <name> tag and named it videos, and xbmc created a database called videos68.  And everything seemed to be working, then when I copied the same advancedsettings over to my raspberry pi installation im stuck with the same error, and it creates another database.

 

This is the error: ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'MyVideos68')

 

You're not supposed to use the <name> tag in eden or later. Because eden has the ability to create its own databases. So you don't have to create it, and you are not supposed to specify a name manually in advanced settings. It somehow prevents xbmc from connecting to the correct database if you have the <name> tag.

 

You should follow the xbmc wiki rather than other guides that are outdated

 

This specific issue caused a lot of confusion because people would just follow lifehacker articles or similar that were written for dharma when you had to create a database and specify the name.

 

EDIT: I also saw that you're using the same advanced settings on multiple devices. Just so you know, each version of xbmc now uses a different database, with the number at the end going up with each revision. This is to prevent problems arising due to database structure changes not being compatible with older versions. So with mysql, you're *supposed* to use the same version on all devices. I guess you can get away with using different databases, but then they are not going to be in sync (watched tags and whatnot)

[Influencer]

I read the same thread, I guess its up to us to test if disks will remain spun up. I just hope my little E350 build will handle it without issues.

 

After getting all the settings how I like them, ill be setting up the MySQL libraries as well, so there, atleast I tied it back to the original thread.

[hooger]

Is this what you did?

 

http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

 

Ignore the mentions of OpenELEC, it's still relevant to any version of XBMC (except the location of advancedsettings.xml)

 

I followed that and http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/ and it still doesn't work.  I've tried the GRANT ALL ON *.* to 'xbmc'; and it still doesn't work.  I even tried changed the user and pass to my root account in the advancedsettings and it still doesn't work.

 

Interesting though, I used the <name> tag and named it videos, and xbmc created a database called videos68.  And everything seemed to be working, then when I copied the same advancedsettings over to my raspberry pi installation im stuck with the same error, and it creates another database.

 

This is the error: ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'MyVideos68')

 

You're not supposed to use the <name> tag in eden or later. Because eden has the ability to create its own databases. So you don't have to create it, and you are not supposed to specify a name manually in advanced settings. It somehow prevents xbmc from connecting to the correct database if you have the <name> tag.

 

You should follow the xbmc wiki rather than other guides that are outdated

 

This specific issue caused a lot of confusion because people would just follow lifehacker articles or similar that were written for dharma when you had to create a database and specify the name.

 

EDIT: I also saw that you're using the same advanced settings on multiple devices. Just so you know, each version of xbmc now uses a different database, with the number at the end going up with each revision. This is to prevent problems arising due to database structure changes not being compatible with older versions. So with mysql, you're *supposed* to use the same version on all devices. I guess you can get away with using different databases, but then they are not going to be in sync (watched tags and whatnot)

 

The raspberry pi uses the latest nightly that i was using to try and set up my database.  I would love to go to eden as thats what my main htpc is using, but for the pi there is not choice, as it only runs a modified version of the nightly.

[BetaQuasi]

Then, as I hinted at near the start of this thread, that's your problem right there - you will never get it working while you have one box on Eden and another on the nightly as:

 

1) The database names will be different (MyVideos60 vs MyVideos68)

2) Even if you could get Eden to map to a Frodo nightly DB, the database structure will be COMPLETELY different.  There are HUGE changes going on in terms of the DB layout etc - , it wouldn't be able to reference correct tables etc etc

 

If you really wanted to, you could take your HTPC up to the latest nightly.. but I'd suggest that if you don't have the knowledge to solve this particular issue, then steer clear of that.  That's not being nasty, I'm actually trying to save you a world of pain

[Influencer]

Obviously not a long time xbmc user but I agree with beta. It's not being nasty or talking down at all. With any program, when its undergoing these types of changes if you don't feel comfortable troubleshooting problems and confident you can find the root cause, running nightlies can cause HUGE headaches. They will work fine...then may not work at all and the only apparent solution is a fresh install. I've gotten in on the ground floor of a few start up apps, and the troubleshooting can become pretty frustrating. Id take the trade off of an unsynced database over a potentially unusable system, atleast until the major kinks are ironed out.

[hooger]

Then, as I hinted at near the start of this thread, that's your problem right there - you will never get it working while you have one box on Eden and another on the nightly as:

 

1) The database names will be different (MyVideos60 vs MyVideos68)

2) Even if you could get Eden to map to a Frodo nightly DB, the database structure will be COMPLETELY different.  There are HUGE changes going on in terms of the DB layout etc - , it wouldn't be able to reference correct tables etc etc

 

If you really wanted to, you could take your HTPC up to the latest nightly.. but I'd suggest that if you don't have the knowledge to solve this particular issue, then steer clear of that.  That's not being nasty, I'm actually trying to save you a world of pain

 

I have another computer running the same nightly as the pi, and i used that one to set up the database, and thats the one where the problems showed up.  I've never tried it with my eden htpc

[spylex]

Obviously not a long time xbmc user but I agree with beta. It's not being nasty or talking down at all. With any program, when its undergoing these types of changes if you don't feel comfortable troubleshooting problems and confident you can find the root cause, running nightlies can cause HUGE headaches. They will work fine...then may not work at all and the only apparent solution is a fresh install. I've gotten in on the ground floor of a few start up apps, and the troubleshooting can become pretty frustrating. Id take the trade off of an unsynced database over a potentially unusable system, atleast until the major kinks are ironed out.

 

I must agree with this view, I am switching back to Eden after using Frodo for almost 2 months now. The new database is a positive move, but still far from mature.