+- 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)
Slow access to database - FIXED - jodeman - 2010-10-15
jodeman Wrote:Can you think of any other reasons why it may be slow? Anything else I can test to try to pin down why it'd be so slow?
Not sure if this will work for anyone else, but it worked for me. I had painfully slow access to the video database from any machine not housing the database. After this fix, it's as quick as the machine the database is on.
On the computer that has the database, I added this line to the my.cnf file in the [mysqld] section:
skip-name-resolve
Now, all is well.
- craigd - 2010-10-16
Here's a potential solution to those getting the 1062 or old version errors with mysql db....
I upgraded my server to win7 and started getting these after setting up for mysql.
I installed my sql and created user normally and it created the db's ok but would not let me add any videos.
In workbench I found that although the user had full access to the server it hadn't been created with any access to the schemas so had to update schema privellages as well which resolved it.
- avus m3 - 2010-10-16
craigd Wrote:Here's a potential solution to those getting the 1062 or old version errors with mysql db....
I upgraded my server to win7 and started getting these after setting up for mysql.
I installed my sql and created user normally and it created the db's ok but would not let me add any videos.
In workbench I found that although the user had full access to the server it hadn't been created with any access to the schemas so had to update schema privellages as well which resolved it.
Pretty sure this was already covered in making the xbmc user basically a super user.
Error 1062s when importing - dc_williamson - 2010-10-20
Perhaps you have drive letters vs. path issues?
Check out http://contentwhores.com/media-centers/configuring-xbmc-to-use-a-mysql-library/, step 5.
- opensauce - 2010-10-21
or try path substitution?
http://wiki.xbmc.org/index.php?title=Advancedsettings.xml#.3Cpathsubstitution.3E
- opensauce - 2010-10-21
Not sure why everyone recommends "Grant all on *.* to 'xbmc'" that gives the xbmc user access to all databases in mysql not just the ones you setup. I used "GRANT ALL on xbmc_video.* TO 'xbmc'" and "GRANT ALL on xbmc_music.* TO 'xbmc'" with no problems.
Though I doubt many people are using their mysql server for anything other than xbmc in this instance.
- ringgh0st - 2010-10-22
i have an idea for the missing thumbs on client pcs.
i use xbmc on three different system with a central mysql database.
the usual problem is that on some pc's the thumbs are not shown because the library was not scraped on these systems (client pc's).
my idea of a workaround is that xbmc itself saves the fanart/posters/covers etc. directly in the folder of the movie or tv-series.
when i access the movie from a client pc, the pictures would be loaded from the moviefolder.
is this possible?
- myrison - 2010-10-23
@ringghost - While XBMC doesn't store files like that, you can already use something like Ember Media Manager to organize files hat way. Thumbs are still stored in the xbmc userdata folder only, but everything else lives with the content. This has a number of advantages, but key among them is for use in a setup like this.
- Doomstone - 2010-10-23
Doomstone Wrote:I am having some problems using a mysql server as my db.
I have just moved from linux to windows, where i used to use mysql as the db, because i have a slave mce.
It can connect to the database, create the tables and right date just fine, but i will just not read from the database. So it can of all of it harts content scan music into the database, but my libary will never be enabled as it thinks there are no songs. This gows the same for movies, i just can't get past set content there.
I'm running
Windows Server 2008 with MySQL 5.1.36
I have tryed both Dharma Beta 2 and Dharma Beta 3. same problem with both.
The xbmc log dose not give any error
xbmc log: http://pastebin.com/LzejFDxk
Another log, where i am able to scan music into the lib and load them again, but the videos are still not working.
http://pastebin.com/3CjtbhcM
I have identified the problem to that is uses "like" in paths where it should use "=", i have posted a long post about this and will there for not repeat it in here. but you can see it here. http://forum.xbmc.org/showthread.php?p=630607#post630607
- ringgh0st - 2010-10-23
myrison Wrote:@ringghost - While XBMC doesn't store files like that, you can already use something like Ember Media Manager to organize files hat way. Thumbs are still stored in the xbmc userdata folder only, but everything else lives with the content. This has a number of advantages, but key among them is for use in a setup like this.
did it! thanx man. ember media manager is definitly one of the best tools for managing. tried some others but this definitly rocks (and has language support)
- RockDawg - 2010-10-24
I'm not sure if this is a mysql db problem per se, but I'm having a problem where deleted TV shows keep re-appearing. I can go into XBMC and delete the series, but the next time I update the library, it will come back. It shows no episodes, but the main show persists. The show does not exist in the folder I have XBMC scanning.
Anyone have any ideas?
- BDPNA - 2010-10-28
Has anyone come up with a solution for extrathumbs yet using SQL? I finally got fanart and thumbnails pulling in automatically using a symbolic link to the Thumbnails folder on my server install on my 2 remote installs. But extrathumbs (which are stored locally in each movie folder) won't pull. I assume this is due to the implementation of extrathumbs (the fact they are not part of the scraping process) and a limitation there's no way around on remote machines in Dharma?
- timdog82001 - 2010-10-28
I just got a Synology DS410j NAS server with mysql built in and I installed phpMyAdmin. I can acces phpmyadmin fine through my browser to adjust settings and so forth, but I canNOT get anything to connect to it through anything - xbmc, mysql client programs, heidisql, etc....Does anybody have any tips or know of a good walkthrough possibly that might aid me here? I've read through lots of the wiki but nothing seems to be helping. Firewall disabled, port 3306 forwarded. Not sure what the problem is!
- avus m3 - 2010-10-28
BDPNA Wrote:Has anyone come up with a solution for extrathumbs yet using SQL? I finally got fanart and thumbnails pulling in automatically using a symbolic link to the Thumbnails folder on my server install on my 2 remote installs. But extrathumbs (which are stored locally in each movie folder) won't pull. I assume this is due to the implementation of extrathumbs (the fact they are not part of the scraping process) and a limitation there's no way around on remote machines in Dharma?
Mine work fine. Does your skin support extra thumbs
- BDPNA - 2010-10-28
Definitely. I've tried a few different versions of Aeon which all support it. Avus, how do you store your extrathumbs? I store mine locally in an "extrathumbs" folder within each movie folder. Maybe you are storing yours differently but I didn't know there was another way. They load fine when using XBMC on the host machine where they actually are stored, but they do not load on any of the remote machines. What skin are you using, Avus?
Fanart and Thumbnail work fine.