postgres socket connection uses the wrong value for database

[mapreri]

Version:

• listmonk: v4.1.0
• OS: Debian 12 (bookworm)

Description of the bug and steps to reproduce:

Trying to install listmonk using unix socket auth

[db]
#host = "localhost"
host = "/var/run/postgresql/"
port = 5433
user = "myuser"
#password = "listmonk"

# Ensure that this database has been created in Postgres.
database = "listmonk"

This shows this on --install:

2025/01/30 07:32:02.942176 main.go:107: v4.1.0 (0a27de1 2024-11-12T18:42:26Z, linux/amd64)
2025/01/30 07:32:02.942285 init.go:163: reading config: config.toml
2025/01/30 07:32:02.942525 init.go:303: connecting to db: /var/run/postgresql/:5433/listmonk
2025/01/30 07:32:02.943965 init.go:307: error connecting to DB: pq: database "myuser" does not exist

It should be noted that:

• the user "myuser" exists
• the database "listmonk" exists

I then created a database named "myuser", and --install proceeded:

2025/01/30 07:32:52.730536 main.go:107: v4.1.0 (0a27de1 2024-11-12T18:42:26Z, linux/amd64)
2025/01/30 07:32:52.730905 init.go:163: reading config: config.toml
2025/01/30 07:32:52.731260 init.go:303: connecting to db: /var/run/postgresql/:5433/listmonk

** first time installation **
** IMPORTANT: This will wipe existing listmonk tables and types in the DB 'listmonk' **
continue (y/N)?  y
2025/01/30 07:32:57.871222 install.go:88: no Super Admin user created. Visit webpage to create user.
2025/01/30 07:32:57.871257 install.go:91: setup complete
2025/01/30 07:32:57.871263 install.go:92: run the program and access the dashboard at localhost:9000

The log keeps talking about the "listmonk" database, but I verifying that the installation was done on the "myuser" database.

[knadh]

hm, I'm not sure how this is happening. The connection string is a standard Postgres DSN string made out of variables in the config:

listmonk/cmd/init.go

Line 306 in ad162c2

fmt.Sprintf("host=%s port=%d user=%s password=%s dbname=%s sslmode=%s %s", c.Host, c.Port, c.User, c.Password, c.DBName, c.SSLMode, c.Params))

listmonk/cmd/install.go

Line 24 in ad162c2

ko.String("db.database"))

If you don't have database = "listmonk" in the config (or the env variable for it configured), then the log won't print "listmonk" as the database name. It comes from the config.

[mapreri]

Why completed? I don't see how this was fixed?

…

On Tue, 11 Feb 2025, 7:54 pm Kailash Nadh, ***@***.***> wrote: Closed #2275 <#2275> as completed. — Reply to this email directly, view it on GitHub <#2275 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAL7FE2CTTPO3GKGNA3WLKL2PJBMTAVCNFSM6AAAAABWETBDBKVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJWGI3DSNRZHE3DQMQ> . You are receiving this because you authored the thread. Message ID: ***@***.***>

[knadh]

Ah, I assumed this was a misconfiguration and was resolved after seeing no response. Please see my previous comment.

[mapreri]

Right, I can confirm you that I have a database="listmonk" in my config (see the excerpt in the first post). I'm really as baffled as you here, especially given the disconnect between the log, and what then actually happens.

2025/01/30 07:32:02.942525 init.go:303: connecting to db: /var/run/postgresql/:5433/listmonk
2025/01/30 07:32:02.943965 init.go:307: error connecting to DB: pq: database "myuser" does not exist

just look at these two lines, where just 0.0015 seconds after the databse name apparently changes...

Please tell me if and how I could help in debugging.

[mapreri]

@knadh do you have idea where this issue might be coming from?

(commenting since this issue is closed, I wouldn't want it to be lost)

[knadh]

I've been unable to reproduce this, unfortunately. Will leave this open for anyone with time to debug.