Handshake inactivity timeout
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.
9 Replies
Project ID:
N/Athis is mysql
not sure what you mean by "I created a pooling "
const db = mysql.createPool({
I don;t know what it means before I just used a single connection.
const db = mysql.createConnection({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_DATABASE
});
are you using the private network to connect to the database
i uploaded my sql file to railay
anytime I add port my app doesn't deploy so I don't put the port railway provided
I don't think so im not sure
please use the private network to connect to your database
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.
Solution
use the private domain and port to connect to the database