Bug #2382 openssl certs stop working after a month
Submitted: 14 Jan 2004 2:43 Modified: 26 Feb 2004 7:40
Reporter: John Saario Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.13 OS:FreeBSD (FreeBSD)
Assigned to: Assigned Account CPU Architecture:Any

[14 Jan 2004 2:43] John Saario
I have been using various 4.0X releases for the past half a year and have set my certificate expiration at 3600 days but the cert semi-randomly stops working after 1-2 months. A timestamp check of the cert files shows they have not been tampered with and the only fix is to use mysqlgen.sh to generate new certs and restart mysql.

mysql  Ver 12.20 Distrib 4.0.13, for portbld-freebsd4.5 (i386) perl, version 5.005_03 p5-DBI-137.

I have the same problem on my 4.7 release with 4.0.16 and am now trying 4.0.17. I never did get the client working with openssl till I installed 4.0.17.

Not sure if this is an openssl mysql or perl problem exactly.

How to repeat:
Run it on freebsd with self generated certificates which should expire in 2009 and use perl to connect to the database using those certs.
[26 Jan 2004 7:40] Sergei Glukhov
I can't repeat this situation. I suppose that problem is not MySQL related.
Could you check expiraton date of certificates after generating?
What is the 'mysqlgen.sh' script? Could you show this script to verify the
appropriateness of generating of certs?
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".