Repository navigation
Local Connection Fails #104
Description
Scenario
- I run
pscale connect galaxy --port 3309locally to connect to my PlanetScale DB - I attempt to connect my T3 app using
import { connect } from "@planetscale/database";
Problem
- When I use
urlto connect to my local db connection, it does not use the specified port - instead is uses port443:
const connection = connect({
url: "mysql://root@127.0.0.1:3309"
});
- When I use
host&usernameto connect to my local db connection, it uses the correct port but it fails with aERR_SSL_WRONG_VERSION_NUMBERstatus code
const connection = connect({
host: "127.0.0.1:3309",
username: "root"
});
I'd love to be able to use this package instead of prisma for my next project.
Anything that can be done to help here would be greatly appreciated!
Activity
mattrobenolt commentedon Apr 10, 2023
techgerm commentedon Apr 10, 2023
@mattrobenolt thanks for the quick response and clarification!
In that case, do you know how I can specify a DB branch in this configuration?
mattrobenolt commentedon Apr 10, 2023
When you create credentials, they're bound to a branch. So you'd just create credentials for the branch you want, and it'll work. Are you observing something differently?
techgerm commentedon Apr 10, 2023
Ah that's my mistake, didn't realize that was the case. Thanks again for your help!
Out of curiosity, are there any future plans to bridge the protocols?
mattrobenolt commentedon Apr 10, 2023
Bride them how? I have some plans. 👀 But curious what you have in mind.
techgerm commentedon Apr 10, 2023
Hmm let me give it some thought and I'll get back to you!
Jolg42 commentedon Aug 14, 2023
(Maybe unrelated to your issue? Feel free to ignore)
From what I see, the
ERR_SSL_WRONG_VERSION_NUMBERerror is caused because fetch tries to do some SSL logic here on a non SSL endpoint.Changing these 2 lines and switching
httpstohttpshould make it work.database-js/src/index.ts
Line 203 in 488e48b
database-js/src/index.ts
Line 254 in 488e48b
janpio commentedon Aug 21, 2023
Related: #135