Yet Another Markdown Include Preprocessor

I'm doing some writing in Pandoc, and the Markdown implementation doesn't have an "include" feature to pull in source code. After looking around, there are some tools that implement #include or !include, but there weren't quite what I wanted, so I wrote this in awk.

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

ERROR 1698 (28000): Access denied for user 'root'@'localhost' started showing up with the system upgrade to Ubuntu 15 and MariaDB.

Fixes are described at

http://superuser.com/questions/957708/mysql-mariadb-error-1698-28000-access-denied-for-user-rootlocalhost/963968

http://superuser.com/questions/949496/cant-reset-mysql-mariadb-root-password

However, there's a way to preserve the additiona

Writing Articles in HTML5

I've been writing HTML forever, but really never looked at the new HTML5 tags. For the most part, I'd devolved into using DIV and SPAN and FORM and a few other tags to code up webpages. That's OK for writing software, but it was getting pretty stupid when I was putting in code like DIV CLASS="address". A quick trip through the HTML5 tags revealed a cornucopia of tags relevant to writing academic papers and computer programming tutorials.

Using LibreOffice to Load Excel Data into an SQL Database

We wanted to know how Bernie Sanders did in several electoral districts.

What are our data sources.

There are two public databases that can help us discover these vote totals. One is the election results broken down by voting precinct. The other is a database that maps the precinct numbers to district numbers.

lavote.net's precinct reports

The Los Angeles County Registrar Recorder publshes vote tallies aggregated by precinct. The problem is, these are reports, not raw or cooked data.

failed with not authorized on admin to execute command { replSetHeartbeat

I got the above error while trying to build a replica set in MongoDB.

If you have security:

security:
  authorization: enabled

Then you need to set up Internal Authentication. This is a kind of password that nodes will use to authenticate that they are part of a network, and can access each other.

Here's the document that explains setting up Internal Authentication.

Looking at Kindle Unlimited (part of Amazon Prime)

I started looking into Kindle Unlimited (KU), a $10 a month borrowing library for Kindle e-books, for tutorials on some subjects I'm studying, and also as a possible publishing platform for articles. What I found is a market that, for readers, is somewhat non-functional.

I looked at 21 books. (Really, it's a little more, but I wasn't paying attention early on.) Of these, I found 7 writer worth reading, and 13 writers to avoid.

Compiling PHP... :(

It's been a few years since I compiled PHP from sources... and "ouch", it's a lot of work. It makes me want to give up, port all the sites to a new OS stack, and deploy that.

Erasing Hard Drive Data

The "gold standard" in this category is "Darik's Boot and Nuke" or DBAN (pronounced D Ban).

DBAN is a tiny version of Linux, usually run from a diskette, that contains a program that will erase any hard disk on your computer. It has several different methods, many which are used by the military to securely erase data.

Mobile Website Editors Reviewed

Reviews of several mobile-phone or tablet-based website editors.

Observations about WordPress, and why I think this weird platform in not in crisis

WordPress is no longer the best blogging platform. I think Medium is that. It's almost like a word processor.

According to the few surveys I've seen, WordPress isn't used as much for blogging as for making "brochure" websites. There's a bit of a product-market mismatch.

The program is so huge once you add Jetpack and a few other plugins that you need to purchase a more expensive hosting plan with 1 Gig of RAM.

The built-in onboarding/user registration code is not only not-OO, it's spaghetti code. Modifying it is difficult, limiting the ways it can be used for growth hacking.

PHP Frameworks get weird

I was getting the itch to write a small web application and started looking around. I had played with Laravel a while back, but it's just a little too large. I wanted to deploy cheaply on my slow server.

The features I wanted were: REST API support, OAuth (client), Routes, User Auth

Phalcon was the most interesting. It's written in C as an extension, and is fast. It does mostly traditional, Laravel style MVC. It can do REST APIs as well, but the example isn't good. It needs some more code to do REST right. Being compiled it is fast. The features resemble Laravel and Twig.

WordPress Multisite Problems with Vagrant

I had some problems setting up Multisite on WP with the Vagrant environment.

The big issue is that the the domains and URLs need to be set just right. This is a little more complicated than a typical server setup because dev setups usually take shortcuts on DNS.

You need to fix the domain names in all the locations where they're resolved.

First, set up DNS. Set up domain names for all the domains you're going to develop, but use local names like "foobar.lo" instead of "foobar.com". They can all point to the IP address your dev server exposes via Vagrant, usually 192.168.33.10.

Adding SSL to the Proxy in Front of devpi

I was getting a bunch of annoying warnings with the devpi index, so I decided to add SSL.

I don't think it was worth it, because the config is a lot harder. Also, I've migrated the entire provisioning to Ansible, so this is just a fragment to add on. You will need to find another howto that explains setting up an HTTPS server.

local-npm with daemontools

Following the advice from Addy Osmani I set up local-npm on the caching proxy server. (So far, we're caching apt, pypi and now npm.)

These examples have URLs to a machine named 'donettes'. That is the cache. Adjust to your own network.

After setting up DNS, you need to install local-npm. The Ubuntu repo version of node is out of date, mainly because node is in flux, and the packages change. So download node from nodejs.org.

Rebuilding a Virtual Machine After Deleting It

This is a note to remind myself how to set up a new VM for development. This is a mess, not a tutorial.

This works on a target environment with this uname -a:

Linux marinela 3.19.0-25-generic #26~14.04.1-Ubuntu SMP Fri Jul 24 21:16:20 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

My host system is set up to run a bunch of VirtualBox VMs. I have a VM network setup, and want to be able to throw away the VMs and start fresh, reconstructing them with an Ansible playbook.

Syndicate content