Database name is mail_archive_environment
Different environments are stored in different directories, with
the directory name being the name of the environment. Two envs are
defined right now - development
and
production.
Here's a link to the database schema:
Also - this project uses the database objects from phplib
Mail is sent to account: open-source-archive@host for production mail archiver,
A sendmail alias for this account invokes a Perl script to do
the archiving. The alias is in the file /etc/aliases
and looks like:
newaliases
command and restarting sendmail.
The save_message*.pl
scripts must be in or be
symlinked to the /etc/smrsh
directory
The perl script uses it's first argument as the name of the database to save the message in, appended with the environment. It obtains the environment by getting the absolute path that it is in, and taking the last element of that.
The Perl script will take the MD5 checksum of the email headers
to create a 128 bit message id, stored as a hex string in the
md5_id
fields of the db schema.
SQL used in the application display depends on the existence of a Subject: and a From: header for each message. Therefore, the Perl script will insert a blank Subject: header if the message has none.
Additionally, views are created on the message_text table to specifically parse out message from and subject headers.
The remainder of the message will be stored in the
message_text
table.
A three part frame is displayed, with left, top, and bottom parts.
The left frame contains the message search criteria and allows setting of user preferences. User preferences include:
User header display preferences are stored in a browser cookie
via means of a javascript snippit. The cookie is in path "/",
and has a name of header_pref
, set to equal the
display radio button selection.
The top frame contains the list of messages selected by the search criteria. Selecting a message from this list will cause the message to be displayed in the bottom frame.
The bottom frame displays message selected from the top frame. A preference setting is consulted to determine the amount of headers to display
Page maintained by Pat Spinler
Last changed on Aug 16, 2000