Re: PEM Installation

Merhabalar Fırat Bey,

/root/.pem dizinini kontrol eder misiniz, orada sertifikalar oluşmuş mu?

Ek olarak aşağıdaki komutun çıktısını da kontrol etmenizde fayda var. Agent sertifikasının adı agent1.crt, PostgreSQL'in data dizini de /var/lib/pgsql/9.5/data değil ise aşağıdaki komutu uygun şekilde değiştirmeniz gerekiyor. Aşağıdaki komutun çıktısı sertifikanın doğrulanması durumunda aşağıdaki gibi olması gerekiyor.

openssl verify -verbose -CAfile /var/lib/pgsql/9.5/data/root.crt /root/.pem/agent1.crt

Örnek çıktı:

agent1.crt: OK

İyi çalışmalar.

Samed YILDIRIM

20.12.2017, 10:18, "Fırat Güleç" firat(dot)gulec(at)hepsiexpress(dot)com:

Merhabalar,

Postgres’in bulunduğu server’a PEM kurulumu yapmaya çalışıyorum. “https://get.enterprisedb.com/docs/PEM_Installation_Guide_v7_Beta.pdf” dokumanını baz alarak “3.1.3 Installing the PEM Server on an Existing Postgres Server” adımını izleyerek PEM server, agent ve apache kurulumunu postgresql’in kurulu olduğu server’a yaptım. Screenshot 1 deki gibi login olabildim, fakat agent’lar unkown olduğu için istatislik vs toplamıyor. “/var/log/pem/worker.log” a baktığımda aşağıdaki gibi “unable to connect to PEM database: FATAL: connection requires a valid client certificate” gibi loglar mevcut. Dökümanı sırası ile yaptım, screenshot 2 de gösterildiği gibi /root/.pem’i certificate path olarak göstermiştim .PEM kullananlar var ise siz de böyle bir hata ile karşılaştınız mı?

Yardımlarınız için şimdiden çok teşekkür ederim.

Postgres version: 9.5.10

Kullanılan pem installer: pem-server-7.0.0-1-linux-x64.run

Screenshot 1:

“/var/log/pem/worker.log”

Wed Dec 20 09:34:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:34:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:34:54 2017 : WARNING: NAGIOSSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:34:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:34:54 2017 : WARNING: SMTPSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:34:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:34:54 2017 : WARNING: Alerts[1]: Unable to establish connection to PEM database.

Wed Dec 20 09:34:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:34:54 2017 : WARNING: SNMPSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:24 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:24 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:24 2017 : WARNING: NAGIOSSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:24 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:24 2017 : WARNING: SMTPSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:24 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:24 2017 : WARNING: Alerts[1]: Unable to establish connection to PEM database.

Wed Dec 20 09:35:24 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:24 2017 : WARNING: SNMPSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:54 2017 : WARNING: NAGIOSSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:54 2017 : WARNING: SMTPSpooler: Unable to establish connection to PEM database.

Wed Dec 20 09:35:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:54 2017 : WARNING: Alerts[1]: Unable to establish connection to PEM database.

Wed Dec 20 09:35:54 2017 : WARNING: unable to connect to PEM database: FATAL: connection requires a valid client certificate

Wed Dec 20 09:35:54 2017 : WARNING: SNMPSpooler: Unable to establish connection to PEM database.

Screehshot 2:

FIRAT GÜLEÇ

Veritabanı Yöneticisi

firat(dot)gulec(at)hepsiexpress(dot)com

M:0 532 210 57 18

İnönü Mh. Mimar Sinan Cd. No:3 Güzeller Org.San.Bölg. GEBZE / KOCAELİ