Can't deploy fresh Remix app

1

Hi,

I’d like to develop a new project using Remix & Fly. I’ve created a new project with remix, and selected the Fly.io hosting template.

Trying to deploy the app failed (or at least does not go till the end I presume)

➜ main ✗ flyctl launch
Creating app in ********
Scanning source code
Detected a Dockerfile app
? App Name (leave blank to use an auto-generated name): ********
Automatically selected personal organization: ********
? Select region: fra (Frankfurt, Germany)
Created app ******** in organization personal
Wrote config file fly.toml
? Would you like to setup a Postgresql database now? Yes
For pricing information visit: https://fly.io/docs/about/pricing/#postgresql-clusters
? Select configuration: Development - Single node, 1x shared CPU, 256MB RAM, 1GB disk
Creating postgres cluster ******** in organization personal
Postgres cluster ******** created
  Username:    postgres
  Password:    ********
  Hostname:    ********
  Proxy Port:  5432
  PG Port: 5433
Save your credentials in a secure place, you won't be able to see them again!

Monitoring Deployment

v0 is being deployed

It is stuck on “v0 is being deployed”. Any help would be greatly appreciated :slight_smile:

2

I’ve restarted my laptop (for other reasons!) and did try again. Now it goes further, but still have an issue:

Monitoring Deployment

1 desired, 1 placed, 1 healthy, 0 unhealthy [health checks: 3 total, 3 passing]
--> v0 deployed successfully

Connect to postgres
Any app within the personal organization can connect to postgres using the above credentials and the hostname "order-db.internal."
For example: postgres://postgres:0565d3773ce4bba4daf40c4c37833ff1847e2a762f4080b0@order-db.internal:5432

See the postgres docs for more information on next steps, managing postgres, connecting from outside fly:  https://fly.io/docs/reference/postgres/
Running flyadmin database-list
Error Failed attaching order-db to the Postgres cluster order: error connecting to SSH server: ssh: handshake failed: ssh: unable to authenticate, attempted methods [none publickey], no supported methods remain.\nTry attaching manually with 'fly postgres attach --app order --postgres-app order-db'


➜  order main ✗ fly postgres attach --app order --postgres-app order-db
Running flyadmin database-list
Running flyadmin user-list
Running flyadmin database-create
Error executing database-create: ERROR: syntax error at or near "order" (SQLSTATE 42601)

I’m starting to think “order” is perhaps a keyword I should not use to name my project :sweat_smile:

3

Long story short, do not use keyword like “select”, “order” and other sensible keywords as your project name, it will not work :wink:

1 Like
4

Whoops. I’ve done exactly this. It’s infuriating. :smiley:

5

Haha, well it didn’t work for me, but it was a poor name choice anyway, my fault :wink:

1 Like
6

@binajmen Just to let you know, this problem has been fixed in version v0.0.16.

You can see what version you’re on by running: fly image show --app <app-name>.

Sorry for the trouble!

1 Like