replication is EASY!!! First make sure both versions of mysql are the
Same..Now set permissions.. "GRANT FILE ON *.* TO REPL@"%" IDENTIFIED BY
 Do that on the master... Shutdown MySQL then tar.gz the files for the
data bases on the primary server And put them on the new slave. 
 Now edit the my.cnf on the master and add this
 Now restart the master. And now add this below to the slave my.cnf
Master-host=<hostname of the master>
Master-user=<replication user>
Master-password=<replication user password>

Now restart the slave and do this from the mysql client

-----Original Message-----
From: Rick Romero [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 16, 2002 1:51 PM
Subject: Re: [vchkpw] mail gateway & smtp auth

You wouldn't necessarily need the MySQL Replication... Just point all
the boxes to the main server with MySQL on it.

Do that first, then play with the replication.. If you get it to work,
recompile vpopmail to use the local MySQL server.


On Wed, 2002-10-16 at 15:31, Lists @ Apted Technologies Inc. wrote:
> im an integrating my companies existing qmail/vpopmail/mysql server 
> and an older setup into one.  i have three boxes that 
> would be the listed mail exchangers and would also perform limited 
> virus checking and spam prevention.  mail comes in to one of them, 
> passes through filtering process, if not rejected, then forwarded to 
> the real mail server where actual mailboxes reside on some raid 
> equipment.  this plan seems great to me, but i have one problem.  smtp

> auth.  if i have qmail/smtp-auth set up on all three of these boxes 
> and the actual server with users maildirs is on another box, how are 
> any mails gonna make it through?  well im thinking i could set up 
> vpopmail on all boxes with mysql replication and have the main mail 
> server as the master, but that seems a bit much to me.  all the other 
> notions i have in my head about how to do this just don't seem clean 
> enough to really want to implement.  i just need a method for 
> qmail/smtp-auth on these three mail exchangers (gateway) to use the 
> auth info from the main mail servers vpopmail/mysql database. does 
> anyone have any suggestions? thanks all.
> -chris

Reply via email to