Our Chinese tcpsndbuf Error

A couple weeks ago we noticed in Virtuozzo that we were getting a lot of tcpsndbuf “Black Zones”.  Thankfully, it wasn’t taking down the server, but it was disheartening.  Checking our bean counters the failcnt (the last number) was huge:

tcpsndbuf        192296     192296    2867477    4096277  151117486

Why was it happening?

After a little research into what a tcpsndbuf is and why this error might arise, it turned out that most people have this problem when tons of emails are being sent out all at once.  If you think this is your problem, check your mail log to see if anything’s fishy.  Look at what was happening email-wise at the time of the “black zone”.  Here’s a post about tracking down a rogue email script.

Another reason this might happen is when large files are being downloaded simultaneously.

Tracking it down

First we checked the mail logs to see if one of our clients had a script that was spamming, or sending out newsletters to a giant email list or some other nefarious plot was at hand.  No dice, they’re good citizens.

Next we checked the bandwidth usage and noticed that one domain in particular was using much more than usual (like 20 times what it usually uses per month).  This site was a blog that ran a weekly feature tracing a single song through all its manifestations being covered by other artists.  Each post had 5 – 10 mp3s. Now we were getting somewhere.

Checking out their apache access logs it turned out that these audio files had been discovered by a website in China.  There were tons requests for the audio files with no referer, originating from an IP in China, or from the site itself.

Fixing It

I’m not trying to hook China up with free Xiu Xiu mp3s so here’s how we stopped them.  Basically we set up an .htaccess file that rejected requests for audio files where the referer didn’t at least have our domain name in it, or that came directly from the offending site.  Here’s the code:

RewriteEngine On
RewriteCond %{REQUEST_URI} /audio/.*
RewriteCond %{HTTP_REFERER} !.*theDomainInQuestion.* [OR]
RewriteCond %{HTTP_REFERER} .*the\.incomingIP\.fromTheChinese\.site.*
RewriteRule .* – [F]

The problem with this method is that it’s pretty strict.  Because it will refuse any downloads that don’t come directly from the domain, this means it will deny links from an RSS feed too.  You could get around this limitation by changing line 3 to something like:

RewriteCond %{HTTP_REFERER} ^$ [OR]

which would prevent requests from no referer, and then tweak it from there, adding more [OR]s to block specific sites.

In consultation with the site owners we decided this strict method was fine.  We added a notice to each post in their RSS feed explaining the problem and notifying readers that the audio files were available on the site.

WordPress “Error establishing a database connection”

If you have the misfortune of experiencing the white screen of doom featuring the simple words “Error establishing a database connection” on your WordPress site, this post might help you troubleshoot.

The Simple Fix

Most people on the internet seemed to have this problem because their wp-config.php database info was incorrect. From the WordPress Forums:

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?

If that’s indeed the problem then you’re in luck, just put the correct database name, database user name, and database password in that file.  Make sure your database host is ‘localhost’ or figure out what is via your hosting company.  Or hassle your hosting company to fix their mysql server.  Here’s the part of wp-config.php you’ll want to change btw:

// ** MySQL settings ** //
define(‘DB_NAME’, ‘*****_wrdp1′); // The name of the database
define(‘DB_USER’, ‘*****_wrdp1′); // Your MySQL username
define(‘DB_PASSWORD’, ‘*****’); // …and password
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

The Hard Fix

Unfortunately this wasn’t my client’s problem.  We are the hosting company and everything was working fine; her db user could connect and had the correct privileges, etc.  After a little tracking down, it turned out that somehow the ‘siteurl’ option for her WordPress installation had been deleted.  This value is also what resides in the “WordPress address (URL)” field under “Settings” on the backend.  Note: don’t delete that.

I went into her database in phpmyadmin, found the table ‘wp_options’, and searched for ‘siteurl’ in the ‘option_name’ field. It was indeed empty so I entered her domain name- ‘http://’ and all- into the ‘option_value’ field.  Viola.

Here’s the sql is you don’t roll GUI:

UPDATE ‘wp_options’ SET option_value=’http://yourdomain.com’ WHERE option_name=’siteurl’

Web hosting that supports artists.

Archives

  • TPG21
  • TPG20
  • TPG19
  • TPG18
  • TPG17
  • TPG16
  • TPG15
  • TPG14
  • TPG13
  • TPG12
  • TPG11
  • TPG10
  • TPG9
  • TPG8
  • TPG7
  • TPG6
  • TPG5
  • TPG4
  • TPG3
  • TPG2
  • TPG1

Lego Hello World
I wish all my printers were made of legos.

LIFE photo archive hosted by Google
Images from Life Magazine going back to 1860′s, hosted by Google

Coming Face To Face With The President
Well crafted story about an under-heard point of view.

In California, Pot Is Now an Art Patron
A new funding source for the arts – reaping big rewards and funding many projects.  It’s pot.

Notes on Portraiture in the Facebook Age

Celebrity Book Club: A List to End All Lists
Because, well, it’s sortof awesome.

Are "Artists' Statements" Really Necessary?
The pros and cons about that nemesis for most artists.

This to That
You tell it what you’ve got and it’ll tell you what to glue them together with.

Work of art: Online store for buyers, sellers
Not the TV show!  Kelly Lynn Jones from Little Paper Planes is interviewed on her project, gives us a cheat sheet to local affordable art resources.

How to make a Daft Punk helmet in 17 months
whoa.