lukasgjetting Posts - Answer Overflow

lukasgjetting

•Created by lukasgjetting on 1/12/2024 in #✋｜help

Unable to connect to newly migrated MySQL service from outside the Railway network

Hi there! I just migrated a legacy MySQL plugin to a service using the migration tool. My API service can correctly connect to the database using the internal domain (database.railway.internal). However, I am unable to connect to the MySQL service from my own machine, using the public domain proxy (roundhouse.proxy.rlwy.net:22516). I receive the following error:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 3

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 3

Seems like there is an issue with the initial handshake, which might be a problem with the proxy?

7 replies

RRailway

•Created by lukasgjetting on 9/25/2023 in #✋｜help

Python not available after recent update(?)

Hiya! I've been deploying via Railway for almost a year now - and it's been great! Starting three days ago, all my builds are failing with the error message Python is not set from command line or npm configuration while building node-gyp. I am deploying JS using yarn. Did a recent update to Railway change anything? Is the default image now more lightweight, meaning Python isn't included? And if so, is there a way to do this while avoiding a custom Dockerfile? I could try to guess the python location and set it as an environment variable, but that seems very brittle... Thanks! --- Project ID: 07fcde41-284c-48e1-83d0-a92b28b116fc Full error:

#10 18.45 gyp ERR! find Python Python is not set from environment variable PYTHON

#10 18.45 gyp ERR! find Python checking if "python3" can be used

#10 18.45 gyp ERR! find Python - "python3" is not in PATH or produced an error

#10 18.45 gyp ERR! find Python checking if "python" can be used

#10 18.45 gyp ERR! find Python - "python" is not in PATH or produced an error

#10 18.45 gyp ERR! find Python

#10 18.45 gyp ERR! find Python

#10 18.45 gyp ERR! find Python Python is not set from environment variable PYTHON

#10 18.45 gyp ERR! find Python checking if "python3" can be used

#10 18.45 gyp ERR! find Python - "python3" is not in PATH or produced an error

#10 18.45 gyp ERR! find Python checking if "python" can be used

#10 18.45 gyp ERR! find Python - "python" is not in PATH or produced an error

#10 18.45 gyp ERR! find Python

#10 18.45 gyp ERR! find Python

25 replies

RRailway

•Created by lukasgjetting on 7/15/2023 in #✋｜help

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. 🙂

13 replies

RRailway

•Created by lukasgjetting on 7/9/2023 in #✋｜help

Changing MySQL system variables (innodb_ft_min_token_size)

Hi! I want to change the innodb_ft_min_token_size system variable for improved search. Here, https://docs.railway.app/databases/mysql#changing-system-variables, it is mentioned that changing system variables is not supported. 1. Is there any alternative solution? I would like to still host the database on Railway. Maybe combining the new docker image deploy with a volume? 2. Are there any plans to support natively changing MySQL system variables like the one I mentioned? And if so, what is the ETA? Thanks!

10 replies

RRailway

•Created by lukasgjetting on 3/3/2023 in #✋｜help

MySQL server seems to be given way more memory than needed

Hi! About a month ago, I messed up some queries, causing Railway to allocate my database service 10 GB memory. Now, a while after the problem has been fixed, it seems to still be floating at 5-7 GB - even with very little activity! Hope that makes sense - thanks Project ID is 07fcde41-284c-48e1-83d0-a92b28b116fc

6 replies

RRailway

•Created by lukasgjetting on 1/13/2023 in #✋｜help

Additional DNS records on same domain as a Railway application

Hi! I am hosting a landing page on Railway with a custom domain using a CNAME record. Now, I am also setting up an email client via Namecheap (their PrivateEmail service). To send emails from @mydomain.com, I have to add an MX record and a TXT record (SPF). However, the DNS spec states that, "if a CNAME record is present, no other data should be present" (https://serverfault.com/questions/834320/adding-both-cname-and-txt-dns-records-for-one-subdomain). Because of this, my emails fail the SPF check while the CNAME is active. I have tried removing the CNAME record, which makes the SPF succeed... This seems like a very common usecase - am I missing something? Do I somehow not have to set up MX/TXT records on the root domain (host: @) to succeed SPF check while sending emails from [email protected]? Thanks!

6 replies

RRailway

•Created by lukasgjetting on 10/19/2022 in #✋｜help

Yarn install frequently fails with ENOENT

Hi! My builds fail quite frequently because of an allegedly missing package when running yarn install. The package causing the error seems to change, so I don't think it's because of a specific package. This happens during the install phase, so before it reaches any of my code. Thanks! Error message:

#12 1.930 error An unexpected error occurred: "https://registry.yarnpkg.com/es-abstract/-/es-abstract-1.20.2.tgz: ENOENT: no such file or directory, open '/usr/local/share/.cache/yarn/v6/npm-es-abstract-1.20.2-8495a07bc56d342a3b8ea3ab01bd986700c2ccb3-integrity/node_modules/es-abstract/.yarn-tarball.tgz'".

#12 1.930 error An unexpected error occurred: "https://registry.yarnpkg.com/es-abstract/-/es-abstract-1.20.2.tgz: ENOENT: no such file or directory, open '/usr/local/share/.cache/yarn/v6/npm-es-abstract-1.20.2-8495a07bc56d342a3b8ea3ab01bd986700c2ccb3-integrity/node_modules/es-abstract/.yarn-tarball.tgz'".

Project ID: 07fcde41-284c-48e1-83d0-a92b28b116fc Config: ╔════ Nixpacks v0.10.2 ════════╗ ║ setup │ nodejs-16_x, yarn-1_x ║ ║────────────────║ ║ install │ yarn install --frozen-lockfile ║ ║────────────────║ ║ build │ yarn build:api ║ ║──────────────║ ║ start │ yarn run-build:api ║ ╚══════════════════════╝

3 replies

Gaming

Programming