Windows and Cisco ASA5505 Problems…

First, create the tables in your new Postgres database. I used a program called Navicat. You should create the tables by hand because the field types are different in MySQL and Postgres.

Use the following command to get mysqldump to create a dump file of the database that you can upload. You can also use Navicat to run the script.

mysqldump databasename tablename -v --compatible=ansi,postgresql --complete-insert=TRUE --extended-insert=FALSE --compact --default-character-set=UTF8 -u username -p -r “c:\shares\postgres.sql”

As a regular user, or as root if you leave off the sudo bits:

sudo yum -y install postgresql postgresql-server php-pgsql
sudo /sbin/chkconfig postgresql on
sudo /sbin/service postgresql start

This is setting up the postgres user. Enter a password you’ll remember when prompted.

sudo passwd postgres

After this command, enter that password again. Now you’ll be logged in as the new postgres user.

su – postgres
psql
create user gpsdata;
create database gpsdata owner gpsdata;
control+d

The following makes it possible to access the database from another computer.

vi /var/lib/pgsql/data/postgresql.conf
add the line:
listen_addresses=’*’

vi /var/lib/pgsql/data/pg_hba.conf
add the line:
host all all 192.168.3.0/24 trust

control+d
sudo /etc/init.d/postgresql restart

Now you’ve just got to open port 5432 on your firewall.

sudo vi /etc/sysconfig/iptables
add the line:
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 5432 -j ACCEPT

sudo /etc/init.d/iptables restart

Normally, I just:

sudo yum check-update
sudo yum update
sudo reboot

Note: A reboot might not be necessary depending on what you are updating.

If yum is having problems resolving some dependencies, or you get the error: “[Errno -1] Metadata file does not match checksum”, try running the command below, then re-running the commands above.

sudo yum clean all

If a “yum clean all” doesn’t fix it, it might be that your satellite server just needs to re-sync with RedHat’s servers. Wait a day and try it again.

If the your system is having trouble communicating with the Red Hat server, you probably need to:

sudo /usr/sbin/rhnreg_ks --force --activationkey=XXXXXXXXXXXXXXXXXXXX

For University of Washington, XXX can be found here.

1. Select the data on the sheet. Note that I had to click the first, hold shift then click the last. Selecting the entire column didn’t work.
2. Right click, then click Copy.
3. Right click, click Paste Special, make sure Transpose is checked.

First, you have to download and install Windows Media Encoder. Then go into your Windows Firewall and check the box next to Media Encoder to allow people to connect to your computer as a media server.

Broadcasting Video using Windows Media Encoder

1. Open Windows Media Encoder on your PC: Click Start / All Programs / Media / Windows Media Encoder / Windows Media Encoder.
2. Double-click ‘Broadcast a live event’.
3. Hopefully the defaults are fine. You might need to change the audio and video drop downs to be your webcam or capture card. Click Next.
4. Make sure the ‘Pull from the encoder’ radio button is selected. Click Next.
5. Make sure ‘HTTP port’ is ‘8080’ Click Next. (you can choose another port, just substitute it in the link below)
6. Select the Bit Rate. If many parties are going to connect, or any parties have a slow connection use a lower bit rate. Click Next.
7. Set archive settings if you want to save a copy, otherwise click Next.
8. Make sure the ‘No, I want to encode…’ radio is selected. Click Next.
9. Click Next, then Finish.

Receiving the Broadcast on a client PC

1. Open Windows Media Player
2. Right click the Title Bar
3. Click File / Open URL
4. Enter: http://mediaserveripaddress:8080/ For example: http://192.168.1.20:8080/.