Issues with 2.4.1 & remote postgresql server

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-PARAMKEYWORDS 
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



_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]