Re: [qmailtoaster] Upgrade
Kyle Quillen wrote: Eric, It looks as though this is what would be required to do this.. At least for centos rpmbuild --rebuild --with cnt40 --define 'spambox 1' qmailadmin-toaster-*.src.rpm rpmbuild --rebuild --with cnt40 --define 'spambox 1' maildrop-toaster-*.src.rpm sorry for the first being on two lines. Thanks Q Hello just to avoid any confusion spambox option is on qmailadmin-toaster-*.src.rpm not maildrop Check spec files :) -Philip On Wed, 2006-12-20 at 21:14 -0700, Eric Shubes wrote: Kyle Quillen wrote: Hey all, I need to do some package updates and was wondering if I use the qtp to do the upgrade if I will need to recompile the vpopmail rpms inorder to keep the spam box or is there something in the scripts that I can modify to keep that option installed. Much thanks Q I haven't gotten around to adding these options (or a way to select them) to the qtp-newmodel script yet. However, I'm planning to do some enhancements to the script soon, like by the end of next week. So you can: .) wait for the enhancements .) do the upgrade and rebuild the required packages again yourself .) modify your qtp-build-rpms script to include the proper flags on the appropriate packages If you give me exactly what needs to be done so I don't have to search the archives for it, I can probably add just that part for you in short order. Take your pick (and let me know). - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[qmailtoaster] SMTP Remote authentication
Hi all! I've been searching and googling for some info but without any success so far, so... I come to the list again for help. Although I have static IP addresses for my mail servers (obviously) I've been struggling with my ISP because for some stupid reason some RBL like SORBS identify my addresses as DHCP addresses and therefore I've been getting blocked. As I expect that my ISP will take a loong time before understanding (and eventually solve) my problem I'm trying to have a quick fix for my e-mail delivery problems. I can use my ISP SMTP servers to relay all my mail and that way they'll not get blocked. The problem with this is that my ISP demands that I authenticate at the SMTP server with my internet account user credentials. I know sendmail has this feature from scratch and I imagine that qmail has this as well. My problem is that I cannot find where to configure this... Can anyone assist pelase? Thanks in advance, Fernando PS: wouldn't SPF be a more reasonable approach that RBL's to fight SPAM???
Re: [qmailtoaster] SMTP Remote authentication
On Dec 21, 2006, at 7:47 AM, Fernando Azevedo wrote: Hi all! I've been searching and googling for some info but without any success so far, so... I come to the list again for help. Although I have static IP addresses for my mail servers (obviously) I've been struggling with my ISP because for some stupid reason some RBL like SORBS identify my addresses as DHCP addresses and therefore I've been getting blocked. As I expect that my ISP will take a loong time before understanding (and eventually solve) my problem I'm trying to have a quick fix for my e-mail delivery problems. I can use my ISP SMTP servers to relay all my mail and that way they'll not get blocked. The problem with this is that my ISP demands that I authenticate at the SMTP server with my internet account user credentials. I know sendmail has this feature from scratch and I imagine that qmail has this as well. My problem is that I cannot find where to configure this... Can anyone assist pelase? you want to take advantage of the qmail-remote-auth patch, documented here: http://wiki.qmailtoaster.com/index.php/Smtproutes in a nutshell, make sure something like this is the last line in /var/ qmail/control/smtproutes: :your.isp.mailserver.com yourusername yourpassword -steve PS: wouldn't SPF be a more reasonable approach that RBL's to fight SPAM??? only if more sites published SPF records. :) anyway, the goal of SPF is really to fight spoofing and thus theoretically cut down on spam, whereas RBLs take a content-based approach. seems to me like that two work well together; why use only one? -- If this were played upon a stage now, I could condemn it as an improbable fiction. - Fabian, Twelfth Night, III,v - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[qmailtoaster] Lost Password
Hi I have lost the password of the QMailToster web administration. I have access to the console. How can I recover or change th password? Thanx - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Lost Password
Basura02 wrote: Hi I have lost the password of the QMailToster web administration. I have access to the console. How can I recover or change th password? The password should be in plain text in the file /usr/share/toaster/include/admin.pass You can also just change it by: htpasswd -bc /usr/share/toaster/include/admin.htpasswd admin admin_password smime.p7s Description: S/MIME Cryptographic Signature
Re: [qmailtoaster] Upgrade
Philip wrote: Kyle Quillen wrote: Eric, It looks as though this is what would be required to do this.. At least for centos rpmbuild --rebuild --with cnt40 --define 'spambox 1' qmailadmin-toaster-*.src.rpm rpmbuild --rebuild --with cnt40 --define 'spambox 1' maildrop-toaster-*.src.rpm sorry for the first being on two lines. Thanks Q Hello just to avoid any confusion spambox option is on qmailadmin-toaster-*.src.rpm not maildrop Check spec files :) -Philip Thanks for the help guys. I was definitely confused, and might not have gotten it right otherwise. I expect that including the --define for the other builds probably wouldn't have hurt anything, but being minimal is sometimes a good thing. ;) I've modified and commited qtp-build-rpms to include the --define, but I haven't rolled it into a QTP release yet because I haven't decided whether or not it needs to be optional. As it presently sits, there's no way to turn it off. That would take some additional modifications that I don't have time to do right now. Q, please test it out by replacing your /opt/qmailtoaster-plus/bin/qtp-build-rpms with the one from http://svn.shubes.net/qtp/trunk/bin/qtp-build-rpms. It should be version 0.2.1. Be sure to set ownership/permissions properly. Let us know how it works for you. -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Upgrade
On Thu, 2006-12-21 at 09:27 -0700, Eric Shubes wrote: Philip wrote: Kyle Quillen wrote: Eric, It looks as though this is what would be required to do this.. At least for centos rpmbuild --rebuild --with cnt40 --define 'spambox 1' qmailadmin-toaster-*.src.rpm rpmbuild --rebuild --with cnt40 --define 'spambox 1' maildrop-toaster-*.src.rpm sorry for the first being on two lines. Thanks Q Hello just to avoid any confusion spambox option is on qmailadmin-toaster-*.src.rpm not maildrop Check spec files :) -Philip Thanks for the help guys. I was definitely confused, and might not have gotten it right otherwise. I expect that including the --define for the other builds probably wouldn't have hurt anything, but being minimal is sometimes a good thing. ;) I've modified and commited qtp-build-rpms to include the --define, but I haven't rolled it into a QTP release yet because I haven't decided whether or not it needs to be optional. As it presently sits, there's no way to turn it off. That would take some additional modifications that I don't have time to do right now. Q, please test it out by replacing your /opt/qmailtoaster-plus/bin/qtp-build-rpms with the one from http://svn.shubes.net/qtp/trunk/bin/qtp-build-rpms. It should be version 0.2.1. Be sure to set ownership/permissions properly. Let us know how it works for you. Eric, I am working on getting a test box setup I should know later on this afternoon whether it works or not . Thanks Q - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Lost Password
The password should be in plain text in the file /usr/share/toaster/include/admin.pass I just noticed that this file has 644 permissions. Shouldn't it be 600? Probably admin.htpasswd as well. EE? It doesn't really matter as '/usr/share/toaster/include' is 770, with the user/group of apache. In other words, nobody but apache and root can even get into the directory to read stuff. Erik - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Lost Password
Erik Espinoza wrote: The password should be in plain text in the file /usr/share/toaster/include/admin.pass I just noticed that this file has 644 permissions. Shouldn't it be 600? Probably admin.htpasswd as well. EE? It doesn't really matter as '/usr/share/toaster/include' is 770, with the user/group of apache. In other words, nobody but apache and root can even get into the directory to read stuff. Erik Oh, ok. Thanks for checking into it. -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[qmailtoaster] Qmail Toaster Per User settings using MySQL
Can someone tell me what I am doing wrong? I don't believe spamassassin is using the database. When I use the spamc utility I get a response saying that my threshold is 4.0 which is what I have in the database. When I send a mail to myself from an outside source, I get a threshold of 5.0. Details are below. Gilbert Server: Centos4.4 Mail: QMAIL-TOASTER I want to use MySQL with the server to allow users the ability to customize spamassassin. http://wiki.apache.org/spamassassin/UsingSQL I added the spamassassin commands I think necessary to the file /etc/mail/spamassassin/local.cf user_scores_dsn DBI:mysql:spamassassin:127.0.0.1 user_scores_sql_password user_scores_sql_username spamassassin user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE \ username = _USERNAME_ OR username = '$GLOBAL' \ OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC the mysql user spamassassin has only SELECT privileges I have added a -q to the spamd service in /var/qmail/supervise/spamd exec /usr/bin/spamd -q -x -u vpopmail -s stderr 21 I run the command echo -e From: user\nTo:user\Subject: Test\n\n | spamc -u '[EMAIL PROTECTED]'' to check if spamd is using my SQL rule set for [EMAIL PROTECTED] and the response reports a required score of 4.0 which is the same as what I have in the SQL database. X-Spam-Status: No, score=2.8 required=4.0 tests=EMPTY_MESSAGE,MISSING_SUBJECT, NO_RECEIVED,NO_RELAYS autolearn=no version=3.1.7 When I send a test message from my yahoo account to that same user, the header reports a 5.0. X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[qmailtoaster] spamassassin bayes location
Hey all, I thought it would be nice to use bayes, just just leave autolearn disable, and just teach it with sa-learn. However, after feeding some spam to it to eat, I still don't see any of the bayes files in the /home/vpopmail/.spamassassin folder, only the auto-whitelist file. Is that right? Is that only for the autolearn database? Or were the files moved in the latest toaster? (I upgraded a month ago) Jared
RE: [qmailtoaster] Spamassassin SASQL
Awesome, got the spam filter filtering mail, at least tagging it with the proper setup via Mysql. One last question, can it place spam in the spam folder when flagged as spam? Thanks -Original Message- From: Eric Shubes [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 11:21 AM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Spamassassin SASQL You need to do step 1 in Quinn's instructions. Even though you've installed the package, when you use the normal procedure for installation, this file is removed at the end as it's only used for building the binary rpm. Ronnie Tartar wrote: I've installed but I do not have a simscan-toaster.spec file in the /usr/src/redhat/SPECS directory. Thanks - Original Message - From: Quinn Comendant [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Monday, December 18, 2006 8:46 PM Subject: RE: [qmailtoaster] Spamassassin SASQL So you're still in? I'm in a rush out of the office, but here are some quick steps: = REBUILDING SIMSCAN RPMs TO SUPPORT PER-USER SPAMC INVOCATION: = 1. Install the RPMS files from simscan-toaster-3.1.7-1.3.6.src.rpm: # rpm -Uvh simscan-toaster-3.1.7-1.3.6.src.rpm 2. Edit the simscan-toaster.spec file: # vi /usr/src/redhat/SPECS/simscan-toaster.spec You can change the configure options at around line 434. You will only need to set --enable-spamc-user option. Here is this part of my simscan-toaster.spec file: --enable-user=clamav \ --enable-attach \ --enable-ripmime=/usr/bin/ripmime \ --enable-per-domain \ --enable-spam \ --enable-spam-hits=20 \ --enable-spamc-user \ --enable-received \ --enable-clamavdb-path=/usr/share/clamav \ --enable-custom-smtp-reject 3. Build an RPM from this spec file: # rpmbuild -bb --with cnt40 --target $(uname -m) /usr/src/redhat/SPECS/simscan-toaster.spec (Replace cnt40 with the flag for your distro.) 4. Install the RPM (the usual disclaimers apply): # rpm -Uvh --force /usr/src/redhat/RPMS/ARCH/simscan-toaster-VERSION.ARCH.rpm (Replace ARCH with yours: i386, i686, etc) 5. Then following the instructions for setting up Spamassassin: http://wiki.apache.org/spamassassin/UsingSQL I haven't offered a control panel to our users (yet), but rather just let them post a support ticket if they have specific SA needs. Then I use a rudimentary shell script to make it easy to add/remove userprefs from the database. Quinn - Strangecode :: Internet Consultancy http://www.strangecode.com/ +1 530 624 4410 On Mon, 18 Dec 2006 19:39:38 -0500, Ronnie Tartar wrote: Looks like I need to use the --enable-spam and the --enable-spam-passthru options. Will I need to download the source to recompile? Or can I install via the simscan-toaster-3.1.7-1.3.6.src.rpm file? -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [qmailtoaster] Qmail Toaster Per User settings using MySQL
The following really helped me, you need to recompile simscan. Quinn really helped me out on this one, I'm just pasting what he sent me. I finally got it up and going. The issue is that simscan is not compiled to pass the username to spamassassin. You have to follow the following steps. So you're still in? I'm in a rush out of the office, but here are some quick steps: = REBUILDING SIMSCAN RPMs TO SUPPORT PER-USER SPAMC INVOCATION: = 1. Install the RPMS files from simscan-toaster-3.1.7-1.3.6.src.rpm: # rpm -Uvh simscan-toaster-3.1.7-1.3.6.src.rpm 2. Edit the simscan-toaster.spec file: # vi /usr/src/redhat/SPECS/simscan-toaster.spec You can change the configure options at around line 434. You will only need to set --enable-spamc-user option. Here is this part of my simscan-toaster.spec file: --enable-user=clamav \ --enable-attach \ --enable-ripmime=/usr/bin/ripmime \ --enable-per-domain \ --enable-spam \ --enable-spam-hits=20 \ --enable-spamc-user \ --enable-received \ --enable-clamavdb-path=/usr/share/clamav \ --enable-custom-smtp-reject 3. Build an RPM from this spec file: # rpmbuild -bb --with cnt40 --target $(uname -m) /usr/src/redhat/SPECS/simscan-toaster.spec (Replace cnt40 with the flag for your distro.) 4. Install the RPM (the usual disclaimers apply): # rpm -Uvh --force /usr/src/redhat/RPMS/ARCH/simscan-toaster-VERSION.ARCH.rpm (Replace ARCH with yours: i386, i686, etc) -Original Message- From: Gilbert T. Gutierrez, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 4:59 PM To: qmailtoaster-list@qmailtoaster.com Subject: [qmailtoaster] Qmail Toaster Per User settings using MySQL Can someone tell me what I am doing wrong? I don't believe spamassassin is using the database. When I use the spamc utility I get a response saying that my threshold is 4.0 which is what I have in the database. When I send a mail to myself from an outside source, I get a threshold of 5.0. Details are below. Gilbert Server: Centos4.4 Mail: QMAIL-TOASTER I want to use MySQL with the server to allow users the ability to customize spamassassin. http://wiki.apache.org/spamassassin/UsingSQL I added the spamassassin commands I think necessary to the file /etc/mail/spamassassin/local.cf user_scores_dsn DBI:mysql:spamassassin:127.0.0.1 user_scores_sql_password user_scores_sql_username spamassassin user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE \ username = _USERNAME_ OR username = '$GLOBAL' \ OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC the mysql user spamassassin has only SELECT privileges I have added a -q to the spamd service in /var/qmail/supervise/spamd exec /usr/bin/spamd -q -x -u vpopmail -s stderr 21 I run the command echo -e From: user\nTo:user\Subject: Test\n\n | spamc -u '[EMAIL PROTECTED]'' to check if spamd is using my SQL rule set for [EMAIL PROTECTED] and the response reports a required score of 4.0 which is the same as what I have in the SQL database. X-Spam-Status: No, score=2.8 required=4.0 tests=EMPTY_MESSAGE,MISSING_SUBJECT, NO_RECEIVED,NO_RELAYS autolearn=no version=3.1.7 When I send a test message from my yahoo account to that same user, the header reports a 5.0. X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [qmailtoaster] Qmail Toaster Per User settings using MySQL
Ronnie, Can you confirn that the logfile /var/log/qmail/spamd/current now contains the correct username rather than user=clamav for all emails. Thanks. Erik, If this is the case,is it possible to have the --enable-spamc-user added to the default simscan-toaster spec file, I can't think that it should affect anything else and think that this would be an improvement to the logging. Might need to add the paths to the bayes filter to /etc/mail/spamassassin/local.cf so everyone picks up the same db. I am still (slowly) working on converting sa-stats.pl to php and was wanting to enable filtering by user but since the current spamd log files don't capture it have been unable to do so with the stock simscan setup. Jon -Original Message- From: Ronnie Tartar [mailto:[EMAIL PROTECTED] Sent: 22 December 2006 02:47 To: qmailtoaster-list@qmailtoaster.com Subject: RE: [qmailtoaster] Qmail Toaster Per User settings using MySQL The following really helped me, you need to recompile simscan. Quinn really helped me out on this one, I'm just pasting what he sent me. I finally got it up and going. The issue is that simscan is not compiled to pass the username to spamassassin. You have to follow the following steps. So you're still in? I'm in a rush out of the office, but here are some quick steps: = REBUILDING SIMSCAN RPMs TO SUPPORT PER-USER SPAMC INVOCATION: = 1. Install the RPMS files from simscan-toaster-3.1.7-1.3.6.src.rpm: # rpm -Uvh simscan-toaster-3.1.7-1.3.6.src.rpm 2. Edit the simscan-toaster.spec file: # vi /usr/src/redhat/SPECS/simscan-toaster.spec You can change the configure options at around line 434. You will only need to set --enable-spamc-user option. Here is this part of my simscan-toaster.spec file: --enable-user=clamav \ --enable-attach \ --enable-ripmime=/usr/bin/ripmime \ --enable-per-domain \ --enable-spam \ --enable-spam-hits=20 \ --enable-spamc-user \ --enable-received \ --enable-clamavdb-path=/usr/share/clamav \ --enable-custom-smtp-reject 3. Build an RPM from this spec file: # rpmbuild -bb --with cnt40 --target $(uname -m) /usr/src/redhat/SPECS/simscan-toaster.spec (Replace cnt40 with the flag for your distro.) 4. Install the RPM (the usual disclaimers apply): # rpm -Uvh --force /usr/src/redhat/RPMS/ARCH/simscan-toaster-VERSION.ARCH.rpm (Replace ARCH with yours: i386, i686, etc) -Original Message- From: Gilbert T. Gutierrez, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 4:59 PM To: qmailtoaster-list@qmailtoaster.com Subject: [qmailtoaster] Qmail Toaster Per User settings using MySQL Can someone tell me what I am doing wrong? I don't believe spamassassin is using the database. When I use the spamc utility I get a response saying that my threshold is 4.0 which is what I have in the database. When I send a mail to myself from an outside source, I get a threshold of 5.0. Details are below. Gilbert Server: Centos4.4 Mail: QMAIL-TOASTER I want to use MySQL with the server to allow users the ability to customize spamassassin. http://wiki.apache.org/spamassassin/UsingSQL I added the spamassassin commands I think necessary to the file /etc/mail/spamassassin/local.cf user_scores_dsn DBI:mysql:spamassassin:127.0.0.1 user_scores_sql_password user_scores_sql_username spamassassin user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE \ username = _USERNAME_ OR username = '$GLOBAL' \ OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC the mysql user spamassassin has only SELECT privileges I have added a -q to the spamd service in /var/qmail/supervise/spamd exec /usr/bin/spamd -q -x -u vpopmail -s stderr 21 I run the command echo -e From: user\nTo:user\Subject: Test\n\n | spamc -u '[EMAIL PROTECTED]'' to check if spamd is using my SQL rule set for [EMAIL PROTECTED] and the response reports a required score of 4.0 which is the same as what I have in the SQL database. X-Spam-Status: No, score=2.8 required=4.0 tests=EMPTY_MESSAGE,MISSING_SUBJECT, NO_RECEIVED,NO_RELAYS autolearn=no version=3.1.7 When I send a test message from my yahoo account to that same user, the header reports a 5.0. X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org