Kodi Community Forum

Full Version: Problem with shared sources.xml no indexing
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey guys i've got abit of a problem here that im hopeing someone can help me out with!

So basicly what i have is i have my advancedsettings.xml on all my clients which refs sources.xml like this:
Code:
<substitute>
from>special://profile/sources.xml</from>
<to>smb://xbmc:[email protected]/XBMC/userdata/sources.xml</to>
</substitute>
</advancedsettings>

Now according to my xbmc.log it loads my advanced settings fine on my raspberry's but i dont see any sources on my raspberries? And my mysql is completely empty except it created the 2 databases as it should, and the xbmc mysql user has all the rights for everything on the entire mysql service.

Here's what my sources contains:

Code:
<sources>
    <programs>
        <default></default>
    </programs>
    <video>
        <default></default>
        <source>
            <name>Movies</name>
            <path>smb://xbmc:[email protected]/Movies/3D/</path>
            <path>smb://xbmc:[email protected]/Movies/Highres/</path>
        </source>
        <source>
            <name>Series</name>
            <path>smb://xbmc:[email protected]/Series/</path>
        </source>
    </video>
    <music>
        <default></default>
    </music>
    <pictures>
        <default></default>
    </pictures>
    <files>
        <default></default>
        <source>
            <name>XBMCHUB</name>
            <path>http://fusion.xbmchub.com/</path>
        </source>
    </files>
</sources>

i have triple checked my sources pointings and honestly it should work? And i find it abit odd that i cant seem to figure out where i supply what type of content these shares contain? Do i need to manually add them on the clients? I just assumed that sources.xml would fix that for me?

Here's my xbmclog:
Code:
23:57:22 T:3038380032  NOTICE: -----------------------------------------------------------------------
23:57:22 T:3038380032  NOTICE: Starting XBMC (12.0 Git:Unknown), Platform: Linux (Debian GNU/Linux 7.0 (wheezy), 3.6.11 armv6l). Built on Feb 22 2013
23:57:22 T:3038380032  NOTICE: special://xbmc/ is mapped to: /opt/xbmc-bcm/xbmc-bin/share/xbmc
23:57:22 T:3038380032  NOTICE: special://xbmcbin/ is mapped to: /opt/xbmc-bcm/xbmc-bin/lib/xbmc
23:57:22 T:3038380032  NOTICE: special://masterprofile/ is mapped to: /home/pi/.xbmc/userdata
23:57:22 T:3038380032  NOTICE: special://home/ is mapped to: /home/pi/.xbmc
23:57:22 T:3038380032  NOTICE: special://temp/ is mapped to: /home/pi/.xbmc/temp
23:57:22 T:3038380032  NOTICE: The executable running is: /opt/xbmc-bcm/xbmc-bin/lib/xbmc/xbmc.bin
23:57:22 T:3038380032  NOTICE: Local hostname: raspbmc
23:57:22 T:3038380032  NOTICE: Log File is located: /home/pi/.xbmc/temp/xbmc.log
23:57:22 T:3038380032  NOTICE: -----------------------------------------------------------------------
23:57:22 T:3038380032  NOTICE: load settings...
23:57:22 T:3038380032  NOTICE: special://profile/ is mapped to: special://masterprofile/
23:57:22 T:3038380032  NOTICE: loading special://masterprofile/guisettings.xml
23:57:22 T:3038380032  NOTICE: Getting hardware information now...
23:57:22 T:3038380032  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
23:57:22 T:3038380032  NOTICE: Loaded playercorefactory configuration
23:57:22 T:3038380032  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
23:57:22 T:3038380032  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
23:57:22 T:3038380032  NOTICE: Loaded settings file from special://xbmc/system/advancedsettings.xml
23:57:22 T:3038380032  NOTICE: Contents of special://xbmc/system/advancedsettings.xml are...
                                            <advancedsettings>
                                              <cputempcommand>/opt/vc/bin/vcgencmd measure_temp | sed -e &apos;s/temp=\([0-9]*\).*/\1 C/&apos;</cputempcommand>
                                              <gputempcommand>/opt/vc/bin/vcgencmd measure_temp | sed -e &apos;s/temp=\([0-9]*\).*/\1 C/&apos;</gputempcommand>
                                              <network>
                                                <cachemembuffersize>10485760</cachemembuffersize>
                                              </network>
                                              <imageres>540</imageres>
                                              <fanartres>720</fanartres>
                                              <video>
                                                <defaultplayer>omxplayer</defaultplayer>
                                                <defaultdvdplayer>omxplayer</defaultdvdplayer>
                                              </video>
                                              <audio>
                                                <defaultplayer>paplayer</defaultplayer>
                                                <streamsilence>false</streamsilence>
                                              </audio>
                                            </advancedsettings>
23:57:22 T:3038380032  NOTICE: Getting hardware information now...
23:57:22 T:3038380032  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
23:57:22 T:3038380032  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.2</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>pass</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.2</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>pass</pass>
                                              </musicdatabase>
                                              <pvr>
                                                <minvideocachelevel>20</minvideocachelevel>
                                                <minaudiocachelevel>20</minaudiocachelevel>
                                              </pvr>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                              </videolibrary>
                                              <substitute>
                                                <from>special://profile/sources.xml</from>
                                                <to>smb://xbmc:[email protected]/XBMC/userdata/sources.xml</to>
                                              </substitute>
                                            </advancedsettings>
23:57:22 T:3038380032 WARNING: VIDEO database configuration is experimental.
23:57:22 T:3038380032  NOTICE: Getting hardware information now...
23:57:22 T:3038380032  NOTICE: Default DVD Player: omxplayer
23:57:22 T:3038380032  NOTICE: Default Video Player: omxplayer
23:57:22 T:3038380032  NOTICE: Default Audio Player: paplayer
23:57:22 T:3038380032  NOTICE: Disabled debug logging due to GUI setting. Level 0.
23:57:22 T:3038380032  NOTICE: Log level changed to 0
23:57:22 T:3038380032  NOTICE: Loading media sources from special://masterprofile/sources.xml
23:57:23 T:3038380032   ERROR: Error: Requested setting (audiooutput.guisoundmode) was not found.  It must be case-sensitive
23:57:23 T:3038380032  NOTICE: Running database version Addons15
23:57:23 T:3038380032  NOTICE: Register - new cec device registered on rpi->RPI: Raspberry Pi CEC Adapter (2708:1001)
23:57:23 T:3029165120  NOTICE: Thread CEC Adapter start, auto delete: false
23:57:23 T:3018847296  NOTICE: Thread XBMC Peripherals start, auto delete: false
23:57:23 T:3038380032  NOTICE: Raspberry PI firmware version: Jan 30 2013 12:19:11
                                            Copyright (c) 2012 Broadcom
                                            version 366105 (release)
23:57:23 T:3038380032  NOTICE: InitWindowSystem: Using EGL Implementation: raspberrypi
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 720 x 480 for display 0 with 720 x 480 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1280 x 720 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 640 x 720 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1280 x 360 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1920 x 1080 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 960 x 1080 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1920 x 540 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 720 x 576 for display 0 with 720 x 576 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1280 x 720 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 640 x 720 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1280 x 360 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1920 x 1080 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 960 x 1080 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1920 x 540 @ 50.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1920 x 1080 @ 24.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 960 x 1080 @ 24.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1920 x 540 @ 24.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1920 x 1080 @ 25.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 960 x 1080 @ 25.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1920 x 540 @ 25.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 720 for display 0 with 1920 x 1080 @ 30.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 720 for display 0 with 960 x 1080 @ 30.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 1280 x 360 for display 0 with 1920 x 540 @ 30.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 72.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 75.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 60.000000 Hz
23:57:23 T:3038380032  NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 72.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 75.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1024 x 768 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1024 x 768 @ 70.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1024 x 768 @ 75.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1152 x 864 @ 75.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 1152 x 720 for display 0 with 1280 x 800 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1280 x 960 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 900 x 720 for display 0 with 1280 x 1024 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 900 x 720 for display 0 with 1280 x 1024 @ 75.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 1275 x 720 for display 0 with 1360 x 768 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 1152 x 720 for display 0 with 1440 x 900 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 1152 x 720 for display 0 with 1440 x 900 @ 75.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 960 x 720 for display 0 with 1600 x 1200 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found resolution 1152 x 720 for display 0 with 1680 x 1050 @ 60.000000 Hz
23:57:24 T:3038380032  NOTICE: Found ([email protected]) at 21, setting to RES_DESKTOP at 16
23:57:24 T:3038380032  NOTICE: Checking resolution 16
23:57:24 T:3038380032  NOTICE: GL_VENDOR = Broadcom
23:57:24 T:3038380032  NOTICE: GL_RENDERER = VideoCore IV HW
23:57:24 T:3038380032  NOTICE: GL_VERSION = OpenGL ES 2.0
23:57:24 T:3038380032  NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 1.00
23:57:24 T:3038380032  NOTICE: GL_EXTENSIONS = GL_OES_compressed_ETC1_RGB8_texture GL_OES_compressed_paletted_texture GL_OES_texture_npot GL_OES_depth24 GL_OES_vertex_half_float GL_OES_EGL_image GL_OES_EGL_image_external GL_EXT_discard_framebuffer GL_OES_rgb8_rgba8 GL_OES_depth32 GL_OES_mapbuffer GL_EXT_texture_format_BGRA8888 GL_APPLE_rgb_422 GL_EXT_debug_marker
23:57:26 T:3038380032  NOTICE: Running database version Addons15
23:57:26 T:3038380032  NOTICE: Running database version ViewModes4
23:57:26 T:3038380032  NOTICE: Running database version Textures13
23:57:26 T:3038380032  NOTICE: Running database version MyMusic32
23:57:26 T:3038380032  NOTICE: Running database version MyVideos75
23:57:26 T:3038380032  NOTICE: Running database version TV22
23:57:26 T:3038380032  NOTICE: Running database version Epg7
23:57:26 T:3038380032  NOTICE: start dvd mediatype detection
23:57:26 T:3038380032  NOTICE: initializing playlistplayer
23:57:26 T:3038380032  NOTICE: DONE initializing playlistplayer
23:57:26 T:2959311936  NOTICE: Thread CDetectDVDMedia start, auto delete: false
23:57:27 T:3029165120   ERROR: CecLogMessage - failed to release the previous LA
23:57:27 T:3029165120   ERROR: CecLogMessage - could not open a connection (try 1)
23:57:29 T:2955551808  NOTICE: Thread CEC Adapter Update Thread start, auto delete: false
23:57:29 T:2946630720  NOTICE: Thread XBPyThread start, auto delete: false
23:57:29 T:3038380032  NOTICE: initialize done
23:57:29 T:3038380032  NOTICE: Running the application...
23:57:29 T:2946630720  NOTICE: -->Python Interpreter Initialized<--
23:57:30 T:2946630720  NOTICE: services: {'sys.service.avahi': 'true', 'sys.service.remote': 'true', 'sys.service.ftp': 'true', 'sys.service.samba': 'true', 'sys.service.ssh': 'true', 'sys.service.cron': 'false', 'sys.service.tvh': 'false'}
23:57:30 T:2946630720  NOTICE: enable service: avahi-daemon
23:57:30 T:2946630720  NOTICE: enable service: eventlircd
23:57:30 T:3038380032   ERROR: SQL: The table does not exist
                                            Query: select count(idSong) as NumSongs from songview
23:57:30 T:3038380032   ERROR: GetSongsCount() failed
23:57:31 T:2946630720  NOTICE: enable service: ftp
23:57:31 T:2930267200  NOTICE: Thread Jobworker start, auto delete: true
23:57:31 T:3038380032  NOTICE: Webserver: Starting...
23:57:31 T:3038380032  NOTICE: WebServer: Started the webserver
23:57:31 T:2930267200   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
23:57:31 T:2930267200   ERROR: GetRecentlyAddedAlbumSongs failed
23:57:31 T:2930267200   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
23:57:31 T:2930267200   ERROR: GetRecentlyAddedAlbums failed
23:57:31 T:3038380032  NOTICE: starting upnp server
23:57:32 T:3038380032  NOTICE: starting upnp renderer
23:57:32 T:2946630720  NOTICE: enable service: samba
23:57:32 T:2930267200   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
23:57:32 T:2930267200   ERROR: GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
23:57:32 T:2930267200   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
23:57:32 T:2930267200   ERROR: GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
23:57:32 T:2930267200   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
23:57:32 T:2930267200   ERROR: GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
23:57:32 T:3038380032  NOTICE: ES: Starting event server
23:57:32 T:3038380032  NOTICE: starting zeroconf publishing
23:57:32 T:2837992512  NOTICE: Thread CEventServer start, auto delete: false
23:57:32 T:2837992512  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
23:57:32 T:2837992512  NOTICE: UDP: Listening on port 9777
23:57:32 T:2821215296  NOTICE: Thread Jobworker start, auto delete: true
23:57:32 T:2829603904  NOTICE: Thread CTCPServer start, auto delete: false
23:57:32 T:2812826688  NOTICE: Thread AirPlayServer start, auto delete: false
23:57:32 T:2804438080  NOTICE: Thread AirTunesServer start, auto delete: false
23:57:32 T:2796049472  NOTICE: Thread Jobworker start, auto delete: true
23:57:33 T:2946630720  NOTICE: enable service: ssh
23:57:33 T:2946630720  NOTICE: disable service: cron
23:57:33 T:2946630720  NOTICE: disable service: tvheadend
23:57:35 T:3038380032  NOTICE: COMXPlayer: Opening: pipe://1/
23:57:35 T:2764588096  NOTICE: Thread COMXPlayer start, auto delete: false
23:57:35 T:2764588096  NOTICE: Creating InputStream
23:57:35 T:2764588096  NOTICE: Creating Demuxer
23:57:35 T:2764588096  NOTICE: Opening audio stream: 0 source: 256
23:57:35 T:2764588096  NOTICE: Creating audio thread
23:57:35 T:2745660480  NOTICE: Thread COMXPlayerAudio start, auto delete: false
23:57:35 T:2764588096 WARNING: CDVDMessageQueue(video)::Put MSGQ_NOT_INITIALIZED
23:57:35 T:3038380032   ERROR: SQL: The table does not exist
                                            Query: select * from songview where dwFileNameCRC='4139365939l' and strPath='pipe://1/'
23:57:35 T:3038380032   ERROR: GetSongByFileName(pipe://1/) failed
23:57:35 T:3038380032   ERROR: SQL: The table does not exist
                                            Query: select * from songview where dwFileNameCRC='4139365939l' and strPath='pipe://1/'
23:57:35 T:3038380032   ERROR: GetSongByFileName(pipe://1/) failed
23:57:36 T:2946630720  NOTICE: system settings from addon: {'sys.config.freq.arm': 840, 'sys.config.freq.gpu': 253, 'sys.config.freq.sdram': 400, 'sys.config.freq.core': 350, 'sys.config.freq.overvolt': 0, 'sys.config.decode.wvc1': '', 'sys.config.disable.overscan': '1', 'sys.config.decode.ac3': '', 'sys.config.freq.isp': 250, 'sys.config.decode.mpg2': '', 'sys.config.decode.dts': ''}
23:57:36 T:2946630720  NOTICE: system settings from /boot/config.txt: {'sys.config.freq.arm': 840, 'sys.config.freq.gpu': 253, 'sys.config.freq.sdram': 400, 'sys.config.freq.core': 350, 'sys.config.freq.overvolt': 0, 'sys.config.decode.wvc1': '', 'sys.config.disable.overscan': '1', 'sys.config.decode.ac3': '', 'sys.config.freq.isp': 250, 'sys.config.decode.mpg2': '', 'sys.config.decode.dts': ''}
23:57:37 T:2764588096 WARNING: CDVDMessageQueue(video)::Put MSGQ_NOT_INITIALIZED
23:57:37 T:2745660480  NOTICE: OMXClock using audio as reference
Edit:

Do i need to setup some folders manually on 1 xbmc to start scraping or ?
So did abit of testing, and i add'd sources manually on a client through the xbmc interface, which resulted in a locally based sources.xml file but indexing went to the sql server, so the problem must be it cant reach the sources.xml? or? i just dont get any information on that? and it loads the advancedsettings correctly?
Try using special://masterprofile instead of special://profile
Syncing sources.xml only helps file view. MySQL keeps track of sources that have "content set" in the database.