Ssh tunnel to remote MySQL

Posted by Michael Thu, 10 Jan 2008 15:52:00 GMT

You’ve got port 3306 (MySQL) firewalled off and you want to use a MySQL GUI every once in a while (or maybe a bunch).

This is a snap with ssh.

On your local Linux/BSD/Mac/Unix machine (works in cygwin too) edit your .ssh/config file and add:

Host somemysqlserver
 Hostname server.mydomain.com #your mySQL server FQDN or IP
 User bob #replace with your valid ssh server username
 LocalForward *:13306 localhost:3306
Now do: 
ssh -f -N somemysqlserver

You can now connect to your localhost port 13306 and it will forward to your MySQL server’s port 3306.

Plus, it’s free and probably already installed on your systems.

Need help? support@imapenguin.com

Posted in , , , , ,  | no comments | no trackbacks

Capistrano 2.0 and Mongrel Recipies

Posted by Michael Tue, 27 Nov 2007 20:15:00 GMT

Capistrano 2.0 doesn’t work with those mongrel recipes we all have nowadays. We scratched our head at some hacks before finding a good solution via the blog world.

Thanks to Megablaix, Inc for posting this code. Works great for us, just tack it onto the end of your deploy.rb and go:

namespace :deploy do
  namespace :mongrel do
    [ :stop, :start, :restart ].each do |t|
      desc "#{t.to_s.capitalize} the mongrel appserver" 
      task t, :roles => :app do
        #invoke_command checks the use_sudo 
        #variable to determine how to run 
        # the mongrel_rails command
        invoke_command "mongrel_rails cluster::#{t.to_s} -C #{mongrel_conf}", :via => run_method
      end
    end
  end

  desc "Custom restart task for mongrel cluster" 
  task :restart, :roles => :app, :except => 
       { :no_release => true } do
    deploy.mongrel.restart
  end

  desc "Custom start task for mongrel cluster" 
  task :start, :roles => :app do
    deploy.mongrel.start
  end

  desc "Custom stop task for mongrel cluster" 
  task :stop, :roles => :app do
    deploy.mongrel.stop
  end
end

Posted in , , ,  | no comments | no trackbacks

VMWare Server 2.0 BETA

Posted by Michael Thu, 15 Nov 2007 17:05:00 GMT

We’ve been testing the 2.0 Beta release of the free VMWare server. We’ve been using the 1.x series in both development and production since it was called GSX server and are very impressed with the 2.0 version.

Our favorite feature is the web based administration console. With a firefox plugin, you can now do what the desktop version could do and more.

Here’s a screenshot:

vmware webshot

We’re available at support@imapenguin.com if you’re interested in how this version will affect your current VMWare servers or are interested in how virtualization can work for you.

Posted in , ,  | no comments | no trackbacks