Re: [vchkpw] MySQL error messages & vpalias.c
Rick Widmer wrote: My travels have finally brought me to the MySQL database module... I am working on improving the error messages returned by vconvert, as part of the process of testing the MySQL back end. The first thing I've noticed is that a number of errors call fprintf(stderr) directly from the extension. I would like to make them record the error in a string, set errori and return the error code where it is apropriate. Then I have to look at the places it is called and update the error handling there. I would prefer to leave the formatting of error messages up to the end user program: ~vpopmail/bin/*, qmailadmin, etc. Any objections? None, code cleanup is always nice :P. I am diving into the source every so often as well for jobs people ask me to do. At first glance, it appers that vpalias.c, vmysql.c and vpgsql.c share common functions. It seems to me that if the code is in vmysql.c and vpgsql.c it should also appear in vcdb.c and vpalias.c should not exist. It looks like there is some ifdef magic going on to hide the code in this file. It seems to me it would be better to add vpalias.c to vcdb.c and add empty function definitions in the other auth back-ends. Ifdefs would remain so you can still switch valias on or off with a ./configure option. Should I move it to cdb.c? Why not? Would be just as easy. Next, there are two programs vconvert and dotqmail2valias that both translate data from file to database, or from database to file. Should I merge the programs into one. Future conversions would then be one step. If the users or aliases have already been converted, you just get duplicate warnings. Merge them? Yes, i was planning on doing this, but i dont have the time. Rick Useless stats on why not to listen to me: 0 patches to vpopmail Just random blabbing :P To busy to do it myself (I still think it needs to be done) X-Istence
[vchkpw] -ERR authorization failed
Hello, I have spent two hours debugging why neither local or virtual users can log into a mail system via pop. I have now found the answer, but it was very obscure and yet obvious. echo '#!/bin/sh' > /var/qmail/supervise/qmail-pop3d/run echo 'PATH=/var/qmail/bin:/usr/local/bin:/usr/bin:/bin' >> /var/qmail/supervise/qmail-pop3d/run echo 'export PATH' >> /var/qmail/supervise/qmail-pop3d/run echo 'exec tcpserver -H -R -v -c100 0 110 qmail-popup '$FQDN' \\' >> /var/qmail/supervise/qmail-pop3d/run echo '/home/vpopmail/bin/vchkpw qmail-pop3d Maildir 2>&1' >> /var/qmail/supervise/qmail-pop3d/run The above is a segment of a script that I use to create the run file. Myself being a C person found it hard to spot the error until I decided to run the tcpserver with logging output to the console so I can see whats going on. The users could then login without problem. So I rebooted. Users could not log in. Then I looked at the process table to see that a '\\' appearing after the domain name. Once I changed the \\ to \ the script was then fine, and no authorization errors!
Re: [vchkpw] valias problem with .qmail-default files
On Wed, 2004-05-05 at 10:29, lola wrote:
> this is a known problem and afaik not solved yet.
Ugh.. I was afraid of that...
> here is my workaround which works for me:
>
> # no | here:
>
> VPOP="/home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
>
> # user xfilter instead of to
>
> xfliter $VPOP
> EXITCODE=0
> exit
So, then, is this correct? :
VPOP="/home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
VHOME=`/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
if (/^X-Spam-Status: *YES/)
{
# try delivering it to a Spam folder
exception {
# Check for an existing Spam folder, create one if it
does not exist
`if [ ! -d "$VHOME/Maildir/.Spam/" ]; \
then \
/usr/bin/maildirmake -f Spam $VHOME/Maildir; \
fi`
# Deliver the message to the Spam folder
xfilter "$VHOME/Maildir/.Spam/"
EXITCODE=0
exit
}
# ah well, I guess they'll just have to live with disappointment
exception {
xfilter "$VPOP"
EXITCODE=0
exit
}
}
else
{
exception {
xfilter "$VPOP"
EXITCODE=0
exit
}
}
--
---
Jason 'XenoPhage' Frisvold
Engine / Technology Programmer
[EMAIL PROTECTED]
RedHat Certified - RHCE # 803004140609871
MySQL Pro Certified - ID# 207171862
MySQL Core Certified - ID# 205982910
---
"Something mysterious is formed, born in the silent void. Waiting alone
and unmoving, it is at once still and yet in constant motion. It is the
source of all programs. I do not know its name, so I will call it the
Tao of Programming."
signature.asc
Description: This is a digitally signed message part
RE: [vchkpw] sending e-mail error
You need to make sure that you have the tcp.smtp.cdb file setup correctly check out the following for more information http://www.palomine.net/qmail/selectiverelay.html I had this problem about a year and a half ago and this worked Michael J. Humphries Alphacomm.net Getting You Connected!!! 906-639-3500 - Carney 906-753-6410 - Stephenson 877-450-3500 - Toll Free www.alphacomm.net -Original Message- From: null [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 5:49 PM To: [EMAIL PROTECTED] Subject: [vchkpw] sending e-mail error Hello folks, I’m having some odd problems with qmail+vpopmail in sending e-mails. I set everything correct in my mail client and I tried first to send e-mails to a mail account in my mail server and it worked just fine, I can log in and receive emails/attachments. When I try to send e-mails I get this error: The message could not be sent because one of the recipients was rejected by the server. Server response: '533 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)'. (Account: 'mail.6s-gaming.com', SMTP Server: 'mail.6s-gaming.com', Error Number: 0x800ccc79). But the odd thing is that a minute later when the mail client tries to send the e-mail (it tries to send e-mails in the error queue) it simply goes just right and e-mail is sent. I tried for 5 minutes sending the e-mail and I kept getting that error over and over but when I idle the client and It tries to send it the mail is sent. INFO: [EMAIL PROTECTED]:/root]: svstat /var/service/* /var/service/pop3d: up (pid 6904) 20121 seconds /var/service/qmail: up (pid 6907) 20121 seconds /var/service/smtpd: up (pid 6906) 20121 seconds /var/service/spamd-service: up (pid 6915) 20121 seconds [EMAIL PROTECTED]:/root]: /usr/local/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: null passwd: -CHUNK- clear passwd: uid: 1 gid: 0 flags: 0 gecos: null limits: No user limits set. dir: /usr/local/vpopmail/domains/6s-gaming.com/null quota: 12345678S usage: 1% last auth: Wed May 5 22:34:45 2004 last auth ip: 81.84.26.99 [EMAIL PROTECTED]:/root]: /usr/local/vpopmail/bin/vdominfo domain: 6s-gaming.com uid: 89 gid: 89 dir: /usr/local/vpopmail/domains/6s-gaming.com users: 2 [EMAIL PROTECTED]:/root]: ps aux | grep qmail root 6902 0.0 0.0 1148 464 p2 IJ 5:07PM 0:00.00 supervise qmail root 6904 0.0 0.0 1176 488 p2 IJ 5:07PM 0:00.03 /usr/local/bin/tcpserver -vDHR -l0 -c200 -xtcp.cdb -- 0 110 /var/qmail/bin/qmail-popup mail.6 qmaill 6905 0.0 0.0 1156 452 p2 IJ 5:07PM 0:00.02 multilog t ./main root 6906 0.0 0.0 1176 476 p2 IJ 5:07PM 0:00.01 /usr/local/bin/tcpserver -vDUHR -lmail.6s-gaming.com -c200 -xtcp.cdb -- 0 25 /var/qmail/bin/q qmails 6907 0.0 0.0 1212 540 p2 IJ 5:07PM 0:00.02 qmail-send qmaill 6908 0.0 0.0 1156 448 p2 IJ 5:07PM 0:00.01 multilog t ./main qmaill 6910 0.0 0.0 1156 448 p2 IJ 5:07PM 0:00.01 multilog t ./main qmaill 6911 0.0 0.0 1156 448 p2 IJ 5:07PM 0:00.01 /usr/local/bin/multilog t /var/log/qmail qmaill root 6912 0.0 0.0 1168 480 p2 IJ 5:07PM 0:00.01 qmail-lspawn ./Maildir/ qmailr 6913 0.0 0.0 1164 460 p2 IJ 5:07PM 0:00.00 qmail-rspawn qmailq 6914 0.0 0.0 1160 476 p2 IJ 5:07PM 0:00.00 qmail-clean root 19279 0.0 0.0 416 208 p2 D+J 10:44PM 0:00.00 grep qmail [EMAIL PROTECTED]:/root]: ps aux | grep vpop vpopmail 6915 0.0 1.2 20532 19092 p2 IJ 5:07PM 0:01.78 /usr/local/bin/perl5.6.1 -T -w /usr/local/bin/spamd -a -c -v -u vpopmail (perl) [EMAIL PROTECTED]:/root]:sockstat –4 vpopmail perl 6915 5 tcp4 213.201.220.29:783 *:* root tcpserver 6906 3 tcp4 213.201.220.29:25 *:* root tcpserver 6904 3 tcp4 213.201.220.29:110 *:* (…) [EMAIL PROTECTED]:/root]: Thanks for all the help that comes! Rgs, Alex
[vchkpw] MySQL / LDAP
Can someone direct me to a descent site that compares or details how to install LDAP and/or MySQL with Qmail please?
Re: [vchkpw] valias problem with .qmail-default files
using xfilter without the " " works for me.
lola
> Von: Jason 'XenoPhage' Frisvold <[EMAIL PROTECTED]>
> Antworten an: [EMAIL PROTECTED]
> Datum: Thu, 06 May 2004 06:26:22 -0400
> An: [EMAIL PROTECTED]
> Betreff: Re: [vchkpw] valias problem with .qmail-default files
>
> On Wed, 2004-05-05 at 10:29, lola wrote:
>> this is a known problem and afaik not solved yet.
>
> Ugh.. I was afraid of that...
>
>> here is my workaround which works for me:
>>
>> # no | here:
>>
>> VPOP="/home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
>>
>> # user xfilter instead of to
>>
>> xfliter $VPOP
>> EXITCODE=0
>> exit
>
> So, then, is this correct? :
>
> VPOP="/home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
> VHOME=`/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
>
> if (/^X-Spam-Status: *YES/)
> {
> # try delivering it to a Spam folder
> exception {
> # Check for an existing Spam folder, create one if it
> does not exist
> `if [ ! -d "$VHOME/Maildir/.Spam/" ]; \
> then \
> /usr/bin/maildirmake -f Spam $VHOME/Maildir; \
> fi`
> # Deliver the message to the Spam folder
> xfilter "$VHOME/Maildir/.Spam/"
> EXITCODE=0
> exit
> }
> # ah well, I guess they'll just have to live with disappointment
> exception {
> xfilter "$VPOP"
> EXITCODE=0
> exit
> }
> }
> else
> {
> exception {
> xfilter "$VPOP"
> EXITCODE=0
> exit
> }
> }
>
>
>
> --
> ---
> Jason 'XenoPhage' Frisvold
> Engine / Technology Programmer
> [EMAIL PROTECTED]
> RedHat Certified - RHCE # 803004140609871
> MySQL Pro Certified - ID# 207171862
> MySQL Core Certified - ID# 205982910
> ---
> "Something mysterious is formed, born in the silent void. Waiting alone
> and unmoving, it is at once still and yet in constant motion. It is the
> source of all programs. I do not know its name, so I will call it the
> Tao of Programming."
>
[vchkpw] -ERR this user has no $HOME/Maildir
I do have a $HOME/Maildir, I don't know why Im getting this error, does the error mean anything to anyone?
Re: [vchkpw] valias problem with .qmail-default files
lola said: > using xfilter without the " " works for me. *Doh* .. :) My biggest concern is how to continue to deliver the spam tagged mail to the spam mailbox.. can this be done with xfilter or is there some parameter I can send to vdelivermail to do this? > lola --- Jason 'XenoPhage' Frisvold Engine / Technology Programmer [EMAIL PROTECTED] RedHat Certified - RHCE # 803004140609871 MySQL Pro Certified - ID# 207171862 MySQL Core Certified - ID# 205982910 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming."
[vchkpw] New Server/Best Software?
Howdy Folks: I've just been asked to either set up a new server or add some services to an existing server. The current server runs netqmail 1.05 + SMTP-AUTH 0.42 & vpopmail 5.4.2 on OpenBSD 3.5. The client's requirements are as follows: -Virus checking -Spam filtering -Quota limitations enforced -Web admin for changing passwords & such -Webmail For ease of administration, the server will run OpenBSD 3.5 whether it goes on the current box or something else. I'm also quite inclined to stick with qmail/vpopmail for the same reasons. What I'm thinking of using consists of the following: ClamAV SpamAssassin SQWebMail QmailAdmin I'd love to hear from anybody who's using these together, & I think I also need to patch qmail for Maildir++ (?) support? Does the patch for that interfere with the SMTP-AUTH patch? Thanks, -Kit -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin "...qui desiderat pacem, praeparet bellum" (...if you would have peace, be prepared for war) -Flavius Vegetius Renatus
RE: [vchkpw] New Server/Best Software?
Kit Halsted wrote: > Howdy Folks: > > I've just been asked to either set up a new server or add some > services to an existing server. [snip] > I'd love to hear from anybody who's using these together, & I think I > also need to patch qmail for Maildir++ (?) support? Does the patch > for that interfere with the SMTP-AUTH patch? I'm using qmail+vpopmail+BincIMAP+SquirrelMail+ClamAV+qmailAdmin. See http://www.differentpla.net/node/view/165 for how I did it. I'm not using SpamAssassin (it's on the list, though), and I don't need quota support. It's all working together extremely well. I'm not aware that you need to patch to support Maildir++: I'm using IMAPdir, and it only took a couple of tweaks to some scripts. Cheers, Roger.
Re: [vchkpw] MySQL / LDAP
Edward Neville wrote: Can someone direct me to a descent site that compares or details how to install LDAP and/or MySQL with Qmail please? http://www.tnpi.biz/ No comparison though. Rainer
Re: [vchkpw] New Server/Best Software?
I have pretty much the same setup, except I use vpopmail in the mix, and squirrelmail for the webmail side of things. I have no experience with SqWebmail, so I can't really compare them. One bonus for squirrelmail is that if you configure spamassasin with mysql support, you can put a highly configurable plugin into squirrelmail to control spamassasin on a per-user basis. Kit Halsted wrote: Howdy Folks: I've just been asked to either set up a new server or add some services to an existing server. The current server runs netqmail 1.05 + SMTP-AUTH 0.42 & vpopmail 5.4.2 on OpenBSD 3.5. The client's requirements are as follows: -Virus checking -Spam filtering -Quota limitations enforced -Web admin for changing passwords & such -Webmail For ease of administration, the server will run OpenBSD 3.5 whether it goes on the current box or something else. I'm also quite inclined to stick with qmail/vpopmail for the same reasons. What I'm thinking of using consists of the following: ClamAV SpamAssassin SQWebMail QmailAdmin I'd love to hear from anybody who's using these together, & I think I also need to patch qmail for Maildir++ (?) support? Does the patch for that interfere with the SMTP-AUTH patch? Thanks, -Kit
RE: [vchkpw] New Server/Best Software?
Roger Lipscombe said: > I'm using qmail+vpopmail+BincIMAP+SquirrelMail+ClamAV+qmailAdmin. See > http://www.differentpla.net/node/view/165 for how I did it. I'm not using > SpamAssassin (it's on the list, though), and I don't need quota support. > It's all working together extremely well. Using Bill Shupp's excellent email toaster here (www.shupp.org/toaster) Has everything you need... I highly recommend squirrelmail as well.. lots of plugins and very easy to use! > I'm not aware that you need to patch to support Maildir++: I'm using > IMAPdir, and it only took a couple of tweaks to some scripts. Yeah, I don't remember patching anything here for that... Bill's toaster has just about everything... He's planning on posting a new version sometime soon (possibly next week) with a few new features, including qscan instead of qmail-scanner... > Cheers, > Roger. --- Jason 'XenoPhage' Frisvold Engine / Technology Programmer [EMAIL PROTECTED] RedHat Certified - RHCE # 803004140609871 MySQL Pro Certified - ID# 207171862 MySQL Core Certified - ID# 205982910 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming."
Re: [vchkpw] New Server/Best Software?
Hi, Jason 'XenoPhage' Frisvold wrote: Yeah, I don't remember patching anything here for that... Bill's toaster has just about everything... He's planning on posting a new version sometime soon (possibly next week) with a few new features, including qscan instead of qmail-scanner... What is this qscan you mention? Google doesn't show anything. I know qscanq, but it doesn't (to me) support SA within it. Regards, Rick
Re: [vchkpw] New Server/Best Software?
Rick Macdougall said: > Hi, > > Jason 'XenoPhage' Frisvold wrote: > > What is this qscan you mention? Google doesn't show anything. I know > qscanq, but it doesn't (to me) support SA within it. My apologies as I was mistaken.. It was qscanq ... And I believe qmail-spamc is the program that supports SA... A quick search find this : http://msgs.securepoint.com/cgi-bin/get/qmail0404/149/1/2/1.html I guess you daisy chain processes together.. :) > Regards, > > Rick --- Jason 'XenoPhage' Frisvold Engine / Technology Programmer [EMAIL PROTECTED] RedHat Certified - RHCE # 803004140609871 MySQL Pro Certified - ID# 207171862 MySQL Core Certified - ID# 205982910 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming."
Re: [vchkpw] New Server/Best Software?
Rick Macdougall said: > Hi, > > Jason 'XenoPhage' Frisvold wrote: > > What is this qscan you mention? Google doesn't show anything. I know > qscanq, but it doesn't (to me) support SA within it. My apologies as I was mistaken.. It was qscanq ... And I believe qmail-spamc is the program that supports SA... A quick search find this : http://msgs.securepoint.com/cgi-bin/get/qmail0404/149/1/2/1.html I guess you daisy chain processes together.. :) > Regards, > > Rick --- Jason 'XenoPhage' Frisvold Engine / Technology Programmer [EMAIL PROTECTED] RedHat Certified - RHCE # 803004140609871 MySQL Pro Certified - ID# 207171862 MySQL Core Certified - ID# 205982910 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming."
[vchkpw] MySQL error messages & vpalias.c
My travels have finally brought me to the MySQL database module... I am working on improving the error messages returned by vconvert, as part of the process of testing the MySQL back end. The first thing I've noticed is that a number of errors call fprintf(stderr) directly from the extension. I would like to make them record the error in a string, set errori and return the error code where it is apropriate. Then I have to look at the places it is called and update the error handling there. I would prefer to leave the formatting of error messages up to the end user program: ~vpopmail/bin/*, qmailadmin, etc. Any objections? At first glance, it appers that vpalias.c, vmysql.c and vpgsql.c share common functions. It seems to me that if the code is in vmysql.c and vpgsql.c it should also appear in vcdb.c and vpalias.c should not exist. It looks like there is some ifdef magic going on to hide the code in this file. It seems to me it would be better to add vpalias.c to vcdb.c and add empty function definitions in the other auth back-ends. Ifdefs would remain so you can still switch valias on or off with a ./configure option. Should I move it to cdb.c? Next, there are two programs vconvert and dotqmail2valias that both translate data from file to database, or from database to file. Should I merge the programs into one. Future conversions would then be one step. If the users or aliases have already been converted, you just get duplicate warnings. Merge them? Rick
