* [Sysadmins] ALS 4.0.1. Постгрес глючит с SSL
@ 2008-07-02 7:56 Alexey Borovskoy
0 siblings, 0 replies; only message in thread
From: Alexey Borovskoy @ 2008-07-02 7:56 UTC (permalink / raw)
To: sysadmins
[-- Attachment #1: Type: text/plain, Size: 1480 bytes --]
Добрый вечер.
Не победил седня глюк. Что надо подкрутить непонятно.
Есть postgresql8.2-server-8.2.4-alt2. Стоит в контейнере ovz.
Сгенерен ssl-сертификат и ключ.
В конфиге постгресса включено ssl=on.
Доступ прописан вот так:
hostssl all all 172.16.81.254/32 md5
При подключении клиента ругается вот так:
LOG: 00000: database system was shut down at 2008-07-02 19:10:53
PETST
LOCATION: StartupXLOG, xlog.c:4672
LOG: 00000: checkpoint record is at 0/42CAEC
LOCATION: StartupXLOG, xlog.c:4762
LOG: 00000: redo record is at 0/42CAEC; undo record is at 0/0;
shutdown TRUE
LOCATION: StartupXLOG, xlog.c:4789
LOG: 00000: next transaction ID: 0/608; next OID: 16385
LOCATION: StartupXLOG, xlog.c:4793
LOG: 00000: next MultiXactId: 1; next MultiXactOffset: 0
LOCATION: StartupXLOG, xlog.c:4796
LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:5188
LOG: 08P01: could not accept SSL connection: ssl session id
callback failed
LOCATION: open_server_SSL, be-secure.c:912
FATAL: 28000: no pg_hba.conf entry for host "172.16.81.254",
user "postgres", database "postgres", SSL off
LOCATION: ClientAuthentication, auth.c:414
Что это, Берримор?
--
Алексей.
GPG key fingerprint
949B BC0E 2C44 7528 4F63 2753 E37A 9E3F 11F3 BDE1
[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] only message in thread
only message in thread, other threads:[~2008-07-02 7:56 UTC | newest]
Thread overview: (only message) (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2008-07-02 7:56 [Sysadmins] ALS 4.0.1. Постгрес глючит с SSL Alexey Borovskoy
ALT Linux sysadmins discussion
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \
sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com
public-inbox-index sysadmins
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sysadmins
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git