Re: [Exim] Mysql issues

Top Page

Reply to this message
Author: Guillaume Finance
Date:  
To: Exim Group
Subject: Re: [Exim] Mysql issues
Hello,

Regarding the performance, if my email server is a Pentium II 400 MHz, 128
Mb RAM - Slackware 7 Linux, is it gonna be fine running Mysql for email
account information storage ?
Currently I have 30 email accounts approx - what could be the limit of email
accounts with my configuration ? (taking into account an average for the
traffix generated by an email account)

cheers
Guillaume

----- Message d'origine -----
De : "robert rotman" <rotman@???>
À : "Guillaume Finance" <g.finance@???>
Cc : "Exim Group" <exim-users@???>
Envoyé : jeudi 23 novembre 2000 00:46
Objet : Re: [Exim] Mysql issues


>
> On Wed, 22 Nov 2000, Guillaume Finance wrote:
>
> > Hello,
> >
> > I currently use Exim 3.03 with files (lsearch) to store the

localdomains, system aliases, virtual aliases,etc...
> > I'm configuring Exim 3.16 to use Mysql database to ease the management

of the email accounts (i.e. manage it on a web interface using PHP4).
> >
> > My first question : Does Mysql decrease the performance of Exim through

the database queries, etc... ?
> >
>
> shortly yes, but it depnds on your setup.
> what's your system like?
> how many mails do you serve?
>
> > My second question is about my configure file. I've taken the working

configure file which is using lsearch. I've tried to modify it to make it
work with Mysql.
> > My Mysql database is called Exim, the user that has access to this

database is admin, and the password is test.
> > The table localdomains has a unique field, name, which is a local

domain.
> >
> > For the local_domains statement, I've used the following:
> >
> > mysql_servers = localhost/exim/admin/test
> > local_domains = localhost:mysql;select namefrom localdomains
>
> you should rathjer use somthing like:
> mysql;select name from localdomains where name='${quote_mysql::$key}'
>
> RTFM about this!
>
> >
> > Although I don't get any error message when I run exim, it return a Mail

delivery message when I test it.
> > What's wrong?
>
> what says "exim -d2 msg-id" if you have messages in the queue?
> what's about the panic_log?
>
>
> robert
>
>