| Author |
Message |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 7 Jun 2012 15:53:02
|
sauconbf
New member
Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline
|
I have two identical servers, 10.20.20.100 and 10.20.20.101.
PEM Server is installed and functioning as expected on 101. I installed PEM Agent on 100. I believe it correctly connected to the server on 101, as the installation process did not throw any errors about pg_hba.conf when I pointed it to 101. The Agent on 100 shows up in my PEM client as an available agent, and I can bind a database to it with the PEM client.
However, the agent remains as status UNKNOWN both from within the PEM Client and from the web interface. Any databases I bind to that agent also remain status UNKNOWN.
I'm not quite sure where to start looking to determine the cause of this. Any troubleshooting thoughts?
Thanks!
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 00:30:48
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 236
Offline
|
I would prefer to see the installation log and agent logs on 101 machine.
On Windows:
- Installation logs can be found at %TEMP%/install-agent.log
- The agent logs can be found in the windows event-manager.
On non-windows:
- Installation logs can be found @ $TEMP/install-agent.log
- The agent logs can be found @ /var/log/pemagent.log
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 08:51:42
|
sauconbf
New member
Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline
|
Ok, thanks for suggesting a look into those logs. The 101 logs look ok, but on every machine with an agent that PEM claims to be in status "UNKNOWN", there are hundreds of entries in /var/log/pemagent.log that look like this:
or, on a different machine that also has an agent hanging in UNKNOWN status,
Do you know what password is failing here? How do I specify or change that password?
Thanks so much for your help!
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 09:02:12
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 236
Offline
|
Can you please post here the content of pg_hba.conf file from the database server, on which PEM server is installed?
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 09:06:38
|
sauconbf
New member
Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline
|
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 09:13:49
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 236
Offline
|
This is certainly not the content, which was expected.
The pem-server installer doe never set 'password' as authentication.
Are you sure - this is the content of pg_hba.conf from pem-server?
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 09:17:43
|
sauconbf
New member
Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline
|
Yes, this is the correct hba.conf. It is not what was expected, probably because I had to change it from what it originally was:
However, when it was configured this way, the PostgreSQL 9.0 server for PEM failed to start:
So I switched it to the pg_hba.conf that I originally posted. Is that what is messing up the remote agents?
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 09:20:39
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 236
Offline
|
Yeah - that's the case.
pemAgent uses ssl authentication to connect to pem-server.
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 8 Jun 2012 10:01:01
|
sauconbf
New member
Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline
|
What would I add to the pg_hba.conf table to get that working correctly? As I mentioned, if I leave it at "@authmethod@", I get that SSL error:
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 14 Aug 2012 04:40:59
|
Sachin_S
Senior member
Joined: 1 Aug 2008 02:37:24
Messages: 486
Offline
|
Hi,
I am not sure if the answer is relevant to you now, but the message you posted is not an error, its just a warning. you can create an empty root.crl file in the PGDATA folder and that warning will go away.
|
--
Regards,
Sachin Srivastava
EnterpriseDB , the Enterprise Postgres company.
|
|
|
 |
|
|