[vchkpw] Qmail SMTP AUTH + vchkpw on 64 bit...
I saw this was discussed a month or two ago, but no conclusion seemed to be reached. I have qmail 1.03, and vpopmail 5.4 installed, and everything works except for SMTP AUTH. I get segfaults or bad user errors, depending on whether or not vchkpw is owned by root or by the vpopmail user. Here's a transcript from a session where vchkpw was owned by vpopmail. When it's owned by root, the last line changes to simply say the authentication failed. 220 domain.com ESMTP EHLO domain.net 250-domain.com 250-AUTH LOGIN PLAIN 250-AUTH=LOGIN PLAIN 250-SIZE 0 250-PIPELINING 250 8BITMIME AUTH LOGIN 334 VXNlcm5hbWU6 dXNlcm5hbWVAZG9tYWluLmNvbQ== 334 UGFzc3dvcmQ6 cGFzc3dvcmQ= 454 oops, problem with child and I can't auth (#4.3.0)
Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences
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
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
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
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
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
[vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences
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
[vchkpw] Adjusting the default .qmail-default
I would like to adjust the default options that are placed in the .qmail-default file when a domain is created, or when a modification is made to a domian through qmailadmin, such that my customizations are preserved. Currently if any changes are made, I loose my pipe to spamc that I run from .qmail-default, also if a user gets a custom .qmail file, they don't get spam-scanned. Basically, I'd just like to know where this is stored at and how to adjust it if it's not just a simple file. Thanks in advance. -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
