Fix spec suite

Was failing because of inconistent use of transactional fixtures, and switch to
mysql test database.