Archive for August 2007

I just read this in the Postfix Release Notes… and thought I had to share.

[Incompat 20060806] Postfix no longer announces its name in delivery
status notifications. Users believe that Wietse provides a free
help desk service that solves all their email problems.

Who said coders don’t have a sense of humor? :)

This neat – one of my favorite products, BeyondTV, records television (standard or HD) but it is only a Windows program. You can use BeyondTV Link to play video on any other PC on the local network (because of bandwidth constraints – if you want to view over the internet, use the BeyondTV Web Interface or Orb)

Your TV, both live and recorder, could also be done using Orb; however Orb lacks the nice interface BeyondTV Link has.

I’ve been contemplating moving to MaxOS X for my next Laptop purchase; this plus VMWare Fusion really makes it easy to switch over to a Mac for us Windows users.

If you are a system administrator, you should dread any time you use the normal “ls” command and receive a strange error in return. That is a sure sign that your machine has been hacked and ls has been replaced by an unknown program. Gnist blog has a nicely written step-by-step list of what you can do to track back an intruder.

In his case it sounds like the original owner of the machine may have used a weak root password on his machine, allowing for someone to crack it and break into the box. People, don’t forget to use a hard-to-brute force password, and finally disable root login s. Instead, use normal users and sudo.

Finally, if you are doing this in a legal setting and preparing for a possible future court case, don’t forget to make an image of the drive (using dd or Norton Ghost) before your analysis; otherwise the intruder can get your evidence thrown out.

Some other security resources:

Meebo, which I have recently been turned on to, yesterday released an iPhone client which is basically a web interface to their chat website (which integrates AIM, Yahoo!, MSN, gtalk, and more). It looks great, take a peek:

Meebo on iPhone

That is great that they are developing this and I applaud them for their efforts of releasing updates on mobile devices.

Now, maybe I have iPhone envy, but wouldn’t it make sense to release this for Windows Mobile since the market share that Windows Mobile has is MUCH greater than iPhone? According to Gartner, Windows Mobile shipped a little over 3 million devices in the 1st quarter of 2007 alone (and that number does not even include “Smartphone” devices). iPhone, according to their own estimates [MacNewsWorld], will sell a million units by Sept 30th.

I asked Meebo about their plans for Windows Mobile. Here is the response I received from Sue:

As far as a Windows Mobile version of meebo, it’s
something that we’ve thought about and are interested in, but at the
moment we don’t have development time and resources to add support for
every device we’d like to.

Here is where it gets tricky. There may be a great market penetration for Windows Mobile – but it is not easy to develop a web app for it because there is no standardized browser platform. Sure, you have Internet Explorer Mobile, but let’s face it – IEM is program is not very good at rendering web pages and would be a nightmare to develop for. Each version of Windows Mobile has differences in IEM that designers would have to be conscious of. The other browsers that Windows Mobile users have the option of using: Opera Mobile, Netfront, Minimo – do not have enough market penetration to make it development worthwhile. [on a sidenote, Opera Mobile is the best browser for Windows Mobile, give it a try if you haven't already.]

Hence, we have the major difference between Windows Mobile and iPhone OS. Windows Mobile, although an “open” system that allows developers to create their own programs, has the problem of having a high cost to develop because you need to have Windows Mobile programming experience.

On the other hand, the iPhone, with it’s “Closed” OS, has a standardized browser that works well and is easy to write web code for. Web publishers around the world are free to write code for it in their native programming languages because the browser is the component that renders the graphics and takes care of the network.

So how is this problem resolved? Nintendo seems to have fixed this very same issue by offering Opera for Wii via the Wii Shop channel. Wii users who install this browser have many options available out there for web interfaces that are designed specifically for the Opera browser on Wii – most notable of these is Orb, which has a beautiful interface for the Wii. Microsoft, ever the profitable company it is, wants users to use IE on Windows Mobile and therefore bundles IEM.

Microsoft needs to get with the program and make their browser easier to write for and more standards compliant. If that doesn’t happen, then we are definitely looking at an iPhone future for mobile devices.

If you use Windows Mobile, please contact Meebo and let them know that you’d like to see a Windows Mobile version of Meebo!

…and other MySQL Oddities.

If your MySQL binary log files are a “Growing” problem… there are a few simple steps you can use to curtail their growth and save your disk space from these huge files.

They probably look like:

mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.000004
mysql-bin.000005

And around 1 gig in size each.

These files are generated when you have log-bin=mysql-bin or other log-bin= line in your /etc/my.cnf configuration file.

There are two ways to fix this problem:

The first is to stop the MySQL server from creating these binary files. The only reason you would need the binary log files is if you are doing mysql replication from a master to a slave. In this case, these files are necessary, at least until the slave(s) has caught up with the master. To stop this from logging, comment out (using #) the line containing ‘log-bin’.

The second is to continue logging – this is necessary as stated above if you are performing SQL replication.

You can add a line to your /etc/my.cnf file which will only keep these files around as long as necessary. The line is:

expire_logs_days = X

Where X is the number of days you’d like to keep them around. I would recommend 10, but this depends on how busy your MySQL server is and how fast these log files grow. Just make sure it is longer than the slowest slave takes to replicate the data from your master.

Just a side note: You know that you should do this anyway, but make sure you back up your mysql database. The binary log can be used to recover the database in certain situations; so having a backup ensures that if your database server does crash, you will be able to recover the data.

  • Welcome to systemBash, a technology and system administration blog by David Drager. If you enjoy this sort of content, can can subscribe to the RSS clicking on that big icon to the right.