Re: [Sqlgrey-users] multiple databases ?

[Lionel B. <lio...@bo...>]

Who Knows wrote the following on 27.09.2005 17:33 :

> Lionel Bouton wrote:
>
>>
>> Just to clarify:
>>
>> If you have one SQLgrey sitting on each server running a MX server 
>> and all of them configured to use the same database you don't have 
>> any single point of failure.
>> If one MX fails, the other(s) handle the trafic. If the database 
>> server fails, all SQLgrey processes switch to passthrough 
>> automatically (and warn the email address configured in sqlgrey.conf) 
>> -> your MX are unaffected but the greylisting stops.
>> If you have one single SQLgrey process and the server it is sitting 
>> on fails, all "incoming" mail trafic stops (Postfix answers requests 
>> with "service temporary unavailable" errors).
>>
>> Lionel.
>
>
> Okay, I was aware that was what was supposed to happen. Is the switch 
> to passthru in the abscense of a database ( or database error ) a 
> config setting because according to my logs my MTAs returned config 
> error when the database was inacessable.


No it is automatic. It is designed to recover from both an unreachable 
database and simple query errors (no answer or clearly invalid answers).
Do you rely on the database for anything else than SQLgrey? Was SQLgrey 
running on the same systems the MTAs were on (ie policy_service declared 
as localhost:<something> on each MTA)?

Lionel.