> You're not understanding, i'm going to put myDNS administration and
> proftpd all togheter in the same application, so any pre existing tool
> will not work for me.
That's what I've done too. Users can add their own subdomains, mailboxes
... The main parts are dbmail, PowerDNS and PureFTP. Apache configs are
generated from database content.
I did that in PHP, this is the code I use to add a new mail user (should
be self explaining I hope):
// ---------------------------------------------------------
// $mboxname (=dbmail user) is something like [EMAIL PROTECTED]
function dbMailboxesAddBox($userid, $mboxname, $password) {
global $dbh;
if (!is_numeric($userid)) die("Internal error file " . __FILE__ .
",line " . __LINE__);
// we always create lowercase mailboxes
$mboxname = strtolower($mboxname);
// get the new id ------------------------------
$newMboxId = dbGetSequenceId(DB_TABLE_USERS_SEQ);
dbBegin();
// create the new user -------------------------
//INSERT INTO users
(user_idnr,userid,passwd,client_idnr,maxmail_size,encryption_type)
//VALUES (7, '[EMAIL PROTECTED]','passwort',999,'1000','')
$query = "INSERT INTO " . DB_TABLE_USERS
. " (" . DB_TABLE_USERS_ROW_ID . ","
. DB_TABLE_USERS_ROW_MBOX . ","
. DB_TABLE_USERS_ROW_PASSWD . ","
. DB_TABLE_USERS_ROW_CLIENT_ID . ","
. DB_TABLE_USERS_ROW_MAXMAILSIZE . ","
. DB_TABLE_USERS_ROW_ENCRYPTION . ")"
. " VALUES (" . $newMboxId . ","
. sqlQuote($mboxname) . ","
. sqlQuote($password) . ","
. $userid . ","
. MAIL_QUOTA . ","
. "'')";
$result = $dbh->query($query);
// sanity checks
if ((DB::isError($result)) || ($dbh->affectedRows() != 1)) {
dbError("dbMailboxesAddBox", $query, $result); exit; }
// create the new INBOX ------------------------
//INSERT INTO mailboxes (owner_idnr, name) VALUES (7,'INBOX')
$query = "INSERT INTO " . DB_TABLE_USERMAILBOX
. " (" . DB_TABLE_USERMAILBOX_ROW_OWNER . ","
. DB_TABLE_USERMAILBOX_ROW_NAME . ")"
. " VALUES (" . $newMboxId
. ",'INBOX')";
$result = $dbh->query($query);
// sanity checks
if ((DB::isError($result)) || ($dbh->affectedRows() != 1)) {
dbError("dbMailboxesAddBox", $query, $result); exit; }
dbLog("info", "addMailbox " . $newMboxId . " (" . $mboxname . ")");
dbCommit();
}
HTH,
Thomas
