Handshake inactivity timeout
zephireis
HOBBYOP

2 years ago

App deploys okay but querying the database gives me a handshaketime out.

I created a pooling to see if that would work it didn't

not sure where to go from here.

12 Replies

zephireis
HOBBYOP

2 years ago

this is mysql


2 years ago

not sure what you mean by "I created a pooling "


zephireis
HOBBYOP

2 years ago

const db = mysql.createPool({


zephireis
HOBBYOP

2 years ago

I don;t know what it means before I just used a single connection.


zephireis
HOBBYOP

2 years ago

const db = mysql.createConnection({

host: process.env.DB_HOST,

user: process.env.DB_USER,

password: process.env.DB_PASSWORD,

database: process.env.DB_DATABASE

});


2 years ago

are you using the private network to connect to the database


zephireis
HOBBYOP

2 years ago

i uploaded my sql file to railay


zephireis
HOBBYOP

2 years ago

anytime I add port my app doesn't deploy so I don't put the port railway provided


zephireis
HOBBYOP

2 years ago

I don't think so im not sure


2 years ago

please use the private network to connect to your database


zephireis
HOBBYOP

2 years ago

What is that? The tables are on railway I set the environment vars app deploys I can see my webapp pages but anytime I query database to login i get the handsake error or my error handling logs are caught.

I looked in mysql the private network seems to be enabled but not sure what that would be used for for this instance.


2 years ago

use the private domain and port to connect to the database


Welcome!

Sign in to your Railway account to join the conversation.

Loading...