Skip to content

Backing Up FreeNAS to an external hard drive

I love this little device: it's an iXsystems MiniNAS running FreeNAS 9.2, with tons of disk space, RAM, fast network connections, all on a low-profile device that uses precious little energy (30W). Nice! And having all my important stuff on one box not only gives me the freedom to screw around with my desktops but simplifies and centralizes the work that goes into backing up my information.

It's tempting to be lulled into security by a hefty NAS running the ZFS file system on RAID-6. Yes you've got some redundancy and a resistant file system. But RAID is not backup - a mistake too many make. And here I ran into some trouble. FreeNAS gives you tons of options for transferring zpool datasets around, and since it's networked you can rsync your heart's content to other systems, but what if you just want to back the stuff up to a hard drive locally? Like an external, USB hard drive? Turns out, there's a way, but it requires a bit of Unix-foo.

Fortunately, this is FreeBSD, so lots of things are possible. Continue reading "Backing Up FreeNAS to an external hard drive"

Categories: Tech
Karma for this article:
Current karma: 5 of 5, 1 vote(s) 56 hits

San Juan, Puerto Rico

The best thing about the folks of San Juan, Puerto Rico is their accent: a lot of them sound like me. That is, they've got a New York accent. That changes everything. In fact, Puerto Rico is practically unique across the Caribbean for being an American territory with strong American connections but a culture and history rooted in the Spanish empire as well, and an island that reflects both.

Miguel took us across town in late morning. "Any earlier and the traffic will kill you," he explained. "It's bad and getting worse" We spent a good deal of time waiting to cross intersections anyway, gazing out at architecture that looked kind of like South Florida, but – amazingly – cleaner and better kept. But it was clear the island is struggling, ad we read it in the papers too: to call Puerto Rico's current situation as a 'slump' would be an understatement. That would explain the continued emigration to places like New York, where well over a million Puerto Ricans join the 3 million that stayed behind. "New York's Puerto Rican community is famous," Miguel explained, adding, "Know the other big center of Puerto Rican emigration? Orlando." And then with a smile and a strategic pause, " That's right: Mickey Mouse eats beans and rice" Continue reading "San Juan, Puerto Rico"

The Laughing Gulls: Little San Salvador

Laughing Gulls

Turns out, good branding matters, even in geography. Don't believe me? Ask someone currently trying to get by while living in Dildo (Newfoundland and Labrador), Crapo (Maryland), Boogertown (North Carolina), Hellhole (Idaho), or Drain (Oregon). There are others, of course. So it is that the little stretch of sand and sea once known as Little San Salvador has done much better with the relatively more evocative name of Half Moon Cay. That's what I was thinking when I awoke to find our boat rocking gently at anchor off the sandy crescent of Caribbean goodness on which were to spend the rest of the day playing and exploring. Continue reading "The Laughing Gulls: Little San Salvador"

Low, White Sand: the Turks and Caicos

I only knew two things about the Turks and Caicos islands before traveling: one, that due to serious concerns about corruption and transparency, the United Kingdom had come close to throwing them out of the British Commonwealth and revoked their right to self government in 2009; and two, that by Caribbean geography alone, it was darned likely I'd find an aquatic paradise of white sand beaches, transparent, turquoise water, and bright sun. On both accounts, I was correct. But I learned a bit more, as well. And mostly, I learned it from Ernest Hemingway. Here, pour yourself a drink before reading on:

Thomas Hudson took a sip of the ice-cold drink that tasted of the fresh green lime juice mixed with the tasteless coconut water that was still so much more full-bodied than any charged water, strong with the real Gordon’s gin that made it alive to his tongue and rewarding to swallow, and all of it tautened by the bitters that gave it color. It tastes as good as a drawing sail feels, he thought. It is a hell of a good drink.
Continue reading "Low, White Sand: the Turks and Caicos"

Rainfall in Saint Thomas

Magen's Bay, Saint Thomas

We raised Saint Thomas on the Caribbean horizon before dawn, and by the time the sun was rising, the air was full of bird calls and we were docked in the magnificent harbor of Charlotte Amalie. The Caribbean, the deep Caribbean! And one of the splendid Antilles Islands, to boot! Continue reading "Rainfall in Saint Thomas"

Categories: Caribbean Islands
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 167 hits

Backing up a MySQL database to individual text files

The situation is as follows: you have a MySQL database that backstops your blog, and you'd like to output each database entry as an individual text file. Not as strange an idea as it seems - maybe you'd like to output whatever edits you made to already-published articles, maybe you'd like a bunch of text files you can use as a backup in case your relational database kicks the bucket. Whatever the reason, anyone who's ever written a blog will agree that significant time and effort goes into writing, and the risk of losing all that text is formidable and vaguely hair-raising.

Here is a script I put together that goes through every entry in a blog's database, and outputs the text to a file whose title is created from the data and the name, with dashes, like this:

2014-10-05-backing-up-a-mysql-database-to-individual-text-files.txt
Continue reading "Backing up a MySQL database to individual text files"
Categories: Tech
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 501 hits

Run sheep, run!

Today is Tabaski, the biggest festival of the year in Senegal. In Arabic it's Eid al-Adha (The Festival of Abraham), and commemorates the moment where, called by God to sacrifice his son Ismael, God sent a ram and Abraham sacrificed it instead of his boy. Muslims sacrifice a ram each year in remembrance.

You can tell Tabaski is coming because you see lots of sheep being transported back and forth: on the roofs of cars, hopefully trussed down under a rice sack, leaving them to admire the countryside, chewing their cud, as they whizz down the highway; also on motorcycles and not infrequently between the legs of the cyclist as he navigates Senegal's crazy traffic. You also start to see sheep tied up to a tree outside the richer households, where it's a not-so-subtle display of wealth and a frequent target of theft. Continue reading "Run sheep, run!"

Categories: Senegal
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 202 hits

Marseille

Marseille

In grad school we studied at length the topic of economic convergence, where given freedom of labor movement and transport of materials, wages and economic conditions gradually meet in the middle, like high and low waters finding middle ground as the barrier falls. Agree with that theory or not, head directly to Marseille to have a look at what that might look like.

We visited Marseille in early summer, but already it was sweltering with Mediterranean heat; the air was humid and the sun seared, especially towards evening when its reflection off the harbor was nearly blinding. Hotter still was the metro, which was packed, nearly airless, and absolutely teeming with throngs and throngs of commuters. Suffocating, we curtailed our cross-town trip and made for the exits, where we caught one of the above-ground tramways plying the same route. Continue reading "Marseille"

Categories: France
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 164 hits

The Queleas

quelea

The Queleas arrived in mid-summer as the temperature in Dakar ramped up. Uninvited but hugely welcome, they have been an entertaining part of my mornings and evenings until the rains came and chased them away.

Chatty little things, several dozen Queleas began setting up shop in the Casuarina trees in our back yard, twisting and weaving bits of grass and needle into bowl-shaped nests that hung from the branches. They were so intensely chirpy that the neighbors complained, but what was not to like about so much energy and activity outside the windows? And their industry and perspicacity were a welcome respite from life in human West Africa. Continue reading "The Queleas"

Categories: Senegal
Vote for articles fresher than 7 days!
Current karma: 1 of 5, 2 vote(s) 363 hits

The Sierra Nevada

We’d thought about traveling to Austria or Switzerland in search of snow, but Spanish friends told us there was an easier way. And there was. Senegal is closest to Spain, and just outside of Granada in the south of Spain, lie the Sierra Nevada, whose 3000 foot peaks gathered snow each winter within just a few hundred miles’ distance from the Mediterranean. Too good to be true?

Too good. And too true. We were there in two days’ travel, taking an evening in Madrid to rest up from yet another red-eye flight from Africa over cups of hot chocolate and a plate of warm churros. Arriving in Granada we proceeded southeast and up, on a bus that left Granada’s station several times each morning carrying travelers and their skis. The road narrowed, turning back on itself again and again and fording small streams as the snow gathered at roadside and the pines thinned, and then we were there at the ski camp. Continue reading "The Sierra Nevada"

Categories: Spain
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 332 hits

Foix

Foix wasn’t even supposed to be part of the trip we’d planned from Toulouse down the length of the Canal de Midi towards the Mediterranean, but as I thumbed through books and maps, the lumpy Pyrenees caught my attention again and again. Running the numbers, I calculated it would be possible. Little did I suspect it would be one of the highlights of our trip, and the glimmer of a forthcoming trip we will plan for another day.

The Pyrenees are an easy train ride from Toulouse, rising slowly through farmland and thistle until the pines begin to close in and the air cools. We stepped out of the station house and heard it: l’Ariège, a cold mountain river somewhere above us. It had rained the night we slept in Toulouse, and the Ariege was running bank full and opaque, carrying leaves from the mountains above us. The sound of the water in the gorge was impressive, and the air was clean and cool: a nice welcome to the mountains for a family that has spent many years at sea level in the tropics. Continue reading "Foix"

Categories: France
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 338 hits

The Traverse at Ngor

Ngor, just beyond a little channel whose twin openings to the sea permit the force of the Atlantic to pour forth in wavelets that meet in the middle in a chaos of interference: it’s an easy traverse by wooden pirogue, ending at the little island that makes for joyful Saturday beach excursions. But speckled with boats at anchor, protected by the worst of the sea’s excesses, it makes a nice paddling excursion, too. So starting in late fall of last year, I made a habit of putting my surfboard in at day’s end and paddling out across the current to Ngor and back.

It was a good workout for the arms and shoulders and therefore probably good for my surfing. It was also an exercise in Senegalese ecology, as the traverse sent me across a channel that, at its deepest, was probably only about ten or twelve feet in depth. That’s deep enough to drown in, and many Senegalese have drowned there due to careless pirogue captains overloading their vessels and racing back and forth in reckless competition with their colleagues. But, except for an instant when, as the tide turns and the sea begins to pull and the ships turn on their moorings, it was no stress for a competent swimmer on a fiberglass longboard. Continue reading "The Traverse at Ngor"

Categories: Senegal
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 362 hits

The borked backup: a tale of database disaster

angry bear

This is a story with a happy ending, eventually. It’s the tale of how Google and some script-fu saved my bacon. There’s a moral, too: don’t be stupid, and you’re stupider than you think you are. That was my case, anyway, when a bear mauled my database.

I was running 4 websites on FreeBSD 9.0, and after two years of upgrading, it was time to upgrade the system to FreeBSD 10.0. That was an upgrade with some risks, and in my case, it went poorly. The system had been getting quirky anyway, so I figured it was time to just wipe it clean and install FreeBSD 10 fresh. I had downloaded to my local machine a full set of backups, so I was ready to go. As the new machine came up, disaster struck. Continue reading "The borked backup: a tale of database disaster"

Categories: Tech
Vote for articles fresher than 7 days!
Current karma: 3.33 of 5, 3 vote(s) 1372 hits

Making Communities, Breaking Communities

Pipedot logo

The online world of the World Wide Web is, in some ways, shattering into individual walled gardens hosted and jealously guarded by corporations who shepherd users into the controlling comfort of apps and single sign ons, and recoup their investments via advertising and datamining. The editorial by Doc Searls in the June 2014 edition of Linux Journal crystalized it for me: the Web as we know it is evolving in a way that benefits those corporations, and those corporations benefit again by trading free entertainment for users' data. There are other problems too, like the filter effect of people being enabled to more stringently than ever select what information they want to be exposed to, and technologies like the Google search engine, that strengthen that effect to the detriment of contrary view points. So much for the Internet being a new era of universal enlightenment and sharing.

But this melancholy point of view takes shape while reflecting on what I do on-line, and with whom, and that brings me to the subject of on-line community. Continue reading "Making Communities, Breaking Communities"

Categories: Tech
Vote for articles fresher than 7 days!
Current karma: none, 0 vote(s) 1847 hits