[vchkpw] Create account with SQL query
I tried to reopen this old thread. Quick question about creating accounts with SQL queries. If you can create accounts using a PHP, PERL interface by using SQL queries, then it would be assumed that you will also remove accounts using this method. By removing a user's record will vpopmail somehow automagically remove the maildir for the user at some time, or does any custom interface need to take into account the need to clean up the filesystem? Thanks in advance. -- Brad Pinkston Firewall/Network Administrator Check Point CCSA Centenary College of LA (318) 869-5721 [EMAIL PROTECTED]
[vchkpw] Re: Create account with SQL query
Brad Pinkston writes: I tried to reopen this old thread. Quick question about creating accounts with SQL queries. If you can create accounts using a PHP, PERL interface by using SQL queries, then it would be assumed that you will also remove accounts using this method. By removing a user's record will vpopmail somehow automagically remove the maildir for the user at some time, or does any custom interface need to take into account the need to clean up the filesystem? AFAIK, using SQL to remove a user will NOT remove the underlying filesystem info for that user. You will need to handle that. There has been some work on a vpopmail daemon (vpopmaild) with a php interface, that would delete a user just as if you did it via the command-line utilities. Thanks in advance. -np Jonathan Shaw [EMAIL PROTECTED]
Re: [vchkpw] Create account with SQL query
On Feb 17, 2005, at 6:07 AM, Brad Pinkston wrote: I tried to reopen this old thread. Quick question about creating accounts with SQL queries. If you can create accounts using a PHP, PERL interface by using SQL queries, then it would be assumed that you will also remove accounts using this method. By removing a user's record will vpopmail somehow automagically remove the maildir for the user at some time, or does any custom interface need to take into account the need to clean up the filesystem? It would take additional work. You could create another table of users scheduled for deletion, and have a cron job running as root that queried that table hourly to delete the mail for that user. Or, just use the existing table and set the users flags to a special value (one that bounces mail, doesn't allow POP/IMAP/SMTP/Webmail access, etc.). Have your cron job search for those records, delete the files for the user and then delete the record. -- 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] How to force a queue buildup in qmail-send?
which file am i supposed to look at? lock, control, status, ok ... run ??? all of those logs are in my qmail file on BSD 4.7 On Wed, 16 Feb 2005 21:51:09 -0600, Rick van Vliet [EMAIL PROTECTED] wrote: Positive Negative wrote: When a user at a domain try to send mail out. It doesn't always work. It gets stuck in a queue on my server. I tried -doqueue and reload and all that. None of it works. We handle the POP and our ISP does the SMTP. All the error messages say its from the qmail-send program. So how can i --force the mail in that queue to go out? Can you be more specific about the errors that you're seeing in your qmail-send log? What seems to be keeping it stuck in the queue... There will be some fairly specific reasons that it's in the queue...those will help you determine if it's even your problem at all. rick -- AIM: FucPsSht
Re: [vchkpw] How to force a queue buildup in qmail-send?
Positive Negative wrote: Positive Negative wrote: When a user at a domain try to send mail out. It doesn't always work. It gets stuck in a queue on my server. I tried -doqueue and reload and all that. None of it works. We handle the POP and our ISP does the SMTP. All the error messages say its from the qmail-send program. So how can i --force the mail in that queue to go out? Can you be more specific about the errors that you're seeing in your qmail-send log? What seems to be keeping it stuck in the queue... There will be some fairly specific reasons that it's in the queue...those will help you determine if it's even your problem at all. rick which file am i supposed to look at? lock, control, status, ok ... run ??? all of those logs are in my qmail file on BSD 4.7 On Wed, 16 Feb 2005 21:51:09 -0600, Rick van Vliet [EMAIL PROTECTED] wrote: Please don't 'top-post'. OK. You stated that all the error messages say...something. You haven't shown us what all the error is/are. I asked you what you're seeing in your log. that would be /wherever/your/qmail-send_logfile is/current (perhaps var/log/qmail/current) Do a tail on that file prompt#tail -n75 /var/log/qmail/current\ |tai64nlocal (this command will show you the last 75 lines in human-readable time format). Did you install this qmail? Your log files are where you installed them. Either way, consult the recommended qmail installation documentation at http://www.lifewithqmail.org, to help narrow down your search. We'll be here.
RE: [vchkpw] Create account with SQL query
Tom Collins wrote: On Feb 17, 2005, at 6:07 AM, Brad Pinkston wrote: I tried to reopen this old thread. Quick question about creating accounts with SQL queries. If you can create accounts using a PHP, PERL interface by using SQL queries, then it would be assumed that you will also remove accounts using this method. By removing a user's record will vpopmail somehow automagically remove the maildir for the user at some time, or does any custom interface need to take into account the need to clean up the filesystem? It would take additional work. You could create another table of users scheduled for deletion, and have a cron job running as root that queried that table hourly to delete the mail for that user. Or, just use the existing table and set the users flags to a special value (one that bounces mail, doesn't allow POP/IMAP/SMTP/Webmail access, etc.). Have your cron job search for those records, delete the files for the user and then delete the record. Or just have your app exec ~vpopmail/bin/vdeluser
[vchkpw] perms on maildirsize
Howdy, Can anyone shed some light on this? I've got maildirsize files randomly flipping to root ownership. I'm a bit confused as to how this could happen - all delivery is done by vpopmail, and none of that stuff runs as root. That leaves courier-imap/pop, which do run as root. So I posted to the courier list (asbestos on, check...) and Mr. Sam replied that this is a known bug in vpopmail. Looking through the vpopmail archives I don't see any sign of this. I do see a few threads about size miscalculations, but that's an entirely different issue. Any ideas? Thanks, Charles -- Forwarded message -- Date: Thu, 17 Feb 2005 18:30:43 -0500 From: Sam Varshavchik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [Courier-imap] perms on maildirsize Charles Sprickman writes: Howdy, I'm running into a problem with courier-imap. We've had some problems with quota display via IMAP where there was no quota or usage reported. I'd dug through the contents of the maildirsize file and all looked good. But one thing I missed is that on all the problem customers the maildirsize file was owned by root. The only thing that touches these maildirs that starts with root perms is courier imap/pop. Any ideas on why it's flipping ownership? I'm running Courier 3.0.8 on FreeBSD 4.9. Delivery is qmail/vpopmail and everything there runs out of tcpserver as the vpopmail user. This bug was previously reported in vpopmail. The vpopmail mailing list is thataway → .
Re: [vchkpw] perms on maildirsize
At 06:44 PM 2/17/2005, Charles Sprickman wrote: Howdy, Can anyone shed some light on this? I've got maildirsize files randomly flipping to root ownership. I'm a bit confused as to how this could happen - all delivery is done by vpopmail, and none of that stuff runs as root. That leaves courier-imap/pop, which do run as root. So I posted to the courier list (asbestos on, check...) and Mr. Sam replied that this is a known bug in vpopmail. Looking through the vpopmail archives I don't see any sign of this. I do see a few threads about size miscalculations, but that's an entirely different issue. Any ideas? [bottom posting to appease the text-formatting nazis] i see that when i run vuserinfo [EMAIL PROTECTED] as root, which is often how i run it Paul Theodoropoulos http://www.anastrophe.com http://www.smileglobal.com