Posts: 5
Joined: Jan 2015
Reputation:
0
I have "Wake devices when deactivating screensaver" activated for convenience, so that I only have to push my remote/keyboard to start both my TV and sound system. But the problem is when I run your tool it will deactivate the screensaver. Is there any solution to this other than deactivate the setting and start my TV and sound manually?
Also.. If I have the Dim screensaver set the screen will be stuck at dimmed when changing profiles. My current solution to this is to have the Dim level at 0%
Posts: 152
Joined: Jan 2010
Reputation:
0
HI Milhouse,
I thought this might be the answer to my woes of missing/not locally cached artwork on my shared mysql clients. However when I run it locally on my ubuntu installation I get this.
~/.kodi/userdata$ ./texturecache.py c
Traceback (most recent call last):
File "./texturecache.py", line 7753, in <module>
main(sys.argv[1:])
File "./texturecache.py", line 7462, in main
if not checkConfig(argv[0]): sys.exit(2)
File "./texturecache.py", line 7043, in checkConfig
data = wcomms.sendJSON(REQUEST, "libPing", checkResult=False, useWebServer=True)
File "./texturecache.py", line 1866, in sendJSON
data = self.sendWeb("POST", "/jsonrpc", json.dumps(request), {"Content-Type": "application/json"}, timeout=timeout)
File "./texturecache.py", line 1834, in sendWeb
raise httplib.HTTPException("Remote web host requires webserver.username/webserver.password properties")
httplib.HTTPException: Remote web host requires webserver.username/webserver.password properties
I do not have a username or password set for the webserver. I can run the command with an 'nc' and it runs fine. But not when I ask it to cache missing artwork with just a 'c'
Any ideas. I tried downloading the cfg file and putting the username and password fields in. I also tried putting a username and password in the webserver config in Kodi and the cfg file to no avail.
I am running it from the ~/.kodi/userdata directory.
Any help appreciated
Cheers
Spart
6 x Raspberry Pi Model B & B+ Pi2 & 3 Zotac Mag Ubuntu 14.04.1 - Ubuntu 14.04.1 Test Machine Kodi Nightly -
RocketNAS 8TB Usable Raid 6 Ubuntu 14.04.1 RocketNAS Build
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
2015-04-03, 20:26
(This post was last modified: 2015-04-03, 20:29 by Milhouse.)
It looks like lastusetime isn't a valid filter for the Textures API, I'll need to look into this further.
In the meantime you should be able to get your query to work by using SQL direct access - add @dbjson=no to your command line. Note that the filter you are using is a date/time string so you will need to use a range, eg. "where lastusetime <= '2015-01-01', as matching on exactly '2015-01-01' is never going to find any rows.
Also note the parser is very basic and requires white space between each term. If you get unusual/unexpected results check the logfile to confirm the correct query is being executed.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 39
Joined: May 2012
Reputation:
3
Thanks a lot, seems to return lots of results now.
What would be the corresponding command to erase all of those?
[/align]
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
See first post, parse the row ids and use the "d" option.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 8
Joined: Aug 2012
Reputation:
0
Does the JSON API allow the script to query or delete without having direct access to SQL? the reason I ask is that I have an unrooted Fire TV which does not allow me to run the script directly on the box, nor does it allow me direct access to the thumbnail folder ( no way to mount it ) if so how would I go about this? would I need something special in my cfg file for this?
If not are there other folks with unrooted Fire TV's and how do you handle it when the thumbnails start to take up too much space on the device
Thanks in advance for your help! I use this script on my Windows boxes all of the time
Posts: 8
Joined: Aug 2012
Reputation:
0
Thanks Milhouse,
Until they figure out how to root the Fire Tv, in the mean time, what do you think I should do if the thumbnail folder gets to big, can I just delete the thumbnail folder and some database within Kodi ( if so what is the name of the database ) and then recache everything with the script? I typically have a lot of shows coming and going so I know there are leftover thumbs and images and the Fire TV does not have a ton of space to waste.
Of course my ideal situation is they figure out how to root the device and allow your script to the do the work as it does on my windows boxes
Thanks again