Category Archives: Databases

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 … Continue reading

Posted in amazon, C.J. Insider, CentOS, Databases, debian, Free Software, freenode, friends, irc, jessie, kvm, MariaDB, mysql, security, Software, sun, Twitter, virtualization, washington, xen | 4 Comments

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 … Continue reading

Posted in debian, freenode, irc, javascript, language, mysql, Natural Language Processing, perl | Leave a comment

Maxine is now running on mariadb

So back when I was working for MySQL AB as support manager for MaxDB, I created an IRC bot to help manage the #maxdb channel on Freenode. We didn’t get a lot of traffic, and Daniel De Graaf mentioned that … Continue reading

Posted in colliertech, Databases, debian, Free Software, freenode, irc, linux, MariaDB, mysql, nsa, open source, SELinux | Leave a comment

I miss you. Please come back?

… Creating var directory ‘/usr/src/git/debian/pkg-mariadb/builddir/mysql-test/var’… Checking supported features… MariaDB Version 5.5.32-MariaDB-1 Installing system database… – SSL connections supported Collecting tests… Using server port 42388 ============================================================================== TEST RESULT TIME (ms) or COMMENT ————————————————————————– worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 … Continue reading

Posted in autotools, C.J. Insider, colliertech, Databases, debian, Free Software, MariaDB, microsoft, perl, security, Software, tls, wheezy, winter, x509 | Leave a comment

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, … Continue reading

Posted in abuse, Databases, debian, F5 Networks, Free Software, git, Networking, NIST, perl, security, Software, SQLite, syndication, wheezy | Leave a comment

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 … Continue reading

Posted in Databases, debian, F5 Networks, feds, Free Software, MariaDB, NIST, performance, perl, security, SQLite, work | 2 Comments

Replaced hypervisor

The system which was hosting this blog had a tendency to go down every few days. I swapped it out for a spare yesterday. Let’s see if it stays up. The hypervisor hosts this web server, a mysql server and … Continue reading

Posted in blog, C.J. Insider, colliertech, debian, Hardware, linux, mysql, Networking, pgp, proliant, security, virtualization, xen | Leave a comment

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 … Continue reading

Posted in Berkeley DB, Databases, F5 Networks, feds, government, NIST, perl, security, work | Leave a comment

And with that, the keyserver is back online

http://keyserver.colliertech.org:11371/pks/lookup?search=0xBA27A83C&op=vindex Go go gadget interwebs. Now to sync back up and get into good standings on the status page.

Posted in Berkeley DB, colliertech, Databases, Free Software, linux, Networking, pgp, security, xen | Leave a comment

Load balancing SIP across Asterisk with BIG-IP

Topology Participating hosts * 1x BIG-IP VE * 1x Debian Squeeze “Provisioning Server” serving DHCP, TFTP & DNS * 3x Nortel/Avaya 1120E hard phones flashed to SIP1120e04.01.13.00 * 2x Debian Squeeze + digium asterisk packages: $ grep asterisk /etc/apt/sources.list deb … Continue reading

Posted in Databases, ESXi, irc, mysql, Networking, open source, Telephony, virtualization, work | Leave a comment