TehShrike Comments

TehShrike

Posts Comments

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

Want me to create an issue?

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

Yes, I am able to connect to the local db with node. I was also to connect to the local db in Deno using this native Deno library: https://github.com/denodrivers/mysql

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

I'm not providing a cert, but I am enabling SSL. When connecting to local:

error: Uncaught (in promise) Error: Bad handshake
    at Object.createConnection (file:///Users/joshduff/git/photoquoter/node_modules/.deno/mysql2@2.3.3/node_modules/mysql2/promise.js:242:31)
    at default (file:///Users/joshduff/git/photoquoter/server/mysql.ts:21:22)
    at file:///Users/joshduff/git/photoquoter/server/index.ts:9:32
    at eventLoopTick (ext:core/01_core.js:181:11)

error: Uncaught (in promise) Error: Bad handshake
    at Object.createConnection (file:///Users/joshduff/git/photoquoter/node_modules/.deno/mysql2@2.3.3/node_modules/mysql2/promise.js:242:31)
    at default (file:///Users/joshduff/git/photoquoter/server/mysql.ts:21:22)
    at file:///Users/joshduff/git/photoquoter/server/index.ts:9:32
    at eventLoopTick (ext:core/01_core.js:181:11)

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

So everything seems cool there. The issue seems to be when connecting to a local database that requires SSL.

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

I am also able to connect to PS with ssl: { rejectUnauthorized: true }

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

I am successfully able to connect to PlanetScale with ssl: { rejectUnauthorized: false }

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

hah, my PlanetScale database was asleep. One moment

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

When I try connecting to PlanetScale with ssl: { rejectUnauthorized: false }, I get an error with the message "unavailable: unable to connect to branch tcancv32qlrt" and then "Uncaught Error: read UNKNOWN"

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

Let me know if you want me to try anything else

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

Besides passing in (or not) that ssl property to createConnection, I also passed in host, user, database, password

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

At some point I guess the default mysql settings started requiring TLS

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

yeah, I can try to write up something more thorough, though about half the details are here: https://discord.com/channels/684898665143206084/684898665151594506/1187550860746698833 the rest of the details are: mysql 8.0.35, from the default macOS installer from https://dev.mysql.com/downloads/mysql/ with no my.cnf file.

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

Yeah, probably.

26 replies

DDeno

•Created by Bairdy on 10/23/2023 in #help

Can you recommend a mysql driver for deno that isn't a complete dead end?

does your server have SSL disabled?

26 replies

DDeno