manka Wrote:
22:25:25 T:5424 M:211607552 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.1.65' (10061))
Access to the database appears to be a major issue here, but i'm not sure where I am going wrong and how to correct it.
Any help would be gratefully received
Manka

Bommy Wrote:Aha! Googling that error message I quote has taken me to...

http://trac.xbmc.org/ticket/9022
http://forum.xbmc.org/showpost.php?p=593315&postcount=438

Now I've added the sources as network paths and things seem to be importing again, although I think I'm about to get saddled with a load of duplicate entries into my database!

Thanks charrua for your work getting this solution worked out, and if you got my PM, sorry I disturbed you!

dora Wrote:Maybe I wasn't clear enough. I also waited for a built in method to make many clients access one database.
Actually, I didn't wait for this feature to become available and I tried to achieve it using symbolic links.
Here are the details:
When using sqlite3 method (currently the default method), the db files are stored in userdata\Database folder (MyMusic7.db and MyVideos34.db).
If you want two xbmc clients to share the same db, all you need to do is make these two files point to the same files on the disk. You can achieve that by using symbolic links. It works even accross the network.
Once you do that, the two xbmc clients share the same db. When one of them updates the db, the other can see the change.
You can also share the whole userdata folder (like I did before the MySQL method became available). By doing that, you share also all your settings, not only the db.
Now, when the MySQL method became available, I decided to give it a chance but it looks like it has some problems, like the thumbnails cache and user profiles.
My question is what are the advantages of the MySQL method over sharing sqlite db files using symbolic links.
I still didn't get an answer for this question.

charrua Wrote:In one word: concurrency
If you need to access the same db from several clients at the same time, MySQL is much better than SQLite. If you will access the db only from one client at a time, then I'm not really shure that the MySQL implementation is a big improvement over SQLite.

dora Wrote: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.

dora Wrote:Thanks for your reply. That's what I thought.
I guess the problem is only with updating the db and not with reading it.
Since I'm making the administrative tasks only from one client (and I'm the only one who does it), I don't expect to encounter any problems.

dora Wrote:As I wrote, in one of my other posts, using symbolic links to share sqlite db looks like a hack so I'm looking forward for the MySQL method to become stable enough.
I've read that the MySQL implementation is redesigned and rewritten again. Do you have an estimated date when it will be available?

Bommy Wrote:Aha! Googling that error message I quote has taken me to...

http://trac.xbmc.org/ticket/9022
http://forum.xbmc.org/showpost.php?p=593315&postcount=438

Now I've added the sources as network paths and things seem to be importing again, although I think I'm about to get saddled with a load of duplicate entries into my database!

Thanks charrua for your work getting this solution worked out, and if you got my PM, sorry I disturbed you!

charrua Wrote:Open port 3306 in Win7 firewall.

manka Wrote:PC in lounge and bedroom on windows 2007 both with dharma 1 installed. Firewall port open for 3306.Manka

• Installed mysql server 5.1
  
• created database for music & video
  
• created user and Granted All on *.*
  
• setup advancedsettings.xml file with proper fields populated
  
• restarted xbmc and imported old video library
  
• setup advancedsettings.xml on other xbmc installs
  

meyersmp Wrote:Running latest stable xbmc & windows 7 all around

SDelcroix Wrote:Sorry for this question..

I've install Dhrama beta 2 under Seven x64... but where is the advancedsettings.xml file ?

:-(

Bommy Wrote:I'm a bit confused about how best to use WakeonLan with this.

I have two pcs - HTPC (which hosts the database and all content) and TVPC (which accesses the database but stores no content). I want to set both to hibernate after 30 minutes of no activity, and to always have XBMC running.

Would be really nice to get the TVPC to send a WOL magic packet to the HTPC whenever it wakes up. Is there a neat way to do this, or should I just resign myself to waking the HTPC via my iPhone WOL app every time? I've seen another post where someone edits to home screen to send WOL packets but they say they have to re-update it every time they change skin, etc. Because if TVPC is running and HTPC is not, the menu basically hangs for a few minutes, which isn't very user-friendly.

I suppose what would be really nice would be if XBMC could, if the dB and/or shares were missing, send a magic packet then wait a specified time before trying to re-access them.