Talk:Complete Virtual Mail Server/Postfixadmin

From Gentoo Linux Wiki

If you want a lighweight webinterface for simply adding mailboxes to your postgres database check out my cakephp-frontend: http://blog.tommmy.de/index.php/2006/07/29/postfix-virtual-mailbox-admin-webinterface/ Hope it's useful for some of you out there.

Added instructions for emerging postfixadmin.

The ebuild in the portage tree won't be replaced with the one supporting postgres as long as the patches are not included upstream. To me it looked like UPSTREAM is not really interested in the postgres support :) so I'd rather keep it in our overlay.

--Wrobel 13:04, 4 March 2006 (GMT)

THe solution to the 1000-UID/GID-Problem is to fix the default setting in the DB, as this is not set at all by postfixadmin 129.13.186.3 01:12, 4 April 2006 (GMT)

can be done by issuing the following commands in mysql or psql:

alter table mailbox alter gid set default 1001; 
alter table mailbox alter uid set default 1001; 

(change 1001 to the uid and gid of your vmail user)

--Nacho01

[edit] postfixadmin patch

this small patch might be helpful for someone: I am using mysql so I installed postfixadmin without the patch mentioned in this howto, I did change the following in postfixadmin:

this will fill the email field and add ".maildir/" to the maildir field. in the files create-mailbox.php and admin/create-mailbox.php, change the insert query on line 187 from this:

$result = db_query ("INSERT INTO mailbox (username,password,name,maildir,quota,domain,created,modified,active) VALUES ('$fUsername','$password','$fName','$maildir','$quota','$fDomain',NOW(),NOW(),'$fActive')"); 

to this:

$result = db_query ("INSERT INTO mailbox (email,username,password,name,maildir,quota,domain,created,modified,active) VALUES ('$fUsername','$fUsername','$password','$fName','$maildir/.maildir/','$quota','$fDomain',NOW(),NOW(),'$fActive')");

--Nacho01

[edit] Web-based management application

I'm currently working on a Java based web application for managing the Postgres database. I already have mailbox creation, alias creation, and administrative account creation support. I would like to open source the application if I could get a couple more developers signed on. If anyone is interested, email at zack@severant.com