How to configure Medusa to run test with local database without SSL mode ?

[a-kouyate]

I'm starting to write integration tests in my Medusa store. As a starting point, I tried to run health.spec.ts, but I'm stuck with db SSL connection requirement.

import { medusaIntegrationTestRunner } from "@medusajs/test-utils"
jest.setTimeout(60 * 1000)

medusaIntegrationTestRunner({
  inApp: true,
  env: {},
  testSuite: ({ api }) => {
    describe("Ping", () => {
      it("ping the server health endpoint", async () => {
        const response = await api.get('/health')
        expect(response.status).toEqual(200)
      })
    })
  },
})

When I run npm run test:integration:http. I get this error

console.error
    Something went wrong while running the migrations

      at migrateDatabase (node_modules/@medusajs/test-utils/src/medusa-test-runner-utils/use-db.ts:27:13)
      at Object.beforeAll_ (node_modules/@medusajs/test-utils/src/medusa-test-runner.ts:126:5)

  console.error
    Error tearing down database: The server does not support SSL connections

My .env.test

DB_HOST=mb-postgres
DB_USERNAME=meandb_rw
DB_PASSWORD=docker
LOG_LEVEL=error

I'm building in local with docker, so I don't want to have to create SSL certificate to make test running. It's a nonsense, and I'm really frustrated of it.

[TheLiminalDream]

I had this issue the other night when building in a docker environment. Here is how i resolved it:

Edit: when running in production you need to use SSL certs and I have plans toma

I updated the medusa-config.ts to include

databaseDriverOptions: process.env.NODE_ENV == "development" ?
      {
        ssl: {
          rejectUnauthorized: false,
        },
      } : {},

this is the whole file:

import { loadEnv, defineConfig } from '@medusajs/framework/utils'

loadEnv(process.env.NODE_ENV || 'development', process.cwd())

module.exports = defineConfig({
  projectConfig: {
   // workerMode: process.env.MEDUSA_WORKER_MODE as "shared" | "worker" | "server" || "shared",
    databaseUrl: process.env.DATABASE_URL,
    http: {
      storeCors: process.env.STORE_CORS!,

      adminCors: process.env.ADMIN_CORS!,
      authCors: process.env.AUTH_CORS!,
      jwtSecret: process.env.JWT_SECRET || "supersecret",
      cookieSecret: process.env.COOKIE_SECRET || "supersecret",
    },
    databaseDriverOptions: process.env.NODE_ENV == "development" ?
      {
        ssl: {
          rejectUnauthorized: false,
        },
      } : {},
  },
  // admin: {
  //   disable: process.env.DISABLE_MEDUSA_ADMIN === "false",
  // },
})