MySQL Bugs: #2382: openssl certs stop working after a month

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.13	OS:	FreeBSD (FreeBSD)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
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.

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?

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".