Using Drizzle Adapter With Libsql Remote URL's

[pauchiner]

I follow the drizzle adapter guide to setup my nextjs app + drizzle + turso.

The problem here is that the documentation only talks about a AUTH_DRIZZLE_URL environment variable for the connection url.

And this is fine for local development, since i run libsql without an auth token.
But when running on production with a turso database, the auth token can't be passed, so this leads to a 401 request.

Im using these versions

"next-auth": "5.0.0-beta.20"
"@auth/core": "0.34.2",
"@auth/drizzle-adapter": "1.4.2",

This is my adapter config:

import {DrizzleAdapter} from '@auth/drizzle-adapter';
import type {Adapter} from 'next-auth/adapters';
import {createUser, getUser} from './helpers';
import {database, schema} from '@/lib/db';

// @ts-ignore
export const adapter: Adapter = {
  ...DrizzleAdapter(database, {
    usersTable: schema.user,
    accountsTable: schema.account,
    sessionsTable: schema.session,
    verificationTokensTable: schema.verificationToken
  }),
  createUser: async data => {
    return await createUser(data);
  },
  getUser: async id => {
    return await getUser(id);
  }
};

[pauchiner]

I forget to add the auth token environment variable to the vercel environment variables.

It seem's like the AUTH_DRIZZLE_URL does nothing in this case