5

I am starting a brand new PlanetScale backed project, with a Prisma setup. I followed the instruction on this official documentation (aside from changing the name of the database) and after locally proxying into the database, I found myself unable to run npx prisma db push command, getting the following error:

server does not allow insecure connections, client must use SSL/TLS

I am very new to database set ups, and prior to this never had an idea I would need to configure any of these connections as I thought they were dealt with as part of what database set-up I was using.

I know that mySql, what I am using through Prisma, needs either an SSL or TLS before it will perform any interactions on a database, but I have yet to find any way to set this up for my environment.

I have seen references to adding ?tls={true} to the end of my DATABASE_URL but that did nothing. Furthermore, given that the provided DATABASE_URL was provided by PlanetScale as

DATABASE_URL='mysql://un5pbmobnc73muwvbo77:************@us-east.connect.psdb.cloud/*******?ssl={"rejectUnauthorized":true}'

I attempted to change {"rejectUnauthorized":true} to {"rejectUnauthorized":false}. This also changed nothing. More elaborate solutions involving objects are the parameters resulted in my database not being found altogether.

I know SSL is deprecated and I should not use it, but not only do I not know how to properly add TLS to my mySQL, but as you may have already determined, I'm finding myself somewhat unable to fully grasp the concept of its implementation at all.

TheMilkMan
  • 143
  • 2
  • 7
  • Any updates on that? – matcheek Dec 18 '22 at 22:06
  • Did you follow this guide on how to use prisma db push with PlanetScale: https://www.prisma.io/docs/guides/database/using-prisma-with-planetscale#how-to-make-schema-changes-with-db-push – Nurul Sundarani Dec 19 '22 at 14:41
  • I did, the issue was the link that PlanetScale provided me was missing one line. It gave me this... `DATABASE_URL='mysql://un5pbmobnc73muwvbo77:************@us-east.connect.psdb.cloud/*******?ssl={"rejectUnauthorized":true}` when it should have had a `3306` in there, making it look like this...`DATABASE_URL='mysql://un5pbmobnc73muwvbo77:************@us-east.connect.psdb.cloud:3306/*******?ssl={"rejectUnauthorized":true}` – TheMilkMan Dec 22 '22 at 14:45
  • Did it work? I'm still getting the same issue. – Y M Dec 25 '22 at 01:18
  • Adding the `3306` worked for me – TheMilkMan Jan 04 '23 at 18:39

2 Answers2

15

Replace ?ssl={"rejectUnauthorized":true} with ?sslaccept=strict. Below is an example.

DATABASE_URL="mysql://xxxx:yyyy@ap-northeast.connect.psdb.cloud/zzzz?sslaccept=strict"

Details are written below.

https://www.prisma.io/docs/concepts/database-connectors/mysql#arguments

Good luck!

susukida
  • 206
  • 1
  • 3
0

For a Laravel application, your ".env" file should look like this:

  • DB_CONNECTION=mysql
  • DB_HOST=XXXX
  • DB_PORT=XXXX
  • DB_DATABASE=XXXX
  • DB_USERNAME=XXXX
  • DB_PASSWORD=XXXX
  • MYSQL_ATTR_SSL_CA=XXXX

NB: you can get these credentials from your Planetscale account by following the steps below:

  1. Click on the database you wish to get the credentials.
  2. Click on the "Overview" menu option.
  3. Click on the "Get connection strings" in the bottom right corner.
  4. From the "Connect with" dropdown options, select "Laravel".
  5. Copy and paste the credentials from the selected option in your ".env" file.
  6. Run the "php artisan optimize:clear" command and you are good to go.

Congratulations!

ovo
  • 61
  • 3