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 to the
>> update server.
>
> 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 and go down the list untill one is found
that accepts the connection.
Which brings up another point. Where do the servers get
defined. Currently they are compiled in via the vmysql.h
file. Which is easy to implement.
Onjre (spelling?) has a patch to get the information from
a environment variables. Which sounds good but I can see
some problems with it, primarily it adds another level
of complexity in running the command line programs. Users
and shell programs would have to set thier environment
variables. Or perhaps a mix of the two, if an environment
variable is set, use that, otherwise use the compiled one.
Another option would be to put the list of servers in some
configuration file that would get parsed. But I can't see
a secure way to attempt to hide the passwords. Since domains
can be stored under any /etc/passwd account, then any user
on the system would need to have access to the file hence
they could find the login information.
Anyone have any thoughts about this? It would be great
to be able to compile one binary and use it on multiple
machines with different mysql server auth info.
Ken Jones
