Windows install troubleshooting

[thereddestdog]

So I have been using the original GitLab script for years, but I think it broke when I upgraded Sonarr to v4.. No problem, I found this project. But when I execute it, I get this error:

I am trying to run it on Windows, are the updates to work with Docker only or something?

[thereddestdog]

Also, how can this script be called in Sonarr v4 since Arguments have been removed?

[thereddestdog]

Going to document my findings here....

OK so I needed to have Python3 installed. That fixed the above syntax error.

However, then I got a different error:

I then needed to install additional Python3 components: requests, and flask

C:\sonarr-episode-trimmer>"C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py" --config config.ini --list-series
Traceback (most recent call last):
  File "C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py", line 9, in <module>
    import requests
ModuleNotFoundError: No module named 'requests'

C:\sonarr-episode-trimmer>cd "C:\Program Files (x86)\Python313-32"

C:\Program Files (x86)\Python313-32>cd "C:\Program Files (x86)\Python313-32\Scripts"

C:\Program Files (x86)\Python313-32\Scripts>pip3 install requests
Collecting requests
  Downloading requests-2.32.3-py3-none-any.whl.metadata (4.6 kB)
Collecting charset-normalizer<4,>=2 (from requests)
  Downloading charset_normalizer-3.4.0-cp313-cp313-win32.whl.metadata (34 kB)
Collecting idna<4,>=2.5 (from requests)
  Downloading idna-3.10-py3-none-any.whl.metadata (10 kB)
Collecting urllib3<3,>=1.21.1 (from requests)
  Downloading urllib3-2.2.3-py3-none-any.whl.metadata (6.5 kB)
Collecting certifi>=2017.4.17 (from requests)
  Downloading certifi-2024.8.30-py3-none-any.whl.metadata (2.2 kB)
Downloading requests-2.32.3-py3-none-any.whl (64 kB)
Downloading certifi-2024.8.30-py3-none-any.whl (167 kB)
Downloading charset_normalizer-3.4.0-cp313-cp313-win32.whl (94 kB)
Downloading idna-3.10-py3-none-any.whl (70 kB)
Downloading urllib3-2.2.3-py3-none-any.whl (126 kB)
Installing collected packages: urllib3, idna, charset-normalizer, certifi, requests
  WARNING: The script normalizer.exe is installed in 'C:\Program Files (x86)\Python313-32\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
Successfully installed certifi-2024.8.30 charset-normalizer-3.4.0 idna-3.10 requests-2.32.3 urllib3-2.2.3

C:\Program Files (x86)\Python313-32\Scripts>"C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py" --config config.ini --list-series
Traceback (most recent call last):
  File "C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py", line 12, in <module>
    from flask import Flask, request, jsonify
ModuleNotFoundError: No module named 'flask'

C:\Program Files (x86)\Python313-32\Scripts>pip3 install flask
Collecting flask
  Downloading flask-3.0.3-py3-none-any.whl.metadata (3.2 kB)
Collecting Werkzeug>=3.0.0 (from flask)
  Downloading werkzeug-3.0.6-py3-none-any.whl.metadata (3.7 kB)
Collecting Jinja2>=3.1.2 (from flask)
  Downloading jinja2-3.1.4-py3-none-any.whl.metadata (2.6 kB)
Collecting itsdangerous>=2.1.2 (from flask)
  Downloading itsdangerous-2.2.0-py3-none-any.whl.metadata (1.9 kB)
Collecting click>=8.1.3 (from flask)
  Downloading click-8.1.7-py3-none-any.whl.metadata (3.0 kB)
Collecting blinker>=1.6.2 (from flask)
  Downloading blinker-1.8.2-py3-none-any.whl.metadata (1.6 kB)
Collecting colorama (from click>=8.1.3->flask)
  Downloading colorama-0.4.6-py2.py3-none-any.whl.metadata (17 kB)
Collecting MarkupSafe>=2.0 (from Jinja2>=3.1.2->flask)
  Downloading MarkupSafe-3.0.2-cp313-cp313-win32.whl.metadata (4.1 kB)
Downloading flask-3.0.3-py3-none-any.whl (101 kB)
Downloading blinker-1.8.2-py3-none-any.whl (9.5 kB)
Downloading click-8.1.7-py3-none-any.whl (97 kB)
Downloading itsdangerous-2.2.0-py3-none-any.whl (16 kB)
Downloading jinja2-3.1.4-py3-none-any.whl (133 kB)
Downloading werkzeug-3.0.6-py3-none-any.whl (227 kB)
Downloading MarkupSafe-3.0.2-cp313-cp313-win32.whl (15 kB)
Downloading colorama-0.4.6-py2.py3-none-any.whl (25 kB)
Installing collected packages: MarkupSafe, itsdangerous, colorama, blinker, Werkzeug, Jinja2, click, flask
  WARNING: The script flask.exe is installed in 'C:\Program Files (x86)\Python313-32\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
Successfully installed Jinja2-3.1.4 MarkupSafe-3.0.2 Werkzeug-3.0.6 blinker-1.8.2 click-8.1.7 colorama-0.4.6 flask-3.0.3 itsdangerous-2.2.0

C:\Program Files (x86)\Python313-32\Scripts>"C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py" --config config.ini --list-series
None/api/v3/series
Traceback (most recent call last):
  File "C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py", line 231, in <module>
    series = api_request("series")
  File "C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py", line 73, in api_request
    r = requests.request(method, url, params=params)
  File "C:\Program Files (x86)\Python313-32\Lib\site-packages\requests\api.py", line 59, in request
    return session.request(method=method, url=url, **kwargs)
           ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Program Files (x86)\Python313-32\Lib\site-packages\requests\sessions.py", line 575, in request
    prep = self.prepare_request(req)
  File "C:\Program Files (x86)\Python313-32\Lib\site-packages\requests\sessions.py", line 484, in prepare_request
    p.prepare(
    ~~~~~~~~~^
        method=request.method.upper(),
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ...<10 lines>...
        hooks=merge_hooks(request.hooks, self.hooks),
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Program Files (x86)\Python313-32\Lib\site-packages\requests\models.py", line 367, in prepare
    self.prepare_url(url, params)
    ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "C:\Program Files (x86)\Python313-32\Lib\site-packages\requests\models.py", line 438, in prepare_url
    raise MissingSchema(
    ...<2 lines>...
    )
requests.exceptions.MissingSchema: Invalid URL 'None/api/v3/series': No scheme supplied. Perhaps you meant https://None/api/v3/series?

[jonfairbanks]

Converting this to a discussion as I do not see any code-level bugs/issues called out here. This seems to be related to environment setup.

[jonfairbanks]

requests.exceptions.MissingSchema: Invalid URL 'None/api/v3/series': No scheme supplied. Perhaps you meant https://None/api/v3/series?

Did you create a config file? The URL for your Sonarr instance is not set.

[thereddestdog]

I do have a config file named config.ini and this is its contents:

[API]
url = http://192.168.86.230:8989
key = #########
api_version = v3

[Series]
thelateshowwithstephencolbert = 5
realtimewithbillmaher = 5
saturdaynightlive = 5
lastweektonightwithjohnoliver = 5
jeopardy = 25
thedailyshow = 21

I see now that it needs to be named settings.config, but I get the same Invalid URL when I changed the name

[thereddestdog]

I am executing "C:\sonarr-episode-trimmer\sonarr-episode-trimmer.py" --config settings.config --list-series, but it looks like even when I don't add the arguments I am getting the same URL error, as if the arguments are not being passed in

[jonfairbanks]

Try --config "C:/Full/Path/To/Your/settings.config" or alternatively use Docker for Windows to setup the container.

[thereddestdog]

Hah! Yes I was executing from the wrong directory! I was finally able to get results with --list-series, but when I run without that argument, no files are actually deleted nor unmonitored

C:\sonarr-episode-trimmer>sonarr-episode-trimmer.py --config settings.config --debug
http://192.168.86.230:8989/api/v3/series
2024-10-29 18:05:11,837 DEBUG    Starting new HTTP connection (1): 192.168.86.230:8989
2024-10-29 18:05:12,013 DEBUG    http://192.168.86.230:8989 "GET /api/v3/series?apikey=b7fff6b319c84d03abd369bed85d5bb2 HTTP/11" 200 None
2024-10-29 18:05:12,025 INFO     Processing: Real Time with Bill Maher
2024-10-29 18:05:12,025 DEBUG    68: 5
http://192.168.86.230:8989/api/v3/episode
2024-10-29 18:05:12,028 DEBUG    Starting new HTTP connection (1): 192.168.86.230:8989
2024-10-29 18:05:12,049 DEBUG    http://192.168.86.230:8989 "GET /api/v3/episode?seriesId=68&apikey=b7fff6b319c84d03abd369bed85d5bb2 HTTP/11" 200 None
2024-10-29 18:05:12,065 DEBUG    # of episodes downloaded: 5
2024-10-29 18:05:12,066 DEBUG    # of episodes to delete: 0
2024-10-29 18:05:12,066 DEBUG    # of episodes monitored: 8
2024-10-29 18:05:12,067 INFO     Unmonitoring old episodes:
2024-10-29 18:05:12,068 INFO     Processing: Saturday Night Live
2024-10-29 18:05:12,068 DEBUG    74: 5
http://192.168.86.230:8989/api/v3/episode
2024-10-29 18:05:12,070 DEBUG    Starting new HTTP connection (1): 192.168.86.230:8989
2024-10-29 18:05:12,098 DEBUG    http://192.168.86.230:8989 "GET /api/v3/episode?seriesId=74&apikey=b7fff6b319c84d03abd369bed85d5bb2 HTTP/11" 200 None
2024-10-29 18:05:12,119 DEBUG    # of episodes downloaded: 4
2024-10-29 18:05:12,120 DEBUG    # of episodes to delete: 0
2024-10-29 18:05:12,120 DEBUG    # of episodes monitored: 5
2024-10-29 18:05:12,121 INFO     Unmonitoring old episodes:
2024-10-29 18:05:12,122 INFO     Processing: Last Week Tonight with John Oliver
2024-10-29 18:05:12,122 DEBUG    76: 5
http://192.168.86.230:8989/api/v3/episode
2024-10-29 18:05:12,124 DEBUG    Starting new HTTP connection (1): 192.168.86.230:8989
2024-10-29 18:05:12,133 DEBUG    http://192.168.86.230:8989 "GET /api/v3/episode?seriesId=76&apikey=b7fff6b319c84d03abd369bed85d5bb2 HTTP/11" 200 None
2024-10-29 18:05:12,139 DEBUG    # of episodes downloaded: 5
2024-10-29 18:05:12,140 DEBUG    # of episodes to delete: 0
2024-10-29 18:05:12,140 DEBUG    # of episodes monitored: 8
2024-10-29 18:05:12,142 INFO     Unmonitoring old episodes:
2024-10-29 18:05:12,143 INFO     Processing: Jeopardy!
2024-10-29 18:05:12,145 DEBUG    259: 25

It appears like the first series of the script, the url isn't generated correctly either

[thereddestdog]

OK I got it working finally!

I do think there's an issue with the --debug output above in the way it's displaying the created URLs, but executing the script is working for me. 🤷

So for future reference:

• Install Python3
• Install requests module via C:\Program Files (x86)\Python313-32\Scripts>pip3 install requests command
• Install flask module via C:\Program Files (x86)\Python313-32\Scripts>pip3 install flask command

I abandoned the idea of executing the script via Sonarr in the Connections section. Instead I am using Windows Task Scheduler to run daily at 4am. This setting is important for it to execute properly: