Hiya, as of this morning, my deployments of my RedwoodJS/Node API have been failing on the build step, due to what seems like Python being missing and needed by node-gyp.
==> Running build command 'corepack enable && yarn install && yarn rw build api'...
[...]
better-sqlite3@npm:8.6.0 STDERR gyp ERR! stack Error: Could not find any Python installation to use
The strange thing is, this was working just fine as of this morning, and I haven’t made any infra changes.
Looking at an older (successful) deployment, it looks like previously it was able to find an old version of Python: better-sqlite3@npm:8.6.0 STDERR gyp info find Python using Python version 3.7.3 found at "/usr/bin/python3"
I’ve tried running this as a Python environment (since from other posts, node is also available), but then it fails trying to unlink pnpm:
Just for troubleshooting purposes, could you add which python && ... to the beginning of your build command, and let me know what that prints to your logs.
Just to confirm, are you trying to create a new database, and thedatabaseName is being ignored? Setting a databaseName will not re-name an existing database.
I opened a support ticket internally for this, so I don’t want to double the work (account under the same email). But the problem that started yesterday is I had:
Up until yesterday morning, this caused DATABASE_URL to be postgresql://user:password@host:port/dbname
However after yesterday morning, it’s now postgresql://user:password@host:port/my_database (e.g. the default database for the postgres instance).
In the support ticket though they said that databaseName is only used for creating the database, and not for connection strings. It sounds like fromDatabase doesn’t reference the databases section, so I have to construct the DATABASE_URL manually.