Re: [vchkpw] .over-quota.msg sent only one time
Michael Bowe ha scritto: Only 1 quota message is to the mailbox owner per 24 hours. This is controlled by a quotawarn file being placed into the user's dir. The datestamp of this file is used to keep track of when the last quota Oh yes, i can see this file i users's home. Thanks -- Alessio Cecchi ++ www.skye.it
[vchkpw] Can't create database 'vpopmail'. Database exists
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm having erraticaly this problem on a qmail+vpopmail box with several mailing lists that has been working well for more than 2 years. This started to happen some weeks ago, and it just happens with a mailing list that has subscribers belonging to one of the domains the server hosts, and the rest are external recipients. The delivering to the external ones is done properly, but delivering to the local recipients fails: @4000422f186d0548d244 delivery 1074: failure: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exist s/vmysql:_sql_error[3]:_No_Database_Selected/Sorry,_no_mailbox_here_by _that_name._vpopmail_(#5.1.1)/ @4000422f186d0548ed9c status: local 27/100 remote 21/100 @4000422f186d054aaaec delivery 1087: failure: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exist s/vmysql:_sql_error[3]:_No_Database_Selected/Sorry,_no_mailbox_here_by _that_name._vpopmail_(#5.1.1)/ @4000422f186d054abe74 status: local 26/100 remote 21/100 @4000422f186d054c2da4 delivery 1089: failure: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exist s/vmysql:_sql_error[3]:_No_Database_Selected/Sorry,_no_mailbox_here_by _that_name._vpopmail_(#5.1.1)/ (etc etc etc) A mysql restart solves the problem for some days... Any idea about why does this happen? Is it some kind of resources problem? What should I tune? Cheers, - - Ruben -BEGIN PGP SIGNATURE- Version: PGP 8.1 iQA/AwUBQi64YwcpyqBKAkY5EQLRwQCgkNwbKS9xGxQju0fX0J9mocKaxmsAnRnw jJLuYmQWmrB58WYGfWIe8wmX =GrxR -END PGP SIGNATURE-
Re: [vchkpw] .over-quota.msg sent only one time
- Original Message - From: Alessio Cecchi [EMAIL PROTECTED] I have set-up /home/vpopmail/domains/.over-quota.msg But the messagges arrives only one time. I delete all the messages, from webmail (sqwebmail), but the message does not return more. Only 1 quota message is to the mailbox owner per 24 hours. This is controlled by a quotawarn file being placed into the user's dir. The datestamp of this file is used to keep track of when the last quota Michael.
RE: [vchkpw] listing over-quota users
Here's what I do. I don't have too many domains or users do it doesn't take too long. du -sk /home/vpopmail/domains/*/*/Maildir /tmp/maildirusage du -sk /home/vpopmail/domains/*/*/*/Maildir /tmp/maildirusage cat /tmp/maildirusage | sort -n | tail -n50 | sort -n -r | mail -s Mail User Quota your-email-here This only gets the top 50 users. You can change it easily. I don't think it would be very efficient for multiple domains. In that case you may want to break it up into a run for each domain. I'd definitely like to see something more efficient :) Charlie From: Tanmaya Anand [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 11:44 PM To: vchkpw@inter7.com Subject: [vchkpw] listing over-quota users Hi I need to list all over-quota users on the system for all domains. Can anyone help me with some similiar perl / shell script to get this done. Regards, Tanmaya http://clients.rediff.com/signature/track_sig.asp
Re: [vchkpw] listing over-quota users
this method is of course fast and dirty, but it might not work for everyone out there. the best aproach is to write a perl script that runs queries on a database, gets path to a user's mailbox on the server, uses File::Find to include only files in Maildir/cur and Maildir/new as well as :subfolders:/cur and :subfolders:/new with the exception of trash folders. that should give a much clearer picture. in addition it can scale better. -- Igor On Wed, Mar 09, 2005 at 08:08:10AM -0800, Charles J. Boening wrote: - Here's what I do. I don't have too many domains or users do it doesn't - take too long. - - du -sk /home/vpopmail/domains/*/*/Maildir /tmp/maildirusage du -sk - /home/vpopmail/domains/*/*/*/Maildir /tmp/maildirusage cat - /tmp/maildirusage | sort -n | tail -n50 | sort -n -r | mail -s Mail - User Quota your-email-here - - - This only gets the top 50 users. You can change it easily. I don't - think it would be very efficient for multiple domains. In that case you - may want to break it up into a run for each domain. - - I'd definitely like to see something more efficient :) - - - Charlie - - - - - - From: Tanmaya Anand [mailto:[EMAIL PROTECTED] - Sent: Tuesday, March 08, 2005 11:44 PM - To: vchkpw@inter7.com - Subject: [vchkpw] listing over-quota users - - - - Hi - - I need to list all over-quota users on the system for all - domains. - Can anyone help me with some similiar perl / shell script to get - this done. - - Regards, - Tanmaya - - - - http://clients.rediff.com/signature/track_sig.asp - -
Re: [vchkpw] listing over-quota users
On Mar 9, 2005, at 6:15 PM, [EMAIL PROTECTED] wrote: the best aproach is to write a perl script that runs queries on a database, gets path to a user's mailbox on the server, uses File::Find to include only files in Maildir/cur and Maildir/new as well as :subfolders:/cur and :subfolders:/new with the exception of trash folders. that should give a much clearer picture. in addition it can scale better. How about using `vpopbull -n` (maybe `vpopbull -n -V`) to get a list of email accounts and then `vuserinfo -Q emailaddress` to get the quota usage? I think that you could even use vuserinfo -d to get the path to the user's maildir, delete the maildirsize file, and then call vuserinfo -Q to have the file rebuilt. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ You don't need a laptop to troubleshoot high-speed Internet: sniffter.com
RE: [vchkpw] listing over-quota users
How about this? snip filename='/home/vpopmail/bin/overquota.sh' #!/bin/sh for i in `/home/vpopmail/bin/vpopbull -n -V`; do echo `/home/vpopmail/bin/vuserinfo -Q $i` $i done /snip Called like this /home/vpopmail/bin/overquota.sh | grep 100% | mail -s Overquota users your-email-addy Charlie -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 4:52 PM To: vchkpw@inter7.com Subject: Re: [vchkpw] listing over-quota users On Mar 9, 2005, at 6:15 PM, [EMAIL PROTECTED] wrote: the best aproach is to write a perl script that runs queries on a database, gets path to a user's mailbox on the server, uses File::Find to include only files in Maildir/cur and Maildir/new as well as :subfolders:/cur and :subfolders:/new with the exception of trash folders. that should give a much clearer picture. in addition it can scale better. How about using `vpopbull -n` (maybe `vpopbull -n -V`) to get a list of email accounts and then `vuserinfo -Q emailaddress` to get the quota usage? I think that you could even use vuserinfo -d to get the path to the user's maildir, delete the maildirsize file, and then call vuserinfo -Q to have the file rebuilt. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ You don't need a laptop to troubleshoot high-speed Internet: sniffter.com
[vchkpw] Can't do setuid
(Sorry, I could not figure it out by myself) It is my first time I try to install qmail and vpopmail on one system. I cannot send an email to this domain. How can I fix it? I used Franks setup script, ... VqAdmin web pages shows: list of domains shows xxx.com.tw show users for this domain tells me: ronald passwd No No 20971520SNo Tue Mar 1 17:11:10 2005 detail shows: Email address: [EMAIL PROTECTED] Sending an email to [EMAIL PROTECTED] will be returned with: 553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1) 550 [EMAIL PROTECTED]... User unknown tail /var/log/qmail/smtpd/current |tai64nlocal shows: 2005-03-10 11:36:53.029059500 tcpserver: status: 1/100 2005-03-10 11:36:53.029064500 tcpserver: pid 12109 from 61.xx.xx.18 2005-03-10 11:36:53.029065500 tcpserver: ok 12109 0:60.248.111.172:25 :61.xx.xx.18::41834 2005-03-10 11:36:58.111483500 Can't do setuid 2005-03-10 11:36:58.353414500 tcpserver: end 12109 status 0 2005-03-10 11:36:58.353419500 tcpserver: status: 0/100 www:/var/qmail/control # cat rcpthosts 192.168.0. xxx.com.tw mail.xxx.com.tw www:/var/qmail/control # cat me mail.xxx.com.tw www:/var/qmail/control # cat locals xxx.com.tw mail.xxx.com.tw www:/var/qmail/control # cat virtualdomains xxx.com.tw:xxx.com.tw bye Ronald
Re: [vchkpw] Can't do setuid - solved = Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/
Stefan Mühlemann wrote: Hi, on my machine this message occured because suidperl had the wrong rights. Just do a chmod 4755 on /usr/bin/suidperl. Stefan, thanks, it helped to get rid of this error, however /var/log/qmail/send/current |tai64nlocal shows for a test message: 2005-03-10 13:00:02.408870500 new msg 250946 2005-03-10 13:00:02.408876500 info msg 250946: bytes 1586 from [EMAIL PROTECTED] qp 13909 uid 508 2005-03-10 13:00:02.527193500 starting delivery 17269: msg 250946 to local [EMAIL PROTECTED] 2005-03-10 13:00:02.527196500 status: local 1/15 remote 0/20 2005-03-10 13:00:02.578995500 delivery 17269: success: did_1+0+0/ 2005-03-10 13:00:02.579000500 status: local 0/15 remote 0/20 2005-03-10 13:00:02.579001500 end msg 250946 2005-03-10 13:00:04.425836500 new msg 250918 2005-03-10 13:00:04.425841500 info msg 250918: bytes 705 from [EMAIL PROTECTED] qp 13955 uid 0 2005-03-10 13:00:04.503679500 starting delivery 17270: msg 250918 to local [EMAIL PROTECTED] 2005-03-10 13:00:04.503685500 status: local 1/15 remote 0/20 2005-03-10 13:00:04.506624500 delivery 17270: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:04.506629500 status: local 0/15 remote 0/20 2005-03-10 13:00:07.595104500 bounce msg 250918 qp 14019 2005-03-10 13:00:07.595109500 end msg 250918 2005-03-10 13:00:07.595602500 new msg 250850 2005-03-10 13:00:07.595604500 info msg 250850: bytes 1290 from qp 14021 uid 507 2005-03-10 13:00:07.672906500 starting delivery 17271: msg 250850 to local [EMAIL PROTECTED] 2005-03-10 13:00:07.672968500 status: local 1/15 remote 0/20 2005-03-10 13:00:07.673444500 new msg 250903 2005-03-10 13:00:07.673530500 info msg 250903: bytes 5549 from [EMAIL PROTECTED] qp 14013 uid 0 2005-03-10 13:00:07.736387500 delivery 17271: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:07.736393500 status: local 0/15 remote 0/20 2005-03-10 13:00:07.736394500 starting delivery 17272: msg 250903 to local [EMAIL PROTECTED] 2005-03-10 13:00:07.736396500 status: local 1/15 remote 0/20 2005-03-10 13:00:10.856376500 bounce msg 250850 qp 14024 2005-03-10 13:00:10.856382500 end msg 250850 2005-03-10 13:00:10.857956500 new msg 250849 2005-03-10 13:00:10.857961500 info msg 250849: bytes 1780 from [EMAIL PROTECTED] qp 14026 uid 507 2005-03-10 13:00:10.937090500 starting delivery 17273: msg 250849 to local [EMAIL PROTECTED] 2005-03-10 13:00:10.937096500 status: local 2/15 remote 0/20 2005-03-10 13:00:10.937097500 delivery 17272: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:10.937099500 status: local 1/15 remote 0/20 2005-03-10 13:00:14.032390500 bounce msg 250903 qp 14029 2005-03-10 13:00:14.032396500 end msg 250903 2005-03-10 13:00:14.033228500 delivery 17273: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:14.033232500 status: local 0/15 remote 0/20 2005-03-10 13:00:14.033233500 triple bounce: discarding bounce/250849 2005-03-10 13:00:14.033234500 end msg 250849 2005-03-10 13:00:14.033523500 new msg 250944 2005-03-10 13:00:14.033525500 info msg 250944: bytes 6134 from qp 14033 uid 507 2005-03-10 13:00:14.092006500 starting delivery 17274: msg 250944 to local [EMAIL PROTECTED] 2005-03-10 13:00:14.092010500 status: local 1/15 remote 0/20 2005-03-10 13:00:14.097660500 delivery 17274: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:14.097666500 status: local 0/15 remote 0/20 2005-03-10 13:00:17.192809500 bounce msg 250944 qp 14036 2005-03-10 13:00:17.192814500 end msg 250944 2005-03-10 13:00:17.193292500 new msg 250849 2005-03-10 13:00:17.193294500 info msg 250849: bytes 6624 from [EMAIL PROTECTED] qp 14038 uid 507 2005-03-10 13:00:17.260665500 starting delivery 17275: msg 250849 to local [EMAIL PROTECTED] 2005-03-10 13:00:17.260670500 status: local 1/15 remote 0/20 2005-03-10 13:00:17.263694500 delivery 17275: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2005-03-10 13:00:17.263700500 status: local 0/15 remote 0/20 2005-03-10 13:00:17.263701500 triple bounce: discarding bounce/250849 2005-03-10 13:00:17.263703500 end msg 250849 Ronald Wiplinger schrieb: (Sorry, I could not figure it out by myself) It is my first time I try to install qmail and vpopmail on one system. I cannot send an email to this domain. How can I fix it? I used Franks setup script, ... VqAdmin web pages shows: list of domains shows xxx.com.tw show users for this domain tells me: ronald passwd No No 20971520SNo Tue Mar 1 17:11:10 2005 detail shows: Email address: [EMAIL PROTECTED] Sending an email to [EMAIL PROTECTED] will be returned with: 553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1) 550 [EMAIL PROTECTED]... User unknown tail /var/log/qmail/smtpd/current |tai64nlocal shows: 2005-03-10 11:36:53.029059500 tcpserver: status: 1/100 2005-03-10 11:36:53.029064500 tcpserver: pid 12109 from 61.xx.xx.18 2005-03-10 11:36:53.029065500 tcpserver: ok 12109