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.
I just upgraded my IBM T41 to Ubuntu 7.10 by doing:
update-manager -c
from the command line. This forces a dist-upgrade check and runs through a pretty slick upgrader. 20 mins and 1 reboot later and she’s back and running without any issues at all.
Zultys auto attendants need an 8bit Mono U-law format wav file. Most recording software will give you a stereo 16bit format at the very least. To convert via sox (available for Unix machines including Macs) simply do:
We’ve been doing a bunch of server setups for folks in VPS’s. I figure we’d save you the cost of hiring us by posting a quick rundown on an Ubuntu Edgy Rails setup:
sudo bash
apt-get update && apt-get upgrade
apt-get remove apache2
apt-get install libssl-dev
apt-get install zlib1g-dev
dpkg --purge apache apache2
apt-get install build-essential
apt-get install libreadline5-dev
cd /usr/local/src/
wget http://apache.mirror99.com/httpd/httpd-2.2.4.tar.gz
tar -xzvf httpd-2.2.4.tar.gz
cd httpd-2.2.4
./configure --enable-proxy --enable-proxy-balancer\
--enable-proxy-http --enable-rewrite --enable-cache\
--enable-headers --enable-ssl --enable-so
make && make install
/usr/local/apache2/bin/apachectl start
apt-get install mysql-server
/etc/init.d/mysql start
cd /usr/local/src/
wget ftp://ftp.ruby-lang.org/pub/ruby/ruby-1.8.6.tar.gz
wget http://rubyforge.org/frs/download.php/17189/rubygems-0.9.2.zip
apt-get install unzip
unzip rubygems-0.9.2.zip
tar -xzvf ruby-1.8.6.tar.gz
cd ruby-1.8.6
./configure && make && make install
cd ../rubygems-0.9.2
ruby setup.rb
gem update
gem install rails --include-dependencies
apt-get install libmysqlclient15-dev
gem install mysql --include-dependencies
gem install mongrel --include-dependencies
gem install mongrel_cluster --include-dependencies
Then you need some optional housecleaning and deploy your app. We’ll assume you know this part. If not, you can flame me via email and I’ll help you.
set a mysql password and add appropiate users and permissions
The following COULD overwrite your current bootloader, so you MIGHT WANT TO READ THE LFS BOOK FIRST!
grub
root(hd0,0)
setup (hd0)
quit
Then create your grub.conf:
cat > /boot/grub/menu.lst << "EOF"
# Begin /boot/grub/menu.lst
# By default boot the first menu entry.
default 0
# Allow 30 seconds before booting the default.
timeout 30
# Use prettier colors.
color green/black light-green/black
# The first entry is for LFS.
title LFS 6.2
root (hd0,0)
kernel /boot/lfskernel-2.6.16.27 root=/dev/hda1
EOF
Now, since we created a separate disk for this, simply make the IDE disk the first in the boot order and boot it up. If you did exactly what I did, with the same hardware setup, this should work for you as easily as it did me.
Have fun! Oh and did I mention to READ THELFS BOOK before you email me questions at mike@imapenguin.com?