Geek Stuff category archive

To my new server. It’s working.

I couldn’t face another cooling tower today, so I spent the day messing with MySQL and WordPress.

I think everything came over okay, but please let me know if anything doesn’t work right.

Adendum: Later that same day:

I think my two or three regular readers will notice a significant performance improvement.

I’ll work on getting all the newsfeeds and stuff working later. Right now, I’m in I-Hate-Computers mode. I even called Opie for tech support and, between us, we managed to get everything working. (Thanks, Opie.) But, like in real life, neither one of us could figure out exactly what was broke or exactly what fixed it. We were yakking on the phone and hitting keys and it started to work.

In the meantime, here is some information about the new box: It runs

XAMPP for Linux 1.6.2, which includes

MySQL 5.0.41, PHP 5.2.2, Apache 2.2.4, and PERL 5.8.7 .

The operating system is Slackware Linux 10.1

The computer is a Pentium III 1000 gHz computer with 528 MB RAM, two IDE harddrives and one SCSI harddrive, a SCSI tape drive, a CD-ROM drive, and an external USB DVD-RW drive.

(aside to Opie) It was a surplussed Checkpoint Win2000 server.

And now back to the regularly scheduled flame wars.

I have a little network.

Now, here’s what’s wierd:

Orca is the new XP box. It’s my own copy of XP; I wiped it and started fresh.

The printer and a couple of directories are shared. Guest logins are allowed. Local login names and passwords on all the computers are the same (I am a bear of very small memory).

Orca can see and browse all the other shares on all the computers on the network, both the Windows computers and the Samba shares on the Linux computers.

The Linux computers can see and browse folders on Orca via Samba. The Linux computers have full Linux networking capability with each other, because Linux networking works, like, you know, out of the box. Well, out of the box as soon as you get LISa working.

But the other bleeding Windows computers! When they try to connect to Orca, they get a “You are not authorized to use this network resource” message.

I know that Orca’s firewall (NetDefense from System Suite v. 5) is set up properly, since the Linux boxes can see the share folders.

Conclusion: Windows workgroup networking sucks.

If anyone has any idea what’s going on, I’d like to hear it.

With apologies to Opie (see his comment here), XAMPP is installed and working. The non-database elements of the website (that is, everything except the blog) have been copied over to the new server and are working almost fine (almost, because the javascript “updated” statement at the bottom of the boating webpages seems to be choking).

I also got the printer successfully networked to the new server.

There are certain security issues with XAMPP I want to resolve. I don’t make anything public with no passwords, thank you very much.

But, over the next few days weeks months, I’ll be working on moving the database and perfecting the theme.

I just knew there was a way to completely automate this process. Now I’ve learned about BASH variables.

#!/bin/bash

# This script stops Apache,
# gzips the current log files,
# removes the old log files (access_log and error_log),
# creates a new folder named with today’s date and time,
# moves the gzipped log files to that location, then
# restarts Apache.
#
# The name of the folder is “month-day-year-hour-minute” so
# that the script can be run multiple times in the same day
# without stepping on itself (unless you run it twice in
# the same second).
#
# If someone wishes to tailor the script to his or her own
# system, it should work fine as long as the path
# statements are edited to reflect his or her configuration.

NOW=$1

: ${NOW:=$(date +”%m-%d-%Y-%H-%m”)}

cd /usr/local/apache2/bin
./apachectl stop

echo “Stopping Apache”

cd /usr/local/apache2/logs
mv access_log access_log.old
mv error_log error_log.old

echo “Renaming log files”

gzip access_log.old
gzip error_log.old

echo “Zipping log files”

#Gzip removes the original files after zipping them.

echo “Removing *.old files.”

mkdir /root/files/oldlogs/$NOW

echo “Making folder /root/files/oldlogs/$NOW”

mv /usr/local/apache2/logs/*.gz /root/files/oldlogs/$NOW

echo “Archiving old log files.”

cd /usr/local/apache2/bin
./apachectl restart

echo “Restarting Apache”

I’ve loaded the Operating System, got the Firewall and Antivirus working, and installed Opera.

Next step: Get Lisa and Samba working.

Oh, yeah, and tomorrow I’m pouring concrete.

Which should resolve some of the speed problems.

I picked up a Dell Dimension 4700 at the local computer secondhand store (which, by the way, has the only repair bench which I will allow to touch any of my boxes). I also got a nice KVM switch from Radio Slum, so that I didn’t need an additional keyboard, mouse, or monitor.

At first, I was unable to get Slackware Linux 11.0 to see the hard drive on the new Dell, till, thanks to Linux Questions dot org, I realized that I was starting cfdisk with the wrong switch.

The computer has and SATA harddrive. Linux sees that as a SCSI (pronounced “scuzzy”) drive.

So, to create the partitions, I had to start cfdisk like this:

cfdisk /dev/sda, (translation: cfdisk /device/scsi drive a)

rather than like this:

cfdisk /dev/hda (translation: cfdisk /device/harddrive a). The later works for IDE drives, which is what most older computers have, but not for SATA drives.

Since, of course, no good deed goes unpunished, there is another wrinkle–Linux is not seeing the network card in the computer. The next step will be to dig up an old network card, slap it in there, and see if Linux sees that (Rule One of Troubleshooting–Rule out hardware problems first).

Since I’ve loaded Slack on at least five or six boxes so far and never run into this before, I’m inclined to think it is a hardware problem, since, with Linux, networking is not an afterthought–it was built in from the beginning.

Once I get this puppy on line, it won’t be long till I retire my PC300 to being just a file server.

And maybe I can get my sidebar back.

My sidebar’s gone freaky on me. I won’t be able to troubleshoot it until this weekend, so I’ve edited it down as much as I can tonight.

But I can’t remember where Quote of the Day resides (blush).

I’ll have it fixed up by Monday.

Addendum, 5/4/2007:

I think the problem was Fire Stats that I was crowing about in the previous post. This site was slow as the Current Federal Administration’s grasp of reality this morning even after a reboot last night.

Fire Stats was just too much of an additional load for this 10-year old computer.

Teach me to crow.

For a short while there this morning, I had the old sidebar back, then it crashed again.

I have removed all traces of Fire Stats and started to shop for a new server. I think it’s just gotten too much for this old computer.

I stopped at Staples in north Dover to get printer cartridges and picked this up:

Leaving Staples, I had an uprecedented experience. I made it all the way through town without a single red light. And this in a town that doesn’t believe in syncing stoplights.

Now to unravel my database. Which will probably have to wait until the weekend.

As you can see from this line at the top of the page:

WordPress database error: [Can’t find file: ‘wp_secureimage.MYI’ (errno: 2)]
DELETE from wp_secureimage WHERE img_datetime < '[time]'

All is not well in SQL Land. There was a momentary–less than a second–power failure this afternoon, and it singed my database. I was telling myself it was time to back it up, but work came first.

But things are better than they were an hour ago, when Apache would not run. Rotating the log files cleared that up.

Now I get to mess with SQL to take care of that error message, but I’m up and running, even if the tires are leaky and I have rags tied around them, like in an old cartoon.

I’m definitely getting that UPS this week.

And I get to learn more about SQL when I get a chance to get away from cooling towers.

It leaves big holes in my browser where the ads should be by redirecting advertisers like DoubleClick to look for their ads on my own harddrive, where, of course, they ain’t.

I use this one, which I learned about here. (Karen, this site is an excellent site for help with Windows in plain English.)

The same HOSTS file works on both Windows and Linux.

In Windows XP, it goes into C:\Windows\System32\Drivers\Etc. The link explains where it goes in other flavors of Windows.

In Slackware Linux, it goes in the root of /etc. Linux users, be careful to copy the contents of your default host file identifying your computer name as 127.0.0.1 into the HOSTS file (it should already have line identifying “localhost” as 127.0.0.1). For other flavors of Linux, consult your local distro.

Be a good host. Get a HOSTS file and make those ads go away.

If you look at my sidebar, over there ——–>

you’ll notice Phillybits’s RSS updates are gone.

They stopped working, for some reason. They are working on my other computers, just not on the server. So I’m giving him a rest until I figure it out. In the meantime, the link in the blogroll still works.

Ziff Davis editor Steven J. Vaughan-Nichols suggests four reasons that Windows Vista is superior to Linux.

I’ll share number two. Follow the link the see the rest:

Reason number two: Linux is a pain to set up. With Linux, you need to put in a CD or DVD, hit the enter button, give your computer a name, and enter a password for the administrator account. Heck, you could break a nail that way! Almost all early customers of Vista will need to redeem their upgrade coupons and then replace their new PC’s XP with Vista. That’ll be loads of fun.

And it had nothing to do with modern pharmaceuticals.

I’ve been a bad little webmaster. I’ve neglected my Apache log files. Then they got too big, and gave me the finger.

I emptied them, and now I’m running again.

That doesn’t have anything to do with the speed of my internet connection, which seems to have slowed to beyond a crawl. Indeed, it was taking so long to download the TV listings that we ended up going to channel 99 and watching them scroll by on the box.

My ISP is crawling for some reason–I hope it’s back to a normal speed tomorrow. And not just on this computer.

Oh, yeah, and didn’t the Bears put the hurt on N’awlins today.

A little while ago, I wrote of my adventures getting Samba working across my network and mentioned that my next project was networking my webserver to the printer on my other Linux computer.

I use CUPS for Linux printing. It worked first-time, all the time on the local printer. But I just couldn’t seem to get CUPS on the webserver to connect with CUPS here.

I solved it today.

I had to correct edit my firewall configuration file (/etc/rc.d/rc.firewall), setting the proper condition to permit a connection. That took asking for help from the Slackware mailing list, since the firewall website seemed to have disappeared. One of the netizens there pointed me to the new website:

PERMIT=”[my subnet]/24″

Then I actually had an idea of my own, and looked inside the CUPS configuration file (/etc/cups/cupsd.conf) and found the following settings to allow or prevent external connections. By default, it was set to DENY ALL from the Big Wide World. I changed it as follows to allow my network in the door:

Encryption IfRequested
Satisfy All
Order deny,allow
Deny From All
Allow From [my subnet]

AuthType Basic
AuthClass System
Encryption IfRequested
Satisfy All
Order deny,allow
Deny From All
Allow From [my subnet]

Now I’m happily printing across the Linux portion of the network.

Now that my youngest has left home, equipped with his own computer, I’ve been slowly removing some of his apps from the “family” (that is, the one he plays games on when he visits) computer.

On of the apps was iTunes (don’t know why, he doesn’t have an iPod).

Today, I was using the Registry Fixer from my Favorite Windows Utility Suite.

It was unable to remove iTunes keys from the registry.

I opened up regedit and found that those keys were installed with NO PERMISSIONS ALLOWED. Not even the Administrator had rights to the keys. I had to manually (well, as manual as anything including a keyboard can be) change the permissions. And, on two of them, I was unable to change the permissions at all.

Those keys are still there cluttering up my computer.

This is not right.

I spent a good part of today decorating my computers for Christmas, with the help of the Keramic Christmas color scheme, KDE Christmas wallpapers and Splash Screens (there was this one, also), and Judy and Jerry’s Place for Winamp (Windows) and XMMS (Linux) skins.

With two Linux computers and one Windows computer, it kept me off the street for a couple of hours.

The only problem I ran into was finding a Christmas/Winter screensaver for Linux/KDE–any suggestions are welcome. Here’s the computer I’m working playing at right now:

One of the things I’ve been doing during my hiatus (see the immediately preceding post) is working on my network. I have two Linux boxes and a Windows box and a big ole 50 GB partion on the webserver that was intended to be a file server for the other computers.

Unfortunately, I couldn’t get the partition to mount. Opie will understand: it was a spelling error in /etc/fstab. (I left the “s” off of “defaults.”)

(Funny. Our teachers used to tell us that spelling was important. Computers have made it sew.)

Now it mounts .

On to Samba.

I have poked in a deletorious fashion at getting Samba to run over the past 18 months, when I got my first Linux box. Now I have it working.

The webserver can see the Windows box and the Windows box can see the webserver and I can move files back and forth with no problems. My laptop can see both of them. The only wrinkle left is that no one else can see the laptop (I think that’s a firewall issue, but I’m going to let it drop for a while).

Next step–Networking the webserver to a printer connected to a whole nother computer.

From the Quotes of the Day (a litle while ago–I’m catching up):

For a long time it puzzled me how something so expensive, so
leading edge, could be so useless, and then it occurred to me
that a computer is a stupid machine with the ability to do
incredibly smart things, while computer programmers are smart
people with the ability to do incredibly stupid things. They
are, in short, a perfect match.
– Bill Bryson, Notes from a Big Country

The question of whether a computer can think is no more
interesting than the question of whether a submarine can swim.
– Edsger Dijkstra

I have a theory about the human mind. A brain is a lot like a
computer. It will only take so many facts, and then it will
go into overload and blow up.
– Erma Louise Bombeck, 1927 – 1996

Computers are like Old Testament gods; lots of rules and no mercy.
– Joseph Campbell

A computer lets you make more mistakes faster than any
invention in human history – with the possible exceptions of
handguns and tequila.
– Mitch Ratliffe

The computer is a moron.
– Peter F. Drucker

From the Washington Post’s “The Checkout” consumer blog:

I know that often, when I am considering flights, I browse the schedule and fares of several airlines before I make a final decision on what flight I want. Then, when I go back to buy a ticket, that initial fare has gone up, sometimes a little ($25 or so), sometimes a lot ($100 plus). That was always the case with Flyi and often the situation with others as well. One aviation expert suggested I clean out my computer’s cookies if that happens and see if I get the lower fare. (A computer cookie is a code that contains a unique ID tag that’s put on your computer by a Web site. That Web site can then track you–or rather your computer–when you revisit it).

I followed the expert’s advice and more often the not, after I cleaned my cookies, I got the initial lower fare offer. The airlines denied they were tracking my cookies when I asked them about this. They all said the fluctuating prices simply reflected the number of seats available on a flight at the particular time I was trying to buy a ticket.

What goes around:

From El Reg:

TJ Hooker star William Shatner will once again play overweight promiscuous space maverick James T Kirk as a new videogame based on the Star Trek franchise is coughed up this October.

Fans of the dead horse have had little to cheer about since Paramount gave up flogging it by canning Star Trek: Enterprise – the one with the fella off Quantum Leap – last year.

Interest in Star Trek has waned, a fact not lost on Shatner. He told Reuters: “The interest in Star Trek has waned.”