<feed xmlns='http://www.w3.org/2005/Atom'>
<title>dome-key-web/license-generator, branch master</title>
<subtitle>DomeKey website</subtitle>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/'/>
<entry>
<title>Move the `bin/` directory into the project root</title>
<updated>2018-11-23T00:04:17+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-23T00:04:17+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=d6969f4eb4aba04e9b3569c45e6c689320861e86'/>
<id>d6969f4eb4aba04e9b3569c45e6c689320861e86</id>
<content type='text'>
Makes more sense to run `./bin/setup` from the root.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Makes more sense to run `./bin/setup` from the root.
</pre>
</div>
</content>
</entry>
<entry>
<title>lighttpd.conf: Allow running from the project root</title>
<updated>2018-11-23T00:02:39+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-23T00:02:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=d9add7fd9b7e81275157b8e9e6e10df26971fd39'/>
<id>d9add7fd9b7e81275157b8e9e6e10df26971fd39</id>
<content type='text'>
* Move the `make run` target into the project root's Makefile
* Update paths in lighttpd.conf to correspond to its new location
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
* Move the `make run` target into the project root's Makefile
* Update paths in lighttpd.conf to correspond to its new location
</pre>
</div>
</content>
</entry>
<entry>
<title>Move lighttpd.conf to project root</title>
<updated>2018-11-22T23:59:48+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-22T23:59:28+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=2412b421df01b5d84199ecfc44679d8493b7b87e'/>
<id>2412b421df01b5d84199ecfc44679d8493b7b87e</id>
<content type='text'>
I want to be able to run `make run` from the project root.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
I want to be able to run `make run` from the project root.
</pre>
</div>
</content>
</entry>
<entry>
<title>Add `brew services` commands to thank-you &amp; fulfillment instructions</title>
<updated>2018-11-22T22:24:40+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-22T22:24:40+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=fac3ea6e4f7ac6abc2e2ff7cbe3ed42fa22fa8b1'/>
<id>fac3ea6e4f7ac6abc2e2ff7cbe3ed42fa22fa8b1</id>
<content type='text'>
Include the new step 2 of installation, starting the program with `brew
services`.

After the license has been added, the daemon must be restarted in order
for the license to be recognised.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Include the new step 2 of installation, starting the program with `brew
services`.

After the license has been added, the daemon must be restarted in order
for the license to be recognised.
</pre>
</div>
</content>
</entry>
<entry>
<title>Add license (mostly GNU AGPLv3+)</title>
<updated>2018-11-21T19:48:42+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-21T19:48:42+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=d924cca39802b2629312a5629625ce41f664b2b3'/>
<id>d924cca39802b2629312a5629625ce41f664b2b3</id>
<content type='text'>
License the software with the GNU AGPLv3+ with the exception of the
'aquatic-prime' and 'paddle' libraries and 'aquatic-prime' binary, which
are licensed under the GNU GPLv3+.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
License the software with the GNU AGPLv3+ with the exception of the
'aquatic-prime' and 'paddle' libraries and 'aquatic-prime' binary, which
are licensed under the GNU GPLv3+.
</pre>
</div>
</content>
</entry>
<entry>
<title>zip: Update test to pass a mutable reference to the file</title>
<updated>2018-11-21T08:41:56+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-21T08:41:56+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=f3bc1129f133cccd592a54f53c8ff9e0da85cd23'/>
<id>f3bc1129f133cccd592a54f53c8ff9e0da85cd23</id>
<content type='text'>
Forgot to change this when I changed the function signature.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Forgot to change this when I changed the function signature.
</pre>
</div>
</content>
</entry>
<entry>
<title>aquatic-prime: Switch to my public fork of `rust-plist`</title>
<updated>2018-11-21T08:38:42+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-21T08:38:42+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=627a486606bc5ebcb52ac417b6156bd9a0ea553e'/>
<id>627a486606bc5ebcb52ac417b6156bd9a0ea553e</id>
<content type='text'>
Published my local fork publicly with the base64 format change.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Published my local fork publicly with the base64 format change.
</pre>
</div>
</content>
</entry>
<entry>
<title>license-generator: Use compile-time environment variables</title>
<updated>2018-11-20T06:20:15+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-20T06:20:15+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=7d7ac8d747be198088664e45e5423919d9876651'/>
<id>7d7ac8d747be198088664e45e5423919d9876651</id>
<content type='text'>
For whatever reason, the environment variables in my `.htaccess` weren't
getting passed to my FastCGI executables on my production server.

Wasn't sure how to get them passed to the programs, so decided instead
to compile the env variables into the binaries.

To do that, we source the environment file before building the release
builds in the Docker container.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
For whatever reason, the environment variables in my `.htaccess` weren't
getting passed to my FastCGI executables on my production server.

Wasn't sure how to get them passed to the programs, so decided instead
to compile the env variables into the binaries.

To do that, we source the environment file before building the release
builds in the Docker container.
</pre>
</div>
</content>
</entry>
<entry>
<title>create_purchasers: Use a single trigger per action</title>
<updated>2018-11-20T02:17:41+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-20T02:17:41+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=7b5863020e3d27173c82acc69fc71b62397f5c59'/>
<id>7b5863020e3d27173c82acc69fc71b62397f5c59</id>
<content type='text'>
Got this error from the production MySQL server:

    (details: Error 1235: This version of MySQL doesn't yet support
    'multiple triggers with the same action time and event for one table')

Change our triggers so we only have one for `BEFORE INSERT`.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Got this error from the production MySQL server:

    (details: Error 1235: This version of MySQL doesn't yet support
    'multiple triggers with the same action time and event for one table')

Change our triggers so we only have one for `BEFORE INSERT`.
</pre>
</div>
</content>
</entry>
<entry>
<title>create_purchasers: Remove `DEFAULT UTC_TIMESTAMP()`</title>
<updated>2018-11-20T01:57:58+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2018-11-20T01:57:58+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/dome-key-web/commit/?id=2068de68350c3dd3ac527a8eb2090d0a9f961866'/>
<id>2068de68350c3dd3ac527a8eb2090d0a9f961866</id>
<content type='text'>
Ended up with this error when running my migrations against the
production server:

    error: migration failed in line 0: BEGIN;

    CREATE TABLE purchasers (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        email VARCHAR(255) NOT NULL,
        secret VARCHAR(255),
        created_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP(),
        updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP()
    );

    CREATE TRIGGER purchasers_updated_at
        BEFORE UPDATE
        ON purchasers FOR EACH ROW
            SET NEW.updated_at = UTC_TIMESTAMP();

    COMMIT;
     (details: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP(),
        updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP()
    );

    CR' at line 6)

Using MySQL 5.6.34 in production and MariaDB 10.3.10 locally. Guess you
can't use `DEFAULT UTC_TIMESTAMP()` there.

To use `UTC_TIMESTAMP()`, create a couple new triggers to set the
timestamp in the `created_at` and `updated_at` columns.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Ended up with this error when running my migrations against the
production server:

    error: migration failed in line 0: BEGIN;

    CREATE TABLE purchasers (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        email VARCHAR(255) NOT NULL,
        secret VARCHAR(255),
        created_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP(),
        updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP()
    );

    CREATE TRIGGER purchasers_updated_at
        BEFORE UPDATE
        ON purchasers FOR EACH ROW
            SET NEW.updated_at = UTC_TIMESTAMP();

    COMMIT;
     (details: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP(),
        updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP()
    );

    CR' at line 6)

Using MySQL 5.6.34 in production and MariaDB 10.3.10 locally. Guess you
can't use `DEFAULT UTC_TIMESTAMP()` there.

To use `UTC_TIMESTAMP()`, create a couple new triggers to set the
timestamp in the `created_at` and `updated_at` columns.
</pre>
</div>
</content>
</entry>
</feed>
