HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)? (http://www.howtoforge.com/forums/showthread.php?t=28083)

the1rob 23rd October 2008 04:04

Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)?
 
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 23rd October 2008 07:11

try postfixadmin for begin
 
Quote:

Originally Posted by the1rob (Post 151323)
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 23rd October 2008 16:40

Quote:

Originally Posted by MAO (Post 151328)

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 24th October 2008 06:25

it's only for administration create, delete, alias (domain and users)
 
Quote:

Originally Posted by marpada (Post 151421)
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 25th October 2008 10:34

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 31st October 2008 00:02

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

MAO 31st October 2008 04:40

Quote:

Originally Posted by falko (Post 151671)
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 31st October 2008 16:41

Quote:

Originally Posted by ikaros (Post 152590)
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 31st October 2008 16:42

Quote:

Originally Posted by MAO (Post 152597)
It's not so different.

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

ikaros 31st October 2008 23:03

@MAO

What is the use for these tables?


All times are GMT +2. The time now is 01:26.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.