Environment Variables
| Variable | Status |
|---|
| FLASK_SECRET_KEY |
MISSING |
| SUPABASE_URL |
MISSING |
| SUPABASE_KEY |
MISSING |
| SUPABASE_BUCKET |
MISSING |
| SMTP_HOST |
MISSING |
| SMTP_PORT |
MISSING |
| SMTP_USER |
MISSING |
| SMTP_PASSWORD |
MISSING |
| SMTP_FROM |
MISSING |
| APP_BASE_URL |
MISSING |
| PORT |
set |
All variables marked MISSING must be set in your Render dashboard:
Render → your service → Environment. After adding them, do a manual deploy
(Render → Manual Deploy → Clear build cache & deploy).
Pipeline Module
Pipeline imported successfully.
Supabase / Database
| Check | Result |
|---|
| supabase package imported |
Yes
|
| SUPABASE_URL |
MISSING
|
| SUPABASE_KEY |
MISSING
|
| Storage bucket |
pipeline-results |
| Live connection test |
Not tested (missing URL or KEY)
|
SUPABASE_URL and SUPABASE_KEY are not set in Render → Environment.
"Supabase is connected" on the Supabase dashboard only means the project is live —
the app still needs the URL and service_role key as environment variables on Render.
Get them from: Supabase dashboard → Project Settings → API →
Project URL and service_role key (NOT the anon key).
Paste both into Render → Environment.
Email / SMTP
| Check | Result |
|---|
| Configured |
NO
|
| SMTP_HOST | (missing) |
| SMTP_PORT | (missing) |
| SMTP_USER |
MISSING
|
| SMTP_PASSWORD |
MISSING
|
| SMTP_FROM | Pharmacophore Pipeline |
| APP_BASE_URL |
(missing — email links will point to localhost)
|
SMTP_USER and SMTP_PASSWORD must be set in Render → Environment.
For Gmail: enable 2FA, then create a 16-char App Password at
myaccount.google.com/apppasswords.
Set SMTP_USER to your Gmail address and SMTP_PASSWORD to the 16-char app password (no spaces).
APP_BASE_URL is missing — email links will point to localhost.
Set it to your Render URL (e.g., https://pharmqsar.onrender.com).
Summary
| Component | Status | Fix |
|---|
| Database (Supabase) |
NOT working
|
Set SUPABASE_URL + SUPABASE_KEY (service_role) in Render → Environment
|
| Email (SMTP) |
NOT configured
|
Set SMTP_USER + SMTP_PASSWORD in Render → Environment
|
After changing environment variables in Render, you must create a new deploy
(Manual Deploy → Clear build cache & deploy) for the changes to take effect.