2 XBMC PCs and 1 Database on the shared NAS

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

- sloth - 2010-10-01 18:14

sloth Wrote:Hello,
I just tried to set up the mysql central database. I tested the the mysql-database with a php script and it exists, and is accessable with the username and password I set. However, when I start XBMC it cannot connect to it ("unable to open database xbmc_video"). This is my advancedsettings.xml file:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.8</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
</advancedsettings>
The database was created as suggested (CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci.
Any ideas, what I am doing wrongly?

Best wishes,
Jonas

Anyone? Any suggestions as to how I can troubleshoot this? I can connect to the xbmc_video database (which is empty) as reported by a script to test mysql connection. The script is located on the fileserver so I am not testing whether mysql can be accessed from another machine. I don't know how I can execute this script on my laptop (no apache, php installed).

- sladinki007 - 2010-10-01 19:59

sloth Wrote:Anyone? Any suggestions as to how I can troubleshoot this? I can connect to the xbmc_video database (which is empty) as reported by a script to test mysql connection. The script is located on the fileserver so I am not testing whether mysql can be accessed from another machine. I don't know how I can execute this script on my laptop (no apache, php installed).

try to install mysqlworkbench or heidisql on your laptop and see if you can connect from that...
it is probably that mysql is set to not accept any connections other then localhost

- flamez - 2010-10-01 22:01

flamez Wrote:I have xbmc storing my video database in mysql fine now! YEAH! but i would like to get my thumbnails stored there as well.

i am running xbmc dharma beta 2 live installed on HD on my Revo and i have my unRaid server storing my mysql video database on.

I have tried many ways to get this working and no luck so far!

I understand that i need to store them in a folder on my nas and not in mysql.

Any ideas to help me get this working?

Thanks for any help!

Flamez

alex84 Wrote:Check this out, question has been solved before mate...
http://forum.xbmc.org/showpost.php?p=605915&postcount=2

Cheers

Thanks Alex ... That post above helped me get it going.

- sloth - 2010-10-02 01:33

Ok, I installed a mysql client on my laptop and cannot connect to the mysql database on my server. It does work via SSH. I also realised that I have iptables running on that server. "iptables -L results in the following:
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

this sounds as if the firewall isn't blocking anything but please correct me if I am wrong. What now? I am really stuck here.

- myrison - 2010-10-02 03:39

flamez Wrote:Ok i got it working! Thanks

Just a friendly tip, it's probably helpful for others reading this if you post what your solution was. Smile

- flamez - 2010-10-02 04:07

myrison Wrote:Just a friendly tip, it's probably helpful for others reading this if you post what your solution was.

alex84 Wrote:Check this out, question has been solved before mate...
http://forum.xbmc.org/showpost.php?p=605915&postcount=2

Cheers

Thanks Alex ... That post above helped me get it going.

- sladinki007 - 2010-10-02 10:07

sloth Wrote:Ok, I installed a mysql client on my laptop and cannot connect to the mysql database on my server. It does work via SSH. I also realised that I have iptables running on that server. "iptables -L results in the following:
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

this sounds as if the firewall isn't blocking anything but please correct me if I am wrong. What now? I am really stuck here.

have a look at this thread ....
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

- sloth - 2010-10-02 17:45

Thanks, that did the trick. Also had to resolve a samba problem but now it is working.

MySQL Issues - nemke - 2010-10-02 21:02

Hi guys,

I've been using the MySQL option for a few months now but a few days ago I noticed that my new items are not getting populated in the movie table properly. Information is missing such as the movie title, description, etc. I am running the latest Dharma 2 Beta but I was running Dharma 1 when I first noticed this error.

I tried dropping the database completely, and XBMC recreated it and started populating, but this didn't help. I've restored my old database now.

Here is the pastebin:
http://pastebin.com/mb9EtCmJ

Thanks,
Nat

- sloth - 2010-10-03 00:34

I just realized that only the computer that imported the database after setting up the mysql databases has covers and movie information. The other two computers do show all the media in library mode but without any info. Any idea how that can be resolved?