--enable-users-big-dir (default)
address extensions = ON --enable-qmail-ext
ip alias = OFF --disable-ip-alias-domains (default)
domain quotas = ON --enable-domainquotas
auth module = mysql --enable-auth-module=mysql
mysql replication = ON --enable-mysql-replication
mys
On May 20, 2005, at 7:48 AM, Shane Metler wrote:
But I noticed (while testing POP3 connections) that both the read and
the write MySQL servers have persistent connections opened up (user:
vpopsqluser, table: vpopmail ) after checking mail once via POP3. The
'last query' time on both MySQL serve
>-Original Message-
>From: Jeremy Kitchen [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 20, 2005 8:27 AM
>To: vchkpw@inter7.com
>Subject: Re: [vchkpw] read DB vs. write / update DB - Qmail, Vpopmail
>(authvchkpw & Mysql replication), Courier-pop3d
>
>On Friday
On Friday 20 May 2005 09:48 am, Shane Metler wrote:
> Hi list,
>
> I have a Qmail cluster running, using Gentoo's patched versions of
> Qmail, vpopmail (using MySQL replication), Courier-imap, and then
> Courier-authlib linked to authvchkpw for IMAP & POP3 authentication.
&
Title: Message
Hi list,
I have a Qmail cluster running, using Gentoo's patched
versions of Qmail, vpopmail (using MySQL replication), Courier-imap, and then
Courier-authlib linked to authvchkpw for IMAP & POP3
authentication.
qmail-1.03
vpopmail-5.4.6
courier-imap-4.0.1
courie
d=85937&atid=577798
vadddomain + mysql replication segfault:
https://sourceforge.net/tracker/index.php?func=detail&aid=895376&group_id=85937&atid=577798
(sorry for long urls)
If I get a chance I'll try to set up a test bed and get some strace
output, but I don't kno
./vadddomain example.com
test (for password)
Segmentation fault
/home/vpopmail/domains is mounted on an nfs share, the domain folder and
postmaster folders are all created, the entry is added to the database,
and everything.
At first I thought it might just have something to do with the tables
no
HA to have two machines as a
failover cluster mounting the database via NFS. I think this'll be a
lot cleaner, and will also integrate in a nicer fashion with the concept
vpopmail has of mysql replication.
Your other option, if you've got money to spend on the problem, is to
get a d
es as a
> failover cluster mounting the database via NFS. I think this'll be a
> lot cleaner, and will also integrate in a nicer fashion with the concept
> vpopmail has of mysql replication.
> Your other option, if you've got money to spend on the problem, is to
> get
You could potentially code in a multiple call update from vpopmail to
some IFDEF'd in mysql servers.
I'm thinking that you could make certain update calls to as many MySQL
servers as you wanted, sending the same SQL statement to each.
I imagine some critical thinking in the process could lead to
a nicer fashion with the concept
vpopmail has of mysql replication.
Your other option, if you've got money to spend on the problem, is to
get a database server which is both supported by vpopmail and supports
more flexible replication. I'd recommend Sybase, since they support real
Greetings,
I've got a working mysql and vpopmail setup going, with replication support. For
those that don't know, replication support in vpopmail means that all updates go to a
single server, where lookups can be sent to another server. I have a local copy of the
replicated database on each
hi everybody!
i'm going to set up a cluster of mail server but i'm not sure, what's
the best way. i'm using qmail/vpopmail/mysql for 3 years now. but now i
have to set up a bigger system. i know that vpopmail has an option
--enable-mysql-replication, but i don't see
It works for me. You might want to try the 4.10.16 version
I just uploaded. Make sure you edit your vmysql.h file
and put the local server in as the READ one, and put
your Master server in as the UPDATE one.
Here are the options I use
./configure --enable-mysql=y --enable-mysql-replication=y
Hi,
I have vpopmail configured with --enable-mysql-replication=y.It is working
fine except that my primary MySQL server is not updated...infact it doesnt
even have the vpopmail database whereas the update server contains all the
tables and the domains info that i have added..
whenever i add
> -Original Message-
> From: Ken Jones [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 3:01 AM
> To: Gabriel Ambuehl
> Cc: [EMAIL PROTECTED]
> Subject: Re: Error trying to compile + new mysql replication release
>
> I guess we could do that. It would
le ones for round robin
> DNS.
> Hence the point of round robin, the above should do the job of
> spreading the load among multiple slaves...
I don't think we need to have round robin slave connections.
What the mysql replication people kind of assume is that there
is a slave server o
-BEGIN PGP SIGNED MESSAGE-
Hello Ken,
Tuesday, June 05, 2001, 12:00:35 PM, you wrote:
>> What about an customizable number of read only machines of which
>> vpopmail chooses one, by round robin, for example?
> I guess we could do that. It would be easier to impliment a
> list of servers
Gabriel Ambuehl writes:
> -BEGIN PGP SIGNED MESSAGE-
>
> Hello Ken,
>
> Monday, June 04, 2001, 6:11:37 PM, you wrote:
>
>> There is on read only server defined, where all the
>> reads go to. If the connection to the read server fails
>> then as a last resort it will try to connect t
Good point. This mysql replication stuff should probably get
a good READ me file too.
Here is what is in the vmysql.h file now:
/* Edit to match your set up
*
* If you are NOT using mysql replication:
* Then edit the UPDATE server with your mysql authentication
* information. The READ server
: "Ken Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 2:11 AM
Subject: Re: Error trying to compile + new mysql replication release
>
> Try the vpopmail-4.10.14 release. I just tested it with the
> same options you used and it compiles cle
-BEGIN PGP SIGNED MESSAGE-
Hello Chris,
Monday, June 04, 2001, 6:44:21 PM, you wrote:
>> master1, while YY only exists on master2), it should work. What I
>> can't say without looking up in the doc is whether a slave can be
>> slave of two masters at the same time.
> Not true, you can d
-BEGIN PGP SIGNED MESSAGE-
Hello Ken,
Monday, June 04, 2001, 6:11:37 PM, you wrote:
> There is on read only server defined, where all the
> reads go to. If the connection to the read server fails
> then as a last resort it will try to connect to the
> update server.
What about an custo
> > 1) does having two master servers make sense?
>
> It normally doesn't work as the master servers don't know of updates
> made to tables of the other master. Now if you can clearly separate
> all records between the two masters (i.e. table XX does only exist on
> master1, while YY only exists o
Try the vpopmail-4.10.14 release. I just tested it with the
same options you used and it compiles cleanly.
btw: I think this version is about the cleanest we can
have with mysql replication.
There is one update server defined. All sql that will
cause the database to be modified is sent to
> Hey Folks,
Hey Ken!
>
> I wonder if anyone who knows about mysql replication
> can answer some questions.
>
> We are thinking of setting up a replicated mysql
> layout with the following:
>
> two master servers
> four slave servers
>
> 1) does having two m
-BEGIN PGP SIGNED MESSAGE-
Hello Ken,
Monday, June 04, 2001, 12:19:00 PM, you wrote:
> I wonder if anyone who knows about mysql replication
> can answer some questions.
Lemme say it this way: we use it.
> We are thinking of setting up a replicated mysql
> layout with t
>two master servers
>four slave servers
>1) does having two master servers make sense?
>It seems like slaves will only talk to one master
>server. So if the master fails there is no automatic
>way to have them fail over to a secondard master.
>Is that true?
Yes. They are working on multiple mast
Hey Folks,
I wonder if anyone who knows about mysql replication
can answer some questions.
We are thinking of setting up a replicated mysql
layout with the following:
two master servers
four slave servers
1) does having two master servers make sense?
It seems like slaves will only talk to
From: Ken Jones <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED]
>> Subject: mysql replication
>>
>> Hey Folks,
>>
>> Would the author of the read/update mysql patch send me
>> an email? I want to put a credit in the AUTHORS and ChangeLog.
>>
Can you add some postgres support?
On Tue, 29 May 2001, Ken Jones wrote:
> Date: Tue, 29 May 2001 17:44:32 GMT
> From: Ken Jones <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: mysql replication
>
> Hey Folks,
>
> Would the author of the read/update mys
Hey Folks,
Would the author of the read/update mysql patch send me
an email? I want to put a credit in the AUTHORS and ChangeLog.
I have the mysql module setup to do all read queries on
one connection and all updates on another connection.
This should fit in well with mysql replication. I was
32 matches
Mail list logo
