codebyko.se

It took some time before realising that client certs and keys can be specified on the connection uri while setting config values. Like this:

SQLALCHEMY_DATABASE_URI: mysql://user:password@hostname/db?ssl_key=ssl/client-key.pem&ssl_cert=ssl/client-cert.pem

Where ssl/ is a relative path from the calling app.

Later on you can confirm that the connection really was over ssl with something like:

res = db.session.execute("SHOW STATUS LIKE '%ssl%'")
for r in res:
print r


You’ll then see some info regarding your connection.

This is just something I put together to jumpstart WordPress development.

	#!/bin/bash
	echo "$(tput setaf 2)Creating directories.$(tput sgr0)"
	NEWDIR=$1
	if [ -d $NEWDIR ]; then
	echo "$(tput setaf 1)FAIL! Directory exists.$(tput sgr0)"
	exit 1
	fi
	mkdir -p $NEWDIR/{htdocs,log}
	cd $NEWDIR
	echo ""
	echo "$(tput setaf 2)Initializing git repo and adds wp as submodule.$(tput sgr0)"
	git init
	git submodule add git://github.com/WordPress/WordPress.git htdocs/wp
	git submodule init
	git submodule update
	echo ""
	echo "$(tput setaf 2)Fetching some stuff from Mark Jaquiths Skeleton repo.$(tput sgr0)"
	wget https://raw.github.com/markjaquith/WordPress-Skeleton/master/wp-config.php -O htdocs/wp-config.php
	wget https://raw.github.com/markjaquith/WordPress-Skeleton/master/local-config-sample.php -O htdocs/local-config.php
	echo ""
	echo "$(tput setaf 2)Add some .gitignore stuff.$(tput sgr0)"
	cat >htdocs/.gitignore <<EOL
	*.swp
	htdocs/local-config.php
	htdocs/content/*
	!htdocs/content/upload
	EOL
	echo ""
	echo "$(tput setaf 2)First init.$(tput sgr0)"
	git commit -am "Autoinit"
	echo ""
	echo "$(tput setaf 2)DONE!$(tput sgr0)"

view raw wp-init.sh hosted with by GitHub

Needed to go through a directory of backuped files and set the mtime. The files had the format x-yymmdd.sql.gz A recent copying of the directory had removed the original mtime attributes (note to self: use rsync with -a flag next time).

This one liner did the trick of converting them back to what they had:

for f in *.sql.gz; do touch -d $(echo $f | \
sed "s/^\w\+-\([0-9]\{2\}\)\([0-9]\{2\}\)
\([0-9]\{2\}\).*/20\1-\2-\3/") $f; done

Could this be improved? Most certainly. I havent figured out how to do repetitions in a good manner in regex

I needed to emulate php’s PHP_ROUND_HALF_EVEN behaviour in mysql and did this:

SELECT IF(MOD(col,2)=1.5), FLOOR(col), ROUND(col))

Where col is a float value.

Edit: It seems as mysql’s ROUND() function does this per default. I should have read TFM.

Thanks to xdotool and this blog post I’ve managed to bring up an IM conversation with a simple key binding. Totally awesome!