[vchkpw] DEAD THREAD RE: [vchkpw] switching database servers

2003-02-14 Thread Benjamin Tomhave
Ok, I started it, I wish to kill it.  All points well made, though a bit
ruder than necessary.  I'll compile against a hostname that is configured
into /etc/hosts and life will be grand.  Thank you.  BTW, I'm disappointed
nobody compared file read for looking up a sql server vs. file read for
looking up hostname.  Can't imagine that would be much different, and thus
doesn't really gain you much in performance.  Just a thought.  Again,
thank you for the responses.

>
> Hi Andrew !!
>
> I guess You did not read the whole story :-)
> It's not about shutting down deliveries.
> It's not even about compiling vpopmail...
>
> It's a comparison of having a vpopmail SQL configfile
> vs. compiled in SQL config (vmysql.h)
>
> Please read the story, I'm tired... bye...
>
>>  Original Message -
>> Date: 15-Feb-2003 05:00:47 +0100
>> From: Andrew Kohlsmith <[EMAIL PROTECTED]>
>> To:  <[EMAIL PROTECTED]>
>> Subject: Re: [vchkpw] switching database servers
>>
>> > 5 min * 60 sec/min = 300 sec
>> > 300 sec / .02 sec/delivery = 15000 deliveries
>>
>> Why on earth would you shut down delivery for the compile?
>>
>> time to make install: 30 seconds
>> 30 sec / .02 sec/delivery = 1500 deliveries
>>
>> that's one order of magnitude, assuming that you need the full 30
>> seconds
> to
>> do a shutdown/make install/startup.  I would believe you could get
>> this
> down
>> by another order of magnitude with a simple script -- making your
>> total  deliveries on the order of 150-250.
>>
>> Speaking from experience on a mid-volume mail server (about a thousand
>>  deliveries per hour) -- qmail compensates perfectly.  In my case I'm
>> also  running every message though spamc and procmail *and* an
>> antivirus scan
> (Rav
>> antivirus) -- You get a 1min load spike of about 22-30 which goes away
> within
>> a minute and you're back down to normal levels.
>>
>> > What about all POP/IMAP connections ?
>> > Many users gets maybe less than 10 emails a day but they
>> > do POP their mailbox every 5 (or less) minutes !!!
>>
>> You schedule it during a normal maintenance window.  Not many people
>> are
> up
>> and about at 4am.  And also speaking from experience, people will get
>> an  error, go "hmm" and try again.  By that time you're back up and
>> nothing  happens.
>>
>> And if you really needed to look like you were always up, you'd have
> already
>> written a very quick and dirty pop/imap server which just replied
>> "yup,  password good, no messages" to any query.
>>
>> Regards,
>> Andrew
>>
>>
>


-- 
Benjamin Tomhave, Senior Systems Engineer
[EMAIL PROTECTED]
Sofast Communicationswww.sofast.net






RE: Re: [vchkpw] switching database servers

2003-02-14 Thread domi

Hi Andrew !!

I guess You did not read the whole story :-)
It's not about shutting down deliveries.
It's not even about compiling vpopmail...

It's a comparison of having a vpopmail SQL configfile
vs. compiled in SQL config (vmysql.h)

Please read the story, I'm tired... bye...

>  Original Message -
> Date: 15-Feb-2003 05:00:47 +0100
> From: Andrew Kohlsmith <[EMAIL PROTECTED]>
> To:  <[EMAIL PROTECTED]>
> Subject: Re: [vchkpw] switching database servers
> 
> > 5 min * 60 sec/min = 300 sec
> > 300 sec / .02 sec/delivery = 15000 deliveries
> 
> Why on earth would you shut down delivery for the compile?
> 
> time to make install: 30 seconds
> 30 sec / .02 sec/delivery = 1500 deliveries
> 
> that's one order of magnitude, assuming that you need the full 30 seconds
to 
> do a shutdown/make install/startup.  I would believe you could get this
down 
> by another order of magnitude with a simple script -- making your total 
> deliveries on the order of 150-250.
> 
> Speaking from experience on a mid-volume mail server (about a thousand 
> deliveries per hour) -- qmail compensates perfectly.  In my case I'm also 
> running every message though spamc and procmail *and* an antivirus scan
(Rav 
> antivirus) -- You get a 1min load spike of about 22-30 which goes away
within 
> a minute and you're back down to normal levels.
> 
> > What about all POP/IMAP connections ?
> > Many users gets maybe less than 10 emails a day but they
> > do POP their mailbox every 5 (or less) minutes !!!
> 
> You schedule it during a normal maintenance window.  Not many people are
up 
> and about at 4am.  And also speaking from experience, people will get an 
> error, go "hmm" and try again.  By that time you're back up and nothing 
> happens.
> 
> And if you really needed to look like you were always up, you'd have
already 
> written a very quick and dirty pop/imap server which just replied "yup, 
> password good, no messages" to any query.
> 
> Regards,
> Andrew
> 
>




Re: [vchkpw] switching database servers

2003-02-14 Thread Andrew Kohlsmith
> 5 min * 60 sec/min = 300 sec
> 300 sec / .02 sec/delivery = 15000 deliveries

Why on earth would you shut down delivery for the compile?

time to make install: 30 seconds
30 sec / .02 sec/delivery = 1500 deliveries

that's one order of magnitude, assuming that you need the full 30 seconds to 
do a shutdown/make install/startup.  I would believe you could get this down 
by another order of magnitude with a simple script -- making your total 
deliveries on the order of 150-250.

Speaking from experience on a mid-volume mail server (about a thousand 
deliveries per hour) -- qmail compensates perfectly.  In my case I'm also 
running every message though spamc and procmail *and* an antivirus scan (Rav 
antivirus) -- You get a 1min load spike of about 22-30 which goes away within 
a minute and you're back down to normal levels.

> What about all POP/IMAP connections ?
> Many users gets maybe less than 10 emails a day but they
> do POP their mailbox every 5 (or less) minutes !!!

You schedule it during a normal maintenance window.  Not many people are up 
and about at 4am.  And also speaking from experience, people will get an 
error, go "hmm" and try again.  By that time you're back up and nothing 
happens.

And if you really needed to look like you were always up, you'd have already 
written a very quick and dirty pop/imap server which just replied "yup, 
password good, no messages" to any query.

Regards,
Andrew




RE: Re: [vchkpw] switching database servers

2003-02-14 Thread domi

heh, yeah...

Let's say recompiling vpopmail takes 5 minutes.

5 min * 60 sec/min = 300 sec
300 sec / .02 sec/delivery = 15000 deliveries

on a hi-traffic mailserver 15000 deliveries
is maybe less than an HOUR 


So, if you do not know where Your SQL is in one hour
then you propably need to check your routines and
plan everything from scratch :-)

In comparison it takes less than 10 sec to change the 
record in /etc/hosts.

You could also have a cmdline switch in .qmail
"| /vdelivermail '' [EMAIL PROTECTED] sqlhost sqluser sqlpass"
which allows you to override the default sqlconf on
PER USER/DOMAIN BASIS if needed...

Or why not pass the config in ENVIRONMENT and just
restart qmail with the new config. time: less than 10 sec

What about all POP/IMAP connections ?
Many users gets maybe less than 10 emails a day but they
do POP their mailbox every 5 (or less) minutes !!!

## what I mean is waste is that I'm not movin around my
## SQL on a day to day basis so I think it's nothing but waste.

It's also true, which you effectively proved here, that
it is very easy to write the "read-sql-config" functionality
into vpopmail code so I guess the problem is solved now !!!
please submit a patch !

There is ofcourse other anvantage of having sql config
in a single text file instead of compiled-in but that's 
another story.

regards, =d0Mi=

PS. one more thing.
The time it took to write this message is more than twice
the time it'd take to move the SQL server and recompile
vpopmail and that is definitely a waste :-)


>  Original Message -
> Date: 15-Feb-2003 00:23:55 +0100
> From: dWi saSonO b <[EMAIL PROTECTED]>
> To:  <[EMAIL PROTECTED]>
> Subject: Re: [vchkpw] switching database servers
> 
> On 14 Feb 2003 22:45:05 -
> [EMAIL PROTECTED] wrote:
> 
> > 
> > To let vpopmail read a config file is nothing
> > but waste
> > 
> > =d0Mi=
> > 
> example program to get server name,user, and passwd.
> 
> #include 
> #include 
> 
> char server[20];
> char user[20];
> char passwd[20];
> 
> int main(void )
> {
> 
> FILE *fd;
> char data[100];
> 
> if((fd=fopen("/tmp/test.conf","r"))==NULL) {
> printf("file tidak bisa dibukan");
> exit(1);
> }
> fgets(data,sizeof(data),fd);
> strcpy(server,data);
> strtok(server,"n");
> //printf("server = %sn",server);
> fgets(data,sizeof(data),fd);
> strcpy(user,data);
> strtok(user,"n");
> //printf("username = %sn",user);
> fgets(data,sizeof(data),fd);
> strcpy(passwd,data);
> strtok(passwd,"n");
> //printf("passwd = %sn",passwd);
> fclose(fd);
> }
> 
> [onOs@shadow tmp]$ time ./test
> 
> real0m0.002s
> user0m0.000s
> sys 0m0.002s
> 
> /dev/hda:
>  Timing buffer-cache reads:   128 MB in  0.91 seconds =141.25 MB/sec
>  Timing buffered disk reads:  64 MB in  3.19 seconds = 20.07 MB/sec
> 
> 
> why waste ??
> running simple program like that only use resources 0.002 s
> that mean every 500 message had lost delay 1 s
> and my hardisk only use QUANTUM FIREBALLlct20 20, ATA DISK drive
> how abaut SCSI IBM with 160 MB/s ??
> it is not "usefull" ?
> 
> 
> -- 
> thx
> onOs
> 
>




Re: [vchkpw] switching database servers

2003-02-14 Thread dWi saSonO b
On 14 Feb 2003 22:45:05 -
[EMAIL PROTECTED] wrote:

> 
> To let vpopmail read a config file is nothing
> but waste
> 
> =d0Mi=
> 
example program to get server name,user, and passwd.

#include 
#include 

char server[20];
char user[20];
char passwd[20];

int main(void )
{

FILE *fd;
char data[100];

if((fd=fopen("/tmp/test.conf","r"))==NULL) {
printf("file tidak bisa dibuka\n");
exit(1);
}
fgets(data,sizeof(data),fd);
strcpy(server,data);
strtok(server,"\n");
//printf("server = %s\n",server);
fgets(data,sizeof(data),fd);
strcpy(user,data);
strtok(user,"\n");
//printf("username = %s\n",user);
fgets(data,sizeof(data),fd);
strcpy(passwd,data);
strtok(passwd,"\n");
//printf("passwd = %s\n",passwd);
fclose(fd);
}

[onOs@shadow tmp]$ time ./test

real0m0.002s
user0m0.000s
sys 0m0.002s

/dev/hda:
 Timing buffer-cache reads:   128 MB in  0.91 seconds =141.25 MB/sec
 Timing buffered disk reads:  64 MB in  3.19 seconds = 20.07 MB/sec


why waste ??
running simple program like that only use resources 0.002 s
that mean every 500 message had lost delay 1 s
and my hardisk only use QUANTUM FIREBALLlct20 20, ATA DISK drive
how abaut SCSI IBM with 160 MB/s ??
it is not "usefull" ?


-- 
thx
onOs




RE: [vchkpw] switching database servers

2003-02-14 Thread domi
   
a simple solution is just configure vpopmail
to connect to a HOSTNAME (even if localhost).
then the only thing you need to do is add a
line to your /etc/hosts or modify your DNS

To let vpopmail read a config file is nothing
but waste

=d0Mi=

>  Original Message -
> Date: 14-Feb-2003 22:40:30 +0100
> From: Benjamin Tomhave <[EMAIL PROTECTED]>
> To:  <[EMAIL PROTECTED]>
> Subject: RE: [vchkpw] switching database servers
> 
> What would it take for this to be a configurable parameter instead of a
> compiled-in parameter?  In other words, would it be possible to add a config
> file, read at startup, from, say vpopmail/etc or qmail/control or similar?
> It seems to me that this would make a lot more sense than requiring the
> server, user and password to be compiled into the program itself.
> 
> > -Original Message-
> > From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 1:47 PM
> > To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> > Subject: RE: [vchkpw] switching database servers
> >
> >
> > Recompile.  And do it from fresh source, don't just do a make clean and
> > reconfigure it.
> >
> > -Clayton
> >
> > -Original Message-
> > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 10:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] switching database servers
> >
> >
> > Hello,
> >
> > If I want to switch from using localhost to another remote host for my
> > vpopmail, does that require a rebuild/recompile, or is there a
> > configurable
> > parameter somewhere that can be modified to make that adjustment?
> >  My notes
> > seem to imply that the only way to change this is by editting the proper
> > values in the vmysql.h file.
> >
> > Thank you,
> >
> > -ben
> >
> > 
> > Benjamin Tomhave, Senior Systems Engineer
> > [EMAIL PROTECTED]
> > Sofast Communications  www.sofast.net
> >
> >
> >
> >
> >
> >
> 
> 
>




RE: [vchkpw] switching database servers

2003-02-14 Thread Clayton Weise
That depends on how remote it is and how much traffic you expect.  You might
want to look into MySQL replication at a certain point.  That way for most
of your queries you can do them locally (on the box), and only upatable
queries will make their way to the main server.  That's what I do.. MySQL
replication is quite simple to setup.  And if you notice there are two
entires in the mysql.h file, one for the read server and one for the update
server.

-Clayton

-Original Message-
From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 14, 2003 1:49 PM
To: [EMAIL PROTECTED]
Subject: RE: [vchkpw] switching database servers


Ok, this raises for me an interesting questionsshould vpopmail only ever
use a local db?  Or is it reasonable to try using a remote (obviously not
too terribly remote) db?

> -Original Message-
> From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 2:47 PM
> To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> That might be feasable.. if vpopmail ran as a daemon.  But vpopmail 
> gets called on by qmail.  So if vpopmail had a config file it could 
> damper it's performance (on slower systems, quite heavily) because 
> every single time vpopmail was run it would have to read that config 
> file.  Remember that vpopmail is called on upon every message 
> delivery, password check, etc etc.
>
> -Clayton
>
> -Original Message-
> From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> What would it take for this to be a configurable parameter instead of 
> a compiled-in parameter?  In other words, would it be possible to add 
> a config file, read at startup, from, say vpopmail/etc or 
> qmail/control or similar? It seems to me that this would make a lot 
> more sense than requiring the server, user and password to be compiled 
> into the program itself.
>
> > -Original Message-
> > From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 1:47 PM
> > To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> > Subject: RE: [vchkpw] switching database servers
> >
> >
> > Recompile.  And do it from fresh source, don't just do a make clean 
> > and reconfigure it.
> >
> > -Clayton
> >
> > -Original Message-
> > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 10:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] switching database servers
> >
> >
> > Hello,
> >
> > If I want to switch from using localhost to another remote host for 
> > my vpopmail, does that require a rebuild/recompile, or is there a 
> > configurable parameter somewhere that can be modified to make that 
> > adjustment?  My notes seem to imply that the only way to change this 
> > is by editting the proper values in the vmysql.h file.
> >
> > Thank you,
> >
> > -ben
> >
> > 
> > Benjamin Tomhave, Senior Systems Engineer [EMAIL PROTECTED]
> > Sofast Communications  www.sofast.net
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>









Re: [vchkpw] switching database servers

2003-02-14 Thread dWi saSonO b
perhaps, but still can use autdaemon without vpopmail become daemon
if i remember sqwebmail using kind of this
using memory as read and write is more faster than disk
but it about easy and "not easy"



On Fri, 14 Feb 2003 13:46:59 -0800
"Clayton Weise" <[EMAIL PROTECTED]> wrote:

> That might be feasable.. if vpopmail ran as a daemon.  But vpopmail gets
> called on by qmail.  So if vpopmail had a config file it could damper it's
> performance (on slower systems, quite heavily) because every single time
> vpopmail was run it would have to read that config file.  Remember that
> vpopmail is called on upon every message delivery, password check, etc etc.
> 
> -Clayton
> 
> -Original Message-
> From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 14, 2003 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
> 
> 
> What would it take for this to be a configurable parameter instead of a
> compiled-in parameter?  In other words, would it be possible to add a config
> file, read at startup, from, say vpopmail/etc or qmail/control or similar?
> It seems to me that this would make a lot more sense than requiring the
> server, user and password to be compiled into the program itself.
> 
> > -Original Message-
> > From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 1:47 PM
> > To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> > Subject: RE: [vchkpw] switching database servers
> >
> >
> > Recompile.  And do it from fresh source, don't just do a make clean 
> > and reconfigure it.
> >
> > -Clayton
> >
> > -Original Message-
> > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 10:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] switching database servers
> >
> >
> > Hello,
> >
> > If I want to switch from using localhost to another remote host for my 
> > vpopmail, does that require a rebuild/recompile, or is there a 
> > configurable parameter somewhere that can be modified to make that 
> > adjustment?  My notes
> > seem to imply that the only way to change this is by editting the proper
> > values in the vmysql.h file.
> >
> > Thank you,
> >
> > -ben
> >
> > 
> > Benjamin Tomhave, Senior Systems Engineer
> > [EMAIL PROTECTED]
> > Sofast Communications  www.sofast.net
> >
> >
> >
> >
> >
> >
> 
> 
> 
> 
> 
> 
> 


-- 
thx
onOs




RE: [vchkpw] switching database servers

2003-02-14 Thread Benjamin Tomhave
Ok, this raises for me an interesting questionsshould vpopmail only ever
use a local db?  Or is it reasonable to try using a remote (obviously not
too terribly remote) db?

> -Original Message-
> From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 2:47 PM
> To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> That might be feasable.. if vpopmail ran as a daemon.  But vpopmail gets
> called on by qmail.  So if vpopmail had a config file it could damper it's
> performance (on slower systems, quite heavily) because every single time
> vpopmail was run it would have to read that config file.  Remember that
> vpopmail is called on upon every message delivery, password
> check, etc etc.
>
> -Clayton
>
> -Original Message-
> From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> What would it take for this to be a configurable parameter instead of a
> compiled-in parameter?  In other words, would it be possible to
> add a config
> file, read at startup, from, say vpopmail/etc or qmail/control or similar?
> It seems to me that this would make a lot more sense than requiring the
> server, user and password to be compiled into the program itself.
>
> > -Original Message-
> > From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 1:47 PM
> > To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> > Subject: RE: [vchkpw] switching database servers
> >
> >
> > Recompile.  And do it from fresh source, don't just do a make clean
> > and reconfigure it.
> >
> > -Clayton
> >
> > -----Original Message-
> > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 10:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] switching database servers
> >
> >
> > Hello,
> >
> > If I want to switch from using localhost to another remote host for my
> > vpopmail, does that require a rebuild/recompile, or is there a
> > configurable parameter somewhere that can be modified to make that
> > adjustment?  My notes
> > seem to imply that the only way to change this is by editting the proper
> > values in the vmysql.h file.
> >
> > Thank you,
> >
> > -ben
> >
> > 
> > Benjamin Tomhave, Senior Systems Engineer
> > [EMAIL PROTECTED]
> > Sofast Communications  www.sofast.net
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>





RE: [vchkpw] switching database servers

2003-02-14 Thread Clayton Weise
That might be feasable.. if vpopmail ran as a daemon.  But vpopmail gets
called on by qmail.  So if vpopmail had a config file it could damper it's
performance (on slower systems, quite heavily) because every single time
vpopmail was run it would have to read that config file.  Remember that
vpopmail is called on upon every message delivery, password check, etc etc.

-Clayton

-Original Message-
From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 14, 2003 1:40 PM
To: [EMAIL PROTECTED]
Subject: RE: [vchkpw] switching database servers


What would it take for this to be a configurable parameter instead of a
compiled-in parameter?  In other words, would it be possible to add a config
file, read at startup, from, say vpopmail/etc or qmail/control or similar?
It seems to me that this would make a lot more sense than requiring the
server, user and password to be compiled into the program itself.

> -Original Message-
> From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 1:47 PM
> To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> Recompile.  And do it from fresh source, don't just do a make clean 
> and reconfigure it.
>
> -Clayton
>
> -Original Message-
> From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 10:41 AM
> To: [EMAIL PROTECTED]
> Subject: [vchkpw] switching database servers
>
>
> Hello,
>
> If I want to switch from using localhost to another remote host for my 
> vpopmail, does that require a rebuild/recompile, or is there a 
> configurable parameter somewhere that can be modified to make that 
> adjustment?  My notes
> seem to imply that the only way to change this is by editting the proper
> values in the vmysql.h file.
>
> Thank you,
>
> -ben
>
> 
> Benjamin Tomhave, Senior Systems Engineer
> [EMAIL PROTECTED]
> Sofast Communications  www.sofast.net
>
>
>
>
>
>









Re: [vchkpw] switching database servers

2003-02-14 Thread dWi saSonO b
why not ?
just add some code of fopen and fgetc with parsing a little string ... and ... *pouf* 

your vpopmail is not working at all
hehehehehehe

On Fri, 14 Feb 2003 14:40:16 -0700
"Benjamin Tomhave" <[EMAIL PROTECTED]> wrote:

> What would it take for this to be a configurable parameter instead of a
> compiled-in parameter?  In other words, would it be possible to add a config
> file, read at startup, from, say vpopmail/etc or qmail/control or similar?
> It seems to me that this would make a lot more sense than requiring the
> server, user and password to be compiled into the program itself.
> 
> > -Original Message-
> > From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 1:47 PM
> > To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> > Subject: RE: [vchkpw] switching database servers
> >
> >
> > Recompile.  And do it from fresh source, don't just do a make clean and
> > reconfigure it.
> >
> > -Clayton
> >
> > -Original Message-
> > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 14, 2003 10:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] switching database servers
> >
> >
> > Hello,
> >
> > If I want to switch from using localhost to another remote host for my
> > vpopmail, does that require a rebuild/recompile, or is there a
> > configurable
> > parameter somewhere that can be modified to make that adjustment?
> >  My notes
> > seem to imply that the only way to change this is by editting the proper
> > values in the vmysql.h file.
> >
> > Thank you,
> >
> > -ben
> >
> > 
> > Benjamin Tomhave, Senior Systems Engineer
> > [EMAIL PROTECTED]
> > Sofast Communications  www.sofast.net
> >
> >
> >
> >
> >
> >
> 
> 
> 


-- 
thx
onOs
Divisi Pusat dan Pengawasan Jaringan
UPPTI - Universitas Brawijaya
Gedung Rektorat Lama Lt. 2
Jl. Veteran Malang 65145
Malang, Jawa Timur
mobile phone : (+62) 08563529463
office phone : (+62) 0341 575878




RE: [vchkpw] switching database servers

2003-02-14 Thread Benjamin Tomhave
What would it take for this to be a configurable parameter instead of a
compiled-in parameter?  In other words, would it be possible to add a config
file, read at startup, from, say vpopmail/etc or qmail/control or similar?
It seems to me that this would make a lot more sense than requiring the
server, user and password to be compiled into the program itself.

> -Original Message-
> From: Clayton Weise [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 1:47 PM
> To: 'Benjamin Tomhave'; [EMAIL PROTECTED]
> Subject: RE: [vchkpw] switching database servers
>
>
> Recompile.  And do it from fresh source, don't just do a make clean and
> reconfigure it.
>
> -Clayton
>
> -Original Message-
> From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 14, 2003 10:41 AM
> To: [EMAIL PROTECTED]
> Subject: [vchkpw] switching database servers
>
>
> Hello,
>
> If I want to switch from using localhost to another remote host for my
> vpopmail, does that require a rebuild/recompile, or is there a
> configurable
> parameter somewhere that can be modified to make that adjustment?
>  My notes
> seem to imply that the only way to change this is by editting the proper
> values in the vmysql.h file.
>
> Thank you,
>
> -ben
>
> 
> Benjamin Tomhave, Senior Systems Engineer
> [EMAIL PROTECTED]
> Sofast Communications  www.sofast.net
>
>
>
>
>
>





RE: [vchkpw] switching database servers

2003-02-14 Thread Clayton Weise
Recompile.  And do it from fresh source, don't just do a make clean and
reconfigure it.

-Clayton

-Original Message-
From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 14, 2003 10:41 AM
To: [EMAIL PROTECTED]
Subject: [vchkpw] switching database servers


Hello,

If I want to switch from using localhost to another remote host for my
vpopmail, does that require a rebuild/recompile, or is there a configurable
parameter somewhere that can be modified to make that adjustment?  My notes
seem to imply that the only way to change this is by editting the proper
values in the vmysql.h file.

Thank you,

-ben


Benjamin Tomhave, Senior Systems Engineer
[EMAIL PROTECTED]
Sofast Communications  www.sofast.net









[vchkpw] switching database servers

2003-02-14 Thread Benjamin Tomhave
Hello,

If I want to switch from using localhost to another remote host for my
vpopmail, does that require a rebuild/recompile, or is there a configurable
parameter somewhere that can be modified to make that adjustment?  My notes
seem to imply that the only way to change this is by editting the proper
values in the vmysql.h file.

Thank you,

-ben


Benjamin Tomhave, Senior Systems Engineer
[EMAIL PROTECTED]
Sofast Communications  www.sofast.net