SSL Certificate Tracking as a PHP Web App
This is a quick little set of PHP pages which can keep track of your SSL certificates (if you have multiple certs from multiple vendors). While working as a systems administrator, I wrote this to keep track of the tons of SSL certificates we had and actively used. Often, we’d find ourselves not knowing when certificates expired until a customer called. This allowed us to be more proactive in managing the certificate expirations, schedule downtimes, inform clients, etc.
This requires the Yahoo! UI framework to function properly. You can download it here.
There’s also a small database schema involved. Here’s a quick schema description:
Table name: SSL_CERTIFICATES
Column: CertDomain, varchar(64), primary key
Column: CertAuth, varchar(64)
Column: ExpirationDate, datetime
Column: Termination, varchar(64)
Column: CertFile, blob
The CertFile field isn’t really used for anything. I later went back and took a crack at actually storing the certificates in the database. I never finished that part. So these pages may not function right out of the box. You’ll need to modify a few things. For one, the $DBReader variable in the getSSLCerts.php and addCert.php pages is just an ODBC link which is used to do all of the database transactions. I had a helper function which did the connection to the database; so it is hidden in the files. You’ll also need to remove the “require(“../common.php”);” lines anywhere you find them. That contained the database functions.
The scripts use ODBC for the database transactions, you can easily swap out the ODBC functions for MySQL functions if desired.
So… with all of that being said *clears throat*…. You may use and distribute any of these php files with or without modification. The author (me) provides NO WARRANTY and is not responsible for any damage caused as a result of running these scripts/pages/files. If you agree to these terms, then feel free to download the files below: