DSM-G600, DNS-3xx and NSA-220 Hack Forum

tommymsw · 2012-02-29 03:02:47

Reference:

Followed these directions to set up mysql:
#mysql -u root -p
>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
>GRANT ALL ON *.* TO 'xbmc';
>exit

I followed this guide for advanced.xml
http://wiki.xbmc.org/index.php?title=HO … your_files

I then deleted the database from on XBMC, added the advanced file and then had it re-make the library by adding the new sources to xbmc. (figuring a fresh library may be better than a backup and restore).

Am I correct that when I am in mysql and type "show databases;" and I do NOT see any that say "xbmc" or "videos" that the share library thing is not working?

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.13 sec)

Because I have never even been able to get the libraries to form when trying to share them on xbmc. Even when I was only doing it from my PC. I don't know what I can be messing up... it's like 3 lines of simple code!

I put the advancedsettings.xml folder in place, but I can still see the xbmc updating to the local directory! And a database never gets created on sysql!

I fear that the .xml file is being ignored? there must be more to it than this because I can never get it to do anything.

Last edited by tommymsw (2012-02-29 03:09:04)

Terrabyte · 2012-03-01 03:41:13

Where are you placing the advancedsettings.xml? What version of xbmc are you using (ie PC, Linux)

Check your log files in xbmc to see if advancedsettings.xml...

Please post your advancedsettings.xml.

tommymsw · 2012-03-01 08:41:49

I have tried with every version of xbmc although currently I am using Eden 1.0
I am running it off of the DNS-320 (following your instructions you gave me)

My file is in:
C:\Users\Z-BOX\AppData\Roaming\XBMC\userdata

<advancedsettings>

<videodatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

</advancedsettings>

This is the only reference I see in the log:
00:34:35 T:3044 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
00:34:35 T:3044 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
00:34:35 T:3044 NOTICE: No settings file to load (special://masterprofile/advancedsettings.xml)
00:34:35 T:3044 NOTICE: Default DVD Player: dvdplayer
00:34:35 T:3044 NOTICE: Default Video Player: dvdplayer
00:34:35 T:3044 NOTICE: Default Audio Player: paplayer
00:34:35 T:3044 NOTICE: Disabled debug logging due to GUI setting. Level 0.
00:34:35 T:3044 NOTICE: Log level changed to 0
00:34:35 T:3044 NOTICE: Loading media sources from special://masterprofile/sources.xml
00:34:38 T:3044 NOTICE: initializing playlistplayer
00:34:38 T:3044 NOTICE: DONE initializing playlistplayer
00:34:39 T:3336 ERROR: CRemoteControl::Connect - failed to connect
00:34:47 T:3044 NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
00:34:47 T:2572 NOTICE: -->Python Interpreter Initialized<--

Last edited by tommymsw (2012-03-01 09:33:45)

tommymsw · 2012-03-01 08:48:56

Should I put the advancedsettings.xml into the /xbmc/system/ folder?

Actually, I see this in the report too:
special://masterprofile/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\userdata

And that is the exact folder I have the .xml in.

Looks like it is just not seeing it!

Last edited by tommymsw (2012-03-01 09:33:04)

Terrabyte · 2012-03-01 17:04:43

Vista/Windows 7: Users\%userprofile%\AppData\Roaming\XBMC\userdata\

Place a copy in C:\Program Files\XBMC\System
(If it is 64bit than \Program Files x86)

See if that works...

What are your specs? (ION, Fusion, Intel)

tommymsw · 2012-03-01 19:13:35

Sorry:
02:04:44 T:2648 NOTICE: Starting XBMC (11.0-RC1 Git:20120226-30312f1), Platform: Windows 7, 32-bit Service Pack 1 build 7601. Built on Feb 26 2012 (compiler 1600)
02:04:44 T:2648 NOTICE: Intel(R) Atom(TM) CPU D525 @ 1.80GHz
02:04:44 T:2648 NOTICE: Desktop Resolution: 1280x1024 32Bit at 60Hz
02:04:44 T:2648 NOTICE: Running with restricted rights
02:04:44 T:2648 NOTICE: Aero is enabled

Terrabyte · 2012-03-01 20:04:17

***** Side Note *****
If you use this box for XBMC only you may want to look at

Openelec.tv

Pretty much XBMC as an appliance type setup. I run it off a USB stick. Boot time is about 10-15 sec to home screen of XBMC.

They have current Eden builds @

http://sources.openelec.tv/tmp/image/openelec-eden/

Last edited by Terrabyte (2012-03-01 21:46:54)

tommymsw · 2012-03-01 21:35:57

Thank you, I had openelec on it first but it had too many problems. Resolution would not work right, image was offset. I messed with it for months. It just didn't have the drivers I needed. I have openelec on another system in my home.

First thing.... when you "show databases" on your mysql... do you see databases named "Xbmc" or "Video"? I just want to make sure I can confirm this is working or not by simply looking for the databases. (As I am testing, I only have the .xml on one system... just waiting to see the database get created)

Second thing... I placed the .xml in BOTH directories, still says "none" in the log.

I copied and pasted the name for the .xml file FROM the log and I copied and pasted the path FROM the log into explorer to make sure it was where it was looking!

Either, there MUST be something I am missing, or "show databases" would not show me the database?

tommymsw · 2012-03-01 21:45:23

Could the file itself be set up wrong? Like too many spaces, or not far enough from the top? I have no idea! lol

tommymsw · 2012-03-01 21:53:53

So.... I may have solved the problem. i took the .xml off of the file.
Importing library now, I will report back.

tommymsw · 2012-03-01 22:03:05

Well a database is being crated. I can see it now. So I am going to assume that was my problem.

File this one under "Do not follow the directions exactly!" lol

tommymsw · 2012-03-01 23:11:05

ungh... backed up my library and the imported it and lost all my "TV" programs. They show up under "files" but not under the TV library.
So I deleted the mysql database went to another XBMC and backed up library and re-inported it to make a new database. Same problem. TV shows imported into "files" but will not show up under the TV library. TV library is empty.

Tried everything.
Delete and re-add source... re-scan (only into files)
edit source, edit content (re-adds only into files)

TV library doesn't work on either system.

I will suck it up and just start from scratch and delete the library and start fresh.

tommymsw · 2012-03-01 23:20:19

This mean anything to anybody?

16:14:19 T:2836 ERROR: Control 1 in window 10099 has been asked to focus, but it can't
16:14:47 T:2836 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\TV\\','','')
16:14:47 T:2836 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\TV\\','',''))

That is obviously my TV folder. But again, I can see and play the files there, they just will NOT show up under the TV Library!

Terrabyte · 2012-03-02 04:02:02

tommymsw wrote:
ungh... backed up my library and the imported it and lost all my "TV" programs. They show up under "files" but not under the TV library.
So I deleted the mysql database went to another XBMC and backed up library and re-inported it to make a new database. Same problem. TV shows imported into "files" but will not show up under the TV library. TV library is empty.

Tried everything.
Delete and re-add source... re-scan (only into files)
edit source, edit content (re-adds only into files)

TV library doesn't work on either system.

I will suck it up and just start from scratch and delete the library and start fresh.

When I did it I started from scratch and add everything as new source. I didn't have much luck with exporting and importing process.

tommymsw · 2012-03-02 05:01:40

JNo luck with starting from scratch either. Something must be left behind. I removed all sources from XBMC, although I can still see them in "files" with no way of deleting. I also dropped the database. I get same results.

Terrabyte · 2012-03-02 05:09:24

1) Delete mediasource.xml and sources.xml (This is like resetting media)
2) Check to see if the advance file is being loaded view logs
3) Check to see if the databases have been created

If the databases are created than you can add new sources.

tommymsw · 2012-03-02 06:57:27

When sharing the databases, should I not use the path to the network drive? Like "Y:/Movies" even though it will be identical on all systems? Or should O go through the sms path to the drive?

tommymsw · 2012-03-02 08:26:14

Closer, closer... I think I have them synced now. I deleted the files you mentioned. changed my path to the smb path and all went well. So I booted up another system with the .xml file on it. They seem to be synced but now I have no thumbnails on the second machine.
I have heard bad things about syncing thumbnails (like taking a long time to lead) and I am not concerned with them matching. So I figured each machine would scrape the shows separately? But when I scan the content on the second machine, it will not download the cover art. Do I have to set up sharing?

If I go to "info" on each movie I can choose "local thumb" and it is there. Not sure why it is not grabbing them automatically.

Got it... just had to remove the source on system 2 and then re-add the source... now it is scanning them all in again? Not sure why I had to do that, or if I will need to do it on each system.

Thank you Terra, you have been very kind with all your help.

Last edited by tommymsw (2012-03-02 08:47:08)

Terrabyte · 2012-03-02 14:29:38

tommymsw wrote:
Closer, closer... I think I have them synced now. I deleted the files you mentioned. changed my path to the smb path and all went well. So I booted up another system with the .xml file on it. They seem to be synced but now I have no thumbnails on the second machine.
I have heard bad things about syncing thumbnails (like taking a long time to lead) and I am not concerned with them matching. So I figured each machine would scrape the shows separately? But when I scan the content on the second machine, it will not download the cover art. Do I have to set up sharing?

If I go to "info" on each movie I can choose "local thumb" and it is there. Not sure why it is not grabbing them automatically.

Got it... just had to remove the source on system 2 and then re-add the source... now it is scanning them all in again? Not sure why I had to do that, or if I will need to do it on each system.

Thank you Terra, you have been very kind with all your help.

Good to here you got things worked out. Sickbeard normally will put meta info in the folder (cover art, nfo, tbn, etc) if you tell it to. When XBMC scans it check to see if this data is in the folder if so it uses that data and doesn't scrape the web for it. You will notice how much faster it does this for TV vs Movies.

For Movies, I use another program to add this info and XBMC does the same this. Much faster

I have a few things syncing as well. This is part of my advance file

Code:

<pathsubstitution>
  <substitute>
    <from>special://masterprofile/Thumbnails/</from>
    <to>smb://x.x.x.x/XBMC/Thumbnails/</to>
  </substitute>
  <substitute>
    <from>special://masterprofile/playlists/</from>
    <to>smb://x.x.x.x/XBMC/playlists/</to>
  </substitute>
  <substitute>
    <from>special://masterprofile/sources.xml</from>
    <to>smb:///x.x.x.x/XBMC/sources.xml/</to>
  </substitute>
  <substitute>
    <from>special://masterprofile/favourites.xml</from>
    <to>smb://x.x.x.x/XBMC/favourites.xml/</to>
  </substitute>
  <substitute>
    <from>special://masterprofile/mediasources.xml</from>
    <to>smb://x.x.x.x/XBMC/mediasources.xml/</to>
  </substitute>
</pathsubstitution>

I copied sources.xml, favourites.xml and mediasources.xml from one of the synced systems.

tommymsw · 2012-03-02 18:24:06

A couple questions if you would be so kind...

So you copied these sources from an XBMC system and placed them on the NAS (I suppose)? And then reference them through your advancedsettings on each machine? So they all use the same sources?

I get why for most of these, but what exactly does sharing "sources" and "mediasources" do? Doesn't that do the exact thing that the mysql database does already?

And I heard that sharing thumbs (if you have a large database) could take a super long time to load each time and slow your media center down. Do you find that to be true?

FYI... I don't have a madiasources file anymore. I assume the advancedsettings stops one from getting made?

Last edited by tommymsw (2012-03-02 19:08:17)

Terrabyte · 2012-03-02 20:42:34

tommymsw wrote:
So you copied these sources from an XBMC system and placed them on the NAS (I suppose)? And then reference them through your advancedsettings on each machine? So they all use the same sources?

Yes

tommymsw wrote:
I get why for most of these, but what exactly does sharing "sources" and "mediasources" do? Doesn't that do the exact thing that the mysql database does already?

You could be right but I wanted all the systems to reference the same files so they look identical to one another.

tommymsw wrote:
And I heard that sharing thumbs (if you have a large database) could take a super long time to load each time and slow your media center down. Do you find that to be true?

I can't say I have experience long load times, but in my case all meta data is placed in the folders with my media. Which makes it load much faster I believe.

tommymsw · 2012-03-02 21:02:36

Yes, I just tried sharing the Thumbs directory. Usually my system was lighting fast, now it takes about 45 seconds to open up the TV library... I think it takes that long to lead the thumbs? I have like 175 TV shows and a few thousand episodes. I will switch it back and see if I get the speed back. But keep the other stuff.

Weird, I tried the same script on the system with openelec and there is no lag when opening the library. Only on the Windows systems.

Last edited by tommymsw (2012-03-02 21:46:26)

Terrabyte · 2012-03-02 22:36:33

tommymsw wrote:
Yes, I just tried sharing the Thumbs directory. Usually my system was lighting fast, now it takes about 45 seconds to open up the TV library... I think it takes that long to lead the thumbs? I have like 175 TV shows and a few thousand episodes. I will switch it back and see if I get the speed back. But keep the other stuff.

Weird, I tried the same script on the system with openelec and there is no lag when opening the library. Only on the Windows systems.

All my systems are linux based guess that is why I am not seeing any lag.

Terrabyte · 2012-03-03 15:18:14

I just remembered did you do this when setting up MySQL

Comment out the bind-address setup in MySQL
#nano /etc/mysql/my.cnf
change from: "bind-address = 127.0.0.1" to: "#bind-address = 127.0.0.1"
add "skip-name-resolve" to [mysqld] section of config
----Control o to write file than Control x to exit file----

Check MySQL Status
#/etc/init.d/mysql status
#invoke-rc.d mysql restart

This should speed things up...

tommymsw · 2012-03-03 20:22:46

Yes, I have all that in. Thank you.
It must be a windows thing because I heard a LOT of people say sharing thumbs (if you have a large collection) takes a lot of time.
And it is fast on my openelec! And that is using the same database with all the same permissions as the windows system.

DSM-G600, DNS-3xx and NSA-220 Hack Forum

Announcement

#1 2012-02-29 03:02:47

Help with sharing XBMC database wirh mysql

#2 2012-03-01 03:41:13

Re: Help with sharing XBMC database wirh mysql

#3 2012-03-01 08:41:49

Re: Help with sharing XBMC database wirh mysql

#4 2012-03-01 08:48:56

Re: Help with sharing XBMC database wirh mysql

#5 2012-03-01 17:04:43

Re: Help with sharing XBMC database wirh mysql

#6 2012-03-01 19:13:35

Re: Help with sharing XBMC database wirh mysql

#7 2012-03-01 20:04:17

Re: Help with sharing XBMC database wirh mysql

#8 2012-03-01 21:35:57

Re: Help with sharing XBMC database wirh mysql

#9 2012-03-01 21:45:23

Re: Help with sharing XBMC database wirh mysql

#10 2012-03-01 21:53:53

Re: Help with sharing XBMC database wirh mysql

#11 2012-03-01 22:03:05

Re: Help with sharing XBMC database wirh mysql

#12 2012-03-01 23:11:05

Re: Help with sharing XBMC database wirh mysql

#13 2012-03-01 23:20:19

Re: Help with sharing XBMC database wirh mysql

#14 2012-03-02 04:02:02

Re: Help with sharing XBMC database wirh mysql

tommymsw wrote:

#15 2012-03-02 05:01:40

Re: Help with sharing XBMC database wirh mysql

#16 2012-03-02 05:09:24

Re: Help with sharing XBMC database wirh mysql

#17 2012-03-02 06:57:27

Re: Help with sharing XBMC database wirh mysql

#18 2012-03-02 08:26:14

Re: Help with sharing XBMC database wirh mysql

#19 2012-03-02 14:29:38

Re: Help with sharing XBMC database wirh mysql

tommymsw wrote:

Code:

#20 2012-03-02 18:24:06

Re: Help with sharing XBMC database wirh mysql

#21 2012-03-02 20:42:34

Re: Help with sharing XBMC database wirh mysql

tommymsw wrote:

tommymsw wrote:

tommymsw wrote:

#22 2012-03-02 21:02:36

Re: Help with sharing XBMC database wirh mysql

#23 2012-03-02 22:36:33

Re: Help with sharing XBMC database wirh mysql

tommymsw wrote:

#24 2012-03-03 15:18:14

Re: Help with sharing XBMC database wirh mysql

#25 2012-03-03 20:22:46

Re: Help with sharing XBMC database wirh mysql

Board footer