LibSQL not working on private network
dvt
TRIALOP

2 years ago

I have a Go project where I'm using LibSQL as the database, in railway, I have my Go server and the LibSQL template running. When I use the public url for the database it works fine, but when I use the private url it doesn't work. I verified that I'm passing the correct private url from the logs.

The error I get is:
failed to execute query INSERT INTO database (column_1, column_2) VALUES ("value_1", "value_2") error code = 2: Error executing statement: Hrana: `http error: `error trying to connect: received corrupt message of type InvalidContentType``

Project ID: ce1bc4e2-67b7-470d-94a2-730b2908e061

8 Replies

dvt
TRIALOP

2 years ago

Project ID:ce1bc4e2-67b7-470d-94a2-730b2908e061

brody
EMPLOYEE

2 years ago

please send the private url you are using, the template should come with one

dvt
TRIALOP

2 years ago

I'm passing the variable to the server like:

dvt
TRIALOP

2 years ago

LIBSQL_PUBLIC_URL="${{libSQL.SQLD_PUBLIC_URL}}"
dvt
TRIALOP

2 years ago

private url is libsql://libsql.railway.internal:8080?tls=0

brody
EMPLOYEE

2 years ago

and what error are you getting, the log you provided does not have an error message about a connection

dvt
TRIALOP

2 years ago

I think I fixed it, I was using the github.com/tursodatabase/go-libsql library, I switched to github.com/tursodatabase/libsql-client-go/libsql and it's working now

dvt
TRIALOP

2 years ago

not sure why it was working with the public url and not the private one previously

Loading...