Re: PostgreSQL+Postfix inquiry

2017-01-30 Thread Jeremy T. Bouse
On 1/30/2017 10:27 AM, Wietse Venema wrote: > Viktor Dukhovni: >>> On Jan 30, 2017, at 8:57 AM, Jeremy T. Bouse >>> wrote: >>> >>> I also found when >>> testing with 'postmap -q' I had to include the PGPASSFILE environment >>> variable as it wasn't being read from main.cf apparently. >> The "impo

Re: PostgreSQL+Postfix inquiry

2017-01-30 Thread Wietse Venema
Viktor Dukhovni: > > > On Jan 30, 2017, at 8:57 AM, Jeremy T. Bouse > > wrote: > > > > I also found when > > testing with 'postmap -q' I had to include the PGPASSFILE environment > > variable as it wasn't being read from main.cf apparently. > > The "import_environment" setting is used to sanit

Re: PostgreSQL+Postfix inquiry

2017-01-30 Thread Viktor Dukhovni
> On Jan 30, 2017, at 8:57 AM, Jeremy T. Bouse > wrote: > > I also found when > testing with 'postmap -q' I had to include the PGPASSFILE environment > variable as it wasn't being read from main.cf apparently. The "import_environment" setting is used to sanitize the environment in master(8) an

Re: PostgreSQL+Postfix inquiry

2017-01-30 Thread Jeremy T. Bouse
On 1/29/2017 6:41 AM, Christoph Moench-Tegeder wrote: > ## Jeremy T. Bouse (jeremy.bo...@undergrid.net): > >> Everything is working fine... So with the PGPASSFILE set in >> import_environment and I've confirmed through procfs that it is in the >> environ file for the postfix processes I comment

Re: PostgreSQL+Postfix inquiry

2017-01-29 Thread Christoph Moench-Tegeder
## Jeremy T. Bouse (jeremy.bo...@undergrid.net): > Everything is working fine... So with the PGPASSFILE set in > import_environment and I've confirmed through procfs that it is in the > environ file for the postfix processes I comment out the 'user' and > 'password' lines in each of the .cf fi

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: [ Charset windows-1252 converted... ] > On 1/28/2017 6:10 PM, Wietse Venema wrote: > > Jeremy T. Bouse: > > [ Charset windows-1252 converted... ] > >> On 1/28/2017 12:16 PM, Wietse Venema wrote: > >>> Sorry about that, I should have written 'import_environment'. That > >>> setting

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
On 1/28/2017 6:10 PM, Wietse Venema wrote: > Jeremy T. Bouse: > [ Charset windows-1252 converted... ] >> On 1/28/2017 12:16 PM, Wietse Venema wrote: >>> Sorry about that, I should have written 'import_environment'. That >>> setting controls what Postfix uses internally, including in its >>> pgsql c

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: [ Charset windows-1252 converted... ] > On 1/28/2017 12:16 PM, Wietse Venema wrote: > > Sorry about that, I should have written 'import_environment'. That > > setting controls what Postfix uses internally, including in its > > pgsql client. > > > > Wietse > > Okay so am I

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: > With the /etc/postfix/pgsql/*.cf files all following the format: > > user = DB_USER > password = DB_PASSWD > hosts = psqldb.undergrid.net > dbname = postfixadmin > query = > > Everything is working fine... So with the PGPASSFILE set in > import_environment and I've con

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
On 1/28/2017 12:16 PM, Wietse Venema wrote: > Sorry about that, I should have written 'import_environment'. That > setting controls what Postfix uses internally, including in its > pgsql client. > > Wietse Okay so am I doing something wrong here... I've got the following in my main.cf:

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: > I tried to set up a PGPASSFILE that I 'chmod 0600' and 'chown > postfix' then added the export_environment setting to my main.cf > pointing to it. Viktor Dukhovni: > The correct setting is "import_environment" not "export_environment". Jeremy T. Bouse: > Thanks Viktor... I'd on

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
On 1/27/2017 11:41 PM, Viktor Dukhovni wrote: >> On Jan 27, 2017, at 6:37 PM, Jeremy T. Bouse >> wrote: >> >> I tried to set up a PGPASSFILE >> that I 'chmod 0600' and 'chown postfix' then added the >> export_environment setting to my main.cf pointing to it. > The correct setting is "import_envir

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Viktor Dukhovni
> On Jan 27, 2017, at 6:37 PM, Jeremy T. Bouse > wrote: > > I tried to set up a PGPASSFILE > that I 'chmod 0600' and 'chown postfix' then added the > export_environment setting to my main.cf pointing to it. The correct setting is "import_environment" not "export_environment". -- Vikt

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Andrew Sullivan
On Fri, Jan 27, 2017 at 06:37:53PM -0500, Jeremy T. Bouse wrote: > I downloaded the source code and poked around a little and doing a > little testing on my current system... I tried to set up a PGPASSFILE > that I 'chmod 0600' and 'chown postfix' then added the > export_environment setting to

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Jeremy T. Bouse
On 1/27/2017 7:03 AM, Wietse Venema wrote: > Jeremy T. Bouse: >>> https://www.postgresql.org/docs/current/static/libpq-pgservice.html >>> https://www.postgresql.org/docs/current/static/libpq-connect.html >>> https://www.postgresql.org/docs/current/static/libpq-pgpass.html >>> >>> I need to test tha

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Wietse Venema
Jeremy T. Bouse: > Then leave out the user and password from the .cf files that would > be precisely the solution I was looking for. Now you mentioned > configuring the table as pgsql:/path/to/file would that also work if > using proxy:pgsql:/path/to/file Perhaps surprisingly, proxy:pgsql:/pat

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Jeremy T. Bouse
On 1/27/2017 7:03 AM, Wietse Venema wrote: > Jeremy T. Bouse: >>> https://www.postgresql.org/docs/current/static/libpq-pgservice.html >>> https://www.postgresql.org/docs/current/static/libpq-connect.html >>> https://www.postgresql.org/docs/current/static/libpq-pgpass.html >>> >>> I need to test tha

Re: PostgreSQL+Postfix inquiry

2017-01-27 Thread Wietse Venema
Jeremy T. Bouse: > > https://www.postgresql.org/docs/current/static/libpq-pgservice.html > > https://www.postgresql.org/docs/current/static/libpq-connect.html > > https://www.postgresql.org/docs/current/static/libpq-pgpass.html > > > > I need to test that. > > > > Regards, > > Christoph > This

Re: PostgreSQL+Postfix inquiry

2017-01-26 Thread Jeremy T. Bouse
On 1/26/2017 3:58 AM, Christoph Moench-Tegeder wrote: > ## Jeremy T. Bouse (jeremy.bo...@undergrid.net): > >> I've been using PostgreSQL, and MySQL in the past, to hold virtual user >> information for my Postfix server. The only thing that has bothered me >> is every *sql_*.cf file I had to setup h

Re: PostgreSQL+Postfix inquiry

2017-01-26 Thread Jeremy T. Bouse
On 1/26/2017 2:15 AM, Patrick Ben Koetter wrote: > * Jeremy T. Bouse : >> I'm going ahead and asking here as I've been searching and haven't >> found any information... >> >> I've been using PostgreSQL, and MySQL in the past, to hold virtual user >> information for my Postfix server. The only

Re: PostgreSQL+Postfix inquiry

2017-01-26 Thread Christoph Moench-Tegeder
## Jeremy T. Bouse (jeremy.bo...@undergrid.net): > I've been using PostgreSQL, and MySQL in the past, to hold virtual user > information for my Postfix server. The only thing that has bothered me > is every *sql_*.cf file I had to setup had to have the username, > password and host to use for the

Re: PostgreSQL+Postfix inquiry

2017-01-25 Thread Patrick Ben Koetter
* Jeremy T. Bouse : > I'm going ahead and asking here as I've been searching and haven't > found any information... > > I've been using PostgreSQL, and MySQL in the past, to hold virtual user > information for my Postfix server. The only thing that has bothered me > is every *sql_*.cf file I h