Thread: pgAgent authentication problem
[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
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/
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/