:: TheOneAndTheOnly.com – Andrew Buckman ::

Urchin 5 Stats Stopping

Blogged in Plesk,The Site,Web Development by Andrew · Saturday March 17, 2007

So it seems there’s something wrong with Urchin 5 that is preventing my web stats from being compiled out of the logs files and into Urchin’s reporting interface. This began happening a year after I switched to the current server (running Plesk 7.5) and I noticed it on a few more important domains and found a fix at that time. Meanwhile I wrote myself a post-it note to go back and fix it on the rest of the domains, which of course I never did. Today I was curious about some stats for one of the domains I hadn’t fixed and thankfully was still able to find my note. I’ve decided to blog the solution so that I don’t have to worry about losing that note any longer and hopefully it will help someone else in the future as well.

If you try processing your log by clicking the “Run Now” button in Urchin Admin and see the following message come up, these instructions should help with your problem.
WARNING: (7063-54-63) Unable to open database for writing since it has been archived

The official solution to this problem exists on the Urchin Help site (now owned by google) at this location:
http://www.google.com/support/urchin45/bin/answer.py?answer=28527&topic=7393

My more detailed walkthrough follows…

The problem has to do with the archiving feature on a per domain basis. If you login to the Urchin Admin interface and configure the profile for that domain, there is a Storage/DB tab. On the tab you’ll see “Archive DB Options” with options for on/off and a timeframe for archiving if you leave it on. Change the setting for “Archive DB” to off and click “Update” to save your change.

The second half of the fix is a bit trickier and will require shell access to your server with an appropriate permissions level that grants you access to urchin’s installation directory. I logged in via ssh and switched to the superuser account to perform the following tasks (obviously you do so at your own risk, remember when you’re the superuser you have the power to break many things you don’t want to break). First, find where urchin is storing its reports for the domain you’re fixing (/usr/local/urchin/data/reports/theoneandtheonly.com/ for this domain). Change to that directory and look at the contents. You should see a variety of zip files named with the following format: YYYYMM-archive.zip. You should unzip these files to restore the data from the archives and remove the archive.zip files after they’ve been unzipped. This is important, you MUST remove the archive files, or at least move them to another directory so Urchin doesn’t see them.

UPDATE: By request, here is a list of the commands I ran for step 2…
cd /usr/local/urchin/data/reports/theoneandtheonly.com/
unzip *-archive.zip
mkdir archive-backup
mv *-archive.zip archive-backup

After both steps above are complete, go back to your Urchin Admin interface and run the stats report. You should see it processing your log files again and your missing data should fill in. Depending on the log file rotation schedule for your webserver you may or may not have gaps. If you keep backups on your server of all the logs, you should be able to reconfigure urchin to process the old files if you don’t have it setup that it does so already.

Dell 2405FPW for $779 again!

Blogged in The Site by Andrew · Tuesday October 11, 2005

It’s back! $779 buys you 24″ of 1920×1200 real estate on your desk!

Use coupon code D8Q403R9G4FJ32 for 35% off.
Update: WFQ9X9GW1VT?2R for 35% off.
Update again: 69$8KC79D53S2H for 35% off.

Final update: I’m guessing that’s it for this quarter.

Dell 2405FPW

The world has ended.

Blogged in The Site by Andrew · Tuesday August 2, 2005

First Intel CPUs and now a “four button” mouse from Apple? I must say it’s about time somebody used a ball for the wheel, hey look a mouse with a trackball! :-) I’m starting to think Apple really is serious about courting Windows users over to their camp this time. Slick little reasonably priced computer? Check. Two (or more) button mouse available? Check. The same Intel processors available with Windows so fights over speed are nearly pointless? Check (soon). Change your mind and decide you can’t live without Windows, reformat to Windows-only or dual-boot? Sounds like it, check.

Dell 2405FPW Insanity

Blogged in The Site by Andrew · Thursday July 28, 2005

Wowsers. So I bought one of the Dell 24″ monsters (2405FPW) and it arrived this week. Just plain crazy, the thing absolutely dwarfs everything around it. I LOVE IT! Best thing I’ve bought computer-wise in ages. When I saw it for $779 (the best deal I’ve seen on it yet, and so much cheaper than Apple’s 23″ Cinema Display) I just had to snap one up. If you’ve got $800-900 lying around, treat yourself to one of these monster LCDs from Dell, regret it you won’t.

I of course happen to have an HDTV card in my computer and can watch over the air broadcasts. Back at 1280×960 on my old monitor I could really only see 720p at full resolution, now at 1920×1200 on the monster I can see full 1080i in all its glory, and glorious it is. If you’ve got a reasonable fast computer and a high-res display, be sure and check out the High Definition WMV files from Microsoft at their WMV HD Showcase. Available downloads at 720p and 1080p that are a sight to behold. Apple also has an HD Gallery for their new QuickTime 7 format (still in beta for Windows-based computers), also gorgeous, though they don’t appear to let you try 1080p on Windows (yet?).

and I’m live…

Blogged in The Site by Andrew · Monday May 2, 2005

Here we are, I think I’ve finished my template massaging for now, got it back into spec so both the XHTML and CSS validate. A few areas to restyle still, but I’m generally pleased with the current layout.

©2010 Andrew Buckman
32 queries. 0.279 seconds.
Powered by Wordpress
theme based on desert by evil.bert