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

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)



- charrua - 2010-09-02

ijhammo Wrote:Hi, the issue is not all equipment needs the same offset. The player in my lounge needs a different offset from my cinema room (different amps)
In that case, shouldn't you adjust the volume on the amps so you can use the same offsets in XBMC?


Cornfused - robkeogh - 2010-09-02

I have no idea why im struggling with this.... have read through all 46 pages of this and others and for some reason I cant get XBMC to populate to a database.

Im on latest version of XBMC & am using mysql 64bit.
Windows 7 ultimate 64

Possible fixes and configs I have tried already are as follows.

Have disabled firewall completely so no issue there.
Have created a user xbmc with all permissions -p xbmc
Have granted root all permissions -p xbmc
Have checked mysql my.ini and its set to latin1 (or whatever the fix was?)

I am using the following xml

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>localhost</host> - have tried both ip of server and localhost
<port>3306</port>
<user>xbmc</user> - have tried both root and xbmc
<pass>xbmc</pass>
<name>xbmc_video</name> - have tried using a different name
</videodatabase>
</advancedsettings>

I also dont get any errors from xbmc on my log

16:01:14 T:1368 M:4294967295 NOTICE: -----------------------------------------------------------------------
16:01:14 T:1368 M:4294967295 NOTICE: Starting XBMC, Platform: Windows build 7600. Built on Dec 23 2009 (SVN:26017, compiler 1500)
16:01:14 T:1368 M:4294967295 NOTICE: Intel® Core™2 Duo CPU E6850 @ 3.00GHz
16:01:14 T:1368 M:4294967295 NOTICE: Desktop Resolution: 1176x664 32Bit at 60Hz
16:01:14 T:1368 M:4294967295 NOTICE: Running with administrator rights
16:01:14 T:1368 M:4294967295 NOTICE: special://xbmc/ is mapped to: C:\Program Files (x86)\XBMC
16:01:14 T:1368 M:4294967295 NOTICE: special://masterprofile/ is mapped to: C:\Users\robkeogh\AppData\Roaming\XBMC\userdata
16:01:14 T:1368 M:4294967295 NOTICE: special://home/ is mapped to: C:\Users\robkeogh\AppData\Roaming\XBMC
16:01:14 T:1368 M:4294967295 NOTICE: special://temp/ is mapped to: C:\Users\robkeogh\AppData\Roaming\XBMC\cache
16:01:14 T:1368 M:4294967295 NOTICE: The executable running is: C:\Program Files (x86)\XBMC\XBMC.exe
16:01:14 T:1368 M:4294967295 NOTICE: Log File is located: C:\Users\robkeogh\AppData\Roaming\XBMC\xbmc.log
16:01:14 T:1368 M:4294967295 NOTICE: -----------------------------------------------------------------------
....blah blah blah about screen resolution
load settings...
16:01:14 T:1368 M:4294967295 NOTICE: special://profile/ is mapped to: special://masterprofile/
16:01:14 T:1368 M:4294967295 NOTICE: loading special://masterprofile/guisettings.xml
16:01:14 T:1368 M:4294967295 NOTICE: Getting hardware information now...
16:01:14 T:1368 M:4294967295 NOTICE: Checking resolution 12
16:01:14 T:1368 M:4294967295 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
16:01:14 T:1368 M:4294967295 NOTICE: Loaded playercorefactory configuration
16:01:14 T:1368 M:4294967295 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
16:01:14 T:1368 M:4294967295 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
16:01:14 T:1368 M:4294967295 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
16:01:14 T:1368 M:4294967295 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
</advancedsettings>
16:01:14 T:1368 M:4294967295 NOTICE: Getting hardware information now.

You can see the full log here if needed http://justpaste.it/xbmc

I dont know if ive missed some silly little thing somewhere but its doing my head in :confused2:

If you can suggest or lend a hand I would be sooo greatful

Cheers in advance
Rob


- albaranov - 2010-09-02

RockDawg Wrote:I tried that and get the exact same thing. I've tried this on two different XBMC boxes and I've tried hosting the Thumbs on both a Linux server and a Windows machine. All act identically. Here is a section of an XBMC log where I tried to "Get Thumb" from inside 'Movie Info' with no luck:

Code:
15:25:11 T:61414256 M:1419407360   DEBUG: thread start, auto delete: 0
15:25:11 T:3078985616 M:1419407360   DEBUG: Alloc resources: 0.13ms (0.01 ms skin load)
15:25:11 T:61414256 M:1419407360   DEBUG: Thread 61414256 terminating
15:25:13 T:3078985616 M:1416462336   DEBUG: LIRC: Update - NEW at 71062135:000000037ff07bdd 00 OK mceusb (OK)
15:25:13 T:3078985616 M:1416462336   DEBUG: OnKey: 11 pressed, action is Select
15:25:13 T:3078985616 M:1416462336   DEBUG: ------ Window Deinit (FileBrowser.xml) ------
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating /home/kevin/.xbmc/userdata/Thumbnails/Video/
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/
15:25:13 T:3078985616 M:1419382784 WARNING: CreateDirectory, cant create dir </home/kevin/.xbmc/userdata/Thumbnails/Video/5/>. trying lower case.
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating /home/kevin/.xbmc/userdata/Thumbnails/Video/5/
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/5/
15:25:13 T:3078985616 M:1419382784   DEBUG: CDatabase: Connecting to database xbmc_video at 192.168.1.20:3306
15:25:16 T:71904112 M:1419382784   DEBUG: Thread 71904112 terminating (autodelete)
15:25:23 T:3078985616 M:1419399168    INFO:   msg: PICTURE::LoadImage: Unable to open image: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn Error: (2)
15:25:23 T:3078985616 M:1419399168   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn
15:25:23 T:3078985616 M:1419399168    INFO:   msg: PICTURE::LoadImage: Unable to open image: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn Error: (2)
15:25:23 T:3078985616 M:1419399168   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn
15:25:27 T:105646960 M:1419399168   DEBUG: Thread 105646960 terminating (autodelete)
15:25:53 T:3078985616 M:1419288576   DEBUG: SECTION:UnloadDelayed(DLL: special://xbmc/system/ImageLib-i486-linux.so)
15:25:53 T:3078985616 M:1419288576   DEBUG: Unloading: ImageLib-i486-linux.so

But after that I can go into that same Thumbnails folder via a FTP client and copy or create a file/folder and it works. It will appear in the Thumbnail folder on my server. It all seems to work with my manual tests. It just seems whatever XBMC does to write the thumb is the only part that's not working.

Hi, I am trying to configure XBMC to work with mySQL. I like the concept of a centralized database and think that charrua and other guys did a great job by introducing this concept.
In my case the installation went rather well (SVN:33330, compiler 1600). The problems appeared when XBMC started scanning media. I got a bunch of errors like: "Texture manager unable to load file", "CDVDDemuxFFmpeg::Open - error reading from input stream", "CDVDAudio::AddPackets - failed to add leftover bytes to render". In fact XBMC freezes and I cannot use it. My knowledge on this subject is very limited, so I searched the forum and google but could not find an answer or a suggestion on how to address these errors. Could you please give a direction? Thanks Alex


- charrua - 2010-09-02

robkeogh Wrote:I have no idea why im struggling with this.... have read through all 46 pages of this and others and for some reason I cant get XBMC to populate to a database.
-----------------------------------------------------------------------
16:01:14 T:1368 M:4294967295 NOTICE: Starting XBMC, Platform: Windows build 7600. Built on Dec 23 2009 (SVN:26017, compiler 1500)

I dont know if ive missed some silly little thing somewhere but its doing my head in
If you can suggest or lend a hand I would be sooo greatful
Cheers in advance
Rob

While reading through all those pages you may have missed the part of the 2nd post where it states:
charrua Wrote:There is a new feature already implemented in XBMC(since svn r28142) that lets you use a central MySQL database for all your clients.

You are using svn r26017...


- charrua - 2010-09-02

albaranov Wrote:Hi, I am trying to configure XBMC to work with mySQL. I like the concept of a centralized database and think that charrua and other guys did a great job by introducing this concept.
Thanks, but all the kudos goes to firnsy for introducing and developing the MySQL features for XBMC and to the rest of the developers for this great piece of software that XBMC is, I just try to share some of my limited knowledge as a XBMC user here.

albaranov Wrote:In my case the installation went rather well (SVN:33330, compiler 1600). The problems appeared when XBMC started scanning media. I got a bunch of errors like: "Texture manager unable to load file", "CDVDDemuxFFmpeg::Open - error reading from input stream", "CDVDAudio::AddPackets - failed to add leftover bytes to render". In fact XBMC freezes and I cannot use it. My knowledge on this subject is very limited, so I searched the forum and google but could not find an answer or a suggestion on how to address these errors. Could you please give a direction? Thanks Alex
Probably the errors are not related to MySQL. Did you try to install an older version of XBMC?


- robkeogh - 2010-09-02

You are using svn r26017...

OMG Howd I miss that! presumed when i downloaded off the official site i would get the latest build

Will get the more recent one now and hopefully that will be sorted.. Ta Very much


- albaranov - 2010-09-02

Charrua,
Sorry for not mentioning firnsy. Your name is everywhere in this thread so I was under impression that... whatever. Thanks for replying.
Quote: Did you try to install an older version of XBMC?

No, I have not tried as I did not assume that it could be the reason. Normally you read: install the latest version because the old bugs have been fixed. Which version do you recommend? Thanks, Alex


- charrua - 2010-09-02

albaranov Wrote:Normally you read: install the latest version because the old bugs have been fixed. Which version do you recommend? Thanks, Alex

Yes, you're right. But sometimes the latest bleeding edge svn versions introduce new bugs (consider that they are compiled on a nightly basis).
Having said that, I'm using the latest version(xbmc-r33324-Dharma_beta1.exe) found at http://mirrors.xbmc.org/nightlies/win32/
and it's working fine, but just to be shure you could try an older version to see if you still have the problem that you described (remember that you need at least r28142). Also it would be useful if you could post a debug log to see what is actually happening.[url=http://mirrors.xbmc.org/nightlies/win32/][/url]


- albaranov - 2010-09-02

Charrua,

Thanks for trying to help me. I'm using the version SVN:33330, compiler 1600. I guess it should not be a problem. I have the log file available - I do not see the attach button... Alex


- charrua - 2010-09-02

albaranov Wrote:Charrua,
Thanks for trying to help me. I'm using the version SVN:33330, compiler 1600. I guess it should not be a problem. I have the log file available - I do not see the attach button... Alex

No problem. Paste the log to http://pastebin.com/ and then post the link here.


- albaranov - 2010-09-02

Charrua,

It is here
http://pastebin.com/4paNsfms

Just in case.
Linux PC: MySQL and all media files are there.
Win7 Master PC: XBMC, all lab work is there, updates, corrections, etc.
Win7 Liv. Room PC: XBMC and connected to the home theater.

Thanks for your time again!
Alex
P.S. Will try xbmc-r33324-Dharma_beta1 tonight.


- charrua - 2010-09-02

albaranov Wrote:Charrua,
It is here
http://pastebin.com/4paNsfms
Just in case.
Linux PC: MySQL and all media files are there.
Win7 Master PC: XBMC, all lab work is there, updates, corrections, etc.
Win7 Liv. Room PC: XBMC and connected to the home theater.
Thanks for your time again!
Alex
P.S. Will try xbmc-r33324-Dharma_beta1 tonight.

You're welcome. Are you able to access the files in the Linux server from the Win7 machines from explorer? I'm not shure, but looking at your log it seems more like a file access problem than a database one.


- albaranov - 2010-09-02

charrua Wrote:You're welcome. Are you able to access the files in the Linux server from the Win7 machines from explorer? I'm not shure, but looking at your log it seems more like a file access problem than a database one.

Definitely yes. While in Win7 I have full rights to all files on the Linux machine. Have not yet tried the other Win7 machine. It was my first test with mySQL yesterday.
Is there any troubleshooting strategy that I can follow? I do not feel comfortable about bothering you and other gurus by asking all these stupid questions. Thanks, Alex
P.S. Still will appreciate every piece of a advice from you smart guys. I wish I could develop something similar.


- albaranov - 2010-09-03

Hi again,

I just installed xbmc-r33324-Dharma_beta1.exe. The log file looks awful - overcrowded with errors. Now it also says that the database is newer than expected - no access to it. I'm lost. Any help, please! Alex


- charrua - 2010-09-03

albaranov Wrote:Hi again,

I just installed xbmc-r33324-Dharma_beta1.exe. The log file looks awful - overcrowded with errors. Now it also says that the database is newer than expected - no access to it. I'm lost. Any help, please! Alex
Again, a full log file in debug mode with the new errors will be welcomed.