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
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
> 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
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
## 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
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
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
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
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
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:
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
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
> 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
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
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
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
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
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
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
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
## 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
* 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
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 had to setup had to have the user
23 matches
Mail list logo
