You've opened a new tab!

Sound familiar? You know IE holds back the Internet right?

Here you'll be able to find my brief notes on computer/linux things I'm currently doing, and if I had any troubles, details about how they were overcome.

My public GPG key
My public SSH key

My github

My nicknames:

  • cgerpheide (official)
  • phoxicle (IRC, forums, twitter)
  • HorseRayX (AOL -- haven't used this one since I was 11)

A list of my favorite XKCDs:

C0mput3rz & T3chno1ogy

Configuring FLOW3 alpha7 to use MySQL

Looking around the internet, I could find no real documentation on switching FLOW3 to use mysql except for one mailing list thread asking for help with a faulty config for alpha6. So, for those of you who are wondering, these are the steps you'll need to follow to configure FLOW3 to use MySQL instead of SQLite, at least in alpha7. Note, as this is an alpha release, it can of course change.

  1. Create a database in mysql.
  2. Run all the create statements inside of /Packages/Framework/FLOW3/Resources/Private/Persistence/SQL/DDL.sql. You'll probably have to add back tick marks (`) to SQL keywords to avoid syntax errors.
  3. Configure FLOW3 to use MySQL by editing the /Configuration/Settings.yaml file. These settings will override the default settings specified in /Packages/Framework/FLOW3/Configuration/Settings.yaml. Note that you may need to create this file yourself:
      # Options for the default PDO backend
        dataSourceName: 'mysql:host=localhost;dbname=yourdbname'
        username: root
        password: yoursqlpassword

And voila, FLOW3 now uses MySQL! Swappable persistence layers FTW.