Stories
Slash Boxes
Comments

Dev.SN ♥ developers

posted by NCommander on Friday March 14 2014, @02:44AM   Printer-friendly
from the timebombs-are-exciting dept.
We had an hour or so or downtime today. After debugging, the root cause came from the SSL certificates we use to establish a database connection from the webserver to the actual DB. As a prelude GoLive, we migrated from unencrypted connections to encrypted connections as we have to cross the Linode internal LAN. In an attempt to improve data security, we generated a set of SSL certificates and used those to encrypt the MySQL connections. In the flurry of golive, no one thought to check the expiry date on said certificates. Out of the box, OpenSSL generates certificates with a one month expiry unless manually changed.

As you might expect, one month later, the certificates expired, and the database stopped accepting remote connections. New certificates were generated with a ten year expiration, and we continue to work towards better documenting our internal processes on the wiki to prevent this sort of thing from happening again. Apache, and slashd are running again, and we appear to be back to status-quo in terms of site operation.

A full incident report will be written up and posted to the wiki in the next few days.
 
This discussion has been archived. No new comments can be posted.
Display Options Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 2) by zigbigadoorlue on Friday March 14 2014, @03:59PM

    by zigbigadoorlue (1092) on Friday March 14 2014, @03:59PM (#16605)

    Good gracious you all are doing a lot of good work for free (and on your vacation!). Do you have a full time job in addition to running this marvelous and confounded site? You all are doing an excellent job particularly as you are currently not getting payed for any of it. Thanks for all that you've given this community.

    Starting Score:    1  point
    Moderation   +1  
       Underrated=1, Total=1

    Total Score:   2  
  • (Score: 2) by NCommander on Friday March 14 2014, @10:04PM

    by NCommander (2) <mcasadevall@dev.soylentnews.org> on Friday March 14 2014, @10:04PM (#16722) Homepage Journal

    I can't speak for anyone else, but I work full time in FOSS technologies. This vacation was setup before I was involved with SoylentNews, which has caused me a lot of grief in hindsight (but then again, hindsight is always 20/20). I've been trying to manage to site, my sanity, and a crazy travel schedule all at once, but I've cleared out my schedule until September to try and get the business side of things assembled.

    --
    Still always moving ...