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
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
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
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 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
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-passwduser 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=mysqlmysql 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
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-passwduser 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=mysqlmysql 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
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
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
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 released
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
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
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
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
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
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
