Railway•2y ago

Handshake timeout error on mySQL

// ---> DATABASE
await mysql.connect()
const db = new QuickDB({ driver: mysql })

// ---> DATABASE
await mysql.connect()
const db = new QuickDB({ driver: mysql })

the error points to where I assign my db I'm using quickdb.js with promise-mysql project ID: ad4f96c1-5839-4882-89ea-53b1a95f4719

22 Replies

Percy•2y ago

Project ID: ad4f96c1-5839-4882-89ea-53b1a95f4719

Brody•2y ago

Are you using the correct environment variables?

FraglyOP•2y ago

yes, I think so

const mysql = new MySQLDriver({
  host: process.env.MYSQLHOST,
  user: process.env.MYSQLUSER,
  password: process.env.MYSQLPASSWORD,
  database: process.env.MYSQLDATABASE,
});

const mysql = new MySQLDriver({
  host: process.env.MYSQLHOST,
  user: process.env.MYSQLUSER,
  password: process.env.MYSQLPASSWORD,
  database: process.env.MYSQLDATABASE,
});

Maybe I should store my data as a json in a discord message Troll

Brody•2y ago

Those are indeed the correct variables Let me do some testing

FraglyOP•2y ago

Alright, thanks for your help Brody!

Brody•2y ago

if possible do you wanna provide me with a full code snippet? code that just connects to the db and would print a success message

FraglyOP•2y ago

async function connectDB() {
    // ---> DATABASE
    const mysql = new MySQLDriver({
        host: process.env.MYSQLHOST,
        user: process.env.MYSQLUSER,
        password: process.env.MYSQLPASSWORD,
        database: process.env.MYSQLDATABASE,
    });

    await mysql.connect()
    const db = new QuickDB({ driver: mysql })
}
connectDB().then(console.log("success")).catch(error => console.error(error))

async function connectDB() {
    // ---> DATABASE
    const mysql = new MySQLDriver({
        host: process.env.MYSQLHOST,
        user: process.env.MYSQLUSER,
        password: process.env.MYSQLPASSWORD,
        database: process.env.MYSQLDATABASE,
    });

    await mysql.connect()
    const db = new QuickDB({ driver: mysql })
}
connectDB().then(console.log("success")).catch(error => console.error(error))