Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences

2004-08-18 Thread Jeremy Kitchen
On Wednesday 18 August 2004 02:45 pm, Nick Bright wrote:
> So it appears to be getting the address properly (yay!), however, it
> didn't create a prefs entry in the database. If it's as simple as "it
> doesn't make it automatically, and just uses the default if it's not
> there" is fine, I just don't know and couldn't really tell from the
> documentation.

yes, that's what it does.

-Jeremy

-- 
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc.
  [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l
kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail



Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences

2004-08-18 Thread Nick Bright
On Wed, 2004-08-18 at 14:37, Nicholas Harring wrote:
> Nick Bright wrote:
> 
> >and my .qmail-default file contains:
> >
> >| /usr/bin/spamc -U /var/run/spamd.socket |
> >/usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox
> >
> >
> >As far as I can tell, this should tell spamd to get the username from
> >vpopmail and query the information out of the database, creating the
> >prefrences if they don't exist already. When I send a test message I get
> >this error in my maillog:
> >
> >Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value 
> >from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or
> >username = '@GLOBAL' order by username asc Table
> >'spamassassin.user_prefs' doesn't exist
> >
> >so, it appears to me, that it isn't getting the proper username for some
> >reason. I also tried the same SPAMDOPTIONS without the
> >--username=vpopmail option, and it still came up with a username of
> >vpopmail (since that is the user that calls spamc, I belive).
> >
> >  
> >
> I use:
> preline /usr/bin/spamc -s 1000 -u [EMAIL PROTECTED]

Ok, I added your -u [EMAIL PROTECTED] to my spamc line, and I get the following
log entries when sending a message:

Aug 18 14:35:09 node0 spamd[32486]: processing message
<[EMAIL PROTECTED]> for [EMAIL PROTECTED]:0.
Aug 18 14:35:09 node0 spamd[32486]: identified spam (1001.0/5.0) for
[EMAIL PROTECTED]:0 in 0.1 seconds, 2678 bytes.

So it appears to be getting the address properly (yay!), however, it
didn't create a prefs entry in the database. If it's as simple as "it
doesn't make it automatically, and just uses the default if it's not
there" is fine, I just don't know and couldn't really tell from the
documentation.

My table is set up as such:

++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra  |
++--+--+-+-++
| username   | varchar(100) |  | MUL | ||
| preference | varchar(30)  |  | | ||
| value  | varchar(100) |  | | ||
| prefid | int(11)  |  | PRI | NULL| auto_increment |
++--+--+-+-++


Does that cause a problem? It's the table description I got from the
documentation at http://old.spamassassin.org/full/2.6x/dist/sql/README,
but I had to remove the word "default" because it wouldn't create the
table with that on there. Maybe that's the problem?

Perhaps at this point, I need to take my question to the spamassassin
list? 

Thanks for your time.


> Works like a charm for me.
> Hope that helps,
> Nick Harring
> Webley Systems
-- 
- Nick Bright
  Terraworld, Inc
  http://home.terraworld.net | 888-332-1616



Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences

2004-08-18 Thread Tom Collins
On Aug 18, 2004, at 12:30 PM, Nick Bright wrote:
and my .qmail-default file contains:
| /usr/bin/spamc -U /var/run/spamd.socket |
/usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox
What if you add "-u [EMAIL PROTECTED]" to the spamc options?
--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences

2004-08-18 Thread Nick Bright
Well, It looks like I was having a dumbass attack. The table name in my
database was wrong, once I fixed that, the error message went away (as
it was "table doesn't exist". 

It still appears to be not pulling the username correctly though, and I
would like to know how to properly adjust that. It is also not creating
the prefrences entry if it doesn't exist, which I belive it should.

Again, any assistance is greatly appreciated.

On Wed, 2004-08-18 at 14:30, Nick Bright wrote:
> Greetings,
> 
> I'm using vpopmail 5.4.5 on WhiteBox EL 3.0, and I'm trying to set up
> per-user prefrences with spamassassin (spamc called from .qmail). I
> don't care if it works with SQL or just puts a user_prefs file in each
> users' Maildir.
> 
> My spamd is running with the following options:
> 
> SPAMDOPTIONS="--daemonize --local --nouser-config --sql-config
> --create-prefs --username=vpopmail --vpopmail
> --socketpath=/var/run/spamd.socket --max-children=64"
> 
> and my .qmail-default file contains:
> 
> | /usr/bin/spamc -U /var/run/spamd.socket |
> /usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox
> 
> 
> As far as I can tell, this should tell spamd to get the username from
> vpopmail and query the information out of the database, creating the
> prefrences if they don't exist already. When I send a test message I get
> this error in my maillog:
> 
> Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value 
> from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or
> username = '@GLOBAL' order by username asc Table
> 'spamassassin.user_prefs' doesn't exist
> 
> so, it appears to me, that it isn't getting the proper username for some
> reason. I also tried the same SPAMDOPTIONS without the
> --username=vpopmail option, and it still came up with a username of
> vpopmail (since that is the user that calls spamc, I belive).
> 
> How can I make spamc read the appropriate username and pass it to spamd,
> or how can I make spamd read this from vpopmail?
> 
> I have also tried this configuration, which I thought should have
> created/used a file in the users' Maildir:
> 
> SPAMDOPTIONS="--daemonize --local --create-prefs --username=vpopmail
> --vpopmail --socketpath=/var/run/spamd.socket --max-children=64"
> 
> Again, I tried this one with and without the --username=vpopmail, they
> both showed it being run as the vpopmail user in the log file.
> 
> I don't care if it works via a file in the maildir, or via SQL, but I
> would really like to get user prefrences working, any advice that anyone
> can give would be very much appreciated. Thanks.
-- 
- Nick Bright
  Terraworld, Inc
  http://home.terraworld.net | 888-332-1616



Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences

2004-08-18 Thread Nicholas Harring
Nick Bright wrote:
and my .qmail-default file contains:
| /usr/bin/spamc -U /var/run/spamd.socket |
/usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox
As far as I can tell, this should tell spamd to get the username from
vpopmail and query the information out of the database, creating the
prefrences if they don't exist already. When I send a test message I get
this error in my maillog:
Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value 
from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or
username = '@GLOBAL' order by username asc Table
'spamassassin.user_prefs' doesn't exist

so, it appears to me, that it isn't getting the proper username for some
reason. I also tried the same SPAMDOPTIONS without the
--username=vpopmail option, and it still came up with a username of
vpopmail (since that is the user that calls spamc, I belive).
 

I use:
preline /usr/bin/spamc -s 1000 -u [EMAIL PROTECTED]
Works like a charm for me.
Hope that helps,
Nick Harring
Webley Systems


Re: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Rick Macdougall

Alexandre Ricardo Souza Silva wrote:
Hello, Rick.
I have installed zlip-1.1.4.8-i3386.rpm, this pocota I cannot be installed?
waiting a brief return.
- Original Message - 
From: "Rick Macdougall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 08, 2004 8:13 PM
Subject: Re: [vchkpw] Vpopmail 5.4.5
   gcc  -g -O2 -Wall   -o vchkpw  vchkpw.o md5.o hmac_md5.o
libvpopmail.a -L/usr/lib/mysql  -lmysqlclient -lz -lm -lcrypt
   /usr/bin/ld: cannot find -lz
   collect2: ld returned 1 exit status

Hi,
A little googling found that zlib-devel should also be installed (Sorry, 
I don't/won't run RedHat)

Regards,
Rick


Re: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Jeremy Kitchen
On Thursday 08 July 2004 07:01 pm, Alexandre Ricardo Souza Silva wrote:
> Hello, Rick.
> I have installed zlip-1.1.4.8-i3386.rpm, this pocota I cannot be installed?
> waiting a brief return.

try zlib-devel

-Jeremy

-- 
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc.
  [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l
kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail



Re: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Alexandre Ricardo Souza Silva
Hello, Rick.
I have installed zlip-1.1.4.8-i3386.rpm, this pocota I cannot be installed?
waiting a brief return.

_
Alexandre Ricardo S.Silva
Network Administrator & Security Analist
Central On Line ( Tornero & Cia )
Componentizar ( Componentizar )
Fone: 11-5070-6796

- Original Message - 
From: "Rick Macdougall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 08, 2004 8:13 PM
Subject: Re: [vchkpw] Vpopmail 5.4.5


> Alexandre Ricardo Souza Silva wrote:
>
>
> > gcc  -g -O2 -Wall   -o vchkpw  vchkpw.o md5.o hmac_md5.o
libvpopmail.a -L/usr/lib/mysql  -lmysqlclient -lz -lm -lcrypt
> > /usr/bin/ld: cannot find -lz
> > collect2: ld returned 1 exit status
>
> Hello,
>
> I believe (but could be mistaken) that -lz is going to look for zlib.
> Did you install the rpm package for zlib ?
>
> Regards,
>
> Rick
>
>



Re: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Rick Macdougall
Alexandre Ricardo Souza Silva wrote:

gcc  -g -O2 -Wall   -o vchkpw  vchkpw.o md5.o hmac_md5.o libvpopmail.a 
-L/usr/lib/mysql  -lmysqlclient -lz -lm -lcrypt
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
Hello,
I believe (but could be mistaken) that -lz is going to look for zlib. 
Did you install the rpm package for zlib ?

Regards,
Rick


Re: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Alexandre Ricardo Souza Silva



Remo
 
    Still nao I made this, you could order an example to me of as I 
make to add I twirled comnado ldconfig - v and vi configurations Waiting a brief 
return
 
/usr/lib/mysql:
    libmysqlclient_r.so.10 
-> libmysqlclient_r.so.10.0.0    
libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
_Alexandre Ricardo S.SilvaNetwork 
Administrator & Security AnalistCentral On Line ( Tornero & Cia 
)Componentizar ( Componentizar )Fone: 11-5070-6796

  - Original Message - 
  From: 
  Remo Mattei 
  To: [EMAIL PROTECTED] 
  Sent: Thursday, July 08, 2004 7:29 
  PM
  Subject: RE: [vchkpw] Vpopmail 
5.4.5
  
  did u try to add the libmysql for vpopmail to your 
  ldconfig?
   
  Remo
  


From: Alexandre Ricardo Souza Silva 
[mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 
2004 4:27 PMTo: [EMAIL PROTECTED]Subject: 
[vchkpw] Vpopmail 5.4.5

staff necessary of one he helps 
of you, good I I installed the vpopmail qmail and and mysql 3.23.54 in red 
hat 9,0, the problem that I am having I am in the compilation of vpopmail 
5.4.5 and I do not know as to make it to function, I go to pass as I am 
compiling and the error that this giving Waiting a brief 
return.
 
./configure \
--enable-learn-passwords=y 
\
--enable-auth-logging=y 
\
--enable-clear-passwd=n  
\
--enable-valias=y  \
--enable-mysql-logging=y 
\
--enable-auth-module=mysql 
\
--enable-qmail-ext=y 
\
--enable-vpopuser=vpopmail 
\
--enable-vpopgroup=vchkpw
vpopmail 
5.4.5    
Current settings---
 
vpopmail directory = 
/home/vpopmail   
uid = 
508   
gid = 503 roaming users = OFF 
--disable-roaming-users (default) password learning = ON  
--enable-learn-passwords md5 passwords = 
ON  --enable-md5-passwords (default)  
file locking = ON  --enable-file-locking (default)vdelivermail 
fsync = OFF --disable-file-sync (default) make 
seekable = ON  --enable-make-seekable 
(default)  clear passwd = OFF 
--disable-clear-passwd user dir hashing  = ON  
--enable-users-big-dir (default)address extensions = ON  
--enable-qmail-ext  
ip alias = OFF --disable-ip-alias-domains 
(default) domain quotas = OFF 
--disable-domainquotas (default)
 auth module = mysql 
--enable-auth-module=mysql mysql replication = OFF 
--disable-mysql-replication (default) mysql 
logging = ON  --enable-mysql-logging  
mysql limits = OFF --disable-mysql-limits 
(default)  MySQL valias = ON  
--enable-valias  
auth inc = 
-I/usr/include/mysql  
auth lib = -L/usr/lib/mysql  -lmysqlclient -lz -lm  system 
passwords = OFF --disable-passwd 
(default)    pop syslog = show 
only failed 
attempts 
--enable-logging=e (default)  auth logging 
= ON  --enable-auth-logging (default)all domains in one SQL table = 
--enable-many-domains (default)
 
make
 
Erro:
 
 
gcc  -g -O2 -Wall   -o vchkpw  vchkpw.o md5.o 
hmac_md5.o libvpopmail.a -L/usr/lib/mysql  -lmysqlclient -lz -lm 
-lcrypt/usr/bin/ld: cannot find -lzcollect2: ld returned 1 exit 
statusmake[2]: *** [vchkpw] Error 1make[2]: Leaving directory 
`/usr/src/qmailrocks/vpopmail-5.4.5'make[1]: *** [all-recursive] Error 
1make[1]: Leaving directory 
`/usr/src/qmailrocks/vpopmail-5.4.5'make: *** [all] Error 2
 
Waiting a brief return
 
 
_Alexandre Ricardo S.SilvaNetwork 
Administrator & Security AnalistCentral On Line ( Tornero & Cia 
)Componentizar ( Componentizar )Fone: 
  11-5070-6796


RE: [vchkpw] Vpopmail 5.4.5

2004-07-08 Thread Remo Mattei



did u try to add the libmysql for vpopmail to your 
ldconfig?
 
Remo

  
  
  From: Alexandre Ricardo Souza Silva 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 
  2004 4:27 PMTo: [EMAIL PROTECTED]Subject: [vchkpw] 
  Vpopmail 5.4.5
  
  staff necessary of one he helps 
  of you, good I I installed the vpopmail qmail and and mysql 3.23.54 in red hat 
  9,0, the problem that I am having I am in the compilation of vpopmail 5.4.5 
  and I do not know as to make it to function, I go to pass as I am compiling 
  and the error that this giving Waiting a brief return.
   
  ./configure \
  --enable-learn-passwords=y 
  \
  --enable-auth-logging=y 
  \
  --enable-clear-passwd=n  
  \
  --enable-valias=y  \
  --enable-mysql-logging=y 
  \
  --enable-auth-module=mysql 
  \
  --enable-qmail-ext=y 
  \
  --enable-vpopuser=vpopmail 
  \
  --enable-vpopgroup=vchkpw
  vpopmail 
  5.4.5    
  Current settings---
   
  vpopmail directory = 
  /home/vpopmail   
  uid = 
  508   
  gid = 503 roaming users = OFF 
  --disable-roaming-users (default) password learning = ON  
  --enable-learn-passwords md5 passwords = ON  
  --enable-md5-passwords (default)  file 
  locking = ON  --enable-file-locking (default)vdelivermail fsync = OFF 
  --disable-file-sync (default) make seekable = 
  ON  --enable-make-seekable (default)  
  clear passwd = OFF --disable-clear-passwd user dir hashing  = 
  ON  --enable-users-big-dir (default)address extensions = ON  
  --enable-qmail-ext  
  ip alias = OFF --disable-ip-alias-domains 
  (default) domain quotas = OFF 
  --disable-domainquotas (default)
   auth module = mysql 
  --enable-auth-module=mysql mysql replication = OFF 
  --disable-mysql-replication (default) mysql 
  logging = ON  --enable-mysql-logging  
  mysql limits = OFF --disable-mysql-limits 
  (default)  MySQL valias = ON  
  --enable-valias  auth 
  inc = 
  -I/usr/include/mysql  
  auth lib = -L/usr/lib/mysql  -lmysqlclient -lz -lm  system 
  passwords = OFF --disable-passwd 
  (default)    pop syslog = show only 
  failed 
  attempts 
  --enable-logging=e (default)  auth logging = 
  ON  --enable-auth-logging (default)all domains in one SQL table = 
  --enable-many-domains (default)
   
  make
   
  Erro:
   
   
  gcc  -g -O2 -Wall   -o vchkpw  vchkpw.o md5.o 
  hmac_md5.o libvpopmail.a -L/usr/lib/mysql  -lmysqlclient -lz -lm 
  -lcrypt/usr/bin/ld: cannot find -lzcollect2: ld returned 1 exit 
  statusmake[2]: *** [vchkpw] Error 1make[2]: Leaving directory 
  `/usr/src/qmailrocks/vpopmail-5.4.5'make[1]: *** [all-recursive] Error 
  1make[1]: Leaving directory `/usr/src/qmailrocks/vpopmail-5.4.5'make: 
  *** [all] Error 2
   
  Waiting a brief return
   
   
  _Alexandre Ricardo S.SilvaNetwork 
  Administrator & Security AnalistCentral On Line ( Tornero & Cia 
  )Componentizar ( Componentizar )Fone: 
11-5070-6796


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-29 Thread François Wautier
Hi,

> I see. You said, in your previous message:
> "The code in vpopmail was first trying to connect to the server for a given
> database. If that was failing, it would try the server only and if that
> succeeded, it was considering that the server was fine but that the DB was
> not created."
>
> So, wouldnt it be safer to consider the second try, if it succeeds? Sorry,
> I dont understand why consider that the database was not created only
> because it took 2 tries to connect to the database.

The way the program before patch was working was

if(openDB( Host, Database) != OK) {
if(openDB(Host) == OK) {
create database
}
}

After the patch it is

if(openDB(Host) != OK) {
return "Can not connect"
}

if(useDB(Database) != OK) {
create database
}

A trivial patch really.

In the pre-patch case, if the first "openDB" fails, it could be because the DB 
is not available...And it goes downhill from there

Best Regards,
François


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-29 Thread Jean Wainer
On Tue, 29 Jun 2004 08:34:30 +0700
François Wautier <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> The patch applies does not solve the underlying problem, the fact that you 
> cannot connect to the DB server. It just makes sure the system behaves > properly 
> even when one cannot access the DB.

I see. You said, in your previous message:
"The code in vpopmail was first trying to connect to the server for a given database. 
If that was failing, it would try the server only and if that succeeded, it was 
considering that the server was fine but that the DB was not created."

So, wouldnt it be safer to consider the second try, if it succeeds? Sorry, I dont 
understand why consider that the database was not created only because it took 2 tries 
to connect to the database.

> In the case of email delivery, proper behaviour means that the message is put 
> back into the queue for later delivery.
Right.

> In other cases, proper behaviour may means that the system complains it does 
> not know your user. I do not know.
Yes, that's actually whats happening. Specially for Outlook users who keep getting a 
request for their password (using Sylpheed, in my case, I can see the "database does 
not exist" error).

> Now that I think about it, that could be the problem I am having. When using 
> IMP-Courier imap-vpopmail  some of my users need to login many times. It 
> could be that, because of the problem, authentication fails and they have to 
> loggin again.
Yes, it happes with me using courier + squirrelmail too.


thanks!

--Jw.
> 
> Best Regards,
>   François
> 
> 
> 
> 
> l
> > On Mon, 28 Jun 2004 21:54:55 +0700
> >
> > François Wautier <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > Since I submitted that patch.. I guess I should answer.
> > >
> > > The code in vpopmail was first trying to connect to the server for a
> > > given database. If that was failing, it would try the server only and if
> > > that succeeded, it was considering that the server was fine but that the
> > > DB was not created.
> > >
> > > Apparently, under some load, it could happen that the first request would
> > > fail, but the second would be accepted...
> > >
> > > All the patch does is make the code connect to the server first and then
> > > use the Database. If the first call fails, the delivery fails (temporary
> > > failure) and the message is delivered later.
> > >
> > > Cheers,
> > >   François
> >
> > Thanks for the explanation, François :)
> >
> > I was having this problem, not only when delivering messages, but specially
> > when checking POP3 mail (vchkpw). Will that be fixed too? Or am I going to
> > get a different error? Also, using Antonio Nati's qmail-smtpd-chkusr patch
> > (as in http://www.interazioni.it/qmail/qmail-smtpd-chkusr-10.html), what
> > will be the effect with the new corrected mysql patch? I was getting some
> > "no such user" errors before...
> >
> > thanks!
> >
> > Jean
> 


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-28 Thread François Wautier
Hi,

The patch applies does not solve the underlying problem, the fact that you 
cannot connect to the DB server. It just makes sure the system behaves 
properly even when one cannot access the DB.

In the case of email delivery, proper behaviour means that the message is put 
back into the queue for later delivery.  

In other cases, proper behaviour may means that the system complains it does 
not know your user. I do not know.

Now that I think about it, that could be the problem I am having. When using 
IMP-Courier imap-vpopmail  some of my users need to login many times. It 
could be that, because of the problem, authentication fails and they have to 
loggin again.

Best Regards,
François




l
> On Mon, 28 Jun 2004 21:54:55 +0700
>
> François Wautier <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Since I submitted that patch.. I guess I should answer.
> >
> > The code in vpopmail was first trying to connect to the server for a
> > given database. If that was failing, it would try the server only and if
> > that succeeded, it was considering that the server was fine but that the
> > DB was not created.
> >
> > Apparently, under some load, it could happen that the first request would
> > fail, but the second would be accepted...
> >
> > All the patch does is make the code connect to the server first and then
> > use the Database. If the first call fails, the delivery fails (temporary
> > failure) and the message is delivered later.
> >
> > Cheers,
> > François
>
> Thanks for the explanation, François :)
>
> I was having this problem, not only when delivering messages, but specially
> when checking POP3 mail (vchkpw). Will that be fixed too? Or am I going to
> get a different error? Also, using Antonio Nati's qmail-smtpd-chkusr patch
> (as in http://www.interazioni.it/qmail/qmail-smtpd-chkusr-10.html), what
> will be the effect with the new corrected mysql patch? I was getting some
> "no such user" errors before...
>
> thanks!
>
> Jean


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-28 Thread Jean Wainer
On Mon, 28 Jun 2004 21:54:55 +0700
François Wautier <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> Since I submitted that patch.. I guess I should answer.
> 
> The code in vpopmail was first trying to connect to the server for a given 
> database. If that was failing, it would try the server only and if that 
> succeeded, it was considering that the server was fine but that the DB was 
> not created.
> 
> Apparently, under some load, it could happen that the first request would 
> fail, but the second would be accepted... 
> 
> All the patch does is make the code connect to the server first and then use 
> the Database. If the first call fails, the delivery fails (temporary failure) 
> and the message is delivered later.
> 
> Cheers,
>   François


Thanks for the explanation, François :)

I was having this problem, not only when delivering messages, but specially when 
checking POP3 mail (vchkpw). Will that be fixed too? Or am I going to get a different 
error?
Also, using Antonio Nati's qmail-smtpd-chkusr patch (as in 
http://www.interazioni.it/qmail/qmail-smtpd-chkusr-10.html), what will be the effect 
with the new corrected mysql patch? I was getting some "no such user" errors before...

thanks!

Jean


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-28 Thread François Wautier
Hi,

Since I submitted that patch.. I guess I should answer.

The code in vpopmail was first trying to connect to the server for a given 
database. If that was failing, it would try the server only and if that 
succeeded, it was considering that the server was fine but that the DB was 
not created.

Apparently, under some load, it could happen that the first request would 
fail, but the second would be accepted... 

All the patch does is make the code connect to the server first and then use 
the Database. If the first call fails, the delivery fails (temporary failure) 
and the message is delivered later.

Cheers,
François


> On Fri, 25 Jun 2004 18:17:53 -0700
>
> Tom Collins <[EMAIL PROTECTED]> wrote:
> > http://vpopmail.sf.net
> >
> > Release Notes:
> >
> > There are significant changes in here for MySQL and Postgres backends.
> >
> > If you've had errors stating "couldn't create table/database because it
> > already exists" with MySQL, you should definitely upgrade.
>
> Well, I was having such errors with 5.4.3, and I did upgrade. It seems to
> be working fine, now. I noticed that this error occured only with the
> server under heavy load (over 8, 10). Since it is fixed now in 5.4.5, I
> have a question out of curiosity: What was the bug that was causing this
> error?
>
> Thanks,
>
> Jean


Re: [vchkpw] Vpopmail 5.4.5 released

2004-06-28 Thread Jean Wainer
On Fri, 25 Jun 2004 18:17:53 -0700
Tom Collins <[EMAIL PROTECTED]> wrote:

> http://vpopmail.sf.net
> 
> Release Notes:
> 
> There are significant changes in here for MySQL and Postgres backends.
> 
> If you've had errors stating "couldn't create table/database because it
> already exists" with MySQL, you should definitely upgrade.

Well, I was having such errors with 5.4.3, and I did upgrade. It seems to be working 
fine, now.
I noticed that this error occured only with the server under heavy load (over 8, 10). 
Since it is fixed now in 5.4.5, I have a question out of curiosity: What was the bug 
that was causing this error?

Thanks,

Jean