Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd October 2008, 04:04
the1rob the1rob is offline
Junior Member
 
Join Date: Oct 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 23rd October 2008, 07:11
MAO MAO is offline
Junior Member
 
Join Date: Dec 2006
Posts: 16
Thanks: 0
Thanked 1 Time in 1 Post
Default try postfixadmin for begin

Quote:
Originally Posted by the1rob View Post
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/
Reply With Quote
  #3  
Old 23rd October 2008, 16:40
marpada marpada is offline
Senior Member
 
Join Date: Sep 2008
Posts: 139
Thanks: 2
Thanked 14 Times in 14 Posts
Default

Quote:
Originally Posted by MAO View Post
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

Last edited by marpada; 13th May 2011 at 01:51.
Reply With Quote
  #4  
Old 24th October 2008, 06:25
MAO MAO is offline
Junior Member
 
Join Date: Dec 2006
Posts: 16
Thanks: 0
Thanked 1 Time in 1 Post
Default it's only for administration create, delete, alias (domain and users)

Quote:
Originally Posted by marpada View Post
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
Reply With Quote
  #5  
Old 25th October 2008, 10:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

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).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 31st October 2008, 00:02
ikaros ikaros is offline
Member
 
Join Date: Aug 2006
Posts: 35
Thanks: 2
Thanked 1 Time in 1 Post
Default

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

Last edited by ikaros; 31st October 2008 at 00:34.
Reply With Quote
  #7  
Old 31st October 2008, 04:40
MAO MAO is offline
Junior Member
 
Join Date: Dec 2006
Posts: 16
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by falko View Post
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.
Reply With Quote
  #8  
Old 31st October 2008, 16:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by ikaros View Post
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
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 31st October 2008, 16:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by MAO View Post
It's not so different.
Yes, but a little bit - probably enough to invest some time to get this working.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #10  
Old 31st October 2008, 23:03
ikaros ikaros is offline
Member
 
Join Date: Aug 2006
Posts: 35
Thanks: 2
Thanked 1 Time in 1 Post
 
Default

@MAO

What is the use for these tables?
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
localhost postfix/master: fatal: bind 127.0.0.1 port 125: Permission denied g18c Installation/Configuration 4 24th March 2009 17:39
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 superman HOWTO-Related Questions 3 23rd October 2008 09:19
Virtual Users And Domains With Postfix, Courier, MySQL...Ubuntu 8.04 glennv HOWTO-Related Questions 5 14th June 2008 11:54
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail Ubuntu 8.04 paulodani HOWTO-Related Questions 7 4th June 2008 00:46


All times are GMT +2. The time now is 10:40.


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