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 MDB2 pear install ‘MDB2#mysql’ pear channel-discover pear.firephp.org pear install firephp/FirePHPCore After starting up mysqld I [...]
Entries for March, 2010
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 excel Substring function). This example references a date in cell AB7 — you’ll have to [...]
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 s_client -showcerts -connect usecobra.com:443 -prexit and we were not accepting verisign G2 cert on cobra [...]
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 2010 This little snippet of code will allow you to select it from the mysql [...]
Secured by