| Lists: | pgsql-tr-genel |
|---|
| From: | Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com> |
|---|---|
| To: | pgsql-tr-genel(at)postgresql(dot)org |
| Subject: | PEM Installation |
| Date: | 2017-12-20 07:17:57 |
| Message-ID: | d484a610f3bc122a1cbe7afb4d67e32b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-tr-genel |
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İ
------------------------------
[image: Inline image 1]
| From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
|---|---|
| To: | Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com>, "pgsql-tr-genel(at)postgresql(dot)org" <pgsql-tr-genel(at)postgresql(dot)org> |
| Subject: | Re: PEM Installation |
| Date: | 2017-12-20 09:15:15 |
| Message-ID: | 523741513761315@web16o.yandex.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-tr-genel |
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İ
| From: | Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com> |
|---|---|
| To: | Samed YILDIRIM <samed(at)reddoc(dot)net>, pgsql-tr-genel(at)postgresql(dot)org |
| Subject: | RE: PEM Installation |
| Date: | 2017-12-20 11:54:27 |
| Message-ID: | 5ba3a2cb9951739caf991cc64fb99294@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-tr-genel |
Merhaba Samed Bey,
Cevabınız için teşekkür ederim.
Evet oluşmuş, komut’un çıktısı OK olarak döndü.
*From:* Samed YILDIRIM [mailto:samed(at)reddoc(dot)net]
*Sent:* Wednesday, December 20, 2017 12:15 PM
*To:* Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com>;
pgsql-tr-genel(at)postgresql(dot)org
*Subject:* 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İ
------------------------------
[image: Inline image 1]
| From: | Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com> |
|---|---|
| To: | Samed YILDIRIM <samed(at)reddoc(dot)net>, pgsql-tr-genel(at)postgresql(dot)org |
| Subject: | RE: PEM Installation |
| Date: | 2017-12-21 12:31:59 |
| Message-ID: | a5c4b92793104f734003d6d18d389550@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-tr-genel |
Merhabalar,
Komut ok döndü fakat hata hala devam ediyor.
Tşkler.
*From:* Fırat Güleç [mailto:firat(dot)gulec(at)hepsiexpress(dot)com]
*Sent:* Wednesday, December 20, 2017 2:54 PM
*To:* 'Samed YILDIRIM' <samed(at)reddoc(dot)net>; 'pgsql-tr-genel(at)postgresql(dot)org' <
pgsql-tr-genel(at)postgresql(dot)org>
*Subject:* RE: PEM Installation
Merhaba Samed Bey,
Cevabınız için teşekkür ederim.
Evet oluşmuş, komut’un çıktısı OK olarak döndü.
*From:* Samed YILDIRIM [mailto:samed(at)reddoc(dot)net <samed(at)reddoc(dot)net>]
*Sent:* Wednesday, December 20, 2017 12:15 PM
*To:* Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com>;
pgsql-tr-genel(at)postgresql(dot)org
*Subject:* 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İ
------------------------------
[image: Inline image 1]
| From: | Ender Uygun <enderuygun(at)hotmail(dot)com> |
|---|---|
| To: | Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com> |
| Cc: | Samed YILDIRIM <samed(at)reddoc(dot)net>, "pgsql-tr-genel(at)postgresql(dot)org" <pgsql-tr-genel(at)postgresql(dot)org> |
| Subject: | Re: PEM Installation |
| Date: | 2017-12-21 13:41:32 |
| Message-ID: | CY4PR07MB30489370C4ADFFEF7738C7AFC70D0@CY4PR07MB3048.namprd07.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-tr-genel |
Bu mail grubuna nasil dahil oldugum ile ilgili bir fikrim yok.
Rica etsem ilgili kisi beni cikarabilir mi?
Cok tesekkur ederim simdiden.
Selamlar
iPhone’umdan gönderildi
Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com<mailto:firat(dot)gulec(at)hepsiexpress(dot)com>> şunları yazdı (21 Ara 2017 15:32):
Merhabalar,
Komut ok döndü fakat hata hala devam ediyor.
Tşkler.
From: Fırat Güleç [mailto:firat(dot)gulec(at)hepsiexpress(dot)com<mailto:firat(dot)gulec(at)hepsiexpress(dot)com>]
Sent: Wednesday, December 20, 2017 2:54 PM
To: 'Samed YILDIRIM' <samed(at)reddoc(dot)net<mailto:samed(at)reddoc(dot)net>>; 'pgsql-tr-genel(at)postgresql(dot)org<mailto:pgsql-tr-genel(at)postgresql(dot)org>' <pgsql-tr-genel(at)postgresql(dot)org<mailto:pgsql-tr-genel(at)postgresql(dot)org>>
Subject: RE: PEM Installation
Merhaba Samed Bey,
Cevabınız için teşekkür ederim.
Evet oluşmuş, komut’un çıktısı OK olarak döndü.
<image001.png>
From: Samed YILDIRIM [mailto:samed(at)reddoc(dot)net]
Sent: Wednesday, December 20, 2017 12:15 PM
To: Fırat Güleç <firat(dot)gulec(at)hepsiexpress(dot)com<mailto:firat(dot)gulec(at)hepsiexpress(dot)com>>; pgsql-tr-genel(at)postgresql(dot)org<mailto:pgsql-tr-genel(at)postgresql(dot)org>
Subject: 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<mailto: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:
<image002.png>
“/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:
<image003.png>
FIRAT GÜLEÇ
Veritabanı Yöneticisi
firat(dot)gulec(at)hepsiexpress(dot)com<mailto: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İ
________________________________
<image004.png>