EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

PEM Agent installation succeeds, hangs "UNKNOWN" indefinitely  XML

Forum Index » Postgres Enterprise Manager
Author Message
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!
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
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!
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
sauconbf

New member

Joined: 7 Jun 2012 14:32:43
Messages: 5
Offline

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
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?

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
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:

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.
 
Forum Index » Postgres Enterprise Manager
Go to:   
Powered by JForum 2.1.8 © JForum Team