Helicone Community Page

Updated last year

Hi all trying out self hosting due to

Hi all - trying out self hosting due to company data security requirements. Just running docker compose up and the ui starts - but there is an error in the logs: Error: connect ECONNREFUSED 127.0.0.1:8123
helicone-web | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1300:16) {
helicone-web | errno: -111,
helicone-web | code: 'ECONNREFUSED',
helicone-web | syscall: 'connect',
helicone-web | address: '127.0.0.1',
helicone-web | port: 8123
I think it’s trying to access clickhouse- does that get set up by the docker compose or is there something I’m missing in setting up the .env file? CLICKHOUSE_HOST=http://localhost
CLICKHOUSE_PORT=8123
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=

default user is postgres

a
p
C
8 comments
i should mention that i was able to create a user and log in and go through some of the onboarding stuff. I'm using it with an example from langchain - and have set up the configuration so data should flow - but nothing is showing up in helicone - which is why i started looking at the logs.
Ok - relazied i made a basic error - the clickhouse .env should have been like this: CLICKHOUSE_HOST=http://clickhouse-db
CLICKHOUSE_PORT=8123
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=
now the message i'm getting is this - clickhouse-migration-runner | % Total % Received % Xferd Average Speed Time Time Time Current
clickhouse-migration-runner | Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
clickhouse-migration-runner | curl: (7) Failed to connect to clickhouse-db port 80: Connection refused
and then this error: "helicone-web | Error executing query:
helicone-web |
helicone-web | WITH total_count AS (
helicone-web | SELECT count(*) as count
helicone-web | FROM response_copy_v3
helicone-web | WHERE (
helicone-web | ((response_copy_v3.organization_id = {val_0 : String} and ((response_copy_v3.request_created_at >= {val_1 : DateTime} and response_copy_v3.request_created_at <= {val_2 : DateTime}) and true)))
helicone-web | )
helicone-web | )
helicone-web | SELECT coalesce(sum(count), 0) as count
helicone-web | FROM total_count
helicone-web | [
helicone-web | 'b4171539-0f0f-4f4e-b683-b1cfb9d80ebf',
helicone-web | 2023-09-07T17:05:16.447Z,
helicone-web | 2023-09-08T17:05:16.447Z
helicone-web | ]
helicone-web |
helicone-web | ClickHouseError: Table default.response_copy_v3 doesn't exist.
helicone-web | at parseError (/app/helicone/web/node_modules/@clickhouse/client/dist/error/parse_error.js:32:16)
helicone-web | at ClientRequest.onResponse (/app/helicone/web/node_modules/@clickhouse/client/dist/connection/adapter/base_http_adapter.js:127:51)
helicone-web | at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
helicone-web | code: '60',
helicone-web | type: 'UNKNOWN_TABLE'
helicone-web | }
"
ok - i've started over and now things are working. When running in self hosted mode what value should i use for the basePath? const model = new OpenAI(
{},
{
basePath: "https://oai.hconeai.com/v1",
}
);
const res = await model.call("What is a helicone?");
Hey @akh , did you setup this in VM or in your local machine ?
Kubernetes tuning in rancher desktop on my local machine
It should be the url that the worker is hosted on. When running locally it is typically this: http://127.0.0.1:8787
Add a reply
Sign up and join the conversation on Discord