Development Software Suite As At 26 June 2004

• Ronald Bradford
• June 26, 2004

Java J2SDK 1.4.2_4 http://java.sun.com/j2se/1.4.2/download.html Tomcat 5.0.25 http://jakarta.apache.org/site/binindex.cgi JSTL 1.1 http://jakarta.apache.org/taglibs/doc/standard-doc/intro.html MySQL 5.0.20 http://dev.mysql.com/downloads/mysql/4.0.html Apache HTTP 2.0.49 http://httpd.apache.org/download.cgi PHP 4.3.7 http://www.php.net/downloads.php PHPMyAdmin 2.5.7 http://www.phpmyadmin.net/ Eclipse 3.0 http://eclipse.org/downloads/index.php Eclipse 3.0 was released today.

MySQL Disable Foreign Keys on Loading Data

• Ronald Bradford
• June 25, 2004

SET FOREIGN_KEY_CHECKS=0;

Adding a second IP address to Linux Server

• Ronald Bradford
• June 24, 2004

If say you want to run apache and tomcat both on port 80 (default), you can create a seperate IP address on an internal network. For RedHat Distros $ cd /etc/sysconfig/network-scripts/

CentOS 3.x YUM Errors

• Ronald Bradford
• June 20, 2004

When getting an error stating the PGP key is not correct rpm –import http://mirror.centos.org/centos-3/RPM-GPG-KEY-CentOS-3 The PGP Key is also reportedly on each CD. More info at http://www.centos.org/modules/smartfaq/faq.php?faqid=29

Changing A Server’s Timezone

• Ronald Bradford
• June 19, 2004

For RedHat 9 $ redhat-config-date (except this requires X) or $ clock $ rm /etc/localtime $ ln -s /usr/share/zoneinfo/Australia/Brisbane /etc/localtime $ /usr/bin/rdate -s time.nist.gov $ /sbin/hwclock –systohc The last two commands can be added to cron for regular syncing with running ntp

• Ronald Bradford
• January 1, 1

RDS Database Instances The instance type used has 8 vCPUs and are selected to support a larger number of database threads in a production workload. Instance Type Resource Specs Price Per Hour (us-east) db.