xcache Revisited

In an earlier post, I complained about xcache 1.2.1 doing nothing but bad things to my server. I ended up moving to eAccelerator for a while instead. Recently, I moved to some better hardware to handle my ever-increasing traffic, and decided to give xcache another try. Low and behold 1.2.2 is out (and has been for a while it seems).

With the aid of a few plugins, I now have over 500 var caches running in xcache along with many php scripts themselves in the cache. My loads are WAY down (but, most of that can be contributed to the better hard ware) and page load times is MUCH faster.

I like it. And i retract my previous statements about it. Well done.

Posted in Server Administration | Tagged | 7 Comments

SEO in a world where the “SE” doesn’t “O”

I spend a ton of time working on SEO aspects of sites I work on. I’m also a pre-release team member over at vBSEO, a 3rd party SEO software add-on for vBulletin forums. Today, I question why I do this.

The ‘big daddy’ Google can’t even seem to get their sub domains correct.
ie,

http://maps.google.com/webmasters/

http://mail.google.com/webmasters/

and

http://www.google.com/webmasters/

all go to the same place.

Both the maps and mail sub domains should 301 re-direct to regular www.

This is an epic duplicate content failure on all accounts. It is possibly the greatest oxy-morons of all time. No one “searches” for Google (ok, maybe a few random’s go to Yahoo.com and search for “google” to get there…), so they seem exempt from anything relating to SEO. Yet, their algorithms penalize websites with duplicate access points.

This is not a difficult ‘final tweak’ either. This is an entry level SEO consideration. Moreover, it can have negative effects on the application itself, such as cookies hitting mix-matched domains.

Maybe Matt Cutts will grace us with a reply here :)

Posted in SEO | Tagged , , , | 5 Comments

IE6 AJAX hang on readyState 3

I recently ran into a problem that took me a few days to find a work around for. Running a basic AJAX POST, IE6 would hang up on readyState 3 for 200 seconds, throw an “Unspecified Error“, and then finally perform the action. Having a user wait 200 seconds for the IE6 timeout to come into effect is simply not a solution. All other browsers I tested, including IE7, were not having this problem.

I read on the web that this may come from SSL or from compression on the webserver. I bypassed our SSL check entirely, and it still happened. I did not mess with the servers for http compression though. To me, that is NOT an option to disable. Bandwidth costs would be too much to even consider this a viable solution.

So, I returned to the programming aspect of it. There has to be a code fix somewhere.

Long story short, IE6 doesn’t handle connection closures properly. A typical request looks something like:


function doajax() {
var url = "/script.php";
var params = "x=123&y=456";

//add timestamp to pass a unique param each time to prevent ie caching the ajax object
timestamp = new Date();
tim1 = (timestamp.getTime());
sec1 = timestamp.getSeconds();
ms1 = timestamp.getMilliseconds();
thetime = tim1+sec1+ms1;

params += "&rand="+thetime

xmlHttp.open('POST',url,true);  
xmlHttp.onreadystatechange = alertContents;  
xmlHttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlHttp.setRequestHeader('If-Modified-Since','Tue, 04 Apr 2006 00:00:00 GMT');  //some date in the past
xmlHttp.setRequestHeader("Content-length", params.length);
xmlHttp.setRequestHeader("Connection", "close");
}
xmlHttp.send(params);

The line in question here is

xmlHttp.setRequestHeader("Connection", "close");

Since this header is effectively applied for each readyState, it ends up hanging up on readyState 3.

The easy fix:
Target ie6 (and other old browsers) to not close the connection.

change the above snippet to:

if(!document.all) {
  xmlHttp.setRequestHeader("Connection", "close");
}

I’m not 100% sure of the implications involved in NOT closing the connection, but I haven’t seen any performance impact, and this cleared up the bug right away. No JS errors, and no 200 second waiting. Give it a try and let me know if it works for you as well.

Posted in Programming | Tagged , | 4 Comments

Freelance Programming Feedback

This post contains comments from people whom I’ve done custom work for in the WordPress, vBulletin, and vBSEO worlds. I’ve asked those that I’ve worked with before to leave a few words here about my quality of work.

If I’ve done work for you, please leave a few words so others who are considering working with me know that I’m legit and can deliver as promised.

Thanks

Posted in Programming | Tagged | 7 Comments

WordPress Permalinks on IIS with ISAPI_Rewrite

I’ve run WordPress here on my CentOS box for nearly 4 years and am quite familiar with the software. Recently, I had a client on a Windows system request a blog be added to their web store. Their webstore is written in ASP and runs on windows. They wanted to stay on the same domain for SEO purposes, (thus site.com/blog/ instead of blog.site.com or a new .com). Without the subdomain or new IP, there’s no way to change DNS for a subdirectory to a different server. This meant I had to get it working on IIS.

Native installations for apache tend not to port well (or perhaps, easily) over to windows/IIS. Thankfully, ISAPI3 from HeliconTech.com supports .htaccess files and makes the job a little easier. WordPress works fine on windows/IIS until you want nice permalinks.

After MUCH searching, testing, and error log analysis, I’ve got a working solution for Windows Server 2003 with ISAPI_Rewrite 3.1.x, running php 5.2.x and mysql 5.0.x community.

  1. index.php should be set up in IIS as a default document (same place you find default.asp, index.htm, etc)
  2. edit wp-settings.php
    Find:

    <?php

    at the very top of the file.

    Replace with:

    <?php
    //*****************************
    //    IIS FIX
    //
    $_SERVER['REQUEST_URI'] = $_SERVER['HTTP_X_REWRITE_URL'];
    //*****************************

  3. create the following htaccess file with the Helicon Manager:

    RewriteEngine On

    #RewriteBase /

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule . - [L]
    RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-.*) $2 [L]
    RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
    RewriteRule . /blog/index.php [L]

    • Note: You may need to alter the RewriteBase or the last rule to your specific location. In my particular case, I was installed on domain.com/blog/

From here, you can edit your permalink structure as you normally would. If the default options has index.php/ as part of the rule, you can remove that.

Posted in Programming, Server Administration | Tagged , , , | 6 Comments

Dreading Tax Season

Every year around this time, I start getting nervous. The fear of getting audited constantly crosses my mind. No accountants around me have a clue about internet marketing. It really is a special niche that most have zero experience with. This is the conversation I had with the last 3 places I called:

ME: Hi, I’m looking to chat with someone experienced with internet marketing income to help me with my taxes.
ACCOUNTANT: ohh, so you run a store?
ME: No, I get paid 1099-misc by many 3rd parties for running their ads and marketing for them.
ACCOUNTANT: Wait, you make money without selling anything?
ME: Yes, I run ads for them on my forums, blogs, and other websites promoting their products, services, etc, of which I get a cut if there’s a sale or a click, depending on the type of ad.
ACCOUNTANT: So you don’t have an inventory?
ME: Thanks for your time.

While I’m sure they are smart with numbers, I simply can’t trust in good faith someone who doesn’t have a clue about the type of business I’m in to make the best business tax choices for me.

On top of all my web income and expenses, I also work W2 with a ‘real’ 9-5 type job. Then, there’s my 401k, my stocks that i’ve bought, sold, and earned dividends on, bank account interest, mortgage interest, my local/state income, property, and car taxes, the percent sq.ft of my dedicated office on my house that I get to write off for a business expense and so on and so forth. At the end of the day, my taxes suck.

To make matters worse, I have an ever-growing pile of tax forms on the floor of my home office.

Tax Forms

The worst part is that I’m still expecting a couple forms in the mail.

Do you dread Tax season as much as I do?

Posted in Off-Topic | Tagged | 5 Comments

Rand() isn’t Random

If you use Microsoft SQL 2000, you’ve probably at one point had to pull random results. The built in rand() function simply doesn’t work. It gives you a random value the first time, and every time after it is the same it seems.

I found a new way to do this today after 20 pages of searching, so hopefully this will help someone else.

ORDER BY newid()

yup, it’s that simple.


SELECT
  TOP 2
    field1
   ,field2
FROM
  TABLE
WHERE
  field1 = 1
ORDER BY
  newid()

To be noted, this will put a full table scan in place before it selects the top 2, so keep performance in mind.

Posted in Programming | Tagged , | Leave a comment

New Toy for the Office

Christmas is coming, and so is the end of the year. I need to spend some money on my business so i don’t get taxed to hell like I did last year. So, I upgraded my office computer.

I’m currently working on a 2yr old HP dv8000 amd turion laptop. it’s had its hay day. The video card on it keeps over heating. I guess it wasn’t meant to be on for nearly 2 years straight. The only time it was off was when i moved, and when we lost power for longer than the battery would last (i don’t even think there was more than one time that happened)

I hit up new egg for a new tower. Back to the tower. Why? Well, I never used my laptop as a laptop at all in the first place. And it’s still good, so i can take it with me on business trips or whatever…. just can’t do anything that requires a lot of video memory like watching movies without it crashing. So, new desktop it is.

Parts coming include vista ultimate, Q6600 quad core processor, 2gb ram, 8600gt video card, dfi T2R (or is it TR2.. i forget) board and a bunch of other random goodies.

With it, I ordered a monitor. I’m still waiting on my parts to build the tower, but the monitor showed up today. Go big, or go home! The Samsung 30″ now sits on my desk. It’s unbelievably huge.

My measly 17″ widescreen laptop on my desk, with my MAudio BX5 powered studio monitors.

laptop - before

With the new 30″ behind it, waiting patiently…

samsung 30 inch monitor

Can’t wait to try this bad boy out!!

Posted in Off-Topic | Tagged | Leave a comment

Getting the Big “Oops” from a Server

I had some minor problems with xCache recently that ended up causing segfaults in my apache install. I had left my SSH putty session open last night and didn’t check my laptop before I trecked into the office this morning (yes, some of us bloggers still have 9-5′s). When I got to work, I noticed my server was down. I had to hard reboot it through the IPMI switch at my data center. I removed xCache from my php.ini and things have been solid since.

I came home from work and looked at my putty session and got a good laugh. “Oops” it tells me. haha. I had a good chuckle about it.

Oops

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: Oops: 0002 [#1]

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: SMP

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: CPU: 1

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: EIP is at kernel_thread_helper+0×7/0×10

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: eax: 00000000 ebx: c0434cd9 ecx: ffffffff edx: ffffffff

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: esi: 00000000 edi: 00000000 ebp: 00000000 esp: e8121fe8

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: ds: 007b es: 007b ss: 0068

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: Process pdflush (pid: 8071, ti=e8121000 task=f67d3000 task.ti=e8121 000)

Message from syslogd@sv03 at Wed Nov 14 04:56:13 2007 …
sv03 kernel: Stack: c2858f60 00000000 00000000 00000000 00000000 00000000

Message from syslogd@sv03 at Wed Nov 14 04:56:14 2007 …
sv03 kernel: Call Trace:

Posted in Server Administration | Tagged , , , | 1 Comment

xCache is More Trouble than it’s Worth

Two servers and a just about every option variation later, I’ve officially given up on xCache.

The first round of problems involved caching config files and forms that needed to be updated all the time. I made exclude rules for those, and eventually it just got too long and became way too tedious to restart apache every time i changed a config file.

Second round of problems involved Apache segfaults. Happened to me twice in 12 hours and cost me a good amount of money as it happened at 5am the second time, and I didn’t log in to check my server until noon (because I was sleeping). 7 hours of downtime across multiple sites that my server hosts, and I’m out some cash because of it, and missed out on some traffic due to a digg’ed post that is currently about to break from upcoming into popular.

I’ve disabled xcache for now, and things seem to be stable again.

Running it, it saved me about .2 average load, and memory usage was about the same at 25% most the time.

I can’t say the site ran faster with it on either.

Maybe i’ll try it again in a later version, but in my opinion, version 1.2.1 is not all it’s cracked up to be.

Posted in Server Administration | Tagged , , , | 4 Comments