Railway•16mo 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•16mo ago

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

Brody•16mo ago

Are you using the correct environment variables?

Fragly•16mo 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•16mo ago

Those are indeed the correct variables Let me do some testing

Fragly•16mo ago

Alright, thanks for your help Brody!

Brody•16mo 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

Fragly•16mo 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))