Re: Valid certificate reported as expired

2008-10-10 Thread Andrej Podzimek
Have you enabled CRL checking too? You can also get that if the nextUpdate time in a CRL has passed. That might explain things if the CRL runs for a month or so. WOW! That's it! Thank you so much! CRL expired exactly the day it stopped working. I did not know that a CRL could expire. Never exp

RE: Valid certificate reported as expired

2008-10-09 Thread Dave Thompson
> -Original Message- > From: [EMAIL PROTECTED] On Behalf Of Andrej Podzimek > Sent: Thursday, 09 October, 2008 10:39 > > Might be some STARTTLS equivalent but I'm not sure what it is for that > > application. > > PostgreSQL always listens on one port. This is the only port I > ever used

Re: Valid certificate reported as expired

2008-10-09 Thread Victor Duchovni
On Thu, Oct 09, 2008 at 10:19:58PM +0200, Andrej Podzimek wrote: > if (i < 0) > { > + FILE * f; > + f = fopen( "/tmp/CERTDUMP_EXPIRED", "w" ); > + PEM_write_X509( f, x ); > + fclose( f ); > ctx->error=X509_V_ERR_CERT

Re: Valid certificate reported as expired

2008-10-09 Thread Dr. Stephen Henson
On Thu, Oct 09, 2008, Andrej Podzimek wrote: >> Then I suggest you run the following command on those systems too: >> openssl verify -CAfile root.crt other.crt >> Where "other.crt" is the EE certificate, server.crt or posgresql.crt > > Says OK on both machines. > >> In crypto/x509/x509_vfy.c the f

Re: Valid certificate reported as expired

2008-10-09 Thread Andrej Podzimek
Then I suggest you run the following command on those systems too: openssl verify -CAfile root.crt other.crt Where "other.crt" is the EE certificate, server.crt or posgresql.crt Says OK on both machines. In crypto/x509/x509_vfy.c the function check_cert_time() is the one you need. Around the

Re: Valid certificate reported as expired

2008-10-09 Thread Dr. Stephen Henson
On Thu, Oct 09, 2008, Andrej Podzimek wrote: >> Hmmm Is that the right port for SSL/TLS if it is it looks like it >> isn't >> just a a case of connecting to the right port to get an SSL/TLS >> connection. Might be some STARTTLS equivalent but I'm not sure what it is >> for that >> applicati

Re: Valid certificate reported as expired

2008-10-09 Thread Victor Duchovni
On Thu, Oct 09, 2008 at 05:43:15PM +0200, Andrej Podzimek wrote: > >When a PEM file holds multiple certificates (a chain), this command > >only shows the first one. You need to break each of the ".crt" files > >into separate files for each certificate, and look at those. > > The root.crt file hol

Re: Valid certificate reported as expired

2008-10-09 Thread Andrej Podzimek
On Thu, Oct 09, 2008 at 04:39:06PM +0200, Andrej Podzimek wrote: I only have one directory and one CA certificate. That makes the task simple. On the client: [EMAIL PROTECTED] .postgresql]$ openssl x509 -in postgresql.crt -text | grep Not Not Before: Mar 25 12:00:00 200

Re: Valid certificate reported as expired

2008-10-09 Thread Victor Duchovni
On Thu, Oct 09, 2008 at 04:39:06PM +0200, Andrej Podzimek wrote: > I only have one directory and one CA certificate. That makes the task > simple. > > On the client: > [EMAIL PROTECTED] .postgresql]$ openssl x509 -in postgresql.crt -text > | grep Not > Not Before:

Re: Valid certificate reported as expired

2008-10-09 Thread Andrej Podzimek
Hmmm Is that the right port for SSL/TLS if it is it looks like it isn't just a a case of connecting to the right port to get an SSL/TLS connection. Might be some STARTTLS equivalent but I'm not sure what it is for that application. PostgreSQL always listens on one port. This is the only po

Re: Valid certificate reported as expired

2008-10-09 Thread Dr. Stephen Henson
On Wed, Oct 08, 2008, Andrej Podzimek wrote: >> Are any intermediate CA certificates involved? > > No. The CA is home-made, created using OpenSSL. It has a self-signed > certificate. > >> This command will dump all certificates received: >> openssl s_client -connect hostname:portnum -showcerts >

Re: Valid certificate reported as expired

2008-10-08 Thread Andrej Podzimek
How about posting the certificate chain printed by -showcerts? If you don't get one, then it's entirely possible that you've got a problem on your server (such as not having the correct private key for the certificate). Well, that is possible, but not very probable. I am the only admin of the

Re: Valid certificate reported as expired

2008-10-08 Thread Kyle Hamilton
How about posting the certificate chain printed by -showcerts? If you don't get one, then it's entirely possible that you've got a problem on your server (such as not having the correct private key for the certificate). -Kyle H On Wed, Oct 8, 2008 at 2:16 PM, Andrej Podzimek <[EMAIL PROTECTED]>

Re: Valid certificate reported as expired

2008-10-08 Thread Andrej Podzimek
Are any intermediate CA certificates involved? No. The CA is home-made, created using OpenSSL. It has a self-signed certificate. This command will dump all certificates received: openssl s_client -connect hostname:portnum -showcerts [EMAIL PROTECTED] ~]$ openssl s_client -connect m

Re: Valid certificate reported as expired

2008-10-08 Thread Dr. Stephen Henson
On Wed, Oct 08, 2008, Andrej Podzimek wrote: > Hello, > > both psql and pgAdmin refuse to connect to my PostgreSQL server using SSL. > These two error messages alternate: > > SSL error: sslv3 alert certificate expired > SSL error: certificate verify failed > > CA certificate is valid

Valid certificate reported as expired

2008-10-08 Thread Andrej Podzimek
Hello, both psql and pgAdmin refuse to connect to my PostgreSQL server using SSL. These two error messages alternate: SSL error: sslv3 alert certificate expired SSL error: certificate verify failed CA certificate is valid till 2011. Server certificate is valid till 2009. Client