using createClient with a localhost db [Windows]

[adehadd-aimgroup]

Hi there!

I have started an app using the [email protected] template and am running an edgdb instance separately for local dev.

This is the content of my <root>\src\server\api\routers\example.ts

import { z } from "zod";
import * as edgedb from "edgedb";

import { createTRPCRouter, publicProcedure } from "~/server/api/trpc";
import { env } from "~/env.mjs";

// const client = edgedb.createHttpClient({
const client = edgedb.createClient({
  dsn: "edgedb://127.0.0.1:10700/edgedb",
  tlsSecurity: env.NODE_ENV == "development" ? "insecure" : "default",
  // dsn: env.EDGEDB_DSN,
  // port: 10700,
});

export const exampleRouter = createTRPCRouter({
  hello: publicProcedure
    .input(z.object({ text: z.string() })) //
    .query(({ input }) => {
      return {
        greeting: `Hello ${input.text}`,
      };
    }),
  data: publicProcedure
    .input(z.object({ text: z.string() })) //
    .query(async ({ input }) => {
      const result = await client.query("select 2+2");
      // console.log(input);
      console.log(result);
      return {
        data: result,
      };
    }),
});

I unfortunately don't get a result, but an exception, the logs I have are:

(node:41928) [DEP0123] DeprecationWarning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066. This will be ignored in a future version.
(Use `node --trace-deprecation ...` to show where the warning was created)

❌ tRPC failed on example.data: Zero-length key is not supported
Attempted to connect using the following credentials:
Parameter          Value                                    Source
---------          -----                                    ------
host               127.0.0.1                                 'dsnOrInstanceName' option (parsed as dsn)
port               10700                                     'dsnOrInstanceName' option (parsed as dsn)
database           edgedb                                    'dsnOrInstanceName' option (parsed as dsn)
user               edgedb (default)                          'dsnOrInstanceName' option (parsed as dsn)
password           undefined (default)                       'dsnOrInstanceName' option (parsed as dsn)
tlsCAData          null (default)                            'dsnOrInstanceName' option (parsed as dsn)
tlsSecurity        insecure                                  'tlsSecurity' option
waitUntilAvailable 30000 (default)                           'dsnOrInstanceName' option (parsed as dsn)      

result returns an undefined hence the error.

Is there anything obvious I am missing regarding why this isn't working?

some extra context of thing tried

Reason for using ipv4 instead of hostname:

A client connection error occurred; reconnecting because of "waitUntilAvailable=30000". ClientConnectionClosedError: network error: Error: connect ECONNREFUSED ::1:10700
    at RawConnection._onError (C:\dev\aimerlin-webapp\node_modules\edgedb\dist\rawConn.js:144:24)
    at TLSSocket.emit (node:events:513:28)
    at emitErrorNT (node:internal/streams/destroy:151:8)
    at emitErrorCloseNT (node:internal/streams/destroy:116:3)
    at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
  source: Error: connect ECONNREFUSED ::1:10700
      at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
      at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
    errno: -4078,
    code: 'ECONNREFUSED',
    syscall: 'connect',
    address: '::1',
    port: 10700
  }
}

[adehadd-aimgroup]

Seems to be that the this was failing on the password, which by default is not set/required for local instances?

In my case I was able to resolve this with the following:

edgedb instance reset-password -I db --password