Thread: pgAgent authentication problem

pgAgent authentication problem

From
Együd Csaba (Freemail)
Date:
[Sorry if this post arrives twice. I have problems with my news reader.]

Hi ,
I installed pgAdmin3 1.6 on WindowsXP SP2. The postgres 8.1.4 server is
running on localhost (port=54814).
I try to test pgAgent before I switch it to production.

I realized that everithing works well when I put a password="xxx" into the
connection string during service INSTALL.
INSTALL command:
pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
dbname=postgres user=postgres password="ZZZZZ" port=54814

BUT
When I try to use pgpass.conf the service reports this: "Couldn't create
connection: fe_sendauth: no password supplied".
(My pgpass.conf is in "C:\Documents and Settings\Csaba\Application
Data\postgresql" folder.)
it's contents:
-------------------------------------------
localhost:54814:*:postgres:ZZZZZ
localhost:54814:*:Csaba:XXXXXX
-------------------------------------------

INSTALL comand:
pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
dbname=postgres user=postgres port=54814

It seems pgagent is not able to find pgpass.conf. BTW, PgAdmin uses it
correctly.
What could be the problem? A bug or more likely a misconfiguration?

Many thanks,

-- Csaba Együd

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.2/559 - Release Date: 2006.11.30.
5:07



Re: pgAgent authentication problem

From
"Ezequias Rodrigues da Rocha"
Date:
Try to put  127.0.0.1:54814:*:postgres:ZZZZZ

In my case it works, but not on Windows (in my case linux CentOS, as Server)

2006/11/30, Együd Csaba (Freemail) <csegyud@freemail.hu>:
> [Sorry if this post arrives twice. I have problems with my news reader.]
>
> Hi ,
> I installed pgAdmin3 1.6 on WindowsXP SP2. The postgres 8.1.4 server is
> running on localhost (port=54814).
> I try to test pgAgent before I switch it to production.
>
> I realized that everithing works well when I put a password="xxx" into the
> connection string during service INSTALL.
> INSTALL command:
> pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
> dbname=postgres user=postgres password="ZZZZZ" port=54814
>
> BUT
> When I try to use pgpass.conf the service reports this: "Couldn't create
> connection: fe_sendauth: no password supplied".
> (My pgpass.conf is in "C:\Documents and Settings\Csaba\Application
> Data\postgresql" folder.)
> it's contents:
> -------------------------------------------
> localhost:54814:*:postgres:ZZZZZ
> localhost:54814:*:Csaba:XXXXXX
> -------------------------------------------
>
> INSTALL comand:
> pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
> dbname=postgres user=postgres port=54814
>
> It seems pgagent is not able to find pgpass.conf. BTW, PgAdmin uses it
> correctly.
> What could be the problem? A bug or more likely a misconfiguration?
>
> Many thanks,
>
> -- Csaba Együd
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.430 / Virus Database: 268.15.2/559 - Release Date: 2006.11.30.
> 5:07
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=                                 Atenciosamente
(Sincerely)                      Ezequias Rodrigues da
Rocha=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/


Re: pgAgent authentication problem

From
"Ezequias Rodrigues da Rocha"
Date:
I would suggest you to put the parameters in the same order you can
find in pgpass.conf

I did like this(starting the service):
/usr/bin/pgagent hostaddr=127.0.0.1 dbname=xxxxxxxx user=xxxx -l 2 &



2006/11/30, Együd Csaba (Freemail) <csegyud@freemail.hu>:
> [Sorry if this post arrives twice. I have problems with my news reader.]
>
> Hi ,
> I installed pgAdmin3 1.6 on WindowsXP SP2. The postgres 8.1.4 server is
> running on localhost (port=54814).
> I try to test pgAgent before I switch it to production.
>
> I realized that everithing works well when I put a password="xxx" into the
> connection string during service INSTALL.
> INSTALL command:
> pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
> dbname=postgres user=postgres password="ZZZZZ" port=54814
>
> BUT
> When I try to use pgpass.conf the service reports this: "Couldn't create
> connection: fe_sendauth: no password supplied".
> (My pgpass.conf is in "C:\Documents and Settings\Csaba\Application
> Data\postgresql" folder.)
> it's contents:
> -------------------------------------------
> localhost:54814:*:postgres:ZZZZZ
> localhost:54814:*:Csaba:XXXXXX
> -------------------------------------------
>
> INSTALL comand:
> pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
> dbname=postgres user=postgres port=54814
>
> It seems pgagent is not able to find pgpass.conf. BTW, PgAdmin uses it
> correctly.
> What could be the problem? A bug or more likely a misconfiguration?
>
> Many thanks,
>
> -- Csaba Együd
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.430 / Virus Database: 268.15.2/559 - Release Date: 2006.11.30.
> 5:07
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=                                 Atenciosamente
(Sincerely)                      Ezequias Rodrigues da
Rocha=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/