Hey Signozians , i've added a password for my loca...
# supportl
L Omary
05/21/2024, 2:58 PMHey Signozians , i've added a password for my local clickhouse in clickhouse-users but the otel-migrator fails to connect to clickhouse ? is there anything else to be done on the otel-collector-config or the docker-compose.yaml ? thank you
a
Ankit Nayan
05/21/2024, 3:24 PM
@Prashant Shahi
p
Prashant Shahi
05/21/2024, 4:12 PMHi @L Omary š
can you share the changes that you have done in the docker-compose and otel-collector config from the default ones?
l
L Omary
05/21/2024, 6:53 PMI've added a password in clickhouse-users , that's the only change i've made.
p
Prashant Shahi
05/22/2024, 2:54 AMokay, you will also need to update the clickhouse password in multiple places.
ā¢
ClickHouseUrlquery-service Copy code
ClickHouseUrl=<tcp://usr:pwd@clickhouse:9000>otel-collector Copy code
clickhousetraces:
datasource: <tcp://usr:pwd@clickhouse:9000/signoz_traces>
clickhousemetricswrite:
endpoint: <tcp://usr:pwd@clickhouse:9000/signoz_metrics>
clickhousemetricswrite/prometheus:
endpoint: <tcp://usr:pwd@clickhouse:9000/signoz_metrics>
clickhouselogsexporter:
dsn: <tcp://usr:pwd@clickhouse:9000/signoz_logs>
...otel-collector-migrator Copy code
command:
- "--dsn=<tcp://usr:pwd@clickhouse:9000>"š 1
a
Ankit Nayan
05/22/2024, 4:58 AM
this should be better managed at single place than spread over at multiple places?
l
L Omary
05/22/2024, 8:29 AMThanks @Prashant Shahi this works great , and i guess if the database is different from default it will be like : tcp://usr:pwd@clickhouse:9000/signoz_logs?database=<new database>
p
Prashant Shahi
05/22/2024, 8:38 AM@L Omary correct
ā
1
Prashant Shahi
05/22/2024, 8:40 AMAnd right, there is one more place where you will need to update.
prometheus.yml Copy code
remote_read:
- url: <tcp://usr:pwd@clickhouse:9000/signoz_metrics>š 1
Prashant Shahi
05/22/2024, 8:44 AM^ This will make sure your promql queries work smoothly, if any.
Prashant Shahi
05/22/2024, 8:50 AMthis should be better managed at single place than spread over at multiple places?we can work on simplifying it to ease out the developer experience - however, for Docker it cannot be at a single place since the prometheus config does not support env variables and involvement of multiple containers envs.
l
L Omary
05/22/2024, 8:53 AMI'll have to do it once , i can create a local script to match and replace it now that i know what to change
L Omary
05/22/2024, 8:55 AMthis is important because you have to be secure by default , and most people that will use that will be insecure and leave their database open : http://demo/?session_timeout=60&output_format_json_quote_64bit_integers=0&enable_http_compression=0&database=signoz_traces&query=select%20*%20from%20distributed_signoz_index_v2%20limit%2020
š 1
a
Ankit Nayan
05/23/2024, 12:55 PM
@L Omary please reshare the above link. It is incorrect now
l
L Omary
05/23/2024, 12:56 PM22 Views