Today Apache complained about SSLCertificateChainFile being deprecated and it told me to use SSLCertificateFile instead.
SSLCertificateFile was already in use with the .crt file. I had to create a new ‘SSLCertificateFile’ by concatenating the .crt file with the ca-bundle, and that fixed the problem:
# cat trust.jj5.net.crt trust.jj5.net.ca-bundle.pem > trust.jj5.net.pem
I followed these instructions to install PHP 5.4 on Ubuntu 12.04 LTS.
Basically:
$ sudo apt-get install python-software-properties $ sudo add-apt-repository ppa:ondrej/php5 $ sudo apt-get update $ sudo apt-get dist-upgrade
I had a problem with my rewrite rules, that looked like this:
DocumentRoot /var/www/trust.jj5.net
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.*) http://trust.jj5.net/sorry.html [L,R]
I was trying to redirect any request which didn’t match a file or directory. The !-f and !-d requirements were failing because the path to the REQUEST_FILENAME wasn’t fully qualified. I fixed the problem by including the DOCUMENT_ROOT:
DocumentRoot /var/www/trust.jj5.net
RewriteEngine On
RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-f
RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-d
RewriteRule (.*) http://trust.jj5.net/sorry.html [L,R]
Happy days! :)
Learned about dir2ogg over here and am using it to convert MP3 to OGG.
So… I installed dir2ogg:
# apt-get install dir2ogg
And then I ran it on some MP3s, and the generated OGG files sounded like chipmunks. I read the man page for dir2ogg and saw that it had an option for mp3-decoder. I tried specifying the lame decoder but it complained that it couldn’t find it, so:
# apt-get install lame
Then I ran dir2ogg with the following command and the ouput OGG files sounded proper!
$ dir2ogg --mp3-decoder=lame --quality=10 .
Happy days!
It was a bit of a trick to find the DateInterval spec hidden away in the constructor doco, not the DateInterval class doco.
| Designator | Description |
|---|---|
| Y | years |
| M | months |
| D | days |
| W | weeks |
| H | hours |
| M | minutes |
| S | seconds |
Today I learned about LIMIT and OFFSET in PostgreSQL, which differs slightly from its MySQL cousin.
I’m always forgetting the syntax for the jQuery ‘document ready’ event. Which is an embarrassment because it’s so simple:
$( document ).ready( handler ) $().ready( handler ) (this is not recommended) $( handler )
I used to use the $( document ).ready( handler ) syntax, but starting today I use the $( handler ) syntax.
Today I used the Datepicker for Bootstrap. I grabbed the files from the CDN.
I wanted to know what the analogue for MySQL ‘show tables’ was in PostgreSQL, and I found the answer, use the information_schema, here:
mysql: SHOW TABLES postgresql: \d postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'; mysql: SHOW DATABASES postgresql: \l postgresql: SELECT datname FROM pg_database; mysql: SHOW COLUMNS postgresql: \d table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table'; mysql: DESCRIBE TABLE postgresql: \d+ table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';
Found a list of HTML Singleton Tags, the tags that don’t require a closing tag.