realtime email backup across computer centers

2003-05-13 Thread Stephan Poehlsen
Hi,

How would you realize a realtime email-backup across two different
computers in two different computer-centers?

Let's say I have a mail-server A in city A and a backup-mail-server B
in city B. So if an airplain crashs one computer-center, no email gets
lost.

I think all mail must be forwarded from server A to B (and must be
acknowledged from B) before server A acknowleges incomming mail.

Does there exists a solution? Maybe with qmail?

Stephan




Re: Which webmail do you prefer? Why?

2003-05-13 Thread Bertrand PERRINE
I confirm with apache 2.0.44/PHP 4.3.1
B.
Koba a écrit :
On Wed, 7 May 2003 11:48:24 -0400, Joey Hess <[EMAIL PROTECTED]> wrote:
I looked at SquirrelMail, but php4 is not supported with apache2.
Yes it does. I'm testing the Apache/2.0.45 PHP/4.3.1 combination and it 
works like a charm. You'll notice a huge speedup in php scripts if you 
are upgrading from apache 1.x.

squirrelmail.org does not recommend using apache2 with it, but I didn't 
have any problem so far.




Re: exponential mail queue growth postfix - Connection timed out

2003-05-13 Thread mimo
Hi,
I have done my research on this - it seems that the major part (99%) of 
timeouts happen with mail.layer-hosting.com[160.116.16.83].

mm
mimo wrote:
I am not sure if this is directly related to DEBIAN isp but anyway, 
since people on this list seem quite experienced I might as well ask you.

This is a postfix-1.1.11 running on RedHat 9.0 (not my fault:) - I 
usually have a mail queue of about 500 messages. Last week (and after a 
colleague upgraded and left for Australia) the queue started growing 
exponentially. Today it's about a 2000 messages sitting there (my q-size 
is calculated from 'active' and 'deferred').
I have tried pflogsumm-1.0.4.pl and noticed alot of 'Connection timed 
out' messages:
/var/log/maillog:14153
/var/log/maillog.1:31009
/var/log/maillog.2:31069
/var/log/maillog.3:30377
/var/log/maillog.4:20078
/var/log/maillog.5:18484
/var/log/maillog.6:13999
/var/log/maillog.7:15149
I have found something about concurrent connections which might correct 
this - any ideas?
That's all I know so far. Any help highly appreciated.

Michael Moritz
/etc/postfix/master.cf
# 
==
# service type  private unpriv  chroot  wakeup  maxproc command + args
#   (yes)   (yes)   (yes)   (never) (50)
# 
==
smtpinetn   -   y   -   -   smtpd
#smtpsinet  n   -   n   -   -   smtpd
#  -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
#submission inetn   -   n   -   -   smtpd
#  -o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
#628  inet  n   -   n   -   -   qmqpd
pickup  fifon   -   y   60  1   pickup
cleanup unixn   -   y   -   0   cleanup
#qmgr fifo  n   -   n   300 1   qmgr
qmgrfifon   -   y   300 1   nqmgr
#tlsmgr   fifo  -   -   n   300 1   tlsmgr
rewrite unix-   -   y   -   -   trivial-rewrite
bounce  unix-   -   y   -   0   bounce
defer   unix-   -   y   -   0   bounce
flush   unixn   -   y   1000?   0   flush
smtpunix-   -   y   -   -   smtp
showq   unixn   -   y   -   -   showq
error   unix-   -   y   -   -   error
local unix  -   n   n   -   -   local
virtual unix-   n   y   -   -   virtual
lmtpunix-   -   y   -   -   lmtp
#
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
# The Cyrus deliver program has changed incompatibly.
#
cyrus unix  -   n   n   -   -   pipe
  flags=R user=cyrus argv=/cyrus/bin/deliver -e -m ${extension} ${user}
uucp  unix  -   n   n   -   -   pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - 
$nexthop!rmail.postfix ($recipient)
ifmailunix  -   n   n   -   -   pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix  -   n   n   -   -   pipe
  flags=Fq. user=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop 
$recipient





*G* mysqld not listening on port 3306

2003-05-13 Thread Gregory Machin
i'm a beginner at mysql server - and i have the following problem i can
connect to my database which is residing on my mail server from my web
server. the my.cnf looks correct and has the port 3306 set , but can't
telnet in eather .

if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root
it gives me the following error:
Can't connect to MySQL server on x.x.x.x (111)
many thanks
greg




Re: *G* mysqld not listening on port 3306

2003-05-13 Thread Emmanuel Lacour
On Tue, May 13, 2003 at 01:36:20PM -, Gregory Machin wrote:
> i'm a beginner at mysql server - and i have the following problem i can
> connect to my database which is residing on my mail server from my web
> server. the my.cnf looks correct and has the port 3306 set , but can't
> telnet in eather .
> 
> if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root
> it gives me the following error:
> Can't connect to MySQL server on x.x.x.x (111)
> 

look at the skip-networking option in my.cnf and comment it.

You also have to make sure mysql tables allow root to connect from your
client host.

Using documentation at mysql.com could be a great idea ;-)

-- 
Emmanuel Lacour  Easter-eggs
44-46 rue de l'Ouest  -  75014 Paris   -   France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76
mailto:[EMAIL PROTECTED]   -http://www.easter-eggs.com




Re: *G* mysqld not listening on port 3306

2003-05-13 Thread Maarten Vink
Gregory Machin wrote:
i'm a beginner at mysql server - and i have the following problem i can
connect to my database which is residing on my mail server from my web
server. the my.cnf looks correct and has the port 3306 set , but can't
telnet in eather .
if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root
it gives me the following error:
Can't connect to MySQL server on x.x.x.x (111)
many thanks
greg

The default debian configuration for mysql has the "skip-networking" 
option set in my.cnf. That is probably causing your problems. Simply 
comment that line in my.cnf and restart mysql.

Maarten Vink



Re: *G* mysqld not listening on port 3306

2003-05-13 Thread Dominik Schulz

"Gregory Machin" <[EMAIL PROTECTED]> wrote on Tue, 13 May 2003 13:36:20 - 
(UTC):

> i'm a beginner at mysql server - and i have the following problem i can
> connect to my database which is residing on my mail server from my web
> server. the my.cnf looks correct and has the port 3306 set , but can't
> telnet in eather .
Did you remove/comment out 'skip-networking' in my.cnf?
That should be the problem.

Mit freundlichen Gruessen / Best regards
Dominik Schulz




Re: *G* mysqld not listening on port 3306

2003-05-13 Thread Jan Zumpe
On Tue, May 13, 2003 at 01:36:20PM -, Gregory Machin wrote:
> i'm a beginner at mysql server - and i have the following problem i can
> connect to my database which is residing on my mail server from my web
> server. the my.cnf looks correct and has the port 3306 set , but can't
> telnet in eather .

You've to comment out the 'skip-networking'-entry in /etc/mysql/my.cnf.


Bye,
Jan.




Re: *G* mysqld not listening on port 3306

2003-05-13 Thread Diederik de Vries




Op di 13-05-2003, om 15:36 schreef Gregory Machin:

i'm a beginner at mysql server - and i have the following problem i can
connect to my database which is residing on my mail server from my web
server. the my.cnf looks correct and has the port 3306 set , but can't
telnet in eather .

if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root
it gives me the following error:
Can't connect to MySQL server on x.x.x.x (111)
many thanks
greg


Did you enable your database server to accept connections from outside? The latest version doesn't open a TCP-socket!
Kind regards!

Diederik de Vries





Heemraadsingel 188
3021 DM Rotterdam
T: +31-10-4776515
F: +31-10-2440250








Re: realtime email backup across computer centers

2003-05-13 Thread Markus Oswald
On Tue, 2003-05-13 at 10:39, Stephan Poehlsen wrote:
> Hi,
> 
> How would you realize a realtime email-backup across two different
> computers in two different computer-centers?
> 
> Let's say I have a mail-server A in city A and a backup-mail-server B
> in city B. So if an airplain crashs one computer-center, no email gets
> lost.
> 
> I think all mail must be forwarded from server A to B (and must be
> acknowledged from B) before server A acknowleges incomming mail.

You could use DRBD to have your spool-directory mirrored. If machine A
goes down, B mounts the DRBD device and takes over the IP address of
your mail-service. Voila, you're up again. Downtime: a few seconds...

The only real problem I see:  If you really want to distribute your
servers across two cities (!), you'll need some really good (i.e.
stable) connection between both servers or you may face a split-brain
situation. A fast Uplink may be nice to as you have to re-sync your
whole device every time one of your servers go down.
Typically DRBD has some Gbit interconnect through a crossover cable to
prevent such a situation due to a switch-failure or something else and
provide reasonable fast re-sync times.

> Does there exists a solution? Maybe with qmail?

The scenario above is completely MTA independent - you can use qmail,
sendmail, postfix, exim, courier-mta, $whatever... 

best regards,
 Markus
-- 
Markus Oswald <[EMAIL PROTECTED]>  \ Unix and Network Administration
Graz, AUSTRIA \ High Availability / Cluster
Mobile: +43 676 6485415\ System Consulting
Fax:+43 316 428896  \ Web Development




Re: realtime email backup across computer centers

2003-05-13 Thread mimo
I would try an NFS mount + procmail recipe:
1. mount something from server B on server A
2. (on server A) create a procmail recipe to copy all incoming mail 
additionally onto the mount from server B

Michael Moritz
Stephan Poehlsen wrote:
Hi,
How would you realize a realtime email-backup across two different
computers in two different computer-centers?
Let's say I have a mail-server A in city A and a backup-mail-server B
in city B. So if an airplain crashs one computer-center, no email gets
lost.
I think all mail must be forwarded from server A to B (and must be
acknowledged from B) before server A acknowleges incomming mail.
Does there exists a solution? Maybe with qmail?
Stephan




Re: realtime email backup across computer centers

2003-05-13 Thread Wouter
On Tue, 13 May 2003, mimo wrote:

> I would try an NFS mount + procmail recipe:
> 
> 1. mount something from server B on server A
> 2. (on server A) create a procmail recipe to copy all incoming mail 
> additionally onto the mount from server B

And what happens if a user retrieves his mail via POP? it should be deleted on
both servers. this would require you to patch your POP server and IMAP server

btw: the easy way to deliver to 2 machines at once is LDAP. just have 2
maildrops for every email address, 1 on either machine. if the 2nd server is
down, the message will be in the mail queue.

W.