replication is EASY!!! First make sure both versions of mysql are the
Same..Now set permissions.. "GRANT FILE ON *.* TO REPL@"%" IDENTIFIED BY
'<password>';
 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
[mysqld]
Log-bin
Server-id=1
 
 Now restart the master. And now add this below to the slave my.cnf
[mysqld]
Log-bin
Server-id=2
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
SHOW_SLAVE_STATUS;


-----Original Message-----
From: Rick Romero [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 16, 2002 1:51 PM
To: [EMAIL PROTECTED]
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.

Rick

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 post.office 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