RE: [vchkpw] Smtp Auth with VPopmail

[patrick . liechty]

Title: RE: [vchkpw] Smtp Auth with VPopmail





Ok. I am getting closer to having smtp auth working with qmail and vpopmail.  I patched qmail with the qmail-smtpd-auth-0.4.2 at http://www.fehcom.de/qmail/smtpauth.html.  I upgraded to vpopmail 5.4.0, which has the vchkpw.c patch included.  I have qmail setup in inetd as so:

smtp stream tcp nowait qmaild /var/qmail/bin/tcp-env tcp-env /var/qmail/bin/qmail-smtpd /opt/vpopmail/bin/vchkpw /bin/true

When I try to send a message using Outlook Express to the server, I get this type of logging in syslog:


Feb 12 00:29:44 cssimsp0 vpopmail[17667]: [ID 997931 mail.notice] vchkpw-smtp: vpopmail user not found [EMAIL PROTECTED]:10.31.4.134

It says it can't find the user.  Any ideas why it can't find that user.  I know that user is setup with that domain(aurum-email.net).

I appreciate the help since I am under a tight deadline.



-Original Message-
From: Tom Collins [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 11, 2004 10:20 AM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Smtp Auth with VPopmail


On Feb 11, 2004, at 8:34 AM, [EMAIL PROTECTED] wrote:
> So if I wanted to set this up in inetd.conf, it would look something 
> like this?
>
> #smtp stream tcp nowait qmaild /var/qmail/bin/tcp-env tcp-env 
> /var/qmail/bin/qmail-smtpd /opt/vpopmail/bin/vchkpw


I'm not sure how you'd set it up in inetd.conf.  Most people set it up 
as a service with tcpserver (see Bill Shupp's excellent toaster guide 
at  for an example).


At the very least, you would need to include "/bin/true" as a final 
parameter to vchkpw.  I don't know if you'd need other changes.


--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/



Notice:  The information contained in this message may be privileged, confidential, and protected from disclosure.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify us immediately by replying to this message, and then delete it from your computer.  All e-mail sent to this address will be received by the Aurum Technology corporate e-mail system and is subject to archiving and review by someone other than the recipient. 

RE: [vchkpw] Eureka! Finished POP3-Frequency-Patch (against brute forcing)

[Anders Brander]

Hi,

On Thu, 2004-02-12 at 04:40, Jake S wrote:
> >> Also, perhaps instead of "you have to wait xx minutes" maybe you can
> >> just list 0 messages.
> > The idea of listing 0 messages (as new) could lead to some support
> > nightmares. A customer consequently using the wrong password, and there
> > is no sign that anything is wrong - or worse, some third malicious part
> > causing this.
> I'm not seeing your logic if a user has made it to checking their
> inbox then the credentials would have already been checked via vchkpw,
> correct or not and the appropriate errors would be listed.

Oh i see - I thought you meant it should return "0 new messages" for bad
user/password - but you actually meant "0 new messages" as response to
correct user/password, but only after x failed tries?

> Also, with a timeout error code your bound to get support calls asking if
> you can bend the rules for that user because they have a "very" important
> message (usually larger penis ads) verses you simply say no new messages
> and no one knows the difference.

If you just say no new messages, it can go on for month without the user
knowing it. It only takes one malicous attacker x failed authentication
attempt every y minutes to effectively suspend mail delivery.

And instead you will receive support calls/emails that goes like "I NEED
THAT EMAIL NOW!!! MY CLIENT SENT IT LIKE 20 YEARS AGO, AND IT STILL
ISN'T HERE!!! SOMETHING IS WACKED WITH YOU PEOPLE!!" (Yep, smile! :-))

/Anders

RE: [vchkpw] Eureka! Finished POP3-Frequency-Patch (against brute forcing)

[Jake S]

Anders Brander said:
> Hi,
>
> On Thu, 2004-02-12 at 02:15, Jake S wrote:
>> Also, perhaps instead of "you have to wait xx minutes" maybe you can
>> just
>> list 0 messages.
>
> The idea of listing 0 messages (as new) could lead to some support
> nightmares. A customer consequently using the wrong password, and there
> is no sign that anything is wrong - or worse, some third malicious part
> causing this.
>
> /Anders
>
>
>
Anders.
I'm not seeing your logic if a user has made it to checking their
inbox then the credentials would have already been checked via vchkpw,
correct or not and the appropriate errors would be listed.

Also, with a timeout error code your bound to get support calls asking if
you can bend the rules for that user because they have a "very" important
message (usually larger penis ads) verses you simply say no new messages
and no one knows the difference.

Just some thoughts

Either way I'd like to see that patch!


Thank you,
Jake S

Re: [vchkpw] vadddomain + mysql replication segfault

[Jeremy Kitchen]

On Wed, 2004-02-11 at 20:38, Jeremy Kitchen wrote:
> I'm going to post this, as well as the problem I found the other day to
> the vpopmail sourceforge page in just a little bit.

done:

vadduser -s bug:
https://sourceforge.net/tracker/index.php?func=detail&aid=895375&group_id=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 know exactly when I'll have the chance to set up 
-Jeremy

-- 
Jeremy Kitchen
Systems Administrator
[EMAIL PROTECTED]
Kitchen @ #qmail on EFNet - Join the party!
.
Inter7 Internet Technologies, Inc.
www.inter7.com
866.528.3530 toll free
847.492.0470 int'l
847.492.0632 fax
GNUPG key ID: 93BDD6CE
-- 
Jeremy Kitchen <[EMAIL PROTECTED]>

[vchkpw] vadddomain + mysql replication segfault

[Jeremy Kitchen]

./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
not existing (the database does, and proper permissions and stuff) which
is why I tried example.com, but that gave me the same problem.

I'd post full details but it was on a customer's machine, and I don't
have the time right this moment to set up a test bed to reproduce the
problem with arbitrary information, and I don't want to submit modified
strace output or anything.

vpopmail 5.4.0, redhat9
# rpm -qa | grep -i mysql
mysql-devel-3.23.58-1.9
MySQL-client-4.0.17-0
MySQL-server-4.0.17-0
MySQL-shared-4.0.17-0
perl-DBD-MySQL-2.1021-3
MySQL-shared-compat-4.0.17-0
(all of those rpms are from the mysql.com site)

Like I said, it appears everything worked it just segfaulted.

I'm going to post this, as well as the problem I found the other day to
the vpopmail sourceforge page in just a little bit.

-Jeremy

-- 
Jeremy Kitchen
Systems Administrator
[EMAIL PROTECTED]
Kitchen @ #qmail on EFNet - Join the party!
.
Inter7 Internet Technologies, Inc.
www.inter7.com
866.528.3530 toll free
847.492.0470 int'l
847.492.0632 fax
GNUPG key ID: 93BDD6CE

Re: [vchkpw] covert from vpasswd to mysql problems

[Tom Collins]

On Feb 11, 2004, at 4:56 PM, Dave Lewis wrote:
That's what I would have thought, but I double checked everything.

In the end it looks like my courier was the problem. I downloaded
the latest one and recompiled it and things are working again
Go Figure.
Did you follow the advice at the start of the UPGRADE file in vpopmail?

---
REMINDER:
When recompiling vpopmail, you need to recompile all binaries that link
into the vpopmail libraries.  These include QmailAdmin, qmail-smtpd (if
you have the chkuser patch applied), Courier-IMAP etc.
---
--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/

RE: [vchkpw] Heureka! Finished POP3-Frequency-Patch (against bruteforcing)

[Anders Brander]

Hi,

On Thu, 2004-02-12 at 02:15, Jake S wrote:
> Also, perhaps instead of "you have to wait xx minutes" maybe you can just
> list 0 messages. 

The idea of listing 0 messages (as new) could lead to some support
nightmares. A customer consequently using the wrong password, and there
is no sign that anything is wrong - or worse, some third malicious part
causing this.

/Anders

Re: [vchkpw] Heureka! Finished POP3-Frequency-Patch (against bruteforcing)

[Anders Brander]

Hi,

On Thu, 2004-02-12 at 01:21, knom wrote:
> I finished the Patch forqmail-pop3d which doesn't allow more then xx logins
> every yy seconds.

Please see my post to the sourceforge tracker [874660]. Can we see the
patch anywhere?

> If you log in more often then eg. 10 times in 5 minutes you get an error
> message which says, that you have to wait xx minutes until relogin.
> Thats quite good against pop3 bruteforcing, I think !

- and, not to nitpick - but imho it's a bad idea to show the timeout. It
would be a handy tool for DOS'ers. They could easily optimize the attack
specific to your site.

/Anders

RE: [vchkpw] Heureka! Finished POP3-Frequency-Patch (against bruteforcing)

[Jake S]

-Original Message-
From: knom [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 11, 2004 4:21 PM
To: [EMAIL PROTECTED]
Subject: [vchkpw] Heureka! Finished POP3-Frequency-Patch (against
bruteforcing)

Hi!
I finished the Patch forqmail-pop3d which doesn't allow more then xx logins
every yy seconds.
(As some of you may know from GMX.net)
If you log in more often then eg. 10 times in 5 minutes you get an error
message which says, that you have to wait xx minutes until relogin.
Thats quite good against pop3 bruteforcing, I think !

If anybody is interested in how including this feature, please write me !

Thanks, knom.


Are you throttling connections by IP address or by username/passwords?

Also, perhaps instead of "you have to wait xx minutes" maybe you can just
list 0 messages. 

Jake

[vchkpw] Heureka! Finished POP3-Frequency-Patch (against bruteforcing)

[knom]

Hi!
I finished the Patch forqmail-pop3d which doesn't allow more then xx logins
every yy seconds.
(As some of you may know from GMX.net)
If you log in more often then eg. 10 times in 5 minutes you get an error
message which says, that you have to wait xx minutes until relogin.
Thats quite good against pop3 bruteforcing, I think !

If anybody is interested in how including this feature, please write me !

Thanks, knom.

Re: [vchkpw] vpopmail intermittent auth problems

[Dana Ducharme]

I upgraded to 5.2.2, but I am still having the same problem.  I also 
tried to recompile sqwebmail without authdeamon, but I'm still only 
getting in about half the time and it still looks like it's using 
authdeamon.  What alternative is there to use with virtual accounts?  
Do I need to recompile with some thing else to authenticate?

again I'm using:
qmail 1.03
qmailadmin-1.0.6
vpopmail-5.2.2
vqadmin-2.3.2
sqwebmail-3.5.3


On Feb 10, 2004, at 4:22 PM, Tom Collins wrote:

On Feb 10, 2004, at 2:07 PM, Dana Ducharme wrote:
I am having intermittent authentication problems with sqwebmail.  
About 80% of the time, things work correctly, however, every now and 
again I will not be able to authenticate until I restart the 
authdeamon, then things are fine again... at least for a while.
Try using vpopmail 5.2.2, as it corrects many bugs in 5.2.1.

You might also be interested in 5.4.0 which was just recently released.

http://vpopmail.sf.net/

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: 
http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/



Dana Ducharme
[EMAIL PROTECTED]
Glen Group
www.glengroup.com

Re: [vchkpw] covert from vpasswd to mysql problems

[Dave Lewis]

That's what I would have thought, but I double checked everything.

In the end it looks like my courier was the problem. I downloaded
the latest one and recompiled it and things are working again
Go Figure.
weird... oh well :) one project down many to go :)

thanks for the reply

Dave

At 05:36 AM 2/11/2004, Andrew Averin wrote:
Hello Dave,

Wednesday, February 11, 2004, 1:14:09 PM, you wrote:

DL> Hey, I'm sure this is something really stupid.. but
DL> I am trying to convert from vpasswd to mysql authentication
DL> I've hit a road block.
DL> here's what I've done

DL> installed vpopmail 5.4.0 (was actually an upgrade too from my existing 
version)

DL> ./configure--disable-roaming-users  --enable-logging=p
DL> --disable-ip-alias-domains
DL> --disable-passwd   --enable-clear-passwd
DL> --disable-domain-quotas
DL> --enable-auth-module=mysql 
--disable-many-domains
DL> --enable-auth-logging
DL> --enable-mysql-logging   --enable-valias
DL> --disable-mysql-limits

DL> make && make install strip

DL> I change teh vpopmail.msql file and add the tables and permissions..

DL> I then do a vconvert on my existing domains and bang... they're in the
DL> database
DL> (so that's all working in theory)
DL> then I go to try to get mail.. setup a dummy account on OutXpress, and it
DL> won't log in
DL> so I check my maillog files.. and I see this..
DL> Feb 11 04:41:37 mail pop3d: Connection, ip=[:::10.10.10.20]
DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server 
Access
DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES) with
DL> database
DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server 
Access
DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES)
DL> Feb 11 04:41:42 mail pop3d: LOGIN FAILED, ip=[:::10.10.10.20]

DL> now.. that's not the username i'm using... so where would it be coming 
from..

DL> I'm using qmail and courier for my pop/imap connections..

DL> as I say.. must be something stupid but I can't for the life of me 
think what..

DL> Suggestions would be greatly appreciated..

DL> Thanks

DL> Dave



IMHO it's all up to MySQL permissions. Just let localhost(if vpomail
and mysql on the same machine) to connect to database in "user" or
"host" table, and check passwords for user vpopmailaccount in mysql
"user" table. It must be the same as you choose when compiled
vpopmail.
--
Best regards,
 Andrewmailto:[EMAIL PROTECTED]

RE: [vchkpw] 5.40 configure errors

[patrick . liechty]

Title: RE: [vchkpw] 5.40 configure errors





I did as you said and configure completed successfully.


Thanks.


-Original Message-
From: Tom Collins [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 11, 2004 2:27 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] 5.40 configure errors


On Feb 11, 2004, at 11:26 AM, [EMAIL PROTECTED] wrote:
> I am trying to compile Vpopmail 5.40 on Solaris 9 Intel.  I am getting 
> configure errors.  I tried running configure with version 5.21 and it 
> works fine.  It looks like the new version uses C++ instead of just 
> C.  Here are the errors:


Actually, we don't use C++.


Can you try removing the line "AC_PROG_CXX" from your configure.in, 
then run autoconf to recreate configure.  After that, run configure and 
see whether you still get that error.


Let me know if it solves the problem and I'll update the master source 
tree.


--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/



Notice:  The information contained in this message may be privileged, confidential, and protected from disclosure.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify us immediately by replying to this message, and then delete it from your computer.  All e-mail sent to this address will be received by the Aurum Technology corporate e-mail system and is subject to archiving and review by someone other than the recipient. 

Re: [vchkpw] 5.40 configure errors

[Tom Collins]

On Feb 11, 2004, at 11:26 AM, [EMAIL PROTECTED] wrote:
I am trying to compile Vpopmail 5.40 on Solaris 9 Intel.  I am getting 
configure errors.  I tried running configure with version 5.21 and it 
works fine.  It looks like the new version uses C++ instead of just 
C.  Here are the errors:
Actually, we don't use C++.

Can you try removing the line "AC_PROG_CXX" from your configure.in, 
then run autoconf to recreate configure.  After that, run configure and 
see whether you still get that error.

Let me know if it solves the problem and I'll update the master source 
tree.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/

[vchkpw] 5.40 configure errors

[patrick . liechty]

I am trying to compile Vpopmail 5.40 on Solaris 9
Intel.  I am getting configure
errors.  I tried running configure
with version 5.21 and it works fine. 
It looks like the new version uses C++ instead of just C.  Here are the errors:

 

Bash-2.05# ./configure  --prefix=/opt/vpopmail
--enable-logging=y

checking for a
BSD-compatible install... /usr/bin/ginstall -c

checking whether
build environment is sane... yes

checking for gawk...
gawk

checking whether
make sets ${MAKE}... yes

checking build
system type... i386-pc-solaris2.9

checking host system
type... i386-pc-solaris2.9

checking for g++...
g++

checking for C++
compiler default output... a.out

checking whether the
C++ compiler works... configure: error: cannot run C++ compiled programs.

If you meant to cross compile, use `--host'.

 

Patrick Liechty 

 









Notice:  The information contained in this message may be privileged, confidential, and protected from disclosure.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify us immediately by replying to this message, and then delete it from your computer.  All e-mail sent to this address will be received by the Aurum Technology corporate e-mail system and is subject to archiving and review by someone other than the recipient. 

Re: [vchkpw] Smtp Auth with VPopmail

[Tom Collins]

On Feb 11, 2004, at 8:34 AM, [EMAIL PROTECTED] wrote:
So if I wanted to set this up in inetd.conf, it would look something 
like this?

#smtp stream tcp nowait qmaild /var/qmail/bin/tcp-env tcp-env 
/var/qmail/bin/qmail-smtpd /opt/vpopmail/bin/vchkpw
I'm not sure how you'd set it up in inetd.conf.  Most people set it up 
as a service with tcpserver (see Bill Shupp's excellent toaster guide 
at  for an example).

At the very least, you would need to include "/bin/true" as a final 
parameter to vchkpw.  I don't know if you'd need other changes.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/

[vchkpw] important Postgres patches (was: Segment Fault Clearopenrelay)

[Tom Collins]

On Feb 11, 2004, at 12:41 AM, Vpopmail Mailinglist wrote:
im using qmail,vpopmail 5.4.0 and psql. Im using pop before Smtp but it
don't work.. The Ips get in the Database in a Table called relay but  
the
table is not readed ( i think so) by tcpserver so it knows who is
allowed to send email. When i do a
'/var/qmail/vpopmail/bin/clearopensmtp' i get a 'Segment Fault'. i have
monitor it with strace ..
This tracker item on SourceForge has two patches for Postgres that fix  
significant problems:

http://sourceforge.net/tracker/index.php? 
func=detail&aid=892595&group_id=85937&atid=577798

After the patches, clearopensmtp should work, and using a valias table  
should work as well.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/

RE: [vchkpw] Smtp Auth with VPopmail

[patrick . liechty]

Title: RE: [vchkpw] Smtp Auth with VPopmail





So if I wanted to set this up in inetd.conf, it would look something like this?


#smtp stream tcp nowait qmaild /var/qmail/bin/tcp-env tcp-env /var/qmail/bin/qmail-smtpd /opt/vpopmail/bin/vchkpw


-Original Message-
From: Tom Collins [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 11, 2004 12:35 AM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Smtp Auth with VPopmail


On Feb 10, 2004, at 11:26 PM, [EMAIL PROTECTED] wrote:
> Is anyone using an smtp auth solution with vchkpw authentication?  Or, 
> can you point me in a good direction.  I have looked at all the smtp 
> auth solutions on the qmail.org site.  None of them seem to support 
> vchkpw.  Any help would be appreciated.
>
> If there isn't a good smtp auth solution, is there a good pop before 
> smtp solution?  I don't want to be a spam server. 


The patch on this page:  is 
known to work fine with vpopmail 5.4.0.


I'm pretty sure we even include that patch in the contrib directory of 
5.4.0...


--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter handheld Network Tester: http://sniffter.com/



Notice:  The information contained in this message may be privileged, confidential, and protected from disclosure.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify us immediately by replying to this message, and then delete it from your computer.  All e-mail sent to this address will be received by the Aurum Technology corporate e-mail system and is subject to archiving and review by someone other than the recipient. 

Re: [vchkpw] vmoduser not working

[Teixeira (listas)]

Em Seg, 2004-02-09 às 16:57, Tom Collins escreveu:

> Please try upgrading to 5.4.0.  

Why the page at Inter7 is so old?

Aren't they involved any more?

-- 
[] Mauricio Teixeira - Maceió/AL/Brazil
[] * Este e-mail serve apenas para listas!!! *
[] * This e-mail is for mailing lists only!!! *

Re: [vchkpw] covert from vpasswd to mysql problems

[Andrew Averin]

Hello Dave,

Wednesday, February 11, 2004, 1:14:09 PM, you wrote:

DL> Hey, I'm sure this is something really stupid.. but
DL> I am trying to convert from vpasswd to mysql authentication
DL> I've hit a road block.

DL> here's what I've done

DL> installed vpopmail 5.4.0 (was actually an upgrade too from my existing version)


DL> ./configure--disable-roaming-users  --enable-logging=p 
DL> --disable-ip-alias-domains
DL> --disable-passwd   --enable-clear-passwd 
DL> --disable-domain-quotas
DL> --enable-auth-module=mysql   --disable-many-domains 
DL> --enable-auth-logging
DL> --enable-mysql-logging   --enable-valias 
DL> --disable-mysql-limits

DL> make && make install strip

DL> I change teh vpopmail.msql file and add the tables and permissions..

DL> I then do a vconvert on my existing domains and bang... they're in the 
DL> database
DL> (so that's all working in theory)

DL> then I go to try to get mail.. setup a dummy account on OutXpress, and it 
DL> won't log in
DL> so I check my maillog files.. and I see this..

DL> Feb 11 04:41:37 mail pop3d: Connection, ip=[:::10.10.10.20]
DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access 
DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES) with 
DL> database
DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access 
DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES)
DL> Feb 11 04:41:42 mail pop3d: LOGIN FAILED, ip=[:::10.10.10.20]


DL> now.. that's not the username i'm using... so where would it be coming from..

DL> I'm using qmail and courier for my pop/imap connections..

DL> as I say.. must be something stupid but I can't for the life of me think what..

DL> Suggestions would be greatly appreciated..


DL> Thanks

DL> Dave



IMHO it's all up to MySQL permissions. Just let localhost(if vpomail
and mysql on the same machine) to connect to database in "user" or
"host" table, and check passwords for user vpopmailaccount in mysql
"user" table. It must be the same as you choose when compiled
vpopmail.


-- 
Best regards,
 Andrewmailto:[EMAIL PROTECTED]

[vchkpw] covert from vpasswd to mysql problems

[Dave Lewis]

Hey, I'm sure this is something really stupid.. but
I am trying to convert from vpasswd to mysql authentication
I've hit a road block.
here's what I've done

installed vpopmail 5.4.0 (was actually an upgrade too from my existing version)

./configure--disable-roaming-users  --enable-logging=p 
--disable-ip-alias-domains
	--disable-passwd   --enable-clear-passwd 
--disable-domain-quotas
		--enable-auth-module=mysql   --disable-many-domains 
--enable-auth-logging
	--enable-mysql-logging   --enable-valias 
--disable-mysql-limits

make && make install strip

I change teh vpopmail.msql file and add the tables and permissions..

I then do a vconvert on my existing domains and bang... they're in the 
database
(so that's all working in theory)

then I go to try to get mail.. setup a dummy account on OutXpress, and it 
won't log in
so I check my maillog files.. and I see this..

Feb 11 04:41:37 mail pop3d: Connection, ip=[:::10.10.10.20]
Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access 
denied for user: '[EMAIL PROTECTED]' (Using password: YES) with 
database
Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access 
denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Feb 11 04:41:42 mail pop3d: LOGIN FAILED, ip=[:::10.10.10.20]

now.. that's not the username i'm using... so where would it be coming from..

I'm using qmail and courier for my pop/imap connections..

as I say.. must be something stupid but I can't for the life of me think what..

Suggestions would be greatly appreciated..

Thanks

Dave

[vchkpw] Functions provided by database interfaces

[Rick Widmer]

If you are currious about what is missing from your favorite database
interface take a look here.(I hope the formatting survives!)
This table lists which functions are defined by each of the database
interface modules in vpopmail.  I hope someone else finds it helpful.
 * = full function
 - = empty function
   = not in file
ad  cdb ldapmysql   pgsql   sybase
vclose  *   *   *   *   *   *
ad  cdb ldapmysql   pgsql   sybase  vpalias
valias_select   *   *   *
valias_select_next  *   *   *
valias_select_all   *   *   *
valias_select_all_next  *   *   *
valias_insert   *   *   *
valias_remove   *   *   *
valias_delete   *   *   *
valias_delete_domain*   *
vcreate_valias_table*   *
ad  cdb ldapmysql   pgsql   sybase
vauth_adddomain -   -   *   *   *   *
vauth_adduser   *   *   *   *   *   *
vauth_crypt *   *   *   *   *   *
vauth_deldomain -   -   *   *   *   *
vauth_deluser   *   *   *   *   *   *
vauth_end_getall*   -   *   *   -   -
vauth_getall*   *   *   *   *   *
vauth_getpw *   *   *   *   *   *
vauth_munch_domain  *   *   *
vauth_open  *   *
vauth_setquota  *   *   *   *   *   *
vauth_setpw *   *   *   *   *   *
ad  cdb ldapmysql   pgsql   sybase
vread_dir_control*  *   *   *   *
vwrite_dir_control* *   *   *   *
vdel_dir_control*   *   *   *   *
vcreate_dir_control *   *
ad  cdb ldapmysql   pgsql   sybase
vget_ip_map *   *   *   *   *   -
vadd_ip_map *   *   *   *   *   -
vdel_ip_map *   *   *   *   *   -
vshow_ip_map*   *   *   *   *   -
vcreate_ip_map_table*   *
ad  cdb ldapmysql   pgsql   sybase
vset_lastauth   *   *   *   *   *
vget_lastauth   *   *   *   *   *
vget_lastauthip *   *   *   *   *
vcreate_lastauth_table  *   *
ad  cdb ldapmysql   pgsql   sybase
vclear_open_smpt*   *   *
vcreate_relay_table *   *   *
vmkpasswd   *   -
vcreate_vlog_table  *   *
ad  cdb ldapmysql   pgsql   sybase
ad_openconn *
ad_clean_one*
ad_clean_packet *
ad_fill_vpw *
ad_print_packet *
ad  cdb ldapmysql   pgsql   sybase
make_vpasswd_cdb*
set_vpasswd_file*
vauth_adduser_line  *
vcdb_strip_char *
ad  cdb ldapmysql   pgsql   sybase
vauth_vpasswd   *   *
dc_filename *
vset_lastauth_time  *
compose_dn  *
ldap_connect*
safe_free   *
safe_strdup *
safe_malloc *
ad  cdb ldapmysql   pgsql   sybase  vlimits
load_connection_info*
vauth_open_update   *
vauth_open_read *
vauth_open_read_getall  *
vopen_smtp_relay*
vupdate_rules   *
logmysql*
vmysql_escape   *
vcreate_limits_table*
vget_limits *   *
vset_limits *   *
vdel_limits *   *
ad  cdb ldapmysql   pgsql   sybase
logpgsql*
vpgsql_escape   *
pg_begin*
pg_end  *
ad  cdb ldapmysql   pgsql   sybase
err_handler *
msg_handler *
vauth_adddomain_size*
vauth_adduser_size  *
vauth_getpw_size*
vauth_deldomain_size*
vaut