Topics

Railway•12mo ago

Unable to connect to a custom MySQL deployment (Dockerfile + volume)

I am currently trying to deploy MySQL via a custom Dockerfile (I need to change innodb_ft_min_token_size, which is not possible with the default MySQL deployment). I am using a simple Dockerfile:

FROM mysql:8.0.33

ARG DB_PASS

ENV MYSQL_ROOT_PASSWORD=$DB_PASS
ENV MYSQL_DATABASE=railway

EXPOSE 3306

FROM mysql:8.0.33

ARG DB_PASS

ENV MYSQL_ROOT_PASSWORD=$DB_PASS
ENV MYSQL_DATABASE=railway

EXPOSE 3306

Looking at the build + deploy logs, everything seems to work correctly. However, I cannot connect to the database. I have connected a default Railway domain. When accessing it via a browser, I get the following error: upstream connect error or disconnect/reset before headers. reset reason: protocol error. When connecting to <railwayDomain>:80 via MySQL Workbench, I get the following error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0. Trying to connect to port 3306 results in a timeout. Am I missing anything? Thanks. 🙂

Solution:

you will not be able to connect to the database externally without some kind of tunnel, railway does not support accessing services over anything but https and 443 externally, you can only connect to it from another service in the same project with the private networking and internal domains

Jump to solution

9 Replies

Percy•12mo ago

Project ID: 82bf36ca-fd00-4567-9aa9-5f90227d2f00

lukasgjetting•12mo ago

82bf36ca-fd00-4567-9aa9-5f90227d2f00 Additionally, the Railway env variable PORT is set to 3306

Solution

Brody•12mo ago

you will not be able to connect to the database externally without some kind of tunnel, railway does not support accessing services over anything but https and 443 externally, you can only connect to it from another service in the same project with the private networking and internal domains

The Big E in Math -> Σ•12mo ago

Just curious if you have any plan to support non-http protocol in the future

Brody•12mo ago

yes there was an announcement from cooper that says they plan to support TCP/UDP in the future at some point, no ETAs where given

The Big E in Math -> Σ•12mo ago

Good to know, thanks.

Brody•12mo ago

no problem! and of course the internal network supports non-http protocols

lukasgjetting•12mo ago

Ok - thank you for the answer

Brody•12mo ago

people have been able to run a Minecraft server on railway through an ngrok tunnel, if it works for Minecraft, should work for a database lol

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Playwright Python in RailwayIt requires `playwright install` to use playwright. Is there a way to call the `playwright install`First deploy ever: What's wrong ?Hi this is my first web app and my first deploy ever. I have this project that a is a fullstack mon DNS Settings for cloudflare for railwayDo i need to add anything else for my domain on cloudflare?My java process get killed for some reasonI want to run a minecraft server. i read https://railway.app/legal/terms to know if it was allowed o Max request timeout?Hi Team Railway, amazing product! Just wondering what the maxiumum amount of time we can wait to sen Django deployment errorHi! I am following along this Mozilla tutorial for deploying Django to Railway (https://developer.mo I want to pay my subscriptionIn the dashboard home says that my subscription is unpaid and in billing i don't find the button to Github build not being picked up by Railway?I pushed to master 31 mins ago thinking it would be in production by now, it hasn't been picked up, Billing after upgrading to ProI just upgraded to pro and I'm the admin for the team. I noticed the billing for my personal account Builds are failing (npmjs unreachable?)Hello, my Next app's builds started to fail today at `npm ci` seemingly because it can't make conta