Re: [exim] Mail Implementation Design

Top Pagina
Delete this message
Reply to this message
Auteur: Dominic Cleal
Datum:  
Aan: exim-users
CC: maillist
Onderwerp: Re: [exim] Mail Implementation Design
On Mon, 21 Aug 2006 08:16:19 +0200
"GamCo - Mail List" <maillist@???> wrote:

> Hi Dominic
>
> Thanks for the reply. Would you be able to point me to a guide on
> creating the flat files from the DB ?


A really simple script could just log into the database and create
files in the format you prefer. For example, using the Vexim database
layout, you could generate a file suitable for use with lsearch by
something similar to this:

mysql -s --skip-column-names -e 'select concat(localpart,"@",domains.domain,": ",smtp) from users,domains where users.domain_id=domains.domain_id' vexim > /etc/exim/user_table

Which will obviously depend on your particular database structure.

As others have said though, it does sound like you have other issues
without resorting to dumping to plain text files. How many queries per
second is the server processing? Are queries optimised and are indexes
placed in the correct places (EXPLAIN SELECT)?

--
Dominic Cleal
dominic@???