SSH Tunneling to mysql server using Putty

mysql, ssh, Tricks, Tutorial
 I've had this question a couple of times in the past few months (since I posted the command line version of this method here ). To make it short and sweet, yes you can use Putty in a windows environment to setup ssh tunnels. Here is the specific scenario with pics for setting up a tunnel to your mysql server (assuming mysql server is running on a machine that you have ssh access to) using putty. This allows you to run mysql-gui-tools under windows and connect thru ssh to your server, without having to open the server to accept connections from the network.Download Putty full install package Run putty and your'll see the following screen. Fill in the hostname of the DB server and choose SSH as protocol.Go down to SSH and Tunnels options.…
Read More

Vista Network Blues…Repeated network disconnect

Microsoft, NERD, rant, Tricks, Tutorial, Windows
A lot of people seem to be running into weird network problems with Vista (MS's latest abortion). The symptoms might include:- Windows messenger issues (disconnects, slowness)- Large network file copies get interrupted or are slowwwww- Network file transfers that seem to hang for no reason- Network ghosts turning on/off the network subsystem- Routers having issues that lead to router reboot- Outlook having synchronization issuesA possible solution is turning off auto-tuning. You see Vista being Vista, wants to always be in control, even when it gets on the network with others. MS has built a new feature into it's network stack that allows Vista to auto-tune the size of the send/receive windows.....why would you want to do this by default when half the worlds firewalls discard non-standard packet sizes is a…
Read More

Stripes be gone…..

Apple, Leopard, Macintosh, OSX, Tricks, Tutorial
If you like to get rid of the stripes in the list view of the new Leopard Finder, open a Terminal Window and type in the following two commands:defaults write com.apple.finder FXListViewStripes -bool FALSEkillall FinderIf you want the fancy stripes back at some point later, type the following two commands in Terminal:defaults write com.apple.finder FXListViewStripes -bool TRUEkillall Findermore to come soon.....
Read More

Turn-off Leopards 3D Dock

Apple, Leopard, Macintosh, OSX, Tricks, Tutorial
Just noticed that if you place your dock on either side of the screen you get a flat dock, instead of that floating 3d look. As much as I like the 3D look, I liked the flat look even more, so after poking around I found out how to disable the 3D look. Open a Terminal window and type in the following two commands:defaults write com.apple.dock no-glass -boolean YESkillall DockTo get the 3D floating dock back you open a Terminal and type the "opposite" two commands:defaults write com.apple.dock no-glass -boolean NOkillall DockKeep coming back.....there will be more soon :-)
Read More

OSX Webmaster special: Shared webserver, bad umask settings, group permissions and filenames with spaces…

Apple, CLI, Linux, Macintosh, OSX, Reference, Shell Script, Tricks, Tutorial, Ubuntu, Unix
Okay so this all started with our users not being able to share files on our webserver. We use SSH only for upload/download and interactive access (ie: no ftp). Through trial and error we found out that the default umask (under OSX Server) for sftp uploaded files are 0033 (ie: rwxr--r--) and directories are 0022 (ie: rwxr-xr-x). This creates a problem when one user uploads a file and another user downloads/modifies and tries to re-upload it -- they simply can't because the group permissions are wrong.If we were using ftp (which we are not) there are some solutions on the net that allow you to modify the startup parameters for the ftp server so that the default umask for all files is 0013 -- which would allow a group of…
Read More

screen…it’s not just for nerds anymore.

CLI, Opensource, Tutorial, Unix
So after hearing from people at work how great the "screen" command was (yeah welcome to gnuland boys and girls), I decided to do a short tutorial on screen. This way I can stop telling them to RTFM and instead tell them to RTFB (Blog). Anyways, What is "screen" first of all....From the pages of wikipedia:GNU Screen is a free terminal multiplexer developed by the GNU Project. It allows a user to access multiple separate terminal sessions inside a single terminal window or remote terminal session. It is useful for dealing with multiple programs from the command line, and for separating programs from the shell that started the program. GNU Screen can be thought of as a text version of graphical window managers, or as a way of putting virtual…
Read More

Do you Mango?

Flash, Travel, Tutorial
From the pages of really useful, well designed websites comes Mango. The webapp (flash 9.0) is simple to use, well layed out and generally works well. It offers 11 Free language courses (Brazilian Portuguese, Polish, Spanish, French, German, Greek, Italian, Japanese, Mandarin Chinese, Pig Latin and Russian). So head over, sign up and learn something new. It's FREE!!!
Read More