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)

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

- charrua - 2010-04-22

There are two different kinds of SQL related errors in your log:

1064: In your case this is due to a bug already reported but not solved yet.
(and already commented earlier in this thread, read back for more info)

1050: This error is XBMC trying to create some tables that are already present in the MySQL database. Try droping the XBMC_Video database in your MySQL server and the run XBMC again to see what happens.

- lestat1977uk - 2010-04-22

i dropped the database but still get the error, i even tried created a new one with a different name, still same error

- charrua - 2010-04-22

lestat1977uk Wrote:i dropped the database but still get the error, i even tried created a new one with a different name, still same error
Did you set the db collation to latin1 instead of utf8?
(as suggested in some of my previous posts)

- lestat1977uk - 2010-04-22

can you explain a little more im kind of new to mysql

- charrua - 2010-04-22

lestat1977uk Wrote:can you explain a little more im kind of new to mysql
Yes, drop the XBMC_Video database, then create a new one manually executing the following sql statement:

Code:
CREATE DATABASE XBMC_Video CHARACTER SET latin1 COLLATE latin1_general_ci;
Then run XBMC.

- lestat1977uk - 2010-04-22

still having problems


01:01:14 T:2240 M:507654144 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
01:01:14 T:2240 M:507654144 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>server2008</host>
<port>3306</port>
<user>root</user>
<pass>xbmc</pass>
<name>xbmc_movies</name>
</videodatabase>
</advancedsettings>
01:01:14 T:2240 M:507650048 WARNING: VIDEO database configuration is experimental.
01:01:14 T:2240 M:507650048 NOTICE: Getting hardware information now...
01:01:14 T:2240 M:507650048 NOTICE: Checking resolution 12
01:01:14 T:2240 M:507650048 NOTICE: Default DVD Player: dvdplayer
01:01:14 T:2240 M:507650048 NOTICE: Default Video Player: dvdplayer
01:01:14 T:2240 M:507650048 NOTICE: Default Audio Player: paplayer
01:01:14 T:2240 M:507650048 NOTICE: Loading media sources from special://masterprofile/profiles/SQL/sources.xml
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture MenuItemNF.png
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture unknown-user.png
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496484352 NOTICE: ES: Starting event server
01:01:41 T:5068 M:496259072 NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
01:01:41 T:5068 M:496246784 NOTICE: UDP: Listening on port 9777
01:02:27 T:2240 M:520585216 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:28 T:2240 M:520556544 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:28 T:2240 M:520556544 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'H:\'
01:02:28 T:2240 M:520548352 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:40 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:40 T:2240 M:521121792 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:40 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'H:\Hellboy II - The Golden Army (2008)\','','')
01:02:40 T:2240 M:521121792 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'H:\Hellboy II - The Golden Army (2008)\','',''))
01:02:41 T:3888 M:521334784 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:41 T:3888 M:521330688 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:41 T:3888 M:521322496 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'H:\'
01:02:41 T:3888 M:521322496 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:41 T:3888 M:521322496 NOTICE: My Videos: Scanning for video info using worker thread, operation took 00:00
01:02:44 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:44 T:2240 M:521121792 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:44 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'H:\'
01:02:44 T:2240 M:521121792 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:49 T:2240 M:523759616 NOTICE: Storing total System Uptime
01:02:49 T:2240 M:523759616 NOTICE: Saving settings
01:02:49 T:2240 M:523706368 NOTICE: stop all
01:02:49 T:2240 M:523706368 NOTICE: ES: Stopping event server
01:02:49 T:5068 M:523747328 NOTICE: ES: UDP Event server stopped
01:02:49 T:2240 M:523812864 NOTICE: stop sap announcement listener
01:02:49 T:2240 M:523812864 NOTICE: clean cached files!
01:02:49 T:2240 M:523800576 NOTICE: unload skin
01:02:49 T:2240 M:526086144 NOTICE: stop python
01:02:49 T:2240 M:526086144 NOTICE: stopped
01:02:49 T:2240 M:526086144 NOTICE: destroy
01:02:50 T:2240 M:526045184 NOTICE: unload sections

- charrua - 2010-04-22

lestat1977uk Wrote:still having problems
As I told you before, you had two kind of errors in the first log you posted:

errors 1050: SOLVED by changing db collation from utf8 to latin1 (check that you don't have (1050) errors anymore in your log)

errors 1064: due to a bug related to storage of local paths that I already reported some time ago and it is still unsolved. For more info about the bug and my proposed temporary solution check here: http://trac.xbmc.org/ticket/9022

- lestat1977uk - 2010-04-22

ah ok.

Well thanks for the help, i hope the bug gets sorted cause until then it seems i won't be bale to set this up.

- charrua - 2010-04-22

lestat1977uk Wrote:ah ok.
Well thanks for the help, i hope the bug gets sorted cause until then it seems i won't be bale to set this up.
You're welcome. While the bug is not solved yet, you can try to solve the problem as I suggested in the last comment of the bug report:
Quote:...for anyone dealing with this bug right now, the solution that I see to add local paths without errors (under windows environments) is to share the path in the network first, and then choose it as a source in XBMC using its networked path instead of the local one. It's not a sophisticated solution but it should work fine. That being said, I really look forward to the upcoming db redesign.
Let me know if that helped.

- WisdomWolf - 2010-04-22

I am going to look into this when I get home. Previously I had been using Sugarsync to sync the Database folder as well as the Thumnail folder. I would assume (if the thumbnail/coverart issue still exists) that the MySQL route + Sugarsync for the Thumbnail directory would work a bit more elegantly than my current solution. Am I correct?

- charrua - 2010-04-22

WisdomWolf Wrote:I am going to look into this when I get home. Previously I had been using Sugarsync to sync the Database folder as well as the Thumnail folder. I would assume (if the thumbnail/coverart issue still exists) that the MySQL route + Sugarsync for the Thumbnail directory would work a bit more elegantly than my current solution. Am I correct?
Yes, I believe you are correct.
Also be aware that there is another temporary solution for the thumbnail cache, originally suggested by MrDVD: symlinking a network shared folder as a common central cache, that way you don't even have to use Sugarsync for syncing thumbnails. The only cons I've found so far with that approach is that XBMC GUI speed suffers a little (at least in my tests) compared to XBMC using a local image cache, and the other issue is that if you loose connection to the network shared cache folder XBMC won't be able to show any poster, fanart, etc. Other than that is a very good temporary solution.

- RockDawg - 2010-04-22

I'm trying to implement this and I'm a little stumped. I keep getting the following error in my log:

Code:
22:56:35 T:3077834640 M:1480773632   DEBUG: CDatabase: Connecting to database xbmc_video at 192.168.1.8:3306
22:59:44 T:3077834640 M:1479913472   ERROR: Unable to open database:xbmc_video [2003](Can't connect to MySQL server on '192.168.1.8' (110))
22:59:44 T:3077834640 M:1479913472   ERROR: Unable to open database at host: 192.168.1.8 db: xbmc_video (old version?)

I downloaded and installed MySQL. I set my advancedsettings.xml to the following:

Code:
<advancedsettings>
<videolibrary>
  <cleanonupdate>true</cleanonupdate>
</videolibrary>
<videodatabase>
  <type>mysql</type>
  <host>192.168.1.8</host>
  <port>3306</port>
  <user>kevin</user>
  <pass>tesla2232</pass>
  <name>xbmc_video</name>
</videodatabase>
</advancedsettings>

In MySQL I created the user 'kevin' with a password of 'tesla2232' and set permissions to full as demonstrated by:

Code:
mysql> SHOW GRANTS FOR kevin;
+-------------------------------------------------------------------------------
-----------------------+
| Grants for kevin@%
                       |
+-------------------------------------------------------------------------------
-----------------------+
| GRANT USAGE ON *.* TO 'kevin'@'%' IDENTIFIED BY PASSWORD '*FFCE64C407E518588E1
CF6800AD85B5617ACBD77' |
| GRANT ALL PRIVILEGES ON `xbmc_video`.* TO 'kevin'@'%'
                       |
+-------------------------------------------------------------------------------
-----------------------+
2 rows in set (0.00 sec)

My server is running on a Win7 machine and my 2 XBMC boxes are different machines running XBMC Live r28256. Should MySQL server show an icon in the system tray when it's running?

- charrua - 2010-04-22

RockDawg Wrote:My server is running on a Win7 machine and my 2 XBMC boxes are different machines running XBMC Live r28256. Should MySQL server show an icon in the system tray when it's running?
No, it doesn't show an icon in the system tray when it's running. You can only see the MySQL service running on the Services window of the win7 Administrative Tools.

Did you open port 3306 in the windows firewall?

- RockDawg - 2010-04-22

I can't believe I overlooked that. Thanks so much!

- RockDawg - 2010-04-22

charrua Wrote:First I copied the thumbnails folder inside userdata to the server, then I shared that path from the server, renamed the thumbnails folder inside userdata folder in the client machine to thumbnails.old (to avoid its deletion) and finally made a NTFS directory symbolic link pointing to the shared folder in my server with the command:
Code:
[b]mklink /D[/b] thumbnails [i]//SERVER_ADDRESS/shared_thumbnails_folder[/i]
If you try it, please let me know if in your case it is also noticeable slower than the local cache. Anyway is not a bad option until the new cache system is in place.

I'm a little confused on this part. From what I read mklink is a Windows command. In my situation the server is Win but the clients are Linux. What would be the proper command?