BosseJ wrote:
> A clear improvement: I can create a playlist in LMSplaylist based on
> Essentia attributes! I could also see that my earlier uploads did leave
> traces in the database:
>
> >
Code:
--------------------
> > root@linux2:~# sqlite3 /var/lib/squeezeboxserver/cache/persist.db
> SQLite version 3.11.0 2016-02-15 17:29:24
> Enter ".help" for usage hints.
> sqlite> select count(*) from essentia_tracks;
> 237
--------------------
> >
>
> From the server log when listing attributes and searching for "non
> danceable"tracks:
>
> >
Code:
--------------------
> > [17-11-29 20:28:18.0226]
Plugins::LMSessentiaIntegration::Plugin::handleJSONP (191) handleJSONP
args={'cmd' => 'getTrackAttributesAsTree'}
> [17-11-29 20:28:18.0229]
Plugins::LMSessentiaIntegration::Plugin::getTrackAttributesAsTree (692) node =
> [17-11-29 20:28:18.2992]
Plugins::LMSessentiaIntegration::Plugin::handleJSONP (281) processing
time=0.276252
> [17-11-29 20:28:40.4979]
Plugins::LMSessentiaIntegration::Plugin::handleJSONP (191) handleJSONP
args={'dbAtts' => [],'dbSearch' => [],'cmd' => 'getTracksByParams','player' =>
'','essAtts' => [{'value' => 'not_danceable','attrib' => 'danceability'}]}
> [17-11-29 20:28:40.4983]
Plugins::LMSessentiaIntegration::Plugin::getTracksByParams (584) track search
page 0, 500, 1 DBsearchs=[] DBatt=[] ESSatt=[{'value' =>
'not_danceable','attrib' => 'danceability'}]
> [17-11-29 20:28:40.4986]
Plugins::LMSessentiaIntegration::Plugin::getTracksByParams (593)
getTracksByParams where final={}
> [17-11-29 20:28:40.4988]
Plugins::LMSessentiaIntegration::Plugin::getTracksByParams (607) final DB
atts={'prefetch' => ['persistent','album','primary_artist'],'page' =>
'1','rows' => '500'}
> [17-11-29 20:28:40.4991]
Plugins::LMSessentiaIntegration::Plugin::getUrlMD5byValues (514) essAttribToSQL
atts=[{'value' => 'not_danceable','attrib' => 'danceability'}]
> [17-11-29 20:28:40.4993]
Plugins::LMSessentiaIntegration::Plugin::getUrlMD5byValues (525) sql=select
urlmd5 from essentia_tracks where id in (select etrackid from essentia_values
where ( attrib='danceability' and value='not_danceable') group by etrackid
having count(etrackid)=1 )
> [17-11-29 20:28:41.9162]
Plugins::LMSessentiaIntegration::Plugin::handleJSONP (281) processing
time=1.417773
>
--------------------
> >
>
> Still can't see any numbers in the webgui though, but now I know it
> works to upload and retrieve values from the database. Excellent,
> thank you :-)
> I'll upload the rest of the files shortly.
After loading all analyzed tracks (23077 json-files) resulting in 22002
entries in the database (upload went smooth AFAICT), i still can't see
anything in the webgui. Unfortunately the popup for Essentia attributes
in the LMSplaylist editor is also empty now :-(. Below is the
corresponding server.log entry:
Code:
--------------------
[17-11-30 17:09:16.1569]
Plugins::LMSessentiaIntegration::Plugin::handleJSONP (191) handleJSONP
args={'cmd' => 'getTrackAttributesAsTree'}
[17-11-30 17:09:16.1575]
Plugins::LMSessentiaIntegration::Plugin::getTrackAttributesAsTree (692) node =
[17-11-30 17:10:13.5804] Plugins::LMSessentiaIntegration::Plugin::handleJSONP
(281) processing time=57.422971
[17-11-30 17:10:13.6231]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (299) publisher for
piCorePlayer PID Proc::Background=HASH(0xa6197a0) will be terminated.
[17-11-30 17:10:13.6325]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (299) publisher for
piCorePlayerDigi PID Proc::Background=HASH(0xa1b46a0) will be terminated.
[17-11-30 17:10:13.6394]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (299) publisher for
Touch Vardagsrum PID Proc::Background=HASH(0xaa5b340) will be terminated.
[17-11-30 17:10:13.6454]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (299) publisher for
Touch Arbetsrum PID Proc::Background=HASH(0xa8b0458) will be terminated.
[17-11-30 17:10:13.6610] Plugins::ShairTunes2W::Plugin::publishPlayer (375)
start avahi-publish-service "piCorePlayerDigi"
[17-11-30 17:10:13.8138]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (291) create client
Slim::Player::SqueezePlay=ARRAY(0x7386588) with proc
Proc::Background=HASH(0xa8fbe68)
[17-11-30 17:10:13.8222] Plugins::ShairTunes2W::Plugin::publishPlayer (375)
start avahi-publish-service "piCorePlayer"
[17-11-30 17:10:13.8971]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (291) create client
Slim::Player::SqueezePlay=ARRAY(0xa25f720) with proc
Proc::Background=HASH(0x9248a68)
[17-11-30 17:10:13.9417] Plugins::ShairTunes2W::Plugin::publishPlayer (375)
start avahi-publish-service "Touch Vardagsrum"
[17-11-30 17:10:14.0124]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (291) create client
Slim::Player::SqueezePlay=ARRAY(0x76028d0) with proc
Proc::Background=HASH(0xa57ddb8)
[17-11-30 17:10:14.0269] Plugins::ShairTunes2W::Plugin::publishPlayer (375)
start avahi-publish-service "Touch Arbetsrum"
[17-11-30 17:10:14.0944]
Plugins::ShairTunes2W::Plugin::playerSubscriptionChange (291) create client
Slim::Player::SqueezePlay=ARRAY(0x97a9210) with proc
Proc::Background=HASH(0xb0dc878)
--------------------
(I left in the recreation of my players that were immediately triggered
after loading the attributes table; probably not significant though...)
Wrt to the question of what perl-version my server has, here's the
server info in LMS:
Code:
--------------------
Logitech Media Server Version: 7.9.1 - 1511211491 @ Tue Nov 21 09:20:44 UTC
2017
Värdnamn: linux2
Serverns IP-adress: 192.168.20.3
HTTP-serverns portnummer: 9000
Operativsystem: Debian - SV - utf8
Plattformsarkitektur: x86_64-linux
Perl-version: 5.22.1 - x86_64-linux-gnu-thread-multi
Audio::Scan: 0.95
Databasversion: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Totalt antal anslutna spelare: 6
--------------------
OS-information:
Code:
--------------------
root@linux2:~# uname -a
Linux linux2 4.4.0-101-generic #124-Ubuntu SMP Fri Nov 10 18:29:59 UTC 2017
x86_64 x86_64 x86_64 GNU/Linux
root@linux2:~# cat /etc/issue.net
Ubuntu 16.04.3 LTS
--------------------
The server itself has 10+ year old HW but was fully wiped and
reinstalled late 2012 (with Ubuntu 12.04LTS) and upgraded to 14.04LTS
and 16.04LTS in 2014 and 2016, respectively. Fully updated since the
beginning. I haven't installed any separate Perl versions AFAIR.
I tried to look in the code but I have very little knowledge of perl and
the indirections (I think) via LMS Slim perl makes it difficult for me
to trace via code reading only. I gave up that path, realizing my
shortcomings :-)
I am not sure exactly how to proceed, but I am thinking of installing
and starting another LMS on another machine, starting from fresh and
only installing LMSessentia, ext4gui and LMSplaylisteditor to ensure
there's no interference from any other plugin. If that works I can add
back the plugins I use on the production machine until something breaks
(hopefully).
This will take some time though ...
Thank you for your efforts so far! Your plugin has great potential I
think and once I get the issues sorted out I'm looking forward to train
some extra genres :-)
Best regards & Thank you again /Bosse
------------------------------------------------------------------------
BosseJ's Profile: http://forums.slimdevices.com/member.php?userid=67378
View this thread: http://forums.slimdevices.com/showthread.php?t=108278
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
