Category: work

  • MySQL Meet-up 20141208

    I had an enjoyable time last night at Twitter with local MySQL DBAs and developers. We had an attendee who has no experience with SQL or programming at all. She is interested in organizing her collection of recipes and had heard a rumor that MySQL was a good tool to use for this task. She […]

  • Happy Birthday to Collier Technologies LLC!

    Five years ago today, Hannah and I completed all of the forms necessary to stand up our LLC. Okay, alright. Our registered agent actually did all of the hard work. Thanks and happy birthday to you too, Molly!

  • Really large NLP corpora

    Jeeze people. You’re all noisy. I’m sure it was all done for posterity’s sake. 23M irclogs/MagNET/#perl.log 29M irclogs/freenode/#mysql.log 36M irclogs/freenode/#debian.log 37M irclogs/foonetic/#xkcd.log 39M irclogs/OFTC/#debian.log 43M irclogs/freenode/#jquery.log 44M irclogs/freenode/#perl.log $ for file in irclogs/MagNET/#perl.log irclogs/freenode/#mysql.log irclogs/freenode/#debian.log irclogs/foonetic/#xkcd.log irclogs/OFTC/#debian.log irclogs/freenode/#jquery.log irclogs/freenode/#perl.log; do echo -n “$file: ” ; head -1 $file ; done irclogs/MagNET/#perl.log: — Log opened Thu […]

  • OpenVPN configs with inline data

    I’ve been issuing a lot of x.509 certs and OpenVPN user configurations lately, and I came across something that has reduced the complexity quite a bit. It seems that OpenVPN configuration files can now include data inline. So rather than generating and distributing the following for each user: a configuration file a chain of CA […]

  • NIST::NVD CWE development – follow along

    I’m in the process of getting the tests passing for the 0.03 release of NIST::NVD::Store::SQLite3 wherein our hero imports the CWE data and cross-indexes it with CVEs and CPEs. Follow along and suggest some patches. I’m developing on Debian Wheezy, but I would very much like input from devs on other platforms. http://git.colliertech.org/?p=NIST-NVD-Store-SQLite3.git;a=summary cjac@foxtrot:/tmp$ time […]

  • NIST::NVD::Store::SQLite3

    I published an SQLite3 storage back-end to NIST::NVD on the CPAN. It’s pretty quick. About as fast as the DB_File one, but without the down side of being tied to DB_File. It shouldn’t be too difficult to re-factor this code to any DBI-based database. MariaDB anyone? I know it works on Debian. The nightly CPAN […]

  • SELinux on Wheezy

    So, Collier Technologies LLC needs to pass annual audits to operate a certification authority recognized by the SoS. To this end, I’m working with the fine group of developers who maintain SELinux. It seems that the configuration of Xorg that I’m using while typing this here blog post does not have a policy set up […]

  • Power blip in Tukwila – everything’s okay.

    There’s been a lot of weather here in Seattle this week. It looks like the Tukwila DC’s power blipped this morning. It gave me an excuse to update some configs on a few of the OpenVPN endpoints, re-configure some of the shorewall6 stuff, and enter a bunch of hosts and IPs into the BIG-IP’s node […]

  • Perl interface to processing / querying NIST’s NVD feed

    For a work project, I wrote a library in perl that can be used to query the NVD feed that NIST publishes here: http://nvd.nist.gov/download.cfm Here’s a snippit from the perldoc: use NIST::NVD::Query; # use convert_nvdcve to generate these files from the XML dumps at # http://nvd.nist.gov/download.cfm my( $path_to_db, $path_to_idx_cpe ) = @ARGV; my $q = […]

  • Business Birthday

    Today is Collier Technologies, LLC’s second birthday. The company’s been around under one name or another since about 2002 or so, initially as a sole proprietorship. Woot, and all that.