That's the message of the month! Perl is okay but PHP is even better :) So long... Patrick
-----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von Randy Lewis (Kenneth R. Lewis) Gesendet: Mittwoch, 13. M�rz 2002 21:12 An: [EMAIL PROTECTED] Cc: Chad Osmond Betreff: Re: [courier-users] Userdb or Mysql Front End Chad, Although something like phpMyAdmin would prove useful for 'seeding' a database with some (few) trial accounts and such..it would kill you to try and use it for a production system. Since that approach would 'suck' BIG TIME, I began adapting some PHP code that was published for use with a CD/DVD Group Share thingy; and it's taken a life of its own. I will be releasing it very, very soon for review, testing and comments; so I've added you e-mail address to my 'Announce/Support' address book for the CourierDB PHP Admin tool list. Although it works (mostly) right now, I need to decide whether or not I will span a 'patch' for the authmysql module so it will process my 'alias' table; and even gather back some 'stats' that would be available for stuffing into the database. We shall see. It's not too much effort, but it does add a level of complexity...you know. Anyway, I've begun putting together some 'screen captures' so folks can see what all has been done and where this Courier+MySQL+PHP Admin tool is going...and elicit comments along the way. I need to create a bunch of phony Admin's and Domains's and Accounts + Aliases before I publish the screen captures for obvious reasons. That'll take a short while but it *is* coming soon. For the group, here is a short / inexact list of existing functionality: 1. Full compatibility with existing authmysql module, if you don't want support for aliases in the database. 2. Auto generate & update of etc/hosteddomains and other files needed for supporting virtual domains. 3. Compatible with the recent patch to authlib/authmoduser.c that allows full support for IP Based Domains (it generates that file too). 4. Super Admin, Privileged Admins and "one Domain/ one Admin" (restricted) administration of e-mail domains, users, passwords - all kinds of crap! 5. Built-in support for multiple aliases per account/domain with good checking to prevent silly duplications, i.e., [EMAIL PROTECTED] (as an alias) will be forbidden if there is already a 'bubba' in that domain - either as an account or an alias. 6. Quick 'radio button' selection of quota, with Admin defined default setting. 7. Super Admin control over defaults for each domain added to the database so things like HOMEDIR, MAILDIR, user's DIR's, UID/GID, etc. are definable and inherited by each account that is added to a defined domain. 8. Some Super Admin tables to preset locale information: like, State/Province values, Country, Domain names (and optional IP addresses; supported by my previously published patch to authlib/authmoduser.c) 9. Login/Logout for Admins. Setup new Admins account with mail to Super Admin for activation. Broadcast mailer feature to notify ALL Admins of something important. 10. Edit your own Admin table. 11. Show all Admain/Managers with e-Mail link to expedite Admin to Admin mailing if needed. 12. A Domain Stats page that reports (text & graphically) that Domain/Account utilization, date / domain distribution, by Admin & Domains, etc. 13. Various lists & views and some neat 'sort by' clicks for these lists. REQUIREMENTS: Apache (I'm using: Apache/1.3.19 (Unix)) PHP4 (I'm using: Version 4.0.6 with the following compile options: --enable-calendar' '--enable-bcmath' '--enable-trans-sid' '--with-yp' '--with-pcre-regex' '--enable-ftp' '--with-xml' '--with-openssl' '--with-zlib' '--enable-sysvsem' '--enable-sysvshm' '--enable-inline-optimization' '--disable-debug' '--without-curl' '--without-gdbm' '--without-gettext' '--with-imap=/usr/local' '--with-imap-ssl=/usr/local' '--with-kerberos' '--without-ldap' '--with-mcrypt=/usr/local' '--without-mhash' '--without-mm' '--without-recode' '--without-snmp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-tiff-dir=/usr/local' '--with-png-dir=/usr/local' '--with-ttf' '--with-xpm-dir=/usr/X11R6' '--without-pdflib' '--disable-dbase' '--disable-filepro' '--with-mysql=/usr/local' '--without-pgsql' '--without-iodbc' NOTE: A key thing, for me, was that I had to set a couple environment variables prior to building PHP4 so that it would know where to find Courier's sendmail and such. Otherwise, PHP4 couldn't call the built-in 'mail' functions. Just an FYI... Your mileage may vary. At any rate, Chad, and others; we'll soon have a reasonable starting point for a MySQL+PHP Admin tool. Randy Lewis, RTMX.NET > Chad Osmond wrote: > > Hello there, > > I am looking for a good either MySQL or userdb front end to administer, add users and domains to Courier. Rather then code one > myself it'd be nice to know if anyone has one or knows for one to share? > > > Chad Osmond _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
