Meek Consulting Websites
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