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
