Author: Aaron Stone
Date: March 2, 2006
Updated: November 6, 2006

Upgrading from DBMail 2.0 to DBMail 2.2

Dependencies

  • Database: MySQL 4.1+ with innodb support, PostgreSQL 7.4+, or SQLite3
  • Glib: (>= 2.8.0)
  • GMime: (>= 2.1.19 or >= 2.2.0)
  • Optional: libSieve (>= 2.2.1)
  • Optional: LDAP such as OpenLDAP.

Config Changes

  • [DBMAIL] section must have driver=mysql/pgsql and authdriver=sql/ldap.
  • SENDMAIL must be now set in [DBMAIL] section, not in [SMTP]
  • [SMTP] section is now [DELIVERY]
  • [DBMAIL] section must have library_directory = /usr/local/lib/dbmail
  • [POP] section must have MINSPARECHILDREN and MAXSPARECHILDREN
  • [IMAP] section must have MAXCHILDREN, MINSPARECHILDREN and MAXSPARECHILDREN

Additionally, you can optionally add query_time_info, query_time_message, and query_time_warning to [DBMAIL]

Schema Changes

  • Use the migrate_from_2.0_to_2.2 script, then run dbmail-util -by

NOTE The migration script takes a LONG time to run. On a 36 GB PostgreSQL dbmail, the script took more than 5 hours to execute. You should be aware of this if upgrading a large mail store

OS Specific Notes for Compiling

1. FreeBSD

Addition Author: Mike O'Brien
Date: March 3, 2006
Updated: October 10, 2006

  • DBMail Builds easily on FBSD. Typically your minimum Dependencies are done like this:
cd /usr/ports/databases/mysql41-server && make install clean
cd /usr/ports/devel/glib20 && make install clean
cd /usr/ports/mail/gmime2 && make install clean // is actually gmime 2.2.3 these days
  • You now have /usr/local installations of mysql, gmime & glib but GLIBc “iconv.h” is expected by

your dbmail in /usr/include as in most Linux variants & build fails with many warnings and errors.

  • Solution is simple: just link from /usr to /usr/local as follows:
  ln -s /usr/local/include/iconv.h /usr/include/iconv.h 

2. Debian

Updated: Apr 5, 2008

edit your sources.list as described below and run:

# apt-get install dbmail dbmail-mysql dbmail-sieve 
etch

Add to your sources.list:

#DBMail /etc/apt/sources.list
deb http://debian.nfgd.net/debian/ stable main
lenny

dbmail-2.2.10 is now part of debian/testing (lenny)

3. Other OS Notes

 
upgrading_to_2.1.txt · Last modified: 2012/02/27 21:27 by bas
 
DBMail is developed by Paul J Stevens together with developers world-wide