Archive for November, 2005

Google Sitemaps Adds Features

Friday, November 18th, 2005

Other than Google Analytics, which came out this week, Google also made some changes to Google Sitemaps. The new features amount to essentially some feedback as to what are the most popular search terms for you site, and what if any errors some of the sitemap urls are generating.

In order to enable the new options, you must verify your site by creating a specifically named html file on your site. The new features are helpful, but may be considered very insignificant when compared to Google Analytics.

Google Analytics

Monday, November 14th, 2005

Google just announced that they are going to providing another service, called Google Analytics. The new service allows webmasters to have free web stats based on Google’s prior Urchin Stats service. All you have to do is signup with Google on their Google Analytics site, and signin using your Gmail, Adsense, or Adwords account.

Once you go through the signup process, you get a simple javascript to add to your html pages.

For WordPress users dt’s Blog.thedt.net site has a Google analytics plugin that gives you a simple text box for you to paste the script code into. I had to correct the plugin code, because for some reason it stripped out the php lines, so if you cannot correct the code from dt’s site, feel free to copy the Google Analytics plugin code from our WordPress forum.

Another Wordpress plugin that is easier to use is Cavemonkey50’s Google Analyticator plugin. Unlike dt’s plugin, Analyticator just asks you for the user account code, and not the entire script.

However how does Google Analytics compete against the other web stats packages out there, well Eric Peterson gives us some of his thoughts on Google giving away web stats.

Flushing DNS Lookups

Thursday, November 10th, 2005

Every now and then I run into a situation where I need to clear my DNS cache. This is sometimes needed when there are negative DNS values, meaning incorrect IP addresses on my computer for certain internet sites that I want to connect to. You can use the following commands to flush DNS and see if this allows you to reach the site.

Mac OS X:

For OS X, Lookupd takes care of cached DNS entries. You will need to open a Terminal session and type the following command:

lookupd -flushcache

On Mac OS X 10.5 Leopard, you no longer have the lookupd command. Use the dscacheutil command instead:

dscacheutil -flushcache

Windows:

For Windows, the IPConfig utility serves as an easy way to view TCP/IP settings and as a utility to flush DNS. You will need to open up a prompt and type the following command:

ipconfig /flushdns

Windows2000 & XP save negative DNS entries by default, so you might want to try disabling negative DNS caching to get a more responsive internet connection.

Microsoft has some notes on DNS settings in Windows too that you can reference.

Custom Shortstat Plugin

Wednesday, November 09th, 2005

A very handy plugin that I use for web stats is Jeff Minard’s Wordpress port of Shortstat, which is a script that Shaun Inman originally wrote.

Shortstat Plugin Conflict

It appears that Jeff recently updated the Shortstat plugin to version 1.3 and that there was a conflict with another great plugin, Google Sitemap Generator. After some research on WebKeyDesign, I found that the 2.7 version of Google Sitemap Generator conflicts with the 1.3 version of the Shortstat plugin. But the 2.7.1 version works fine. If you have not updated Sitemap to 2.7.1, first do that then download the new 1.3 version of Shortstat and set that up. This should make both plugins work.

Shortstat Slows Down Wordpress Dashboard

As if the Dashboard was not slow enough some days, Shortstat adds even more delay due to the IP address lookup that it does. You can disable this feature if you do not particularly care about what country your visitors are from. Most webmasters want to know what state or region in the USA, instead of the country, so for many webmasters this feature is not specific enough. To disable the feature just go to line 119 and look for the following code:

$coinfo = @file(’http://www.hostip.info/api/get.html?ip=’ . $ip);
$country_string = explode(’:',$coinfo[0]);
$country = trim($country_string[1]);

Change the code to this:

// $coinfo = @file(’http://www.hostip.info/api/get.html?ip=’ . $ip);
// $country_string = explode(’:',$coinfo[0]);
// $country = trim($country_string[1]);
$country = ‘(Private Address) (XX)’;

The Dashboard will still be slow due to feeds but Shortstat will not add to the delay.

Shortstat Database Data

If you take a quick look at the stats that you get, you can tell that they can start to add up and that while these stats are adequate for a quick daily glance, they are not really something to keep for a year or even more than a few months, so what you eventually need to do is zap the stats from time to time.

Shortstat adds two tables to the WordPress database: ss_stats and ss_search. I personally zap ss_stats more often than ss_search, since ss_search has the data for sites that refer to me and what searches people have used on my weblog. You can however zap both tables. If you have your log hosted on cPanel or have access to just phpMyAdmin you can easily do this. You will need to select only the two tables, and none of the other tables or you could end up deleting your blog data!!! Make sure you backup first. You can reference my Optimize Your MySQL Databases instructions, which should help you understand the process a bit better. The only difference is that instead of optimizing the table, you will be choosing to empty the selected table.

(more…)

DSL Router & Forwarding Ports Problem

Monday, November 07th, 2005

If you read my previous post on Troubleshooting Ports on DSL, then perhaps you will get the whole idea on how to forward ports, but as I discovered, powering off your routers may cause packet loss afterwards.

In a typical DSL setup your main DSL modem provide DHCP services, and although there is only one physical ethernet port that it connects to, unless you specifically setup the DSL modem to forward all traffic to your LAN router, chances are a reset could send packets to another ip address and all of a sudden your packets get lost going to a different ip.

To work around this, you either have to be careful about how you reset your routers or force the DSL modem to route everything to one IP address, therefore losing some of the firewall protection that the DSL modem is providing.

Here is a proper way to reset your home network and routers.

1. Turn off everything. This includes computers, routers, DSL modem.

2. Power on the DSL Modem first. Wait a few minutes until the LAN and WAN lights turn solid, usually green.

3. Power on your home router, the Linksys, Netgear, D-Link, or whatever brand you have.

4. After a couple of minutes, turn on the computers and other devices on your network.

5. Verify the NAT on the DSL modem is still setup properly and that the home router is connecting to the DSL modem with the correct IP address.

For the Cisco 678 ADSL modem, telnet into it and type:

show nat

The last lines that come up will show the last packets that were sent and what local ip they were sent to. It should be 10.0.0.2 for the 678, unless you changed it.

Close
Powered by ShareThis