could not unmarshal json from script output: EOF

[nshybrid]

I've set up the database using a docker container for postgres:17.2-bookworm on port 25432. I loaded the data manually using DBeaver and Execute script. I'm able to query the DB using DBeaver and get the right result:

select *
from derived_video dv
where dv.dvd_id = 'JUR-013';

I updated my *.py file to the below (removed my local ip):
conn = psycopg2.connect(database="r18",
host="192.168.x.x",
user="postgres",
password="postgres",
port="25432")

However, when scraping on my stashapp, I get an error saying "could not unmarshal json from script output: EOF". Which leads me to think either the JSON is malformed or there's no response. Any way I can check logs?

[javstash]

Yes, check Settings -> Logs, the scraper should print out something like this

[Scrape / R18dev_SQL] CONTENT ID: jur013 @ %
[Scrape / R18dev_SQL] sceneByName | DVD CODE: JUR-013
[Scrape / R18dev_SQL] DVD CODE: JUR-013  ->  jur013 @ mono
[Scrape / R18dev_SQL] {"name": "JUR-013"} @ sceneByName

[nshybrid]

Posting the resolution here, in case anyone else finds it.
I checked the logs and saw:

ERRO[2025-02-04 18:46:02] [Scrape / R18dev_SQL]   File "/root/.stash/scrapers/custom/R18dev_SQL/R18dev_SQL.py", line 3, in <module> 
ERRO[2025-02-04 18:46:02] [Scrape / R18dev_SQL]     import psycopg2    
ERRO[2025-02-04 18:46:02] [Scrape / R18dev_SQL] ModuleNotFoundError: No module named 'psycopg2' 
ERRO[2025-02-04 18:46:02] could not unmarshal json from script output: EOF 
ERRO[2025-02-04 18:46:02] scrapeSingleScene: input: scrapeSingleScene scraper R18dev_SQL: could not unmarshal json from script output: EOF 
2025-02-04T18:46:02.223771124-05:00 INF Response: 200 OK httpRequest={"proto":"HTTP/1.1","remoteIP":"192.168.0.84:62721","requestID":"0a5c8154a96b/Be1QSLXioh-000011","requestMethod":"POST","requestPath":"/graphql","requestURL":"http://192.168.0.8:6969/graphql"} httpResponse={"bytes":140,"elapsed":27.722826,"status":200} service=stash```

I then ran `pip install psycopg2-binary --break-system-packages` and my issue was resolved!