XBMC Standalone Library Updater for UnRAID

[bobbintb]

It should be and it's on my to do list. Someone else helped with the compiling and there are some things that need fixing. XBMC does require certain versions to compile but I'm not sure why it requires certain versions to run because, honestly, I'm not that experienced in this.

 

There is also an ongoing discussion about this and other package dependency issues for the upcoming plugin manager for UnRAID. Right now there isn't really a standard way of doing a lot of things and it leads to these issues. These discussions are an attempt to ameliorate those problems.

[Orbi]

yes, the $ signifies the prompt so it is not typed. i wasnt sure about having to create the database or not. mine was already created and i believe that xbmc will create it in some cases. i dont remember though. i think based on your feedback i will clean up the instructions a tad to be more noob friendly.

 

That is a good idea for users new to this. Any idea why the install folder of MySQL Server is not accessible out of the box? I have to chmod it every time I reboot.

 

Both the video and music databases have to be created for XBMC to run. It would be good to include the following url in the OP instrutions for users creating their databases: http://wiki.xbmc.org/index.php?title=XBMC_databases/Versions. As you can see, the database name evolves with the versions of xbmc. Had I used a recent nightly, I should have named my databases "MyVideos76" and "MyMusic37".

[bobbintb]

No idea why. I've never had a problem with the MySQL permissions. But that is a separate plugin. You have to chmod every time? Definately not right. Something is changing it back. Check the code for the MySQL plugin or check with the author on that.

 

And that URL you mentioned has been in the OP for a long time. It's at the top. 

[Orbi]

Ah yes, good one about the url. 

 

On a general note, why is SALUD set up with a user and password for accessing the video and music databases? I mentionned that

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';

does not survive boot plus it obliges you to set a user and password for every XBMC client in the house. Unless the MySQL server is used for other purposes than XBMC, there is not much to gain from securing it that way.

[bobbintb]

how does it oblige you to set the password for every client? you have to copy the settings from advancedsettings.xml regardless of whether or not there is a password. i suppose if you are manually typing all the settings every time you would have more typing. but just copying the settings over is the same with or without a password.

 

granted the information is not really important, you should always secure a database. plus i believe it has a password by default and i left it that way. maybe not, i dont remember. ive only set it up once. plus you certainly dont lose anything by securing it.

 

ive never had anyone have any issues with the settings not surviving on reboot. what version of mysql are you using?

[bobbintb]

I love this plugin.... Thank you very much for doing this.

 

I have a question/suggestion.... I have configured Couchpotato to notify my Salud install... but I notice that it does not scrape the actor images... Could this feature be enabled?

 

Many thanks again,

 

H.

 

should be. is this a setting that can normally be accessed through the gui? if so you should be able to just find it in guisettings.xml and change it.

[Orbi]

how does it oblige you to set the password for every client? you have to copy the settings from advancedsettings.xml regardless of whether or not there is a password. i suppose if you are manually typing all the settings every time you would have more typing. but just copying the settings over is the same with or without a password.

 

granted the information is not really important, you should always secure a database. plus i believe it has a password by default and i left it that way. maybe not, i dont remember. ive only set it up once. plus you certainly dont lose anything by securing it.

 

ive never had anyone have any issues with the settings not surviving on reboot. what version of mysql are you using?

 

I spoke too soon. The settings indeed survive reboot. All is fine, salud detects the MySQL databases. It detects my Movies share, but not my TV Shows. I tried renaming the share to TV-Shows, thinking the space between TV and shows might be the issue, but it's not detecting it. Here's my sources.xml:

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>TV Shows</name>
            <path pathversion="1">smb://TOWER/TV Shows/</path>
        </source>
        <source>
            <name>Movies</name>
            <path pathversion="1">smb://TOWER/Movies/</path>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
    </music>
    <pictures>
        <default pathversion="1"></default>
    </pictures>
    <files>
        <default pathversion="1"></default>
        <source>
            <name>Movies</name>
            <path pathversion="1">smb://TOWER/Movies/</path>
        </source>
	<source>
            <name>TV Shows</name>
            <path pathversion="1">smb://TOWER/TV Shows/</path>
        </source>
    </files>
</sources>

 

What do you think it could be?

[bobbintb]

not sure. was this manually created? i usually just add the sources to a full xbmc, and copy the xml file to rule out any human error. the path looks ok. maybe a permissions issue accessing the folder?

[Orbi]

I copied it from my win7 xbmc client. There shouldn't be any errors.

 

The TV Shows share has the same settings as the Movies share. I think we can rule out permissions issues:

root@Tower:~# ls -l /mnt/user/
total 3
drwxrwxrwx 1 nobody users   48 2013-09-21 19:33 Movies/
drwxrwxrwx 1 nobody users  480 2013-08-29 03:40 Music/
drwxrwxrwx 1 nobody users 2480 2013-08-14 03:49 Pictures/
drwxrwxrwx 1 nobody users  424 2013-08-29 04:04 Storage/
drwxrwxrwx 1 nobody users  128 2013-08-28 03:41 TV\ Shows/
drwxrwxrwx 1 nobody users  112 2013-08-21 04:44 Video/

 

I checked the log and there is not a single mention of /mnt/user/TV Shows.

[exist2resist]

A few days ago my Salud Installation started acting up.

At first it wouldn't add World War Z and Episodes of Suits to the SQL db.

Then it stopped adding anything new all together, movies and TV weren't being added to the db.

The process is running, I can reach the web interface and log in on port 9091, so everything looks like is up and running.

I rebooted the server, and still nothing.

If I manually scan in XBMC on my HTPC it adds the shows and movies to the db and propagates to my RaperryPi in the bedroom, so I know the db works fine.

I also checked sources.xml and advancedsettings.xml, they both look fine.

Any ideas?

[overbyrn]

A few days ago my Salud Installation started acting up.

At first it wouldn't add World War Z and Episodes of Suits to the SQL db.

Then it stopped adding anything new all together, movies and TV weren't being added to the db.

The process is running, I can reach the web interface and log in on port 9091, so everything looks like is up and running.

I rebooted the server, and still nothing.

If I manually scan in XBMC on my HTPC it adds the shows and movies to the db and propagates to my RaperryPi in the bedroom, so I know the db works fine.

I also checked sources.xml and advancedsettings.xml, they both look fine.

Any ideas?

I don't use the Salud plugin, but I do run a headless instance of XBMC.  You may have already done so, but check the xbmc.log file for clues as I'd assume the log would be the best place to find out why it's not updating as you'd expect.  I'm afraid I can't advise where the log file lives on your system, as I say I don't run the plugin so my setup is likely to be different.  Do a find for it, it must be somewhere.

 

 

[MrLondon]

I have now dropped the 2 databases in mysql and let your plugin create them, which it did successfully, but as soon as it's supposed to do a library scan it just takes 0 seconds.

 

11:23:18 T:1118700192   DEBUG: Mysql execute: CREATE TABLE musicvideo ( idMVideo integer primary key auto_increment , idFile integer,c00 text,c01 text,c02 text,c03 text,c04 text,c05 text,c06 text,c07 text,c08 text,c09 text,c10 text,c11 text,c12 text,c13 text,c14 text,c15 text,c16 text,c17 text,c18 text,c19 text,c20 text,c21 text,c22 text,c23 text) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:18 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_musicvideo_file_1 on musicvideo (idMVideo, idFile)
11:23:19 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_musicvideo_file_2 on musicvideo (idFile, idMVideo)
11:23:19 T:1118700192    INFO: create artistlinkmusicvideo table
11:23:19 T:1118700192   DEBUG: Mysql execute: CREATE TABLE artistlinkmusicvideo ( idArtist integer, idMVideo integer)
                                             CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:19 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_artistlinkmusicvideo_1 ON artistlinkmusicvideo ( idArtist, idMVideo)
11:23:19 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_artistlinkmusicvideo_2 ON artistlinkmusicvideo ( idMVideo, idArtist)
11:23:19 T:1118700192    INFO: create genrelinkmusicvideo table
11:23:19 T:1118700192   DEBUG: Mysql execute: CREATE TABLE genrelinkmusicvideo ( idGenre integer, idMVideo integer)
                                             CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:20 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_genrelinkmusicvideo_1 ON genrelinkmusicvideo ( idGenre, idMVideo)
11:23:20 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_genrelinkmusicvideo_2 ON genrelinkmusicvideo ( idMVideo, idGenre)
11:23:20 T:1118700192    INFO: create studiolinkmusicvideo table
11:23:20 T:1118700192   DEBUG: Mysql execute: CREATE TABLE studiolinkmusicvideo ( idStudio integer, idMVideo integer)
                                             CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:20 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_studiolinkmusicvideo_1 ON studiolinkmusicvideo ( idStudio, idMVideo)
11:23:26 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_studiolinkmusicvideo_2 ON studiolinkmusicvideo ( idMVideo, idStudio)
11:23:26 T:1118700192    INFO: create directorlinkmusicvideo table
11:23:26 T:1118700192   DEBUG: Mysql execute: CREATE TABLE directorlinkmusicvideo ( idDirector integer, idMVideo integer)
                                             CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:26 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_directorlinkmusicvideo_1 ON directorlinkmusicvideo ( idDirector, idMVideo )
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_directorlinkmusicvideo_2 ON directorlinkmusicvideo ( idMVideo, idDirector )
11:23:27 T:1118700192    INFO: create streaminfo table
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE TABLE streamdetails (idFile integer, iStreamType integer, strVideoCodec text, fVideoAspect float, iVideoWidth integer, iVideoHeight integer, strAudioCodec text, iAudioChannels integer, strAudioLanguage text, strSubtitleLanguage text, iVideoDuration integer) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ix_streamdetails ON streamdetails (idFile)
11:23:27 T:1118700192    INFO: create sets table
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE TABLE sets ( idSet integer primary key auto_increment , strSet text)
                                             CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ixMovieBasePath ON movie ( c23(12) )
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ixMusicVideoBasePath ON musicvideo ( c14(12) )
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ixEpisodeBasePath ON episode ( c19(12) )
11:23:27 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ixTVShowBasePath on tvshow ( c17(12) )
11:23:28 T:1118700192    INFO: create seasons table
11:23:28 T:1118700192   DEBUG: Mysql execute: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:28 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ix_seasons ON seasons (idShow, season)
11:23:28 T:1118700192    INFO: create art table
11:23:28 T:1118700192   DEBUG: Mysql execute: CREATE TABLE art(art_id INTEGER PRIMARY KEY auto_increment , media_id INTEGER, media_type TEXT, type TEXT, url TEXT) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ix_art ON art(media_id, media_type(20), type(20))
11:23:29 T:1118700192    INFO: create tag table
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE TABLE tag (idTag integer primary key auto_increment , strTag text) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_tag_1 ON tag (strTag(255))
11:23:29 T:1118700192    INFO: create taglinks table
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE TABLE taglinks (idTag integer, idMedia integer, media_type TEXT) CHARACTER SET utf8 COLLATE utf8_general_ci
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_taglinks_1 ON taglinks (idTag, media_type(20), idMedia)
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE UNIQUE INDEX ix_taglinks_2 ON taglinks (idMedia, media_type(20), idTag)
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE INDEX ix_taglinks_3 ON taglinks (media_type(20))
11:23:29 T:1118700192    INFO: create deletion triggers
11:23:29 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM taglinks WHERE idMedia=old.idMovie AND media_type='movie'; END
11:23:30 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_tvshow AFTER DELETE ON tvshow FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idShow AND media_type='tvshow'; DELETE FROM taglinks WHERE idMedia=old.idShow AND media_type='tvshow'; END
11:23:30 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_musicvideo AFTER DELETE ON musicvideo FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idMVideo AND media_type='musicvideo'; DELETE FROM taglinks WHERE idMedia=old.idMVideo AND media_type='musicvideo'; END
11:23:30 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_episode AFTER DELETE ON episode FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idEpisode AND media_type='episode'; END
11:23:30 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_season AFTER DELETE ON seasons FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idSeason AND media_type='season'; END
11:23:30 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_set AFTER DELETE ON sets FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idSet AND media_type='set'; END
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_person AFTER DELETE ON actors FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idActor AND media_type IN ('actor','artist','writer','director'); END
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE TRIGGER delete_tag AFTER DELETE ON taglinks FOR EACH ROW BEGIN DELETE FROM tag WHERE idTag=old.idTag AND idTag NOT IN (SELECT DISTINCT idTag FROM taglinks); END
11:23:31 T:1118700192    INFO: create episodeview
11:23:31 T:1118700192   DEBUG: Mysql execute: DROP VIEW IF EXISTS episodeview
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE VIEW episodeview AS SELECT   episode.*,  files.strFileName AS strFileName,  path.strPath AS strPath,  files.playCount AS playCount,  files.lastPlayed AS lastPlayed,  files.dateAdded AS dateAdded,  tvshow.c00 AS strTitle,  tvshow.c14 AS strStudio,  tvshow.c05 AS premiered,  tvshow.c13 AS mpaa,  tvshow.c16 AS strShowPath,   bookmark.timeInSeconds AS resumeTimeInSeconds,   bookmark.totalTimeInSeconds AS totalTimeInSeconds,   seasons.idSeason AS idSeason FROM episode  JOIN files ON    files.idFile=episode.idFile  JOIN tvshow ON    tvshow.idShow=episode.idShow  LEFT JOIN seasons ON    seasons.idShow=episode.idShow AND seasons.season=episode.c12  JOIN path ON    files.idPath=path.idPath  LEFT JOIN bookmark ON    bookmark.idFile=episode.idFile AND bookmark.type=1
11:23:31 T:1118700192    INFO: create tvshowview
11:23:31 T:1118700192   DEBUG: Mysql execute: DROP VIEW IF EXISTS tvshowview
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE VIEW tvshowview AS SELECT   tvshow.*,  path.strPath AS strPath,  path.dateAdded AS dateAdded,  MAX(files.lastPlayed) AS lastPlayed,  NULLIF(COUNT(episode.c12), 0) AS totalCount,  COUNT(files.playCount) AS watchedcount,  NULLIF(COUNT(DISTINCT(episode.c12)), 0) AS totalSeasons FROM tvshow  LEFT JOIN tvshowlinkpath ON    tvshowlinkpath.idShow=tvshow.idShow  LEFT JOIN path ON    path.idPath=tvshowlinkpath.idPath  LEFT JOIN episode ON    episode.idShow=tvshow.idShow  LEFT JOIN files ON    files.idFile=episode.idFile GROUP BY tvshow.idShow;
11:23:31 T:1118700192    INFO: create musicvideoview
11:23:31 T:1118700192   DEBUG: Mysql execute: DROP VIEW IF EXISTS musicvideoview
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE VIEW musicvideoview AS SELECT  musicvideo.*,  files.strFileName as strFileName,  path.strPath as strPath,  files.playCount as playCount,  files.lastPlayed as lastPlayed,  files.dateAdded as dateAdded,   bookmark.timeInSeconds AS resumeTimeInSeconds,   bookmark.totalTimeInSeconds AS totalTimeInSeconds FROM musicvideo  JOIN files ON    files.idFile=musicvideo.idFile  JOIN path ON    path.idPath=files.idPath  LEFT JOIN bookmark ON    bookmark.idFile=musicvideo.idFile AND bookmark.type=1
11:23:31 T:1118700192    INFO: create movieview
11:23:31 T:1118700192   DEBUG: Mysql execute: DROP VIEW IF EXISTS movieview
11:23:31 T:1118700192   DEBUG: Mysql execute: CREATE VIEW movieview AS SELECT  movie.*,  sets.strSet AS strSet,  files.strFileName AS strFileName,  path.strPath AS strPath,  files.playCount AS playCount,  files.lastPlayed AS lastPlayed,   files.dateAdded AS dateAdded,   bookmark.timeInSeconds AS resumeTimeInSeconds,   bookmark.totalTimeInSeconds AS totalTimeInSeconds FROM movie  LEFT JOIN sets ON    sets.idSet = movie.idSet  JOIN files ON    files.idFile=movie.idFile  JOIN path ON    path.idPath=files.idPath  LEFT JOIN bookmark ON    bookmark.idFile=movie.idFile AND bookmark.type=1
11:23:31 T:1118700192   DEBUG: Mysql commit transaction
11:23:31 T:1118700192  NOTICE: Running database version TV22
11:23:31 T:1118700192  NOTICE: Running database version Epg7
11:23:31 T:1118700192   DEBUG: Initialize, updating databases... DONE
11:23:31 T:1118700192  NOTICE: initializing playlistplayer
11:23:31 T:1118700192  NOTICE: DONE initializing playlistplayer
11:23:31 T:1118700192    INFO: JSONRPC v6.0.3: Successfully initialized
11:23:31 T:1118700192   DEBUG: ADDON: Starting service addons.
11:23:31 T:1118700192    INFO: removing tempfiles
11:23:31 T:1118700192   DEBUG: ADDON: Starting service addons.
11:23:31 T:1118700192  NOTICE: initialize done
11:23:31 T:1125391216  NOTICE: Thread CVideoInfoScanner start, auto delete: false
11:23:31 T:1118700192   DEBUG: Process - no profile autoexec.py (/mnt/user/xbmc/portable_data/userdata/autoexec.py) found, skipping
11:23:31 T:1118700192   DEBUG: NetworkMessage - Starting network services
11:23:31 T:1118700192  NOTICE: Webserver: Starting...
11:23:31 T:1118700192  NOTICE: WebServer: Started the webserver
11:23:31 T:1118700192   DEBUG: CLastfmScrobbler: Clearing session.
11:23:31 T:1118700192   DEBUG: CLibrefmScrobbler: Clearing session.
11:23:31 T:1125391216  NOTICE: VideoInfoScanner: Starting scan ..
11:23:31 T:1125391216   DEBUG: CAnnouncementManager - Announcement: OnScanStarted from xbmc
11:23:31 T:1125391216  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
11:23:31 T:1125391216   DEBUG: CAnnouncementManager - Announcement: OnScanFinished from xbmc
11:23:31 T:1125391216   DEBUG: Thread CVideoInfoScanner 1125391216 terminating
11:24:39 T:1131412336   DEBUG: webserver: request received for /jsonrpc
11:24:39 T:1131412336   DEBUG: JSONRPC: Incoming request: { "jsonrpc": "2.0", "method": "VideoLibrary.Scan", "id": "mybash"}
11:24:39 T:1131412336   DEBUG: JSONRPC: Calling videolibrary.scan
11:24:39 T:1125391216  NOTICE: Thread CVideoInfoScanner start, auto delete: false
11:24:39 T:1125391216  NOTICE: VideoInfoScanner: Starting scan ..
11:24:39 T:1125391216   DEBUG: CAnnouncementManager - Announcement: OnScanStarted from xbmc
11:24:39 T:1125391216  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
11:24:39 T:1125391216   DEBUG: CAnnouncementManager - Announcement: OnScanFinished from xbmc
11:24:39 T:1125391216   DEBUG: Thread CVideoInfoScanner 1125391216 terminating

 

Any idea why this is still is happening?

 

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>series</name>
            <path pathversion="1">smb://tower/series/</path>
        </source>
        <source>
            <name>movies</name>
            <path pathversion="1">smb://tower/movies/</path>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
        <source>
            <name>music</name>
            <path pathversion="1">smb://tower/music/</path>
        </source>
    </music>
    <pictures>
        <default pathversion="1"></default>
    </pictures>
    <files>
        <default pathversion="1"></default>
    </files>
</sources>

 

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.0.14</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase>
   
   <musicdatabase>
        <type>mysql</type>
        <host>192.168.0.14</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>
<videolibrary>
	<backgroundupdate>true</backgroundupdate>
	<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>	

[bnevets27]

I'm having trouble with couchpotato updating salud.  Sickbeard has no trouble at all with sending a update request to salud and runs fine. I tried pointing the couchpotato notification/update request to one of my client pc's running openelec 3.2 (xbmc boxes) and it updates the mysql database without issue.

 

So I assume its something to do with the interaction between xbmc salud and couchpotato seeing as couchpotato can successfully update the mysql db through a different xbmc install.

 

 

I'm using the latest couchpotato as of today (Version 324415be15e0618e5b54ad490c1b2932c09368de (September-23-13 8:35:51 PM)(source, master - ID 1927)

And the latest nzbToMedia script by clinton-hall

I have the actual IP address of the server in both sickbeard and couchpotato. ie 192.168.1.111 as apposed to localhost or 127.0.0.1 or 0.0.0.0 Not sure if that's bad practice or not...

 

 

Any ideas?

 

15:07:48 T:1127279472   DEBUG: webserver: request received for /jsonrpc
15:07:48 T:1127279472   DEBUG: JSONRPC: Incoming request: [{"jsonrpc": "2.0", "params": {}, "method": "JSONRPC.Version", "id": "JSONRPC.Version"}]
15:07:48 T:1127279472   DEBUG: JSONRPC: Calling jsonrpc.version
15:07:48 T:1127279472   DEBUG: webserver: request received for /jsonrpc
15:07:48 T:1127279472   DEBUG: JSONRPC: Incoming request: [{"jsonrpc": "2.0", "params": {"message": "Downloaded xxxxxxxxxxxxxxxxxx", "image": "https://raw.github.com/RuudBurger/CouchPotatoServer/master/couchpotato/static/images/notify.couch.small.png", "title": "CouchPotato"}, "method": "GUI.ShowNotification", "id": "GUI.ShowNotification"}]
15:07:48 T:1127279472   DEBUG: JSONRPC: Calling gui.shownotification
15:07:48 T:1127279472   DEBUG: JSONRPC: Value does not match any of the enum values in type
15:07:49 T:1127279472   DEBUG: webserver: request received for /jsonrpc
15:07:49 T:1127279472   DEBUG: JSONRPC: Incoming request: [{"jsonrpc": "2.0", "params": {"message": "Downloaded xxxxxxxxxxxxxxxxxxx", "image": "https://raw.github.com/RuudBurger/CouchPotatoServer/master/couchpotato/static/images/notify.couch.small.png", "title": "CouchPotato"}, "method": "GUI.ShowNotification", "id": "GUI.ShowNotification"}, {"jsonrpc": "2.0", "params": {"directory": "/mnt/user/xxxxxxxxxxxxxxxxxxxxxxxx"}, "method": "VideoLibrary.Scan", "id": "VideoLibrary.Scan"}]
15:07:49 T:1127279472   DEBUG: JSONRPC: Calling gui.shownotification
15:07:49 T:1127279472   DEBUG: JSONRPC: Value does not match any of the enum values in type
15:07:49 T:1127279472   DEBUG: JSONRPC: Calling videolibrary.scan
15:07:49 T:1125129072  NOTICE: Thread CVideoInfoScanner start, auto delete: false
15:07:49 T:1125129072  NOTICE: VideoInfoScanner: Starting scan ..
15:07:49 T:1125129072   DEBUG: CAnnouncementManager - Announcement: OnScanStarted from xbmc
15:07:49 T:1125129072  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
15:07:49 T:1125129072   DEBUG: CAnnouncementManager - Announcement: OnScanFinished from xbmc
15:07:49 T:1125129072   DEBUG: Thread CVideoInfoScanner 1125129072 terminating

[bobbintb]

A few days ago my Salud Installation started acting up.

At first it wouldn't add World War Z and Episodes of Suits to the SQL db.

Then it stopped adding anything new all together, movies and TV weren't being added to the db.

The process is running, I can reach the web interface and log in on port 9091, so everything looks like is up and running.

I rebooted the server, and still nothing.

If I manually scan in XBMC on my HTPC it adds the shows and movies to the db and propagates to my RaperryPi in the bedroom, so I know the db works fine.

I also checked sources.xml and advancedsettings.xml, they both look fine.

Any ideas?

 

that is puzzling. have there been any changes to the server? can you provide a log for when you attempt a scan?

[bobbintb]

I have now dropped the 2 databases in mysql and let your plugin create them, which it did successfully, but as soon as it's supposed to do a library scan it just takes 0 seconds.

 

Any idea why this is still is happening?

 

are you able to successfully send a test notification?

[bobbintb]

I'm having trouble with couchpotato updating salud.  Sickbeard has no trouble at all with sending a update request to salud and runs fine. I tried pointing the couchpotato notification/update request to one of my client pc's running openelec 3.2 (xbmc boxes) and it updates the mysql database without issue.

 

So I assume its something to do with the interaction between xbmc salud and couchpotato seeing as couchpotato can successfully update the mysql db through a different xbmc install.

 

 

I'm using the latest couchpotato as of today (Version 324415be15e0618e5b54ad490c1b2932c09368de (September-23-13 8:35:51 PM)(source, master - ID 1927)

And the latest nzbToMedia script by clinton-hall

I have the actual IP address of the server in both sickbeard and couchpotato. ie 192.168.1.111 as apposed to localhost or 127.0.0.1 or 0.0.0.0 Not sure if that's bad practice or not...

 

 

Any ideas?

 

not sure. i wonder if there is some issue with the new version. it's just odd that sickbeard is fine but couchpotato isnt. the only thing i can think of at the moment is to just double check the settings, which i'm sure you already have. i will keep looking into it. as far as the ip address is concerned that isnt an issue, just preference.

[overbyrn]

Hi bobbin, question... Have you compiled xbmc headless against anything later than Gotham alpha6? 

 

Apologies, for the rather odd question, but I don't use the plugin so not sure what version of xbmc you're using headless.  I ask as somewhere between Gotham alpha7 and current master something with AE Sink must have changed as the damn thing starts and shuts down almost immediately. 

 

One for me to post on the xbmc forum I know, but figured I'd ask as you've an interest in this area yourself.

 

 

Regards,

overbyrn

 

 

[bobbintb]

the current version is compiled from 12.2 frodo (top of the OP in bold )

 

but if you are asking if i have also done any compiles in testing or anything with another version, no, i have not.

[overbyrn]

the current version is compiled from 12.2 frodo (top of the OP in bold )

Guilty.  Didn't read the OP 

 

but if you are asking if i have also done any compiles in testing or anything with another version, no, i have not.

Ah well, I guess I'll stick my Gotham alpha7 headless for now.  FYI, myvideos db incremented between alpha 6 & 7.  Something to watch out for if using a centralised MySQL DB and mixed XBMC clients. Especially if - like me - you use OpenElec Generic x86_64 as there's no pre-built version matching Gotham alpha 7.  Plenty for rPi, none for Generic   

 

Guess I'll have to figure out how to self-build OpenElec...

[ubergeek]

So I still haven't had much success...I'm thinking of reinstalling mysql, but not sure how to remove entirely. But looking at my logs it looks like a package might be missing (libcurl)? as HAL errors are present

 

Like I said previously I can get sickbeard to connect successfully, but webpage from xbmc salud is always empty showing only "file not found"...library scans also return 0.00 seconds and I did create correct databases and xbmc user with permissions set...I'm sure its something simple but I just keep missing it.

 

Anyway a plugin could be interfering, perhaps PLEX?

 

/usr/bin/tail -n 1000 -f /mnt/user/xbmc/portable_data/temp/xbmc.log
?09:56:24 T:1118552688 NOTICE: -----------------------------------------------------------------------
09:56:24 T:1118552688 NOTICE: Starting XBMC (12.2 Git:20130502-32b1a5e), Platform: Linux (Slackware 13.1.0, 3.9.6p-unRAID i686). Built on May 30 2013
09:56:24 T:1118552688 NOTICE: special://xbmc/ is mapped to: /mnt/user/xbmc/
09:56:24 T:1118552688 NOTICE: special://xbmcbin/ is mapped to: /usr/local/lib/xbmc
09:56:24 T:1118552688 NOTICE: special://masterprofile/ is mapped to: /mnt/user/xbmc/portable_data/userdata
09:56:24 T:1118552688 NOTICE: special://home/ is mapped to: /mnt/user/xbmc/portable_data
09:56:24 T:1118552688 NOTICE: special://temp/ is mapped to: /mnt/user/xbmc/portable_data/temp
09:56:24 T:1118552688 NOTICE: The executable running is: /usr/local/lib/xbmc/xbmc-server.bin
09:56:24 T:1118552688 NOTICE: Local hostname: Tower
09:56:24 T:1118552688 NOTICE: Log File is located: /mnt/user/xbmc/portable_data/temp/xbmc.log
09:56:24 T:1118552688 NOTICE: -----------------------------------------------------------------------
09:56:24 T:1118552688 DEBUG: ConsoleKit.Manager: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.ConsoleKit was not provided by any .service files
09:56:24 T:1118552688 DEBUG: UPower: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.UPower was not provided by any .service files
09:56:24 T:1118552688 DEBUG: ConsoleKit.Manager: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.ConsoleKit was not provided by any .service files
09:56:24 T:1118552688 DEBUG: DeviceKit.Power: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.DeviceKit.Disks was not provided by any .service files
09:56:24 T:1118552688 DEBUG: Systemd error: org.freedesktop.DBus.Error.ServiceUnknown: The name org.freedesktop.login1 was not provided by any .service files
09:56:24 T:1118552688 DEBUG: UPower: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.UPower was not provided by any .service files
09:56:24 T:1118552688 DEBUG: Previous line repeats 1 times.
09:56:24 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:24 T:1118552688 NOTICE: No Devices found - retry: 5
09:56:26 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:26 T:1118552688 NOTICE: No Devices found - retry: 4
09:56:28 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:28 T:1118552688 NOTICE: No Devices found - retry: 3
09:56:30 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:30 T:1118552688 NOTICE: No Devices found - retry: 2
09:56:32 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:32 T:1118552688 NOTICE: No Devices found - retry: 1
09:56:34 T:1118552688 ERROR: CAESinkOSS::EnumerateDevicesEx - Failed to open mixer: /dev/mixer
09:56:34 T:1118552688 NOTICE: Found 0 Lists of Devices
09:56:34 T:1118552688 NOTICE: load settings...
09:56:34 T:1118552688 NOTICE: special://profile/ is mapped to: special://masterprofile/
09:56:34 T:1118552688 NOTICE: loading special://masterprofile/guisettings.xml
09:56:34 T:1118552688 NOTICE: Getting hardware information now...
09:56:34 T:1118552688 INFO: Using analog output
09:56:34 T:1118552688 INFO: AC3 pass through is enabled
09:56:34 T:1118552688 INFO: DTS pass through is enabled
09:56:34 T:1118552688 INFO: AAC pass through is disabled
09:56:34 T:1118552688 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
09:56:34 T:1118552688 NOTICE: special://xbmc/system/playercorefactory.xml does not exist. Skipping.
09:56:34 T:1118552688 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
09:56:34 T:1118552688 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
09:56:34 T:1118552688 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
09:56:34 T:1118552688 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
09:56:34 T:1118552688 NOTICE: Contents of special://profile/advancedsettings.xml are...

true
cputemp
gputemp

18


true


mysql
192.168.2.110
3306
xbmc
xbmc


mysql
192.168.2.110
3306
xbmc
xbmc


true
95
true
true
true


true


false

09:56:34 T:1118552688 WARNING: VIDEO database configuration is experimental.
09:56:34 T:1118552688 NOTICE: Getting hardware information now...
09:56:34 T:1118552688 INFO: Using analog output
09:56:34 T:1118552688 INFO: AC3 pass through is enabled
09:56:34 T:1118552688 INFO: DTS pass through is enabled
09:56:34 T:1118552688 INFO: AAC pass through is disabled
09:56:34 T:1118552688 NOTICE: Default DVD Player: dvdplayer
09:56:34 T:1118552688 NOTICE: Default Video Player: dvdplayer
09:56:34 T:1118552688 NOTICE: Default Audio Player: paplayer
09:56:34 T:1118552688 NOTICE: Disabled debug logging due to GUI setting. Level 0.
09:56:34 T:1118552688 NOTICE: Log level changed to 0
09:56:34 T:1118552688 NOTICE: Loading media sources from special://masterprofile/sources.xml
09:56:34 T:1118552688 ERROR: Missing or invalid and/or in source
09:56:34 T:1118552688 INFO: creating subdirectories
09:56:34 T:1118552688 INFO: userdata folder: special://masterprofile/
09:56:34 T:1118552688 INFO: recording folder:
09:56:34 T:1118552688 INFO: screenshots folder:
09:56:34 T:1118552688 INFO: thumbnails folder: special://masterprofile/Thumbnails
09:56:34 T:1118552688 INFO: load language info file: special://xbmc/language/English/langinfo.xml
09:56:34 T:1118552688 DEBUG: trying to set locale to en_US.UTF-8
09:56:34 T:1118552688 INFO: global locale set to en_US.UTF-8
09:56:34 T:1118552688 INFO: load English language file, from path: special://xbmc/language/
09:56:34 T:1118552688 DEBUG: POParser: PO file has Win Style Line Endings. Converted in memory to Linux LF for file: /mnt/user/xbmc/language/English/strings.po
09:56:34 T:1118552688 DEBUG: POParser: loaded 2686 strings from file /mnt/user/xbmc/language/English/strings.po
09:56:34 T:1118552688 INFO: CSoftAE::InternalOpenSink - sink incompatible, re-starting
09:56:34 T:1118552688 ERROR: CAESinkOSS::Initialize - Failed to open the audio device: /dev/dsp
09:56:34 T:1118552688 DEBUG: CSoftAE::InternalOpenSink - NULL Initialized:
09:56:34 T:1118552688 DEBUG: Output Device : Device not found
09:56:34 T:1118552688 DEBUG: Sample Rate : 44100
09:56:34 T:1118552688 DEBUG: Sample Format : AE_FMT_FLOAT
09:56:34 T:1118552688 DEBUG: Channel Count : 2
09:56:34 T:1118552688 DEBUG: Channel Layout: FL,FR
09:56:34 T:1118552688 DEBUG: Frames : 22000
09:56:34 T:1118552688 DEBUG: Frame Samples : 2
09:56:34 T:1118552688 DEBUG: Frame Size : 8
09:56:34 T:1118552688 DEBUG: CSoftAE::InternalOpenSink - Using speaker layout: 2.0
09:56:34 T:1118552688 DEBUG: CSoftAE::InternalOpenSink - Internal Buffer Size: 176000
09:56:34 T:1122413424 NOTICE: Thread CSoftAE start, auto delete: false
09:56:34 T:1122413424 INFO: CSoftAE::Run - Thread Started
09:56:35 T:1118552688 NOTICE: Running database version Addons15
09:56:35 T:1118552688 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/libcpluff-i486-linux.so)
09:56:35 T:1118552688 DEBUG: Loading: /usr/local/lib/xbmc/system/libcpluff-i486-linux.so
09:56:35 T:1118552688 INFO: ADDON: cpluff: 'Could not read plug-in directory /mnt/user/xbmc/portable_data/addons: No such file or directory'
09:56:35 T:1118552688 INFO: ADDON: cpluff: 'Could not read plug-in directory /usr/local/lib/xbmc/addons: No such file or directory'
09:56:35 T:1118552688 WARNING: LoadMappings - peripherals.xml does not exist
09:56:35 T:1118552688 DEBUG: UDisks: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.UDisks was not provided by any .service files
09:56:35 T:1118552688 DEBUG: DeviceKit.Disks: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.DeviceKit.Disks was not provided by any .service files
09:56:35 T:1118552688 DEBUG: Selected HAL as storage provider
09:56:35 T:1118552688 INFO: HAL: Starting initializing
[b]09:56:35 T:1118552688 ERROR: HAL: Failed to initialize hal context: (null)
09:56:35 T:1118552688 ERROR: HAL: no Hal context
09:56:35 T:1118552688 DEBUG: SECTION:LoadDLL(libcurl.so.4)
09:56:35 T:1118552688 DEBUG: Loading: libcurl.so.4[/b]
09:56:35 T:1118552688 NOTICE: Running database version Addons15
09:56:35 T:1118552688 DEBUG: Initialize, updating databases...
09:56:35 T:1118552688 NOTICE: Running database version ViewModes4
09:56:35 T:1118552688 NOTICE: Running database version Textures13
09:56:37 T:1118552688 NOTICE: Running database version MyMusic32
09:56:38 T:1118552688 NOTICE: Running database version MyVideos75
09:56:38 T:1118552688 NOTICE: Running database version TV22
09:56:38 T:1118552688 NOTICE: Running database version Epg7
09:56:38 T:1118552688 DEBUG: Initialize, updating databases... DONE
09:56:38 T:1118552688 NOTICE: initializing playlistplayer
09:56:38 T:1118552688 NOTICE: DONE initializing playlistplayer
09:56:38 T:1118552688 INFO: JSONRPC v6.0.3: Successfully initialized
09:56:38 T:1118552688 DEBUG: ADDON: Starting service addons.
09:56:38 T:1118552688 INFO: removing tempfiles
09:56:38 T:1118552688 DEBUG: ADDON: Starting service addons.
09:56:38 T:1118552688 NOTICE: initialize done
09:56:39 T:1125243760 NOTICE: Thread CVideoInfoScanner start, auto delete: false
09:56:39 T:1118552688 DEBUG: Process - no profile autoexec.py (/mnt/user/xbmc/portable_data/userdata/autoexec.py) found, skipping
09:56:39 T:1118552688 DEBUG: NetworkMessage - Starting network services
09:56:39 T:1118552688 NOTICE: ES: Starting event server
09:56:39 T:1118552688 INFO: JSONRPC Server: Successfully initialized
09:56:39 T:1118552688 DEBUG: CLastfmScrobbler: Clearing session.
09:56:39 T:1118552688 DEBUG: CLibrefmScrobbler: Clearing session.
09:56:39 T:1127394160 NOTICE: Thread CEventServer start, auto delete: false
09:56:39 T:1127394160 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
09:56:39 T:1127394160 NOTICE: UDP: Listening on port 9777
09:56:39 T:1125243760 NOTICE: VideoInfoScanner: Starting scan ..
09:56:39 T:1125243760 DEBUG: CAnnouncementManager - Announcement: OnScanStarted from xbmc
09:56:39 T:1125243760 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
09:56:39 T:1125243760 DEBUG: CAnnouncementManager - Announcement: OnScanFinished from xbmc
09:56:39 T:1129491312 NOTICE: Thread CTCPServer start, auto delete: false
09:56:39 T:1125243760 DEBUG: Thread CVideoInfoScanner 1125243760 terminating
09:59:38 T:1118552688 DEBUG: CAnnouncementManager - Announcement: OnScreensaverActivated from xbmc

[bobbintb]

that's possible plex could be interfering but not likely since the plugins are installed in alphabetical order. it's still worth trying to disable plex and see if it works.

 

also, why use plex and xbmc?

[mygoogoo]

also, why use plex and xbmc?

 

unRAID Ubiquity, of course. Some of us access our unRAID media remotely via Plex since XBMC is graphically intensive and runs poorly on remote devices.

 

For some users an iPhone or iPad Plex app, or a Roku device with Plex is less cost prohibitive than let's say a dedicated PC or Zotac ZBox.

[bobbintb]

right but why use them both? more the most part, each can do what the other can, so why install both of them?

[bnevets27]

right but why use them both? more the most part, each can do what the other can, so why install both of them?

 

http://wiki.xbmc.org/?title=Add-on%3APleXBMC

 

It is desirable to run both. Just learned this myself. Plex is definitely the best solution for accessing your library remotely, be it a phone, tablet, computer or XBMC remotely. Since it has transcoding which is a necessity when accessing files remotely (I know its not a necessity for all but most have bandwidth limitations)  XBMC doesn't have this capability ATM.

[CrashnBrn]

right but why use them both? more the most part, each can do what the other can, so why install both of them?

 

http://wiki.xbmc.org/?title=Add-on%3APleXBMC

 

It is desirable to run both. Just learned this myself. Plex is definitely the best solution for accessing your library remotely, be it a phone, tablet, computer or XBMC remotely. Since it has transcoding which is a necessity when accessing files remotely (I know its not a necessity for all but most have bandwidth limitations)  XBMC doesn't have this capability ATM.

 

Just my opinion of this. I tried PleXBMC and went back to just XBMC after a couple of days. As mentioned for transcoding Plex is great, but I lost so much functionality of my XBMC set up that I thought it wasn't worth it. Also Plex does it's own scraping unless you get a plug which forces it to scrape your data. After I had everything set up with Plex, I went right back to XBMC with a SQL DB and haven't looked back.

 

Though now if I look at my setup, it makes complete sense to have both Plex and XBMC running at the same time! Hmmmm, I need to stay off of the forums....