Can't connect to Redis through a unix socket

[diogotcorreia]

Hey,
I'm packaging Dawarich for Nixpkgs, and we usually use Unix sockets for connecting to Redis and Postgres.
It appears that the way Dawarich constructs only works for host/port URLs and not for unix:// URIs.

OS & Hardware
NixOS 25.11 (unstable, master branch)
Hardware is irrelevant for this issue

Version
0.29.1

Describe the bug

Code in Dawarich adds /<number> to the value of REDIS_URL.
This works fine for redis:// URIs, but breaks unix:// URIs, since it is just treated a path separator.
The correct syntax for unix:// URIs would be ?db=<number>.

See https://github.com/redis-rb/redis-client/blob/98a51a42c9952f76238da7f6390315e7d1edb6b3/lib/redis_client/url_config.rb#L30-L42

To Reproduce

1. Setup Redis with unix sockets
2. Set REDIS_URL to unix:///run/redis-dawarich/redis.sock
3. Try to run the migrations

Expected behavior
Dawarich should support both unix:// and redis:// URIs.

Logs

machine # [   54.538659] dawarich-init-db-start[1001]: Tasks: TOP => data:migrate
machine # [   54.539811] dawarich-init-db-start[1001]: (See full trace by running task with --trace)
machine # [   54.541120] dawarich-init-db-start[1001]: Migrating to BindExistingPointsToFirstUser (20240525110530)
machine # [   54.542560] dawarich-init-db-start[1001]: == 20240525110530 BindExistingPointsToFirstUser: migrating ====================
machine # [   54.544216] dawarich-init-db-start[1001]: == 20240525110530 BindExistingPointsToFirstUser: migrated (0.0510s) ===========
machine # [   54.545935] dawarich-init-db-start[1001]: Migrating to RemovePointsWithoutCoordinates (20240610170930)
machine # [   54.547383] dawarich-init-db-start[1001]: == 20240610170930 RemovePointsWithoutCoordinates: migrating ===================
machine # [   54.549008] dawarich-init-db-start[1001]: Found 0 points without coordinates...
machine # [   54.550278] dawarich-init-db-start[1001]: Points without coordinates removed.
machine # [   54.551477] dawarich-init-db-start[1001]: INFO  2025-07-09T17:31:48.798Z pid=1001 tid=221: Sidekiq 8.0.4 connecting to Redis with options {size: 10, pool_name: "internal", url: "unix:///run/redis-dawarich/redis.sock/1"}
machine # [   54.554235] dawarich-init-db-start[1001]: Failed enqueuing BulkStatsCalculatingJob to Sidekiq(stats): RedisClient::CannotConnectError (Not a directory - connect(2) for /run/redis-dawarich/redis.sock/1 (unix:///run/redis-dawarich/redis.sock/1))
machine # [   54.559829] systemd[1]: dawarich-init-db.service: Main process exited, code=exited, status=1/FAILURE
machine # [   54.561625] systemd[1]: dawarich-init-db.service: Failed with result 'exit-code'.
machine # [   54.564899] systemd[1]: Failed to start dawarich-init-db.service.

Solution

A possible solution would be to use the built-in db argument instead, since it works with any type of URI.

See https://github.com/redis-rb/redis-client/blob/98a51a42c9952f76238da7f6390315e7d1edb6b3/lib/redis_client/config.rb#L198-L201

Additional context
Bug introduced with #1420

I have a working fix and will be making a PR shortly.

Relates to NixOS/nixpkgs#345622

[Morethanevil]

Would like to use this too. Are socket connection possible for Postgres?

[diogotcorreia]

@Morethanevil Yes, socket connections seem to be working for PostgreSQL:
https://github.com/diogotcorreia/nixpkgs/blob/fe7665dfe4c1f4e11b61e7271b732934f32540e4/nixos/modules/services/web-apps/dawarich.nix#L36-L38
https://github.com/diogotcorreia/nixpkgs/blob/fe7665dfe4c1f4e11b61e7271b732934f32540e4/nixos/modules/services/web-apps/dawarich.nix#L360

Just set DATABASE_HOST to /run/postgresql, and perhaps DATABASE_USER and DATABASE_NAME

[Morethanevil]

Good to know, thanks 😊

I only tried the standard compose for testing and looking around a bit. I will wait for your PR being merged, so I can move this to my production environment

[ThxAndBye]

This would be very helpful. I ran into the same issue when trying to setup dawarich.
Looks like #1508 is ready to go but the issue got transferred to a discussion? So is there any information about if and when this will be available in a release version or does the transfer to a discussion mean that it's off the table?

Thanks @diogotcorreia for the analytics and PR to allow a redis socket and @Freika for the software in the first place.

[ThxAndBye]

Thanks you @Freika for adding the changes to the 0.36.0-rc.1
The Sidekiq is now starting for me and connecting to the Redis via the Unix Socket and the container keeps running.

With the main application I still get the same issue, where the Redis database is added directly to the URL part of the connection.

Migrating to RemovePointsWithoutCoordinates (20240610170930)
== 20240610170930 RemovePointsWithoutCoordinates: migrating ===================
  TRANSACTION (0.1ms)  BEGIN
  ↳ app/models/import.rb:7:in '<class:Import>'
  Point Count (5.9ms)  SELECT COUNT(*) FROM "points" WHERE (longitude = 0.0 OR latitude = 0.0)
Found 0 points without coordinates...
  Point Load (0.3ms)  SELECT "points".* FROM "points" WHERE (longitude = 0.0 OR latitude = 0.0)
Points without coordinates removed.
INFO  2025-11-15T16:18:52.396Z pid=21 tid=1w5: Sidekiq 8.0.8 connecting to Redis with options {size: 10, pool_name: "internal", url: "unix:///run/valkey/valkey.sock/15"}
Failed enqueuing BulkStatsCalculatingJob to Sidekiq(stats): RedisClient::CannotConnectError (Not a directory - connect(2) for /run/valkey/valkey.sock/15 (unix:///run/valkey/valkey.sock/15))

If there are any additional information needed then I'm happy to help.

[diogotcorreia]

#1970