OGo on Debian lenny

Hi,

I've been reviewing the installation of OGo on Debian lenny.

Previously, I was running OGo on etch, with Postgres 7.4 and Apache2

My OGo package versions were from the nightly builds, although they 
hadn't been kept up to date.

Anyhow, I've followed this process to migrate from my etch server to a 
lenny server (see below).  This is not an in-place upgrade, it is a 
migration to a freshly built lenny box.

Could people please provide feedback on this issue, particularly the 
following topics:

- will there be a build for lenny, without the dependencies on packages 
from etch?
- is it safe to run the etch version on lenny?
- is it safe to run this version with Postgres 8.3 from lenny?
- How should an etch user update the schema when a lenny version does 
arrive?  I'm guessing there might have been changes.

Regards,

Daniel


- Do a basic lenny install (Select `stanard system'), install apache2, etc

- Install some packages from etch (does anyone believe any of these 
would be unsafe on lenny?):

  mkdir /tmp/deb-etch
  cd /tmp/deb-etch
  wget 
http://ftp.uk.debian.org/debian/pool/main/g/gcc-4.1/libobjc1_4.1.1-21_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/g/gcc-4.1/gcc-4.1-base_4.1.1-21_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/o/openldap2/libldap2_2.1.30-13.3_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/g/gnutls13/libgnutls13_1.4.4-3+etch1_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/l/lzo/liblzo1_1.08-3_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/o/opencdk8/libopencdk8_0.5.9-2_i386.deb
  wget 
http://ftp.uk.debian.org/debian/pool/main/p/postgresql-8.1/libpq4_8.1.15-0etch1_i386.deb
  dpkg -i *

- Install various OGo packages (same versions that I had on etch)

libapache2-mod-ngobjweb_4.7.svn1583-1_i386.deb
libsope-appserver4.7_4.7.svn1598-1_i386.deb
libsope-core4.7_4.7.svn1598-1_i386.deb
libsope-gdl1-4.7_4.7.svn1598-1_i386.deb
libsope-ical4.7_4.7.svn1598-1_i386.deb
libsope-ldap4.7_4.7.svn1598-1_i386.deb
libsope-mime4.7_4.7.svn1598-1_i386.deb
libsope-xml4.7_4.7.svn1598-1_i386.deb
sope4.7-gdl1-postgresql_4.7.svn1557-1_i386.deb
sope4.7-libxmlsaxdriver_4.7.svn1557-1_i386.deb
sope4.7-versitsaxdriver_4.7.svn1557-1_i386.deb
libfoundation1.1_1.1.5.svn164-1_i386.deb
libfoundation1.1-data_1.1.5.svn163-1_all.deb
libfoundation1.1-tools_1.1.5.svn163-1_i386.deb
libobjc1_4.1.1-21_i386.deb
libopengroupware.org-db-project5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-db-project5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-docapi5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-docapi5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-fs-project5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-fs-project5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-logic5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-logic5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-pda5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-pda5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-webmail5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-webmail5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-webui-foundation5.3_1.1.svn2077-1_i386.deb
libopengroupware.org-webui-foundation5.3-dev_1.1.svn2077-1_i386.deb
libopengroupware.org-zidestore1.5_1.1.svn2077-1_i386.deb
libopengroupware.org-zidestore1.5-dev_1.1.svn2077-1_i386.deb
opengroupware.org1.1_1.1.svn2077-1_all.deb
opengroupware.org1.1-database_1.1.svn2077-1_i386.deb
opengroupware.org1.1-nhsd_1.1.svn2077-1_i386.deb
opengroupware.org_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-app_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-contact_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-core_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-i18n-de_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-dk_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-en_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-es_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-eu_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-fr_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-hu_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-it_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-jp_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-nl_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-no_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-pl_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-pt_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-ptbr_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-se_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-i18n-sv_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-job_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-mailer_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-news_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-project_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-scheduler_1.1.svn2077-1_i386.deb
opengroupware.org1.1-webui-theme-blue_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-theme-default_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-theme-kde_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-theme-ooo_1.1.svn2077-1_all.deb
opengroupware.org1.1-webui-theme-orange_1.1.svn2077-1_all.deb
opengroupware.org1.1-xmlrpcd_1.1.svn2077-1_i386.deb
opengroupware.org-database-scripts_1.1.svn2077-1_i386.deb
opengroupware.org-environment_1.1.svn2077-1_all.deb
opengroupware.org-misc-tools_1.1.svn2077-1_i386.deb
opengroupware.org-skyaptnotify_1.1.svn2077-1_i386.deb
opengroupware.org-webmail-tools_1.1.svn2077-1_i386.deb
opengroupware.org-zidestore1.5_1.1.svn2077-1_i386.deb

- Say `no' to the configuration question

- run ogo-create-instance

- Tell ogo-create-instance not to create a database

- Import the database (as extracted from the etch server with pg_dump)

 su -s /bin/sh postgres
 createuser -DRS ogo
 createdb -O ogo ogo
 pg_restore -d ogo -U postgres /tmp/ogo.pgc

- Restart ogo

/etc/init.d/opengroupware.org restart









-- 
OpenGroupware.org Discussion [email protected]
http://mail.opengroupware.org/mailman/listinfo/discuss