Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)?

[the1rob]

Awesome tutorial! Works like a champ. I got everything under the sun running perfectly.

So how the heck do I admin this thing? User creation, password changing, etc...Is there a program or web front end, or am I stuck working with phpmyadmin?

I've seen this question posted on the tutorial, so I figured I'd throw it out here and get a public answer.

It's my first time working with postfix, so be gentle...


The1Rob

[MAO]

Originally Posted by the1rob

Awesome tutorial! Works like a champ. I got everything under the sun running perfectly.

So how the heck do I admin this thing? User creation, password changing, etc...Is there a program or web front end, or am I stuck working with phpmyadmin?

I've seen this question posted on the tutorial, so I figured I'd throw it out here and get a public answer.

It's my first time working with postfix, so be gentle...


The1Rob

postfixadmin
http://postfixadmin.sourceforge.net/

[marpada]

Originally Posted by MAO

postfixadmin
http://postfixadmin.sourceforge.net/

I didn't know that, I'm used to phpmyadmin . Can it be used by users to change its passwords?
________
MFLB LIFETIME WARRANTY
________
Ford ranger specifications

[MAO]

Originally Posted by marpada

I didn't know that, I'm used to phpmyadmin . Can it be used by users to change its passwords?

If you use IMAP (webmail) you can try with HORDE/IMP http://www.horde.org + passwd app for horde
or roundcube or squirrelmail with passwd options

[falko]

You can't use Postfixadmin with this tutorial because the table structures are different.

But the users can change their passwords with Squirrelmail (that's also described in that tutorial).

[ikaros]

Maybe falko could tell us if webmin,ispconfig or ebox are "compatible" with the tutorial.

[MAO]

Originally Posted by falko

You can't use Postfixadmin with this tutorial because the table structures are different.

But the users can change their passwords with Squirrelmail (that's also described in that tutorial).

CREATE DATABASE emailbase;

GRANT SELECT ON emailbase.* TO mailuser@localhost IDENTIFIED BY 'xxxxxxxxxxxxxxx';
GRANT SELECT, CREATE, INSERT, DELETE, UPDATE ON emailbase.* TO mailadmin@localhost IDENTIFIED BY 'xxxxxxxxxxxxxxxx';

USE emailbase;

CREATE TABLE `admin` (
`username` varchar(255) character set latin1 NOT NULL default '',
`password` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=InnoDB COMMENT='Virtual Admins';

CREATE TABLE `alias` (
`address` varchar(255) character set latin1 NOT NULL default '',
`goto` text character set latin1 NOT NULL,
`domain` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`address`),
KEY `address` (`address`)
) ENGINE=InnoDB COMMENT='Virtual Aliases';

CREATE TABLE `alias_domain` (
`alias_domain` varchar(255) character set latin1 NOT NULL default '',
`target_domain` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`alias_domain`),
KEY `active` (`active`),
KEY `target_domain` (`target_domain`)
) ENGINE=InnoDB COMMENT='Domain Aliases';

CREATE TABLE `config` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) character set latin1 NOT NULL default '',
`value` varchar(20) character set latin1 NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB COMMENT='PostfixAdmin settings';

CREATE TABLE `domain` (
`domain` varchar(255) character set latin1 NOT NULL default '',
`description` varchar(255) character set latin1 NOT NULL default '',
`aliases` int(10) NOT NULL default '0',
`mailboxes` int(10) NOT NULL default '0',
`maxquota` bigint(10) NOT NULL default '0',
`quota` bigint(20) NOT NULL default '0',
`transport` varchar(255) character set latin1 default NULL,
`backupmx` tinyint(1) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`domain`),
KEY `domain` (`domain`)
) ENGINE=InnoDB COMMENT='Virtual Domains';

CREATE TABLE `domain_admins` (
`username` varchar(255) character set latin1 NOT NULL default '',
`domain` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
KEY `username` (`username`)
) ENGINE=InnoDB COMMENT='Domain Admins';

CREATE TABLE `fetchmail` (
`id` int(11) unsigned NOT NULL auto_increment,
`mailbox` varchar(255) character set latin1 NOT NULL default '',
`src_server` varchar(255) character set latin1 NOT NULL default '',
`src_auth` enum('password','kerberos_v5','kerberos','kerberos _v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any') character set latin1 default NULL,
`src_user` varchar(255) character set latin1 NOT NULL default '',
`src_password` varchar(255) character set latin1 NOT NULL default '',
`src_folder` varchar(255) character set latin1 NOT NULL default '',
`poll_time` int(11) unsigned NOT NULL default '10',
`fetchall` tinyint(1) unsigned NOT NULL default '0',
`keep` tinyint(1) unsigned NOT NULL default '0',
`protocol` enum('POP3','IMAP','POP2','ETRN','AUTO') character set latin1 default NULL,
`extra_options` text character set latin1,
`returned_text` text character set latin1,
`mda` varchar(255) character set latin1 NOT NULL default '',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT='Fetchmail';

CREATE TABLE `log` (
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(255) character set latin1 NOT NULL default '',
`domain` varchar(255) character set latin1 NOT NULL default '',
`action` varchar(255) character set latin1 NOT NULL default '',
`data` varchar(255) character set latin1 NOT NULL default '',
KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB COMMENT='Log';

CREATE TABLE `mailbox` (
`username` varchar(255) character set latin1 NOT NULL default '',
`password` varchar(255) character set latin1 NOT NULL default '',
`name` varchar(255) character set latin1 NOT NULL default '',
`maildir` varchar(255) character set latin1 NOT NULL default '',
`quota` bigint(20) NOT NULL default '-1',
`domain` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=InnoDB COMMENT='Virtual Mailboxes';

CREATE TABLE `vacation` (
`email` varchar(255) character set latin1 NOT NULL default '',
`subject` varchar(255) character set latin1 NOT NULL default '',
`body` text NOT NULL,
`cache` text NOT NULL,
`domain` varchar(255) character set latin1 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`email`),
KEY `email` (`email`)
) ENGINE=InnoDB COMMENT='Virtual Vacation';

CREATE TABLE `vacation_notification` (
`on_vacation` varchar(170) NOT NULL,
`notified` varchar(170) NOT NULL,
`notified_at` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`on_vacation`,`notified`),
CONSTRAINT `vacation_notification_ibfk_1` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Virtual Vacation Notifications';

Here is dabastructure!
It's not so different.

[falko]

Originally Posted by ikaros

Maybe falko could tell us if webmin,ispconfig or ebox are "compatible" with the tutorial.

ISPConfig is not compatible, and I don't think the ebox is. Not sure about Webmin.

[falko]

Originally Posted by MAO

It's not so different.

Yes, but a little bit - probably enough to invest some time to get this working.

[ikaros]

@MAO

What is the use for these tables?