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

- charrua - 2010-03-27 04:32

bradvido88 Wrote:I'm finally trying the symlinks for shared thumbnail folders... however one of my xbmc machines is windows XP...

Anyone know if it's possible to create a symlink/juntion to a network share in windows XP?

http://technet.microsoft.com/en-us/sysinternals/bb896768.aspx
or
http://www.rekenwonder.com/linkmagic.htm

- bradvido88 - 2010-03-27 04:39

charrua Wrote:http://technet.microsoft.com/en-us/sysinternals/bb896768.aspx
or
http://www.rekenwonder.com/linkmagic.htm

Tried them both. They work for local targets but fail for network share targets. Mapping a drive didn't help either

- pkellum - 2010-03-27 05:17

charrua Wrote:(you don't need to create the database, XBMC will create it for you the first time you run it after modifying the advancedsettings.xml).
I'm using the nightly build 28256.

I seem to be missing something here. XBMC never creates the databases for me, instead I get a ton of the following errors.

Code:
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database:xbmc_video (0)
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)

And, if I create the databases myself it seems to miss creating some of the tables and it never saves the content type when I create or edit the sources.

Any idea what's going wrong?

- charrua - 2010-03-27 05:33

bradvido88 Wrote:Tried them both. They work for local targets but fail for network share targets. Mapping a drive didn't help either

Try this one: http://www.pearlmagik.com/winbolic/

- charrua - 2010-03-27 05:35

pkellum Wrote:I'm using the nightly build 28256.

I seem to be missing something here. XBMC never creates the databases for me, instead I get a ton of the following errors.

Code:
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database:xbmc_video (0)
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
And, if I create the databases myself it seems to miss creating some of the tables and it never saves the content type when I create or edit the sources.

Any idea what's going wrong?

Can you paste a bigger piece of the log enabling debug mode in XBMC first?

- pkellum - 2010-03-27 06:00

charrua Wrote:Can you paste a bigger piece of the log enabling debug mode in XBMC first?
Here you go,

http://pastebin.com/66PWESR3

- MrDVD - 2010-03-27 11:37

pkellum Wrote:I'm using the nightly build 28256.

I seem to be missing something here. XBMC never creates the databases for me, instead I get a ton of the following errors.

Code:
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database:xbmc_video (0)
20:09:14 T:4872 M:1919246336   ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)

And, if I create the databases myself it seems to miss creating some of the tables and it never saves the content type when I create or edit the sources.

Any idea what's going wrong?

Hallo, is your database on localhost as you try to connect to localhost.

Can you tell use a bit more about your install ? (where is what installed ?)

- charrua - 2010-03-27 13:36

pkellum Wrote:Here you go,

http://pastebin.com/66PWESR3
Watching at your log it seems that XBMC is having problems connecting to the MySQL server.

Basic things that you can check first:
1- As asked by MrDVD, Is MySQL server installed in the same PC as XBMC, if not you should change localhost in <host></host> and write the network address of the MySQL server instead.
2- The port of the MySQL server is 3306 (as configured by default)? If not change that in <port></port>
3- Did you create the user xbmc in the MySQL server? Did you give that user enough permissions to create databases and tables? Did you set the pass for xbmc user also as xbmc?

- MrDVD - 2010-03-27 14:10

There is even more to know.
On which OS mysql is running ?
As i had to add under ubuntu for my mysql server inside my.cnf
Code:
bind-address        = IPfromtheServer
by default it was also localhost and this mean that you can only connect via localhost to mysql.

- pkellum - 2010-03-27 19:22

charrua Wrote:Watching at your log it seems that XBMC is having problems connecting to the MySQL server.

Basic things that you can check first:
1- As asked by MrDVD, Is MySQL server installed in the same PC as XBMC, if not you should change localhost in <host></host> and write the network address of the MySQL server instead.
2- The port of the MySQL server is 3306 (as configured by default)? If not change that in <port></port>
3- Did you create the user xbmc in the MySQL server? Did you give that user enough permissions to create databases and tables? Did you set the pass for xbmc user also as xbmc?
1) It's installed on the same PC.
2) Port is 3306
3) I created a user named xbmc with a password of xbmc that has full permissions.

I'm running it on a Windows XP Pro box.

The strange thing is that XBMC is connecting to the database. If I create the databases for it then it will create some of the tables. But, it misses some like the tvshows table.

I can access the database just fine from the shell and from PHP.