Theo's Typesafe CultTTC
Theo's Typesafe Cult•3y ago
Jacob

Error when running `drizzle-kit push:mysql` to a Planetscale database

so after reading through the Doc's it looks like i need an SSL cert to run the push however i'm not sure how to configure that with drizzle and from what i've sceen from others they are doing it an easier way.

This is the error I get when running drizzle-kit push:mysql: 
bash 
> drizzle-kit push:mysql

drizzle-kit: v0.19.2
drizzle-orm: v0.27.0

No config path provided, using default 'drizzle.config.ts'
Reading config file 'G:\GitHub\Meally\apps\meally\drizzle.config.ts'
G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.2\node_modules\drizzle-kit\index.cjs:34259
      const createConnectionErr = new Error();
                                  ^

Error: unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS

    at createConnection2 (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.2\node_modules\drizzle-kit\index.cjs:34259:35)  
    at connectToMySQL (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.2\node_modules\drizzle-kit\index.cjs:36340:60)     
    at Command.<anonymous> (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.2\node_modules\drizzle-kit\index.cjs:51785:28) {
  code: 'ER_UNKNOWN_ERROR',
  errno: 1105,
  sqlState: 'HY000'
}


This is my config:
typescript 
import 'dotenv/config';
import type { Config } from 'drizzle-kit';
import { env } from './env.mjs';

const config: Config = {
  schema: './src/db/schemas/',
  out: './src/db/migrations',
  driver: 'mysql2',
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },

};

export default config;

Does anyone know how i an connect to Planetscale with the latest version drizzle?
Was this page helpful?