On 8/29/07, vivek khurana mailing.vivek@gmail.com wrote:
On 8/29/07, Agnello George agnello.dsouza@gmail.com wrote:
Hi
I Have a query , i have configured postfix on my linux system and have configured postfixadmin ( connected to mysql databases) . To administer
the
virtual domaina, when i log to the main admin pannel and add a mail box
to
a domain it says "unable to create mailbox! " however when i check the
mysql
What uid/user is runing postfix ? Does the uid/user has sufficient rights to create maildir ? Looks like the uid/user does not have rights to create maildir under your mail home.
My instalation instruction are as follows
create a user and group called vmail with the home directory /home/vmail. This is where all mail boxes will be stored.
groupadd -g 5000 vmail
useradd -g vmail -u 5000 vmail -d /home/vmail -m
chown -R vmail:vmail /home/vmail
chmod 771 /home/vmail
my postfix------------> main.cf looks like this
vi main.cf
queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
mail_owner = postfix
# The hostname is preferably the hostname you get from your ISP.
# Otherwise take the one from your primary domain
myhostname = server.isp-domain.tld
# Let this point to your primary registered domain
mydomain = domain.tld
# receive mail on all network interfaces.
inet_interfaces = all
# reject all mail for unknown users.
unknown_local_recipient_reject_code = 550
debug_peer_level = 2
#
# my additions for the virtual domain administration
# to use the MySQL database.
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 5000
virtual_transport = virtual ========================================> or ===> vmail
virtual_uid_maps = static:5000
#
# The settings for the SASL authentication using the autdaemon.
smtpd_recipient_restrictions =
permit_mynetworks,
permit_sasl_authenticated,
reject_non_fqdn_hostname,
reject_non_fqdn_sender,
reject_non_fqdn_recipient,
reject_unauth_destination,
reject_unauth_pipelining,
reject_invalid_hostname,
reject_rbl_client list.dsbl.org,
reject_rbl_client bl.spamcop.net,
reject_rbl_client sbl-xbl.spamhaus.org
enable_server_options = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl2_auth_enable = yes
smtpd_sasl_security_options = noanonymous
smtpd_sasl_application_name = smtpd
smtpd_sasl_local_domain = $myhostname
broken_sasl_auth_clients = yes
smtpd_use_pw_server = yes
smtpd_pw_server_security_options = plain,login,cram-md5
server_enabled = 1
#
# OPTIONAL PART
#smtpd_helo_required = yes
#disable_vrfy_command = yes
#smtpd_data_restrictions = reject_unauth_pipelining
#smtpd_etrn_restrictions = reject
##############################################
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
my authmysqlrc looks like this
MYSQL_SERVER localhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
# if you used the MySQL package from Server Logistics use the
# following settings otherwise check your MySQL installation.
MYSQL_SOCKET /private/tmp/mysql.sock
MYSQL_PORT 3306
# The name of the MySQL database we will use:
MYSQL_DATABASE postfix
# the table in the database with the users
MYSQL_USER_TABLE mailbox
# which field in the table has the password
MYSQL_CRYPT_PWFIELD password
# the numerical userid of the postfix account
MYSQL_UID_FIELD '5000'
#the numerical groupid of the postfix account
MYSQL_GID_FIELD '5000'
# the username as defined in the table mailbox
MYSQL_LOGIN_FIELD username
# the location of the mailboxes on the server
# Please change this is you are going to use a different location.
MYSQL_HOME_FIELD '/home/vmail'
# The user's name (optional)
MYSQL_NAME_FIELD name
# The location where the user mailbox is defined in the table.
MYSQL_MAILDIR_FIELD maildir ################################################
Could some one pls help me out here ......