Hello,
I'm stumped with using a remote postgresql database for authentication.
I went through the process once, failed, debugged, failed again. I could successfully use psql to access the remote database from my host machine, so I do not believe the remote access is an issue.
I implemented an instance using sqlite3 database and it worked just fine.
from auth-sql.conf.ext
sql_driver = pgsql
pgsql 72.44.55.66 { parameters { sslmode = require user = user password = 123 dbname = db } }
I'm using lmtp over sockets to deliver mail to dovecot, in order to isolate any interaction issues. With a postgresql db I get "Mailbox isn't a valid mbox file", but with changes only to auth-sql.conf.ext it fails.
I can run the queries from psql and they work.
I'm pretty much out of ideas of things to try.
I could not find anything to validate the syntax of the psql data. All the examples had "psql localhots {"
Because of the above, I am wondering if there may be an issue in the postgres driver somehow?
I did look at the documentation for https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWOR... but I'm unsure what is needed.
Thanks for any ideas, help, hints. If someone has an example that works with 2.4.1-4 (7d8c0e5759) on debian 13 that would be great
Terry