Finding my roots

A friend asked me a question. I still haven’t found the answer.
In search of the answer, I found, preserved in Google’s cache (I don’t know how much longer it would have been there) my father’s family tree, going all the way back to 1746 in, of all places, New Jersey. (The furthest back I’d ever been able to go was about 1840.) Supposedly my Farquhar ancestor who came over on the boat was one John Farquhar, who arrived in either North Carolina or Virginia sometime in the 1730s. But my source on that is about as reliable as the Weekly World News.

It appears that John Farquhar was actually the brother of my direct ancestor, a Scotsman who was named, appropriately (I think), Adam Farquhar. And John did eventually end up heading south. Adam headed west.

I never could trace Adam’s family back. There’s a huge gap between 1729, Adam’s birth date, and 1382, when Farquhar Shaw, the founder of Clan Farquharson, lived–“Farquhar” used to be a Gaelic first name, which can be translated “beloved man” or “honest man,” but Shaw was so highly regarded that his descendants called themselves “Farquharson,” literally, “Son of Farquhar.” Later, some of his descendants shortened the last name back to “Farquhar.” So how are Adam and Farquhar Shaw related? All that’s known is that Adam’s father was born between 1700 and 1710. We don’t even know his first name.

Anglos have always had problems with the name “Farquhar”–it’s pronounced FAR-kwur, in case you’re wondering–but we always hear goofy variations of the pronounciation, and far-out spellings. Adam apparently often went by “Adam Forker.” The children of his second wife tended to retain the Scottish spelling and pronounciation, while the children of his first wife tended to go by “Forker.”

Adam’s Farquhars mostly ended up in Ohio, and a lot of his Forkers ended up further west, in Kansas. One of his descendants, Della Forker, married a Kansan named Walter Percy Chrysler–the founder of Chrysler Corporation.

How many people can say their half fourth cousin twice removed married Walter Chrysler?

Probably more than you think. My great great great grandfather Dr. Edward Andrew Farquhar had 11 kids.

Dr. Edward connects me to a trio of other people you’re likely to have heard of–at least if you’re American. Dr. Edward married Elizabeth Stratton, whose great great great grandmother was named Deborah Adams. Deborah Adams’ father was named John Adams, and he was born in Plymouth, Mass., in 1630. That fact made me really start to wonder. You’ve probably heard of some people named Adams from Massachusetts.

Declaration of Independence signer Samuel Adams and U.S. presidents John Adams and John Quincy Adams were descended from an English immigrant named Henry Adams. Henry Adams’ grandfather, also named Henry Adams, had an older brother named Richard. Elizabeth Stratton is descended from Richard Adams, making her the sixth cousin three times removed of John and Samuel Adams. Which makes me the sixth cousin eight times removed of John and Samuel Adams.

This stuff is addictive.

Oh, and to answer the other obvious question: not counting the Adams family–which I’ve traced back to 1392 and expect to be able to go back at least one generation further–I can trace my earliest ancestor back to 1462, in England.

When will we take security seriously?

Overheard today at work:
“Hackers don’t usually work during the day, or on weekends…”

I guess by that same logic, I could say that I ran file servers with all ports exposed on the public Internet for years and never got hacked (just don’t mention that those years started in 1996 and ended in 1998).

It’s sad that there are people who still don’t take security seriously. The attitude I heard 10 years ago–“What? Do they want to look at the GIFs and JPEGs on my hard drive? If they can get in, they can have ’em!”–pervades today. Nobody’s interested in your GIFs and JPEGs because you don’t have anything that hasn’t been posted on Usenet’s alt.binaries groups a dozen times, but they want your high-speed connection. It doesn’t matter anymore how insignificant you are. If your computer is online, they want it.

I’m quickly reaching the point where I believe it’s socially irresponsible to have anything faster than a 56K dialup connection and not have a hardware-based firewall sitting between you and the Internet. I bought a couple of the low-end Network Everywhere-brand (made by Linksys) 4-port cable/DSL routers a year ago. I paid $50 apiece for them. That’s what you’ll pay for a shrink-wrapped “Internet Security” software package, but it’s more effective and it doesn’t slow your computer down. Even a one-computer household should have one.

As far as antivirus software goes, Grisoft offers antivirus software free for home use. Yes, it slows your computer down. If you don’t like that, run Linux. Grisoft’s AVG is free, effective, and easy to use. And it stamps outgoing e-mail, assuring your friends that your mail has been scanned. That’s comforting in these days.

Hopefully the typical computer user will soon outgrow the teenage it-can’t-happen-to-me mindset.

But I won’t hold my breath. Since hackers only work on weekdays, problems can only happen when I’m at work and my home PC is off, right?

Using your logs to help track down spammers and trolls

It seems like lately we’ve been talking more on this site about trolls and spam and other troublemakers than about anything else. I might as well document how I went about tracking down two recent incidents to see if they were related.
WordPress and b2 store the IP address the comment came from, as well as the comment and other information. The fastest way to get the IP address, assuming you haven’t already deleted the offensive comment(s), is to go straight to your SQL database.

mysql -p
[enter the root password] use b2database;
select * from b2comments where comment_post_id = 819;

Substitute the number of your post for 819, of course. The poster’s IP address is the sixth field.

If your blogging software records little other than the date and time of the message, you’ll have to rely on your Apache logs. On my server, the logs are at /var/log/apache, stored in files with names like access.log, access.log.1, and access.log.2.gz. They are archived weekly, with anything older than two weeks compressed using gzip.

All of b2’s comments are posted using a file called b2comments.post.php. So one command can turn up all the comments posted on my blog in the past week:

cat /var/log/apache/access.log | grep b2comments.post.php

You can narrow it down by piping it through grep a bit more. For instance, I knew the offending comment was posted on 10 November at 7:38 pm.

cat /var/log/apache/access.log | grep b2comments.post.php | grep 10/Nov/2003

Here’s one of my recent troublemakers:

24.26.166.154 – – [10/Nov/2003:19:38:28 -0600] “POST /b2comments.post.php HTTP/1.1” 302 5 “https://dfarq.homeip.net/index.php?p=819&c=1” “Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 Firebird/0.7”

This line reveals quite a bit: Besides his IP address, it also tells his operating system and web browser.

Armed with his IP address, you can hunt around and see what else your troublemaker’s been up to.

cat /var/log/apache/access.log | grep 24.26.166.154
zcat /var/log/apache.access.log.2.gz | grep 24.26.166.154

The earliest entry you can find for a particular IP address will tell where the person came from. In one recent case, the person started off with an MSN search looking for information about an exotic airplane. In another, it was a Google search looking for the words “Microsoft Works low memory.”

You can infer a few things from where a user originally came from and the operating system and web browser the person is using. Someone running the most recent Mozilla Firebird on Linux and searching with Google is likely a more sophisticated computer user than someone running a common version of Windows and the version of IE that was supplied with it and searching with MSN.

You can find out other things about individual IP addresses, aside from the clues in your logs. Visit ARIN to find out who owns the IP address. Most ARIN records include contact information, if you need to file a complaint.

Visit Geobytes.com IP Locator to map the IP address to a geographic region. I used the IP locator to determine that the guy looking for the airplane was in Brooklyn, and the Microsoft guy was in Minneapolis.

Also according to my Apache logs, the guy in Brooklyn was running IE 6 on Windows XP. The guy in Minneapolis was running Mozilla Firebird 0.7 on Linux. (Ironic, considering he was looking for Microsoft information.) It won’t hold up in a court of law, but the geographic distance and differing usage habits give at least some indication it’s two different people.

Shrinking Windows 2000 and XP

Seeing as this used to be my big topic, I would be remiss if I didn’t mention that it’s now possible to remove Internet Explorer, Windows Media Player, and other components from Windows 2000 and XP using software from litepc.com.
I haven’t tested it, so I don’t know how much difference it makes, performance-wise. It made a large difference in Windows 98–removing IE caused system speedups of anywhere from 10 to 25 percent, which is more than you gain by upgrading your CPU a speed grade or two. This was mostly due to two factors: reduced memory consumption and inefficiencies in the FAT/FAT32 file systems. It’s been known for about 20 years that performance starts to degrade dramatically once you have more than 100 files in a program or operating system’s subdirectory (Microsoft even said as much in the DOS 5.0 manual).

Since most people run XP and 2000 with NTFS, and since systems with half a gig of memory or more are becoming commonplace, I don’t know if removing IE will make as much difference in this day and age. It certainly makes sense from a security standpoint though–rip out IE, Media Player and Outlook Express and replace them with third-party apps, and you’ve just eliminated most of the programs whose security holes affect desktop PCs. It comes at the expense of compatibility though. Some programs utilize Outlook Express and IE components–although some programs will install the missing DLLs.

But for special-purpose PCs, or other PCs that aren’t running any software that uses those programs, or PCs that are strapped for disk space, it makes sense to give it a shot.

When an AMD system gives you problems, always suspect the power supply

I did some power supply swapping this weekend. My video editing PC had outgrown its 300-watt power supply and I needed something fast, so I bought an Antec 430-watt TruePower box locally. I paid $30 too much, and it’s definitely a show-off box, with gold plating everywhere and multicolored sheathing around the power cables. I don’t care at all about that, but I do care that now my jammed-to-the-gills video editing machine has lots of steady, reliable power. How jammed? It has one PCI slot and one drive bay open. It can suck down some juice.
I then turned my attention to my 1.1 GHz Athlon. I’ve been building it for months. At one point I thought the motherboard was bad because the system always hung after the second reboot during an OS install. Always. I tried different Linux flavors, different Windows flavors, everything. Then the problems continued after I changed the motherboard. Prior to that I’d suspected the memory, but that worked fine in other systems. Then I tried every hard drive I could lay hands on. It didn’t matter how great the drive worked anywhere else, if I tried to run anything but DOS on my AMD, the system wouldn’t let me finish installation.

Once I’d tried a different motherboard, that only left the power supply. My case is an Inwin, with a 250w Powerman power supply installed at the factory. I swapped in my 300W Antec–newly unemployed after being replaced in my video editing box–and the system became stable.

Rule number one, which I’d forgotten, is to always suspect the power supply when dealing with AMD stuff.

In all honesty, I don’t remember when I bought that Inwin case, so I have no idea whether that Powerman was AMD approved or not. But the Antec provides considerably more power on the +3.3v and +5v rails and it works. The Powerman powers old Intel (P2-class) and AMD K6 stuff just fine, but none of my Athlon stuff.

So if you’re cobbling together an Athlon from spare parts and it’s not working, either salvage or buy a decent-quality power supply, preferably one that you know has successfully powered AMD gear in the past. I’ll bet it starts working.

FTE – a DOS-style editor for Linux

I don’t remember what I was looking for, but I found another DOS-style editor for Linux and Unix.

FTE is another editor that harkens back to the look of the typical DOS app of about 10 years ago, similar to SETEDIT. For casual editing, either program will do very nicely, and provide a look and feel comparable to the QuickBasic-derived editor that came with DOS 5 and 6.

Read more

The first PC I ever built

I’ve noticed a disturbing trend lately: Everyone who built his own PC knows everything. Just ask him.
Now, don’t get me wrong: It’s admirable to build your own PC rather than just buying Dell’s special of the week (although some people would be better off just doing exactly that), and it does require at least skill with handling a screwdriver. But it’s not what it used to be. Today, building a PC makes you know something. It no longer makes you an expert.

Read more

What to expect around here

I’m still not recovered, but I expect to be on my way. The doc put me on some prescription meds. Which reminds me: The mafia My health insurance company seems to have changed prescription providers YET AGAIN, and I missed my card in the mail. What is this, flavor-of-the-week?
It’s incredibly messed up when it’s easier to get your new license plates than it is to get a bottle of Amoxicillin.

So I’m torqued off right now.

As far as the recurring problems with spammy comments and trolls, I’m fed up with it. I appreciate the people like Dustin Cook and, yes, that arrogant French aristocrat, for telling the most recent one to shove off. But that’s not a permanent solution.

I’m looking at another piece of software that can be set to require commenters to be registered users–if you want to comment, you’ve got to give a username and password. I hate that. I really do. I don’t want people to have to go through the hassle. I don’t want people wondering what else will happen with their e-mail addresses, which I will require. (The answer is, nothing, because I hate spam more than I hate taxes, but the general public doesn’t know that.) Unfortunately, it seems to be the only way to reduce the trolls and stop the spam.

As far as Railroad Tycoon 3, due to my recent sickness I’ve only been able to play two short games. It’s not a radical departure from Railtycoon 2. The economics are a bit different (and far more realistic) and the graphics are a whole lot better, and overall the game is a lot more realistic now. I can safely say I recommend it. They set the requirements at 400 MHz, 128 MB of RAM, and a 16-meg AGP video card. I played on a 366 with 128 megs and a 16-meg Radeon 7000 video card. It was acceptable. You could probably get by with a 300 MHz machine with the same memory and video card, but there’ll be times when you’ll want more horsepower. 500-600 MHz would definitely be more comfortable.

The R. Collins Guide to Health

R. Collins Farquhar IV, aristocrat and scientist.
To the uneducated rabble.

Greeting:

I awoke this morning at my usual 11 a.m., and my manservants bathed me, as they usually do. As I had planned to visit my black-sheep brother, I had instructed my man-servant to have one of my modernized 1967 Rolls-Royces across the river in nearby Columbia, Illinois, which is the closest place I can land my Tu-144. The roads around David’s house are positively wretched, totally inadequate for an aristocrat, and one such as myself should minimize the amount of time he spends on them.

When I arrived, I instantly perceived something was wrong. The white Honda I have grown used to seeing in front of his house in addition to his silver Honda was absent. It seems my brother has been courting lately and probably not with much success. He has never asked my advice on courtship, which probably has much to do with his lack of success in that department. Of course, one never arose to the ranks of the aristocracy by sharing, which is why I personally do not recommend courtship or marriage.

I found David in his bed with two very old comforters pulled over his contumacious body. He never sleeps at this hour unless he is sick. I, of course, never get sick, owing my good health to my steady consumption of fine brandy and cigars. My pipe also helps. I understand that David has never smoked a pipe in his life, and only three cigars, and cheap ones at that, which might explain why he was laying there in his sotto voce state.

He never said a word. Typically he makes some comment about being really buff, and when he is in a particularly obstinate mood, he talks about being little and dainty and really buff. In reality, my brother’s body is as little and scrawny as his little-and-dainty mind, which is demonstrated by his obvious lack of knowledge of what “little and dainty” actually means. Just call my brother super-tryo.

Which reminds me: Thanks to my cigars and brandy and steady diet of imported caviar, my rotund being makes me the paragon of fine health. But I only drink decaffienated brandy, because caffeine dehydrates you.

Another clue was that he was not sleepwalking. That boy walks more in his sleep than I walk in a year. Of course, the upper crust should not have to walk. That is what manservants are for. Aristocrats should be carried. When I walked into his little-and-dainty bedroom in his little-and-dainty house and found him sleeping on his little-and-dainty queen-sized bed, he sort of sat up and growled something at me. One of my manservants said he said to go away. So I went into his little-and-dainty computer room and sat down at one of his little-and-dainty computers, and found it logged into his web site. He really needs to learn not to stay logged in. He could slow me down by 15 minutes if I had to hack my way in the way I did the first few times.

I will have to get Jacques Pierre Cousteau Bouilliabaise Nouveau Riche Ongle d’orteil le Raunche de la Stenche to take time from his busy schedule and accompany me when I next return to David’s house. We can cheer him up by insulting him, and he can watch two fine members of the upper crust enjoy cigars and aged brandy in our smoking jackets as we rebuild an antique radio.