✋｜help

Django app deployment crashes due to cffi and libffi

Llionel6651

9/6/2023

Trying to deploy a Django app to Railway.
After it builds successfully the deployment crashes with this error:

#10 378.9         Running setup.py install for cffi: started
#10 378.9         Running setup.py install for cffi: finished with status 'error'
#10 378.9         error: subprocess-exited-with-error
#10 378.9
#10 378.9         × Running setup.py install for cffi did not run successfully.
#10 378.9         │ exit code: 1
#10 378.9         ╰─> [60 lines of output]
#10 378.9             Package libffi was not found in the pkg-config search path.
#10 378.9             Perhaps you should add the directory containing

libffi.pc'
#10 378.9 to the PKG_CONFIG_PATH environment variable
#10 378.9 No package 'libffi' found`

Llionel6651

9/6/2023

4ad98339-d4b3-47d9-973d-7162b5b5fd9f

Bbrody192

9/6/2023

please provide full build logs
https://bookmarklets.up.railway.app/log-downloader/

Tthallescomh

9/6/2023

cool tool brody

Bbrody192

9/6/2023

thamks

Llionel6651

9/7/2023

Llionel6651

9/7/2023

there was attempt as well.

Llionel6651

9/7/2023

Llionel6651

9/7/2023

mysqlclient is in the requirements.txt

Bbrody192

9/7/2023

it wants MySQLdb though

Llionel6651

9/11/2023

thanks that fixed that one
what about the cffi error in this log?

Llionel6651

9/11/2023

Bbrody192

9/11/2023

send your railway.json please

Llionel6651

9/11/2023

Bbrody192

9/11/2023

give this a try

{
  "$schema": "https://schema.up.railway.app/railway.schema.json",
  "build": {
    "builder": "NIXPACKS",
    "nixpacksPlan": {
      "providers": ["python"],
      "phases": {
        "setup": {
          "nixPkgs": ["...", "nodejs", "libffi"]
        },
        "ci": {
          "dependsOn": ["setup"],
          "cmds": ["npm ci"]
        }
      }
    }
  },
  "deploy": {
    "numReplicas": 1,
    "startCommand": "python3 manage.py migrate && python3 manage.py collectstatic --no-input && gunicorn readinghood.wsgi",
    "restartPolicyType": "ON_FAILURE",
    "restartPolicyMaxRetries": 10
  }
}

Llionel6651

9/11/2023

Llionel6651

9/11/2023

still not working

Bbrody192

9/11/2023

send your requirements.txt please

Llionel6651

9/12/2023

Bbrody192

9/12/2023

does your project use every one of those modules?

Llionel6651

9/12/2023

probably not

Bbrody192

9/12/2023

please remove everything you are not using, let me know when thats done

Llionel6651

9/12/2023

kk
one second sorry
I have a question actually. Why is it still installing packages on an old version of requirements? I have changed the requirements.txt file so it shouldn't be doing that right?

Bbrody192

9/12/2023

does the repo have the correct requirements.txt in it?

Llionel6651

9/12/2023

yep
anyway. it's somewhat working now. I think there's an issue with my database, as I can't run it locally after some changes
will have to fix that first
build logs are fine, but deploy logs get stuck on accessing database
will get back to you
thanks so far

Bbrody192

9/12/2023

do you use a railway hosted database?

Llionel6651

9/12/2023

yeah
postgres

Bbrody192

9/12/2023

can i see a screenshot of your service variables please

Llionel6651

9/12/2023

what's that?

Bbrody192

9/12/2023

the variables for the railway service

Llionel6651

9/12/2023

Bbrody192

9/12/2023

sorry thats not what i asked for

Llionel6651

9/12/2023

these ones?

Bbrody192

9/12/2023

that is a plugin
i asked for the service variables

Llionel6651

9/12/2023

Llionel6651

9/12/2023

this one?

Bbrody192

9/12/2023

yes
you should be using a reference variable, please delete that variable and replace it with a reference variable
https://docs.railway.app/develop/variables#reference-variables

Llionel6651

9/12/2023

Llionel6651

9/12/2023

which one should i use for postgresql?

Bbrody192

9/12/2023

the same one you where already using, just this time its a reference

Llionel6651

9/12/2023

like this?

Llionel6651

9/12/2023

Bbrody192

9/12/2023

not at all
https://docs.railway.app/develop/variables#reference-variables
https://docs.railway.app/develop/variables#plugin-variables
please read

Llionel6651

9/12/2023

this way?

Bbrody192

9/12/2023

not at all
can you please read the docs sections i linked

Llionel6651

9/12/2023

Llionel6651

9/12/2023

Bbrody192

9/12/2023

can you please read the docs sections i linked

Llionel6651

9/12/2023

Bbrody192

9/12/2023

there we go
now please show me your code that connects to the database

Llionel6651

9/12/2023

Bbrody192

9/12/2023

you are still using sqlite
you will need to add the rest of the pstgres reference variables to your service and then configure your settings.py like this
https://github.com/railwayapp-templates/django/blob/main/mysite/settings.py#L81

Llionel6651

9/12/2023

Bbrody192

9/12/2023

looks fine at first glance

Llionel6651

9/12/2023

so it works, but there's an issue with my code
so its not working
if that makes sense
ahah

Bbrody192

9/12/2023

whats your start command

Llionel6651

9/12/2023

python3 manage.py migrate && python3 manage.py collectstatic --no-input && gunicorn readinghood.wsgi

Bbrody192

9/12/2023

also looks good

Llionel6651

9/12/2023

yeah its my code
i was using a mysql database
and it was working

Bbrody192

9/12/2023

it was using sqlite not mysql

Llionel6651

9/12/2023

yeah i changed to sqlite to use the mdn tutorial
doesnt seem to work using sqlite nor postgres

Bbrody192

9/12/2023

whats not working

Llionel6651

9/12/2023

will retry with mysql and get back to you
"django.db.utils.ProgrammingError: relation "book" does not exist
LINE 1: SELECT DISTINCT "book"."Category" FROM "book""

Bbrody192

9/12/2023

stay with postgres, mysql is costly

Llionel6651

9/12/2023

Llionel6651

9/12/2023

Bbrody192

9/12/2023

just looks like a code issue to me tbh

Llionel6651

9/12/2023