• configure the leaderboard - include church jpg as background
• choose menu solution and place appropriately
• same with calendar - event may be the wrong module in 6.x
• drop in the login somewhere - perhaps at the bottom
• "links"
• latest image and galleries

General notes on upgrading from Drupal5 to Drupal6

The database suffered from

• installation and removal of CiviCRM and Gallery 2
• inconsistent character sets and collation sequences

CiviCRM uses "Foreign Keys" and the default MySQL settings protect against deletion  of tables which provide FKEYs which are referenced in other tables. The workaround is

set foreign_key_checks=0;

We need a list of CiviCRM tables which can be obtained with

mysqldump -ptup@c --add-drop-table --no-data mtvale | grep ^DROP | grep civicrm

g2 tables do not use foreign keys and can be dropped straight away

For reasons of simplicity and sanity we should use the same "unicode" character set and collation sequence everywhere. They are "utf8" and "utf8-general-ci" (case insensitive). To convert a table:

Facing a number of upgrades, we have to start somewhere. I choose MtValeUMC.org because it is relatively simple.

A walled garden has application for The Old Time Fiddler's Convention.

Considerable features:

• Advertisement of service
• Community bulletin
• User accounting
  • Previous session statistics
  • Current session statistics
  • MAC records
• Session management
  • Rent-a-day
  • Bandpass cut-out

Perhaps strangely, I think we are ideally suited for Community Organizing. There is an interesting section at http://en.wikipedia.org/wiki/Community_organizing. We might start by describing how and why we might be good at that.

We need a simple letter describing our qualifications and declaring our interest in an organization's needs.

Proposal writing and submission may be a way to get into organizations that don't recruit directly.

http://foundationcenter.org/getstarted/faqs/html/propsample.html has lots of suggestions.

 

software installation script

tasksel install dns-server
tasksel install lamp-server
tasksel install mail-server
tasksel install openssh-server
apt-get install bash-completion
apt-get install ca-certificates
apt-get install curl
apt-get install cvs
apt-get install cvsd
apt-get install finger
apt-get install imagemagick
apt-get install lftp
apt-get install mailman
apt-get install ntp
apt-get install patch
apt-get install php5-cgi
apt-get install php5-cli
apt-get install php5-curl
apt-get install php5-gd
apt-get install php5-imagick
apt-get install php5-imap
apt-get install php5-mcrypt
apt-get install php5-mysqli
apt-get install phpmyadmin
apt-get install php-pear
apt-get install procmail
apt-get install tree
apt-get install unzip
apt-get install vim
apt-get install vsftpd
apt-get install whois

Prepare a script to install additional packages to the base command line install. We might start with four applications of tasksel.

apache2-mpm-worker
apparmor
apparmor-utils
auth-client-config
bash-completion
binutils-static
cpp
cpp-4.2
cupsddk
cupsddk-drivers
cupsys
cupsys-common
dhcp3-server
ebox
ebox-ca
ebox-dhcp
ebox-dns
ebox-firewall
ebox-network
ebox-ntp
ebox-objects
ebox-printers
ebox-samba
ebox-services
ebox-usersandgroups
fontconfig
foomatic-db
foomatic-db-engine
foomatic-db-hpijs
foomatic-filters
fping
friendly-recovery
fuse-utils
gcc-4.2-base
gconf2
gconf2-common
gettext
ghostscript
graphviz
gsfonts
hpijs
hplip
hplip-data
jnettop
ldap-auth-client
ldap-auth-config
libapache-authcookie-perl
libapache-singleton-perl
libapache2-mod-perl2
libart-2.0-2
libatm1
libauthen-sasl-perl
libavahi-client3
libavahi-common-data
libavahi-common3
libavahi-compat-libdnssd1
libbind9-30
libbit-vector-perl
libc6-i686
libcache-cache-perl
libcairo2
libcarp-clan-perl
libchart-perl
libck-connector0
libclass-container-perl
libclass-data-inheritable-perl
  

ant
antlr
apache2-common
bind9-doc
binutils
courier-authdaemon
courier-authlib
courier-authlib-userdb
courier-base
courier-doc
courier-imap
courier-imap-ssl
courier-pop
courier-pop-ssl
courier-ssl
cpp-4.1
debhelper
dpkg-dev
ecj-bootstrap
ecj-bootstrap-gcj
fastjar
finger
fontconfig
gappletviewer-4.1
gcc-4.1
gcj-4.1
gcj-4.1-base
gdb
gettext
gij-4.1
gjdoc
grepmap
html2text
intltool-debian
java-common
java-gcj-compat
java-gcj-compat-dev
libapr0
libatk1.0-0
libbcel-java
libc6-dev
libcairo2
libcommons-beanutils-java
libcommons-collections-java
libcommons-collections3-java
libcommons-dbcp-java
libcommons-digester-java
libcommons-el-java
libcommons-fileupload-java
libcommons-launcher-java
libcommons-logging-java
libcommons-modeler-java
libcommons-pool-java
libcommons-validator-java
libcupsys2
libdb3
libdb3-util
libdns21
libfam0
libgcj-bc
libgcj-common
libgcj7-0
libgcj7-awt
libgcj7-dev
libgcj7-jar
libgtk2.0-0
  

apache2-common
apachetop
console-common
console-data
dvd+rw-tools
evms
evms-ncurses
expect
fam
fontconfig
gcc-4.0-base
grepmap
hwdata
hwinfo
iptraf
jfsutils
libadns1
libapr0
libc6-i686
libdbus-1-2
libdns21
libevms-2.5
libfam0
libgnutls12
libhal1
libnewt0.51
libparted1.6-13
libsasl2
libssl0.9.7
libtasn1-2
linux-image-2.6.15-26-server
lshw-common
lvm-common
lvm2
make
mdadm
mkisofs
php5-mysqli
postgresql-8.1
postgresql-client-8.1
proftpd
python2.4
python2.4-minimal
reiser4progs
reportbug
sysvinit
tcl8.4
tclreadline
ttf-bitstream-vera
ttf-freefont
xfsprogs

alsa-base
alsa-utils
apache2
apache2-mpm-prefork
apache2-utils
apache2.2-common
bind9
bitchx
ca-certificates
curl
cvs
cvsd
defoma
dmsetup
dselect
esmtp
esmtp-run
fontconfig-config
gcc-4.1-base
ia32-libs
imagemagick
lftp
lib32gcc1
lib32stdc++6
lib32z1
libapache2-mod-php5
libapr1
libaprutil1
libasound2
libauthen-pam-perl
libbind9-0
libc-client2002edebian
libc6-i386
libcurl3
libdb4.2
libdb4.3
libdb4.4
libdbd-mysql-perl
libdbd-pg-perl
libdbi-perl
libdevmapper1.02
libdns22
libesmtp5
libfontconfig1
libfontenc1
libfreetype6
libgd2-xpm
libglib2.0-0
libice6
libio-pty-perl
libisc11
libisccc0
libisccfg1
libiw28
libjasper-1.701-1
libjpeg62
liblcms1
libldap2
liblwres9
liblzo1
libmagick9
libmd5-perl
libmysqlclient15off
libnet-daemon-perl
libnet-ssleay-perl
libopencdk8
libpam-foreground
libpci2
libpcre3
libplrpc-perl
libpng12-0
libpq4
libpq5
libsm6
libsqlite0
libt1-5
libtiff4
libx11-6
libx11-data
libxau6
  

acpi
acpid
adduser
apparmor
apparmor-utils
apt
apt-utils
aptitude
at
base-files
base-passwd
bash
bash-completion
belocs-locales-bin
bind9-host
binutils-static
bsdmainutils
bsdutils
busybox-initramfs
bzip2
command-not-found
command-not-found-data
console-setup
console-terminus
console-tools
coreutils
cpio
cpp
cpp-4.2
cron
dash
debconf
debconf-i18n
debianutils
dhcp3-client
dhcp3-common
diff
dmidecode
dnsutils
dosfstools
dpkg
e2fslibs
e2fsprogs
ed
eject
ethtool
fdutils
file
findutils
friendly-recovery
ftp
fuse-utils
gcc-4.2-base
gettext-base
gnupg
gpgv
grep
groff-base
grub
gzip
hdparm
hostname
ifupdown
info
initramfs-tools
initscripts
inputattach
installation-report
iproute
iptables
iputils-arping
iputils-ping
iputils-tracepath
klibc-utils
klogd
language-pack-en
language-pack-en-base
laptop-detect
less
libacl1
libatm1
libattr1
libbind9-30
libblkid1
libbz2-1.0
libc6
libcap1
libcomerr2
  

We are currently using Forums as an approximation of Scrum - one of the versions of "Agile" development. Drupal Forums were handy (i.e. already in place). Modest efforts have been made to flesh out some examples. After two weeks, the results are not encouraging.

As the most ardent advocate, my own level of compliance is meager. Team compliance even less.

Looking for the magic "pill", I found the NetBeans people were using "Teamwork" - http://www.twproject.com/home.page

Teamwork is written in Java and the web component runs under a web server with Java support. Their recommendation is "Tomcat". Early experience with Tomcat (Jasper Server) suggested that "Tomcat" was not a "good neighbor" for Apache/PHP. Although the source is available (GPL), the installer leads to a per user fee. Tomcat is a task/project in itself.

We have a network monitoring tool in place - "ntop". I'd like to know specifically how we can use "ntop" in a "bottom line" sense at LSNet. There is an overview here - http://www.ntop.org/overview.html

 

Completed - cracked and configured 3com routers

Tomorrow - sitesatlas, marketing at office

Three hardware zones

• DMZ - between Comcast cable modem and hecate, horace, badday, pbx, etc
• NOC - everything south of bench room
• WAR - Grayson St to Bench room

One 3com router for each

3Com 3c16980 switches

Reinitialized, ip and password assigned

 

• null modem cable - http://www.aggsoft.com/rs232-pinout-cable/nullmodem-db9-to-db9.htm
• minicom 19200, n, 8, 1
• Reset configuration
  
  • username: 3comcso
  • password: RIP000
  • reset:y
• bounce power
• login - admin/no password
• ip, interface, define
• http://192.168.1.23/
• login - admin/no password
• ip - (192.168.1.23) at 00:D0:96:D5:8E:98
• changed password to usual root password
• play
• 2nd box ip - (192.168.1.24) at 00:50:99:C2:E1:D8
• 3rd box ip -(192.168.1.25) at 08:00:4E:8F:40:78