{"id":1247,"date":"2013-12-18T07:45:46","date_gmt":"2013-12-18T15:45:46","guid":{"rendered":"http:\/\/wp.colliertech.org\/cj\/?p=1247"},"modified":"2013-12-18T07:45:46","modified_gmt":"2013-12-18T15:45:46","slug":"maxine-is-now-running-on-mariadb","status":"publish","type":"post","link":"https:\/\/wp.c9h.org\/cj\/?p=1247","title":{"rendered":"Maxine is now running on mariadb"},"content":{"rendered":"<p>So back when I was working for <a href=\"http:\/\/en.wikipedia.org\/wiki\/MySQL_AB\">MySQL AB<\/a> as support manager for <a href=\"http:\/\/en.wikipedia.org\/wiki\/MaxDB\">MaxDB<\/a>, I created an IRC bot to help manage the #maxdb channel on <a href=\"http:\/\/en.wikipedia.org\/wiki\/Freenode\">Freenode<\/a>.  We didn&#8217;t get a lot of traffic, and <a href=\"http:\/\/pgp.mit.edu\/pks\/lookup?op=vindex&#038;search=0x02B9D0B1075D1576\">Daniel De Graaf<\/a> mentioned that he could use a bot to help manage some <a href=\"http:\/\/en.wikipedia.org\/wiki\/Iptables\">iptables<\/a> factoids over on #netfilter.  So I had her join.  He taught her all sorts of interesting things.  She stored these factoids in a MySQL database.  I have just migrated from MySQL to <a href=\"http:\/\/en.wikipedia.org\/wiki\/MariaDB\">MariaDB<\/a> which I compiled from source.  Here are the packages:<\/p>\n<p><a href=\"http:\/\/www.colliertech.org\/~cjac\/debian\/\">http:\/\/www.colliertech.org\/~cjac\/debian\/<\/a><\/p>\n<pre>\r\ncjac@mariadb:~$ mysql -u root -p\r\nEnter password: \r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 5322\r\nServer version: 5.5.32-MariaDB-1-log (Debian)\r\n\r\nCopyright (c) 2000, 2013, Oracle, Monty Program Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt; use maxine;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nMariaDB [maxine]&gt; \r\n<\/pre>\n<pre>\r\n15:22 &lt; cj&gt; maxine: iptables?\r\n15:22 &lt; maxine&gt; hmmm... iptables is a generic table structure for the \r\n                definition of rulesets. Each rule within a chain consists of a \r\n                number of classifiers (iptables matches) and one optional \r\n                connected action (iptables target).\r\n<\/pre>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=cjamescollier\" class=\"twitter-share-button\">Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;t get a lot of traffic, and Daniel De Graaf mentioned that he could use a bot to help manage some iptables factoids over on #netfilter. So [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[60,165,17,79,103,181,47,209,12,232,102,233],"tags":[],"class_list":["post-1247","post","type-post","status-publish","format-standard","hentry","category-colliertech","category-databases","category-debian","category-free-software","category-freenode","category-irc","category-linux","category-mariadb","category-mysql","category-nsa","category-open-source","category-selinux"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1YDIB-k7","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/1247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1247"}],"version-history":[{"count":3,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/1247\/revisions"}],"predecessor-version":[{"id":1250,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/1247\/revisions\/1250"}],"wp:attachment":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}