Re: mysql high availability

2001-05-30 Thread Ken Jones
This is probably worth talking about now, since we are working on the mysql module for the next several weeks. Using Matt's read/update patch as a starting point the mysql functions are broken up into read-only queries and update queries with separate definitions in vmysql.h for two mysql login c

Re: vuserinfo on different box to main vpopmail install, shared filer

2001-05-30 Thread Jack Howard
In a previous message, Ben Beuchler <[EMAIL PROTECTED]> said: >You need a coopy of the /var/qmail/users/cdb file from the mail server >on the linux box. It uses that file to figure out which directory to >look in for the vpasswd.cdb file. If it can't find the users/cdb file, >it uses garbage fo

Re: dbfunctions - it's over

2001-05-30 Thread Jason Lim
Hi Ken, I in no way meant any bad feelings towards you. As I mentioned, I only came into this late in the game, so I only know what I see and hear, and from what people were saying, it sounds like they were screwed over. Doesn't mean they really were ;-) Anyway, you really don't have to convince

Patch to allow runtime configuration via environment variables

2001-05-30 Thread Ondřej Surý
This patch allow runtime configuration of: * default domain : ie. VPOPMAIL_DOMAIN=foobar.com * open smtp cur file : OPEN_SMTP_CUR_FILE=/etc/vpopmail/open-smtp * open smtp tmp file : OPEN_SMTP_TMP_FILE=/etc/vpopmail/open-smtp.tmp * tcp smtp file : TCP_SMTP_FILE=/etc/vpopmail/tcp.smtp (ha

Re: mysql high availability

2001-05-30 Thread Ken Jones
Hi Dave, Dave 'Duke of URL' Weiner writes: >> This is probably worth talking about now, since we are working >> on the mysql module for the next several weeks. Using Matt's >> read/update patch as a starting point the mysql functions >> are broken up into read-only queries and update queries >>

Re: mysql high availability

2001-05-30 Thread Sean C Truman
Ken, A good way of getting around the NFS locking problem is to insert another program inbetween tcpserver and qmail-smtpd that checks a database for a relay flag (Which can be set when you call open_smtp_relay()).and that program sets the RELAYCIENT. Sean - Original Message - From:

Re: mysql high availability

2001-05-30 Thread Dave Weiner
> Hi Dave, Hi Ken! :) > Yes, I was looking at that. > The first thing that I ran into is trying to minimize database > transactions during a pop access. The authentication part is > easy, just read the user info from mysql. > > There are two optional transactions that do updates during > an auth

Re: vPopmail compile issues? seg faults every program!

2001-05-30 Thread Jason Lim
Hi, Look in "unstable". Its in there. Tell me if you still can't find it. Sincerely, Jason - Original Message - From: "Rolf Martin-Hoster" <[EMAIL PROTECTED]> To: "Jason Lim" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 9:45 PM Subject: Re: vPopmail compile issues? seg faults every

Vpopmail+Qmail -- pop3 has lost it's mind!

2001-05-30 Thread David Gartner
Question! I've got a high availibilty cluster running qmail and vpopmail. Three computers mount /home from an nfs server. In the home directory is the vpopmail directory (all vpop apps and config's are in this dir). I have made /var/qmail/control and /var/qmail/users match on all nodes. When

RE: Vpopmail+Qmail -- pop3 has lost it's mind!

2001-05-30 Thread Matt Simerson
Make sure the clocks are syncronized on all the POP servers. Having incorrect or out of sync dates will cause such fun stuff. Matt > -Original Message- > From: David Gartner [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 10:28 AM > To: [EMAIL PROTECTED] > Subject: Vpopmail+Q

RE: mysql high availability

2001-05-30 Thread Matt Simerson
I've been down this road and that's a terrible way to do it. Why? Because for every SMTP connection you have to initiate a connection to the database. That's expensive. What you really want to do is have the tcpserver program make a persistent connection to the database and query it for every SMTP

Re: Vpopmail+Qmail -- pop3 has lost it's mind!

2001-05-30 Thread David Gartner
That fixed it! many many thanks :) David Gartner Matt Simerson wrote: > Make sure the clocks are syncronized on all the POP servers. Having > incorrect or out of sync dates will cause such fun stuff. > > Matt > > > -Original Message- > > From: David Gartner [mailto:[EMAIL PROTECTED]] >

Re: mysql high availability

2001-05-30 Thread Sean C Truman
Matt, I can provide you with load specifications. MySQL can handle the work load. I have one customer site running 5 Node Cluster, This does over 500,000 messages a day. Attached is a extended-status from the mysql database server, a show of load average on the machine and also shows the tabl

RE: mysql high availability

2001-05-30 Thread Matt Simerson
Oh trust me, I know that. :-) My point was that it's much less expensive to have tcpserver open up a persistent connnection to the MySQL server and keep it open rather than launching another (albeit small) program that connects to and queries the database. I'm only using MySQL for my SMTP relay (