5 replies

Running `drizzle-kit introspect:pg` returns "client password must be a string"

I'm attempting to move from objection.js+knex.js over to Drizzle and I'm running

drizzle-kit introspect:pg

drizzle-kit introspect:pg

against my database but I'm getting the error:

Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

Here's my

drizzle.config.ts

drizzle.config.ts

import type { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './src/db/migrations',
  connectionString: 'DATABASE_URL',
} satisfies Config;

import type { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './src/db/migrations',
  connectionString: 'DATABASE_URL',
} satisfies Config;

If i change

connectionString: 'DATABASE_URL',

connectionString: 'DATABASE_URL',

connectionString: process.env.DATABASE_URL

connectionString: process.env.DATABASE_URL

, I get the error:

Invalid input

Invalid input

I've also tried to specify all the information in my connection string in the CLI params like

drizzle-kit instropect:pg --host=... --user=... --password...

drizzle-kit instropect:pg --host=... --user=... --password...

but get the same error.

Any help would be appreciated. Thanks in advance.

Drizzle Team•3y ago•

5 replies

PGT

Running `drizzle-kit introspect:pg` returns "client password must be a string"

I'm attempting to move from objection.js+knex.js over to Drizzle and I'm running

drizzle-kit introspect:pg

drizzle-kit introspect:pg

against my database but I'm getting the error:

Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

Here's my

drizzle.config.ts

drizzle.config.ts

import type { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './src/db/migrations',
  connectionString: 'DATABASE_URL',
} satisfies Config;

import type { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './src/db/migrations',
  connectionString: 'DATABASE_URL',
} satisfies Config;

If i change

connectionString: 'DATABASE_URL',

connectionString: 'DATABASE_URL',

connectionString: process.env.DATABASE_URL

connectionString: process.env.DATABASE_URL

, I get the error:

Invalid input

Invalid input

I've also tried to specify all the information in my connection string in the CLI params like

drizzle-kit instropect:pg --host=... --user=... --password...

drizzle-kit instropect:pg --host=... --user=... --password...

but get the same error.

Any help would be appreciated. Thanks in advance.

Running `drizzle-kit introspect:pg` returns "client password must be a string"

Similar Threads

Running `drizzle-kit introspect:pg` returns "client password must be a string"

Similar Threads

Similar Threads

Similar Threads