Re: [vchkpw] Configure options for MySQL support?
I now do this with my mail toaster setup
(http://matt.simerson.net/computing/mail/toaster/).
When you run the perl script (toaster_setup.pl -s vpopmail) it asks you
a bunch of questions and then rewrites vmysql.h with your answers
instead of the default values. Then it runs ./configure with the
appropriate --enable-* stuff based on the interview.
Here's the useful logic:
sub set_up_vmysql {
my ($mysql_repl, $my_write, $my_read, $my_user, $my_pass) = @_;
copy(vmysql.h, vmysql.h.orig);
my @lines = read_file(vmysql.h);
foreach my $line (@lines) {
chomp $line;
if ( $line =~ /^#define MYSQL_UPDATE_SERVER/ ) {
if ($mysql_repl) {
$line = #define MYSQL_UPDATE_SERVER \$my_write\;
} else {
$line = #define MYSQL_UPDATE_SERVER \$my_read\;
};
} elsif ( $line =~ /^#define MYSQL_UPDATE_USER/ ) {
$line = #define MYSQL_UPDATE_USER \$my_user\;
} elsif ( $line =~ /^#define MYSQL_UPDATE_PASSWD/ ) {
$line = #define MYSQL_UPDATE_PASSWD \$my_pass\;
} elsif ( $line =~ /^#define MYSQL_READ_SERVER/ ) {
$line = #define MYSQL_READ_SERVER \$my_read\;
} elsif ( $line =~ /^#define MYSQL_READ_USER/ ) {
$line = #define MYSQL_READ_USER \$my_user\;
} elsif ( $line =~ /^#define MYSQL_READ_PASSWD/ ) {
$line = #define MYSQL_READ_PASSWD \$my_pass\;
};
};
write_file(vmysql.h, @lines);
};
On Tuesday, February 25, 2003, at 10:14 AM, Andre Fortin wrote:
This sounds like a good idea to me.. I'd like to see this in the
future.
Andre
-Original Message-
From: Robin Bowes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 10:13 AM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Configure options for MySQL support?
David,
On Tue, February 25, 2003 2:13 pm, David Richardson said:
I don't plan on changing my MySQL params very often, but I'm _certain_
that I'll forget to update vmysql.h during a recompile and I'll
foobar my
Vpopmail.
Can you guess what bit me resulting in my raising this as an issue?!!
Perhaps we could just cobble together a helper perl script to query
for
and rewrite the vmysql.h params as part of the compile script(s) you
use.
That's another possibility...
Without a lot of other me too votes, is there interest from the
vpopmail
team in having this idea go a particular direction (into config/make
or
external perl)? Is this even the appropriate venue to ask???
Let's wait and see...
R.
--
Robin Bowes | http://robinbowes.com
Re: [vchkpw] Configure options for MySQL support?
Robin, if it's up for a vote, I'll second your motion! I don't plan on changing my MySQL params very often, but I'm _certain_ that I'll forget to update vmysql.h during a recompile and I'll foobar my Vpopmail. Perhaps we could just cobble together a helper perl script to query for and rewrite the vmysql.h params as part of the compile script(s) you use. Without a lot of other me too votes, is there interest from the vpopmail team in having this idea go a particular direction (into config/make or external perl)? Is this even the appropriate venue to ask??? Thanks, Dave. -- Original Message -- From: Robin Bowes [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 25 Feb 2003 08:50:23 - (GMT) Hi, I currently use a script to build vpopmail to mame sure I keep the same configure options: [EMAIL PROTECTED] tarballs]# cat vpopmail.config.sh #!/bin/bash ./configure \ --enable-tcpserver-file=/etc/tcprules.d/qmail-smtpd \ --enable-logging=e \ --enable-log-name=vpopmail \ --enable-default-domain=robinbowes.com \ --enable-file-sync=n \ --enable-auth-logging=y \ --enable-qmail-ext=y \ --enable-clear-passwd=y \ --enable-valias=y \ --enable-roaming-users=y \ --enable-mysql=y \ make \ make install-strip I keep this in /home/tarballs along with my vpopmail tarballs: [EMAIL PROTECTED] tarballs]# ls -d vpopmail* vpopmail-5.2.1.tar.gz vpopmail-5.3.16.tar.gz vpopmail.config.sh vpopmail-5.3.12.tar.gz vpopmail-5.3.7.tar.gz vpopmail-5.3.16 vpopmail-5.3.9.tar.gz If I need to build vpopmail (any version), I so the following: [EMAIL PROTECTED] tarballs]# tar zxf vpopmail-5.3.12.tar.gz [EMAIL PROTECTED] tarballs]# cd vpopmail-5.3.12 [EMAIL PROTECTED] vpopmail-5.3.12]# ../vpopmail.config.sh creating cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes ... This worked perfectly until I enabled MySQL support. Now I must edit vmysql.h to include the server/user/password for mysql. Would it be possible to add in a few options for configure to supply these values on the command line, e.g.: ./configure \ --with-mysql-update-server=servername \ --with-mysql-update-user=username \ --with-mysql-update-password=password \ --with-mysql-read-server=servername \ --with-mysql-read-user=username \ --with-mysql-read-password=password The --with-mysql-read-* options could be optional, i.e. use the update server values if the read server is not present. I'd hack this myself, but I'm afraid I know little about writing configure scripts. Thanks, R. -- Robin Bowes | http://robinbowes.com
Re: [vchkpw] Configure options for MySQL support?
David, On Tue, February 25, 2003 2:13 pm, David Richardson said: I don't plan on changing my MySQL params very often, but I'm _certain_ that I'll forget to update vmysql.h during a recompile and I'll foobar my Vpopmail. Can you guess what bit me resulting in my raising this as an issue?!! Perhaps we could just cobble together a helper perl script to query for and rewrite the vmysql.h params as part of the compile script(s) you use. That's another possibility... Without a lot of other me too votes, is there interest from the vpopmail team in having this idea go a particular direction (into config/make or external perl)? Is this even the appropriate venue to ask??? Let's wait and see... R. -- Robin Bowes | http://robinbowes.com
RE: [vchkpw] Configure options for MySQL support?
This sounds like a good idea to me.. I'd like to see this in the future. Andre -Original Message- From: Robin Bowes [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:13 AM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Configure options for MySQL support? David, On Tue, February 25, 2003 2:13 pm, David Richardson said: I don't plan on changing my MySQL params very often, but I'm _certain_ that I'll forget to update vmysql.h during a recompile and I'll foobar my Vpopmail. Can you guess what bit me resulting in my raising this as an issue?!! Perhaps we could just cobble together a helper perl script to query for and rewrite the vmysql.h params as part of the compile script(s) you use. That's another possibility... Without a lot of other me too votes, is there interest from the vpopmail team in having this idea go a particular direction (into config/make or external perl)? Is this even the appropriate venue to ask??? Let's wait and see... R. -- Robin Bowes | http://robinbowes.com
