Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd December 2009, 19:53
mandelbrot mandelbrot is offline
Junior Member
 
Join Date: Sep 2009
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Howto tutorial on Postfix mail server.

Referring to this and others: http://www.howtoforge.com/virtual-us...ail-ubuntu8.10

Specifically this line:
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';


I'm wondering why this user account needs any write privileges to the mail database? As far as I know, it is only using select statements invoked by postfix..

Am I missing something here?
Reply With Quote
Sponsored Links
  #2  
Old 23rd December 2009, 14:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

You're right, but if you want to write your own webmail interface where you can create, update and delete users, then this is useful. Also, SquirrelMail needs the UPDATE privilege because otherwise it wouldn't be possible to change passwords.
__________________
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
  #3  
Old 23rd December 2009, 17:01
mandelbrot mandelbrot is offline
Junior Member
 
Join Date: Sep 2009
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply, falko.

If may follow up with another question:
Can I adapt the previously linked how-to with postfixadmin? If so what would be involved? Just rewrite the SQL look-ups to the postfixadmin created database and repopulate the postfixadmin tables from the other tables?
Reply With Quote
  #4  
Old 24th December 2009, 16:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

I've never tried Postfixadmin with this setup. You might have to change a few MySQL tables and also the SQL queries in the Postfix and Courier configuration.
__________________
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
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 11:49
Need help get mail to work (can't recieve and apperently can't send) omega13a Installation/Configuration 19 20th August 2009 22:06
Postfix problem and few questions Gimly Installation/Configuration 12 7th July 2009 17:27
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 23:53
Webmail Relay Error palkat General 17 23rd April 2006 19:12


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


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