we can't connect to the database

leonelchaucaHOBBY

a year ago

It does not work from the railway database manager but if from my sql workbench, it does not open the connection, we made the suggestions that appeared to us and even so the problem could not be resolved, including the database crash

View Deploy details

ⓘ Deployment information is only viewable by project members and Railway employees.

12 Replies

a year ago

Please provide exact errors.

What's the current state of your database's deployment?


leonelchaucaHOBBY

a year ago

These are the logs when the deploy is done ... 2024-06-06 05:04:22+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.

2024-06-06 05:04:22+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2024-06-06 05:04:22+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.

'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

2024-06-06T05:04:23.264872Z 0 [System] [MY-015015] [Server] MySQL Server - start.

2024-06-06T05:04:23.383117Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 7

2024-06-06T05:04:23.389652Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2024-06-06T05:04:23.642418Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2024-06-06T05:04:23.874488Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2024-06-06T05:04:23.874538Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2024-06-06T05:04:23.880505Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.

2024-06-06T05:04:23.905076Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.4.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.

2024-06-06T05:04:24.189458Z 8 [Warning] [MY-011302] [Server] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'

2024-06-06T05:04:24.189781Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

2024-06-06T05:05:06.258310Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.4.0).

2024-06-06T05:05:06.797054Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.

2024-06-06T05:05:06.797084Z 0 [System] [MY-015016] [Server] MySQL Server - end.


a year ago

Please answer my second question.


leonelchaucaHOBBY

a year ago

Database Connection

We are unable to connect to the database over the public network.


a year ago

I'm sorry but that doesn't answer my question, the team is looking into it anyway.


leonelchaucaHOBBY

a year ago

We tested the backend with postman and it is normal, it could be a wailway error, it could be an error in the ssl certificate, but what does it mean with the state of the database, thanks


a year ago

It means the state of the database's most recent deployment.


leonelchaucaHOBBY

a year ago

active

Attachments


a year ago

Please share a link to your project.


leonelchaucaHOBBY

a year ago


a year ago

I didn't mean an invite, just send the simple link to your project.



we can't connect to the database - Railway Help Station