Monthly Archives: March 2010

Configuring Apache on CENTOS: Just some random notes on what I had to do to get my Perferred tools installed on Apache under centos: yum install php-Smarty php-pear php-pear-MDB2 php-mysql To get pear configured I ran these commands: pear upgrade … Continue reading

Posted in Uncategorized | Leave a comment

Calculating the Fiscal Year in Excel

Jason came up with this nifty formula to calculate the fiscal year in excel based on a string in the YYYY-MM-DD format. It could be adapted to support other formats by changing the MID substring values ( MID is the … Continue reading

Posted in Uncategorized | 1 Comment

Using CRL lists with PKI certificate of authorities

Notes from 3/8/2010  troubleshooting crl issues. Users called and could not access the cobra web site. They were using certificates issued by Verisign – specifically: CN=VeriSign Client External Certification Authority – G2 I checked our page using the command: openssl … Continue reading

Posted in Uncategorized | Leave a comment

converting julian date to real date in mysql

We’ve got data that uses a funky date format — not a true julian date  but the Year followed by the DAY of the year. i.e. 2010005 = January 5th, 2010 2010031 = January 31st 2010 2010365 = December 31st … Continue reading

Posted in Uncategorized | Leave a comment