Month: July 2007

Over the past few days, I’ve been trying to achieve the proverbial “holy grail” of display resolutions with my Sony KF-42E200A television. These series of TV’s also go by the series name E2000; the A in E200A indicates the Canadian model of this set. They use LCD rear projection technology, and are nearly deprecated in favour of people wanting thinner LCD panel or plasma TV’s. I, however, enjoy the more accurate colour reproduction, wealth of inputs and inexpensive nature of this particular 42″ set. It also has a replaceable lamp in the event that it dies.

However, it’s buyer beware for this TV when attempting to use the system as a home theatre PC; because the E2000 series has deprecated a VGA port in place of two HDMI inputs, you have to be wary of what resolution you decide to send it. The TV is “smart” enough to detect common PC resolutions (800×600, 1024×768, 1152×864) and tries to adapt them to the screen size, but also detects common HDTV resolutions (720x480p, 1280x720p, 1920x1080i.) When a HDTV resolution is detected, the TV automatically “overscans” the content:

This is perfectly acceptable for DVD and game console content, because all of those devices compensate for overscanning when outputting video. However, when it comes to PC usage, your desktop often gets cut off, making it fairly difficult to see certain icons and controls. You do have several options: changing the resolution or resizing the desktop within your ATI Catalyst Control Center / nVidia Desktop Manager. For my 8500GT, I can’t use PowerStrip or similar programs to force a custom resolution because the driver support’s not there.

In any event, what I’ve found so far is that setting the resolution to 1152×648 (I’m using a DVI to HDMI cable) will give a 1:1 pixel mapping resolution, with a slight amount of black borders around the edges. Then, using the nVidia control panel, I changed the resolution to 1280×720 and selected “do not resize my desktop” in the HDTV settings panel. Afterwards, I switched the desktop back to 1152×648 for standard PC usage.

When configuring Windows Media Center, I chose a 720p resolution, which automatically compensates for the overscan issue and uses the nVidia 1280×720 settings.

Reference links that may assist in your efforts are at AVSForum:

Sony E2000 Settings/Tweak Thread
The Official Sony E2000 series Thread
Setting up PowerStrip to yield 1:1 Pixel Mapping on Sony A10 LCD RPTV

In an effort to be regular with my content – considering this week has not been kind to my posting schedule – I’ll continue with “Random Links of Interest Friday”. Here’s what I’ve stumbled across this week:

• A List Apart: Sliding Doors CSS. This article provides examples of how to implement rounded tabs by styling an unordered list element.
• CBC News: Digg dumps Google for Microsoft as ad partner. Facebook already has had the Microsoft contract for a while now, and I’m fairly certain Microsoft’s ad business is operated outside of the MSN/Windows Live norms.
• ColorSchemer Online. I’ve been doing a few web designs this week and sites like this one have been immensely helpful in selecting complimentary colours for links, active elements, etc…
• O2Networks Blog: A friend of mine, Dave Aldwinckle, has joined the weasel community of people who write things nobody else wants to hear online. He’s already got some great content online, such as this uTorrent technical manual for new users to the world of BitTorrent. (Disclaimer: EdgeLink Consulting indirectly hosts and helps with the IT dirty work for Dave’s site.
• Wall Street Journal: Hide the Button: Steve Jobs Has His Finger on It. A discussion of everyone’s favourite CEO and his hatred for buttons in user interfaces.
• McAfee Site Advisor Phishing Quiz. See if you can spot the scam sites from the real ones. Most of the problems, though, stem from incredibly poor English. If any of these scammers paid a technical writer to proofread their content, it would start getting really challenging to separate the real from the imitation sites.
• ScoreHero gets new Guitar Hero III information. While I’m probably not picking up this game (waiting for Rock Band personally), it’s neat to hear about the improvements coming in the next version of the game. The forum thread is full of fanboys, though – as would be expected if your favourite game developer paid for a trip to you to see their next product.
• The Math Moron. A Slate columnist, frustrated with her own mathematical ineptitude, decides to enroll in Kumon to be better able to help her daughter with homework. Also check out her latest piece about being a standardized patient and the following chat transcript.
• RewriteRule examples for Apache. While the actual rules themselves are regular expressions (regex), the formatting of them can be slightly different. This site has a few good examples for your webserver configuration.
• TOBlog: Your Rights as a Photographer in Toronto. A former coworker of mine wrote this post about what you’re legally allowed to do when taking pictures. Good advice for anyone who’s gotten a digital camera and is starting out into photography.

It’s “System Administration Saturday”, which is my new informal term for all the maintenance and hijinks required to maintain a stable home network and computing environment each week. I have a significantly overcomplicated LAN, but it’s necessary to maintain the concept of “access from anywhere” that I enjoy being able to use.

Along with the usual maintenance required during the week, one of the things I figure I should do is maintain a real-life changelog of what goes on so that I know what might’ve recently been changed. Today’s can be summarized as:

• Enabled the jumbo frame setting on bender and monolith with a payload size of 9000 bytes. I’m still only seeing spikes of 20% usage on the gigabit Ethernet adapter from bender, but file transfers across the switch are slightly improved in speed.
• Attempted another fix to the WRT54G v8’s port forwarding configuration to resolve FTP passive mode issues. No word on whether this has worked yet; if not, I’d be willing to bet there’s something odd with FileZilla Server requiring a reinstallation.
• Resynchronized the bender dropbox and downloads folders to monolith. monolith‘s disk space is sitting at 475GB free of 1.71TB total. There’s room in the box for one more internal SATA drive and one eSATA unit, but I’d need a new, reliable enclosure to put an eSATA disk into production.

Along with these changes, I’ve compiled a list of several potential new upgrades that would be “nice to have” items whenever I get a bit of spare cash:

Edit: Fixed table formatting to be less… wide.

I don’t really have much in the way of new or interesting music to recommend to people. Phil‘s Thursday posts of random greatness pretty much have that covered, and my iTunes library contains quite a number of bands that are distinctly on the side of “emo“, “screamo” or “god why do you have that.” Sure, there’s the occasional excellent band like Ill Scarlett, and a reasonable selection of popular music (Top 40 radio promo albums), but frankly I’m more on the consumer end of things rather than the trendsetter.

In lieu of providing MP3 filezzzz, then, I figured I’d provide some interesting links that have shown up in my browser history this week.

• Ars Technica: NVIDIA exec to PC makers: Pimping overpriced gaming PCs hurts. Game developers don’t want to write DirectX 10 games because of a common stereotype that DX10-class machines cost over $3000. In truth, you can build a very capable DX10 box for $1500 – but most people don’t even want to pay that. People buying the low-end Dell systems these days are getting an Intel Graphics Media Accelerator that will just squeeze out Aero Glass capabilities.
• CBC News: Massive cuts, fare hike coming to Toronto transit. Subway fares are already $2.75, and it’s pretty much an essential service in the GTA. Not good news by any means.
• Checkers has been solved. It’s now been mathematically proven that the game of checkers, played against a perfect opponent, can only result in a draw.
• The vi guide provides a cheatsheet for using the UNIX-y editor vi. I’ve personally used it for some CS assembly projects to avoid nonsense with Windows/UNIX line endings, and it’s a worthwhile editor to at least be aware of if you’re going to be working with a terminal.
• [H]ardOCP: TFT Technology Breakdown. This forum thread discusses the different types of LCD panels that can be found in flat-screen monitors. I was always quite impressed with my VX2025WM’s capabilities and display: now I know that it’s got a P-MVA panel, I know I’d be disappointed if I dropped down to a TN unit. Another good link is TFT Central, which indicates that a 24″ monitor upgrade to consider would be the BenQ FP241W.
• Yahoo News: Former Spammer: ‘I Know I’m Going to Hell’. Not only are those spam messages annoying and insidious, but they can be targeted to specific users. Don’t buy any cheap prescription drugs online unless you want to be bombarded with spam for them later.
• AlterNet: Neocons on a Cruise: What Conservatives Say When They Think We Aren’t Listening. It’s like a good old melange of racism, ignorance and stupidity all rolled into one on this ship!
• Gmail Skins: Tweak your Gmail account with this Firefox extension. Still has some bugs, so make sure the first time you save your configuration you know what you want.

Any links you’ve run into this week that are interesting, useful or amusing?

Let’s say you have a shared web hosting account on a random cheap provider, and the only way to access the MySQL server is to either connect from an SSH command line or use phpMyAdmin. While both of these options are okay, in some circumstances it’s not exactly wise to have a phpMyAdmin installation publically accessible, as it lends itself to repeated bruteforce attacks and is subject to server configuration changes. I know on my personal server, there have often been times that I’ve inadvertently left a myAdmin installation wide open for anyone to monkey with the database.

I also enjoy using an application called SQLyog, which is a Windows GUI tool for managing MySQL databases. The Community Edition of the application has proven to be more than sufficient for my random projects, and I highly suggest anyone doing database work on Windows take a look at the application.

Using some details from this article, with an updated version of PuTTY, here’s how I go about configuring my local system to connect to a remote MySQL server:

Start PuTTY:

Define your connection settings and save them:

Navigate to the Connection / SSH / Tunnels view, and provide the following settings:

Source Port: 3306
Destination: localhost:3306
(This assumes you don’t have a MySQL server running on your local machine. If you do, change localhost:3306 to localhost:freeport where freeport is the number of a free port on your workstation.)

Click the Add button, then save your connection settings. In the Forwarded Ports list, you should see L3306 localhost:3306.
Open the connection and sign in to the remote system.

Start SQLyog and define a connection to localhost:3306.

Your connection will be tunnelled through SSH to the remote server transparently. Make sure that you close SQLyog before you close the PuTTY tunnel.

Let me know how this works for your development situations – even if you have direct access to the MySQL server, you should still check out SQLyog for database development if you haven’t already tried it.

It’s Monday, and I’m back from a weekend excursion to the States. While some of my esteemed associates were doing pub crawls and partaking in other local festivities, my entire family opted to head down to an outlet mall in Grove City, PA to acquire some inexpensive American merchandise. As Dave’s Canadian retailers post mentions, there is really no excuse for some of the pricing disparities between Ontario and a comparable state.

And yes, the title of this post is accurate: On most clothing, there is no state sales tax, which is otherwise 6%. When you buy a ridiculously overpriced (yet trendy) sweater from, say, Hollister – the exorbitant price on the tag is the exorbitant price on the receipt, and nothing else goes to the government.

I speak specifically about a retailer like Hollister as I had the opportunity to go into one of these stores (this is in a different mall, not the Grove City outlets) while in the States. For those unfamiliar with them, the store is constructed like a beachfront cabin:

The entire store’s construction is an overabundant exercise in target marketing to the 12-25 year old demographic. As soon as you walk on to the “deck”, there are two sides to the store – one for guys, one for girls. There’s also an immediate assault of their in-house scents, as well as overly obnoxious “surfer dude”-style music. If you’ve heard any pop/rock from Warped Tour – basically any new music produced by RIAA labels that isn’t screamo – that’s about what you’d hear. From memory – I heard songs from Halifax, Fall Out Boy, Paramore, and some group with a surfer-style remix of “Message in a Bottle”.

From a technical perspective, the music is customer-controllable by a touchscreen beside the cash register area, which would make an interesting programming project (think managed queues, plus audio output.) They also have the relevant CD’s for sale at the register, which is a good way to push merchandise from other categories. Hey, if you’ve heard the song in the store, why not pick up the entire album?

After nearly dropping my jaw at the prices of some of the shorts and jeans available there, I went to the clearance section (at the back of the store, obviously) and managed to pick up some decently priced items. I now own a new bathing suit, plus a few shirts that I haven’t gotten for free from software companies!

Next on the list of stores in the mall was a place called Steve & Barry’s, who specialize in incredibly inexpensive clothing, as well as hilariously inappropriate shirts. I purchased several of these items, which you will see in person over the next few weeks. Unfortunately one of the best shirts in the store wasn’t in stock at all: it was a map of the state, overlaid with an Amish buggy and a marker for the town of Intercourse. The caption on the shirt? “Intercourse, PA. Come again!”

The Grove City outlet mall is a haven for decent and cheap merchandise. The trick to the experience is shopping at stores that have “Outlet” or “Factory Store” in the title, and immediately going towards the back of the building towards the deals.

Possibly one of the best deals in the place, besides the ubiquitous clothing, was the Sony outlet store. A set of MDR-EX71SL earbuds that go for $60CDN are available, refurbished, for $19.99 US. The next model up (MDR-EX81SL) goes for $29.99 US. I’ve had the 71SL’s since last year’s trip, and the 81’s available this year are even better. I’d highly recommend these for anyone wanting a high-quality set of earbuds for their MP3 player.

Article Update, January 7, 2009

Just got this snippet as part of an Amazon recommendations email for Anberlin’s Cities:

Unlike most emo bands that merely offer a laundry list of personal hardships over the sound of loud guitars, the members of Anberlin know that they can seek salvation in a higher power, so the songs on Cities aren’t so much about self-pity as self-preservation. It’s a refreshing twist on the formula, especially when paired with the industrial-strength hooks the spiritual Florida band knocks out on tracks like “Dismantle. Repair.” and “Godspeed.” On the latter, the group’s frontman Stephen Christian lashes out against the bad habits of his secular counterparts: “Tell them who you were, who you really were/Kill yourself slowly over time, fashion statement suicide.” –Aidin Vaziri

One thing I recently found out from looking through some example CSS: when doing web development or design, you may want to apply certain attributes to one type of input field but not another. For example,

is coded:

<input type="button" value="A Button" />


The problem therein is that you may want different borders, backgrounds or sizing attributes for your buttons, text fields, radio buttons, check boxes and password fields. Internet Explorer is an especially aggravating candidate for this, since it enforces border styles around the actual radio button itself. Safari behaves differently than other browsers as well, since it likes to enforce OS X-style control attributes.

In your CSS file or <style> tag section, you can force specific elements with attributes to take certain styles, such as this example from a recent project:

input[type="text"], input[type="password"], textarea {
border: 1px solid #aaa;
background-color: #f5f5f5;
}
input[type="text"]:focus, input[type="password"]:focus, textarea:focus {
border: 1px solid #336bc3;
background-color: #ffffff;
}
input[disabled][type="text"] {
border: 1px solid #888;
background-color: #ddd;
}
input[disabled][type="text"]:hover {
border: 1px solid #888;
background-color: #ddd;
}

In this example, text fields and textarea elements will be styled with a specific background color and border, which won’t affect other elements such as buttons.

Another neat trick I’ve learned while working on this project is the ability to put action images inside <button> elements. Instead of the <input type="button" /> tag, using the HTML 4 <button> element allows even more tricks. For example:

<button type="button"><img src="images/rss.gif" alt="" /> RSS</button>

would give something like this:

RSS

I’ve had several articles and references to my computer setup and preferred applications written before. I figure the list is due for an update with the latest hotness in technology.

CD/DVD Burning

• Mac OS X: Disk Utility for ISOs, iTunes, Disco
• Windows: Nero Burning ROM 7

DVD Video Burning

• RipIt4Me with DVD Decrypter and DVD Shrink

Virtual DVD Drive

• Daemon Tools 3.47 (don’t use version 4.x)

Instant Messaging

• Mac OS X: Adium X
• Windows: Windows Live Messenger, Pidgin (formerly gAIM)

BitTorrent

• uTorrent with ScrapeTorrent

Newsgroups

• SABnzbd with NOVA theme
• NewsLeecher

Graphics Editing

• Fireworks

Audio/Video Players

• iTunes
• VLC
• CCCP codec pack
• Media Player Classic

File Transfer Clients

• FileZilla
• WinSCP
• FlashFXP

Programming and Development

• Eclipse
• Eclipse PHP Development Tools
• Subclipse (SVN client for Eclipse)
• Visual Studio 2005 Express

As per Major Nelson’s post:

The free update will introduce several significant features, bug fixes and updates based on user feedback, including Xbox LIVE Vision Camera support (player bankrolls will not be reset with this update).

Now with live video, players can put on their best poker face and scrutinize the faces of their opponent’s in true poker fashion. Using the Xbox LIVE Vision Camera also allows players to use a series of game faces using the snapshot mode for all-ins, wins, losses, folds and more. Other features of the update include the following:

· Improved usability such as the addition of Custom Match Lists, which allows gamers to view and select which available Custom Match game they would like to join.

· Improved rich presence in the game, allowing players to not only see what their friends are up to, but also if they just won that big pot!

· Improved matchmaking and user results.

· Scoring and screens are more readable than before.

· Multi-language support including English, French, German, Italian and Spanish.

New premium downloadable content allows players to customize the in-game environment, and access new gamerpics and themes

This update being free almost makes up for the travesty of the Guitar Hero II song pack costing $6.25US for three songs. Didn’t they hear the massive outrage last time? It was even worse than the horse armor scandal with Oblivion.