Revision as of 07:37, 6 May 2011

Notes

Note: All of the commands on this page must be run as root.

Operating System

• Basic Debian 6.0 "squeeze" install - You will not need the desktop applications group.

Set the System Locale

The locale needs to be set correctly for the database. It is easiest to set it at the beginning of the installation.

• Set the locale correctly -
  • For the US, generate both en_US and en_US.UTF-8, but (IMPORTANT) pick en_US as the default...

  dpkg-reconfigure locales

Prerequisites

Aptitude & Required Libraries

Add the freeside repository

• Add the following apt source to /etc/apt/sources.list (for Debian 6.0 "squeeze"):

deb http://freeside.biz/~ivan/freeside-squeeze/ ./

• Run aptitude update.

Install the Appropriate Packages

• Run this command to install all prerequisites:

aptitude install adduser apache2 apache2-mpm-prefork apache2-utils gcc gnupg ghostscript gsfonts gzip latex-xcolor \
  less libapache-dbi-perl libapache2-mod-perl2 libapache2-request-perl libapache-session-perl \
  libbusiness-creditcard-perl libcache-cache-perl libcache-simple-timedexpiry-perl libchart-perl \
  libclass-container-perl libclass-data-inheritable-perl libclass-returnvalue-perl libcolor-scheme-perl \
  libcompress-zlib-perl libconvert-binhex-perl libcrypt-passwdmd5-perl libcrypt-ssleay-perl libcss-squish-perl \
  libdate-manip-perl libdbd-mysql-perl libdbd-pg-perl libdbi-perl libdbix-dbschema-perl libdbix-searchbuilder-perl \
  libdevel-stacktrace-perl libdevel-symdump-perl libdigest-sha1-perl liberror-perl libexception-class-perl \
  libfile-counterfile-perl libfile-rsync-perl libfont-afm-perl libfreezethaw-perl libfrontier-rpc-perl \
  libgd-gd2-noxpm-perl libgd-graph-perl libgd2-noxpm libhtml-format-perl libhtml-mason-perl libhtml-parser-perl \
  libhtml-scrubber-perl libhtml-tagset-perl libhtml-tree-perl libhtml-widgets-selectlayers-perl libio-stringy-perl \
  libipc-run-perl libipc-run3-perl libipc-sharelite-perl libjavascript-rpc-perl libjson-perl \
  liblingua-en-inflect-perl liblingua-en-nameparse-perl liblocale-gettext-perl liblocale-maketext-fuzzy-perl \
  liblocale-maketext-lexicon-perl liblocale-subcountry-perl liblog-dispatch-perl libmailtools-perl libmime-perl \
  libmodule-versions-report-perl libnet-daemon-perl libnet-ping-external-perl libnet-scp-perl libnet-ssh-perl \
  libnet-whois-raw-perl libnetaddr-ip-perl libnumber-format-perl libpam-modules libpam-runtime libpaper-utils \
  libparams-validate-perl libparse-recdescent-perl libpcre3 libpg-perl libplrpc-perl libregexp-common-perl \
  libspreadsheet-writeexcel-perl libstring-approx-perl libstring-shellquote-perl libterm-readkey-perl \
  libtest-inline-perl libtext-autoformat-perl libtext-charwidth-perl libtext-csv-perl libtext-iconv-perl \
  libtext-quoted-perl libtext-reform-perl libtext-template-perl libtext-wrapi18n-perl libtext-wrapper-perl \
  libtie-ixhash-perl libtime-duration-perl libtime-modules-perl libtimedate-perl libtree-simple-perl \
  libuniversal-require-perl liburi-perl libwant-perl libwww-perl libxml-parser-perl libyaml-perl lmodern make \
  perl perl-base perl-modules postgresql postgresql-client rsync slidentd openssh-client openssh-server texlive \
  texlive-latex-extra texinfo traceroute ttf-bitstream-vera ttf-dustin ucf zlib1g \
  libdatetime-perl libdatetime-format-strptime-perl libfile-slurp-perl libspreadsheet-parseexcel-perl \
  libauthen-passphrase-perl libnet-domain-tld-perl libbusiness-us-usps-webtools-perl libxml-simple-perl \
  libemail-sender-perl libemail-sender-transport-smtp-tls-perl libemail-sender-perl \
  libemail-sender-transport-smtp-tls-perl libhtml-defang-perl libdatetime-format-natural-perl libcgi-pm-perl \
  libfile-sharedir-perl libmodule-versions-report-perl libtext-wikiformat-perl libnet-server-perl \
  libhttp-server-simple-perl libhtml-rewriteattributes-perl libmime-types-perl libperlio-eol-perl \
  libgnupg-interface-perl libdata-ical-perl libdate-ical-perl libcalendar-simple-perl libdatetime-set-perl \
  libhook-lexwrap-perl libhttp-server-simple-mason-perl libxml-rss-perl libipc-run-safehandles-perl libpoe-perl \
  libsoap-lite-perl libhtml-tableextract-perl libhtml-element-extended-perl libcam-pdf-perl \
 libgd-barcode-perl libnet-openssh-perl sam2p psmisc 

Verify the correct locale is set

• Check your /etc/postgresql/8.4/main/postgresql.conf for the lc_ lines. If they are set to "= 'en_US.UTF-8'"...
• The postgresql cluster will need to be dropped and re-initialized

pg_dropcluster 8.4 main --stop
pg_createcluster --locale en_US 8.4 main

• Don't forget to restart postgresql

/etc/init.d/postgresql-8.4 restart

Installation

Follow the regular installation instructions.