Press "Enter" to skip to content

nuxx.net Posts

Poopy Creek

This is one of my least favorite parts of riding outdoors: unexpected encounters with dog poop. Not only is it feces, but being dog stuff it’s greasy and difficult to clean off. I must have picked this up somewhere at Stony Creek last night while riding. After getting in the car I thought it smelled suspiciously unclean in there, but I’d just written it off as sweaty clothes or my nose playing tricks on me.

1 Comment

Black and White Lane Markings on M-59

A couple of days ago while driving on M-59 between M-53 and I-75 I noticed that the white dashed highway lines had been augmented with black rectangles on the distant (furthest away from you) side. I had a few theories about what these may be for, but the reality turned out to be a bit more mundane yet effective: additional marking to increase contrast on areas where sun glare is a problem, particularly on light-colored road surfaces.

This section of road was recently replaced with the new surface being all concrete, so it has a fairly light colored surface. When wet and/or with a bit of glare the markings practically disappear, as the embedded contraflective additives don’t really work, or reflect the same amount of light as the road surface.

I’d originally thought (and somewhat hoped) that these were augmenting existing markings to facilitate machine vision used by autonomous vehicles. Others suggested to me that they may be IR reflective to make markings more visible to night vision equipment. There was also the chance that it was a boondoggle to adjust the lane marker length to some standard.

This question was posed to Ask Metafilter and Facebook, email was sent to MDOT to ask, and I started doing some research. The most conclusive answer I could find was the augmentation of colored (white, in this case) markings to increase their visibility. Specifically, section 3A.05 of the Manual on Uniform Traffic Control Devices, 2009 Edition, Revision 2 states:

Black may be used in combination with the colors mentioned in the first sentence of Paragraph 1 where a light-colored pavement does not provide sufficient contrast with the markings.

and

When used in combination with other colors, black is not considered a marking color, but only a contrast-enhancing system for the markings.

I also eventually received a reply from MDOT stating:

The markings are part of a pilot project aimed at helping motorists see pavement markings during certain times of day when the suns glare/reflection is strong. The black outlines the white making the markings more prominent.

and

As I understand we will be putting more out on MDOT’s road in the next few years in locations where visibility by the sun is diminished.

So, that answers it. These markings are simply to increase contrast and improve visibility against the light colored concrete surface.

UPDATE: A photo of these lane markings can be see in this post.

Leave a Comment

Moving CiviCRM on Joomla to WordPress

With recent work done on the MMBA website I’ve had to move the CiviCRM instance from an older copy hosted on Joomla to a new one hosted on WordPress. The general suggestion for doing this is to export and import the data, but this is both a bit frustrating to do (because of a need to specify which columns contain which fields) and PHP kept running out of memory when exporting, even after I moved it up to 256MB per process.

This copy of CiviCRM wasn’t really used, but it did have a lengthy set of contacts that I could not afford to lose. Thus, I looked into what was necessary to move the tables themselves instead of just exporting/importing the data.

I ended up using these steps to get the contact data moved over and it seemed to work well for me. This may not be the best way to do it, and it may introduce some problems down the line, but this did work for me and seems fine thus far, so I wanted to document the steps here:

1) Install WordPress and the CiviCRM plugin with the new installation of CiviCRM going to a different database or table prefix than the current.

2) Ensure that the WordPress CiviCRM plugin works, only going as far as the first screen which prompts to set up an organization name, email addresses, etc.

3) Using phpMyAdmin export all CiviCRM tables to a .sql file except for:

civicrm_acl_cache
civicrm_acl_contact_cache
civicrm_domain
civicrm_cache
civicrm_group_contact_cache

With the option: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement.

4) To avoid issues with Foreign Key Constraints add this line to the top of the .sql file:

SET foreign_key_checks = 0;

And this to the bottom:

SET foreign_key_checks = 1;

5) If the new set of tables has a different prefix than the old, search/replace in the .sql to change each table name to the prefix used by the WordPress-based CiviCRM instance.

6) Import the .sql into the WordPress-based CiviCRM database using the MySQL command line utility:

mysql -u username -p databasename < civicrm_export.sql

7) Enter the CiviCRM plugin in WordPress and confirm that all the contacts have been moved over.

These steps were performed on the following configuration:

- Apache/2.2.22 (FreeBSD) mod_ssl/2.2.22 OpenSSL/0.9.8q mod_fastcgi/2.4.6
- MySQL 5.5.22 (from FreeBSD Ports)
- WordPress 3.3.2 w/ CiviCRM 4.1.0
- Joomla 1.5.24 w/ CiviCRM 3.4.7

2 Comments

Now With IPv6 and SSL (but no SPDY)

Since moving to a new server running Apache for hosting websites I’ve been able to make quite a few changes that just weren’t quite possible with lighttpd. One major change is the use of IPv6. Ever since the move I’ve set up all hosted sites with AAAA records and made them available via IPv6, and it’s been working great. While I don’t see much traffic on this yet, I’m happy to know that the sites are all able to be reached this way. For reference:

;; ANSWER SECTION:
nuxx.net.               300     IN      AAAA    2607:f4b8:5:2:e611:5bff:feac:3a60

I’ve also been wanting to move my personal site, nuxx.net, to be HTTPS-only. While not particularly important for most public content, this does protect session cookies for various admin functions that I may host under this domain, along with keeping any private content from prying eyes. Thanks to an SSL certificate from the new-to-me registrar gandi.net it was pretty easy to get this set up. I was then able to take the old non-HTTPS vhost and permanently redirect it over to the secure one, and all content simply moved over to the secure side:

<VirtualHost *:80>
    ServerName nuxx.net
    ServerAlias www.nuxx.net
    ServerAdmin c0nsumer@nuxx.net
    Redirect permanent / https://nuxx.net/
</VirtualHost>

The browser test screenshot seen above from Qualys SSL Labs SSL Server Test (live results here) shows that HTTPS is pretty well set up on nuxx.net. I’m sure it could be better, but for now I think it’s pretty good.

Thanks to the magic of this bit of SQL I was able to update all http://nuxx.net links in nuxx.net blog posts to https://nuxx.net, allowing most pages to validate as fully secure. I’ll have to do something similar on the other apps to bring them up to snuff:

UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://nuxx.net', 'https://nuxx.net');

Amusingly, the use of HTTPS seems to dramatically cut down on automated SPAM. Perhaps some of the link spamming tools don’t want to deal with the overhead (or cert validation?) of HTTPS? I’d figure they could just ignore them, though…

Anyway, with all of this in place, I got to thinking about SPDY, Google’s shiny new protocol. An Apache module for implementing it, mod-spdy has been released and there is a FreeBSD Port for it, so I decided to give it a go. While the installation worked and Chrome showed it working (as seen via chrome://net-internals/#spdy). Unfortunately, I ran into a couple bugs. Most notable was that a number of httpd processes failed, and I ran into documented issues #36 and #39 which left me with an odd taste for this module. I’ve since disabled it, but once a new version is released I’ll probably try it again.

Leave a Comment

Deuter Race Air Lite Pack Leak and Replacement

When riding I almost always carry a Deuter Race Air Lite hydration pack (photo) containing stuff I may need during the ride. I’ve had the bag for less than a year and recently a leak developed at the bottom of the bladder, right at the base of the outlet’s weld. Deuter bags carry a lifetime warranty, so I submitted a warranty request.

A few days later I had a new bladder in my possession, and instead of sending the old one back Deuter just asked for a photo of the bladder and where it’s leaking. That’s what can be seen above. This leak wasn’t huge, but it was enough that with each ride the bottom of my bag would be wet, occasionally dripping on me. I was more concerned that it would grow, resulting in an unexpected failure leaving me stuck without water.

I’ve been really happy with the Deuter pack thus far, and good warranty support when it failed was a nice bonus.

Leave a Comment

Satan Can’t Punctuate

Lunch time today found me taking a quick ride at River Bends, and while there I came across this dumpster. Graffiti reading “Satan Was Here” on a dumpster doesn’t really surprise me, but the quotation marks surrounding the upside down cross do. Has the moronic use of quotation marks purely for emphasis really gone this far?

Leave a Comment

Fox Float RP23 Seal Replacement

This evening, as part of doing a bunch of needed maintenance on the Titus (cables, bottom bracket, shock, etc) I replaced the seals on the Fox Float RP23 rear shock. Using the ~$15 OEM seal kit this was surprisingly easy to do. I followed along with this video from Fox and the actual work took less time than watching the video.

The most difficult part was removing the bottom bushings, but this was pretty easily done by holding them using a bench vise and some neoprene to keep the parts from being marred and gently rotating them while lifting on the shock. Pressing the bushings back into place was even easier, done just using the vise jaws and some more padding.

There is still another evening’s worth of work to go on the bike before I’ll be able to put the shock back on, but everything went well enough that I expect it’ll work fine. I’m more concerned about getting all the drivetrain bits put together and working right.

Leave a Comment

U+1F4A9 Successfully Deployed

Today I successfully employed one of the new characters in Unicode 6.0, U+1F4A9, also known as PILE OF POO (dog dirt). (See the table and list of names here.)

Needing a separate, sealing garbage can for Roxie’s collected poop I grabbed a spare one from the basement, but I figured it needed some manner of appropriate labeling. This did it. I printed it on a full-page label, sealed it with packing tape, cut it out, and stuck it in place. Hopefully the can will also help keep the garage from smelling like fresh poop on warm days.

Check out this page for more information on this character and to see if your browser and installed fonts support it. Hopefully it does.

Leave a Comment

Fox Lake Road May Be Impassable

Yesterday’s ride took Erik, Nick, and I out west to visit an area that we’d only heard about and Erik was anxious to see, Fox Lake Road. I was not disappointed, as the segment between Honert Rd and County Line Rd. / Washburn Rd. was some nice hills in the quite-attractive Ortonville Recreation Area.

Starting out from the Clarkston Road crossing of the Paint Creek Trail we ended up around 69 miles for the day, and a moving time of just a smidge over 5.5 hours. This met my goal, but I seem to have failed to keep my heart rate high enough for some parts of the ride. For much of it (likely while climbing) I had it fairly high, but on the flatter segments (and likely longer downhills) it dropped lower than I should have kept it. Hopefully this’ll be okay… While tired I had enough energy left at the end of the ride yesterday to make a decent effort on the Miller Rd. hills, so hopefully I won’t have problems with next weekend’s 5.5 – 6 hour ride, and whatever comes after that…

Here’s two more photos from yesterday:

· Inside the Men’s changing area at Bald Mountain State Recreation Area’s Lower Trout Lake beach.
· Titus Racer X 29er laying in some leaves along Fox Lake Road when stopping to take a break.

Now, off to Stony Creek to build some single track.

1 Comment

Poopy Avocado

This morning’s breakfast organic avocado from Whole Foods has bird poop on it. This amuses me. Not that it’s a problem, since the skin is essentially just a wrapper.

(Amusingly, this is one of the best avocados I’ve had in Michigan in a while. There’s no bruising, it ripened nicely on the counter, and it’s quite tasty. Danielle chose well while at the store.)

Leave a Comment