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
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] Create account with SQL query
- Original Message - From: Brad Pinkston Can an account be created by inserting username and crypted password directly into the database? Yes Basically, will vpopmail create the pw_dir field entry, then set and create the actual directory according to the directory structure? Yes Some PHP and ASP info is available here : http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm#CREATE_MAILBOX_VIA_SQL Michael.
Re: [vchkpw] Create account with SQL query
On Friday 05 November 2004 04:33 pm, Brad Pinkston wrote: > Can an account be created by inserting username and crypted password > directly into the database? Basically, will vpopmail create the pw_dir > field entry, then set and create the actual directory according to the > directory structure? > > We'd like to create a custom user management interface without having to do > command line calls if possible. Yep. You can do that. You will need to encrypt the password using the unix style mysql crypt function. Ken