Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Fedora This forum is for the discussion of the Fedora Project.


  Search this Thread
Old 10-15-2004, 09:24 PM   #1
LQ Newbie
Registered: Oct 2004
Location: Melbourne Australia
Posts: 1

Rep: Reputation: 0
Unhappy mysql, postfix, dovecot & spamassassin

Hi guys,


I have the following installed on my Fedora C2 box. Love Fedora is great.

Fedora C2
MySql 4.0.21
Postfix 2.1.5
Spamassassin 2.63

My mail server was receiving and sending mail fine. Untill I configured dovecot and spamassassin. I still can send and receive emails but all the received emails get routed to one user ( thats to me). I have created an aliase for "root" and every other email that comes for other users get o me. WHT IS THAT. Do I have to out some entries into my postfix database tables?? Do I have to create a user list pf some sort for mysql?

below is my config:
## Postfix $ mysql cfg
home_mailbox = Maildir/
recipient_delimiter = +
mydestination = $myhostname,$transport_maps
alias_maps = mysql:/etc/postfix/
relocated_maps = mysql:/etc/postfix/
transport_maps = mysql:/etc/postfix/
virtual_maps = mysql:/etc/postfix/
local_recipient_maps = $alias_maps $virtual_mailbox_maps unixasswd.byname

virtual_mailbox_base = /home/vmail
virtual_mailbox_maps = mysql:/etc/postfix/
virtual_uid_maps = mysql:/etc/postfix/
virtual_gid_maps = mysql:/etc/postfix/

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
mail_owner = postfix

myhostname =
mydomain =
myorigin = $mydomain

unknown_local_recipient_reject_code = 550
debug_peer_level = 2
debugger_command = \
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin \
xxgdb $daemon_directory/$process_name $process_id & sleep 5 \
sendmail_path = /usr/sbin/sendmail.postfix
newaliases_path = /usr/bin/newaliases.postfix
mailq_path = /usr/bin/mailq.postfix
setgid_group = postdrop
html_directory = /usr/share/doc/postfix-2.1.5-documentation/html
manpage_directory = /usr/share/man
sample_directory = /etc/postfix
readme_directory = /usr/share/doc/postfix-2.1.5-documentation/readme

broken_sasl_auth_clients = yes
smtpd_sasl_security_options = noanonymous
smtpd_recipient_restrictions = permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_local_domain = $myhostname
smtpd_hello_required = yes
smtpd_hello_restrictions = permit_mynetworks, reject_invalid_hostname, reject_unauth_pipelining, reject_unknow_sender_domain
alias_database = hash:/etc/postfix/aliases
smtpd_helo_required = yes
user = postfix
password = mypassword
dbname = postfix
table = postfix_transport
select_field = destination
where_field = domain
hosts = localhost

MANY THANKS GUYS!!! I am new to Fedora and Mail servers.

Old 10-18-2004, 08:40 PM   #2
LQ Newbie
Registered: Sep 2004
Location: Melbourne - Australia
Distribution: ?
Posts: 2

Rep: Reputation: 0
Hey Guys,

Well I have resolved the issue by removing the transport map for mysql. I now can receive and send emails to all users with UID's but not for virtual users, I think the issue is still with mysql. I don't know why it does not populate the database tables. Is there someone here is has any idea, please



Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix Dovecot Help BigAppleFan Linux - Newbie 7 08-15-2005 05:08 PM
Postfix Dovecot Spamassassin php4u Fedora 1 04-09-2005 02:48 AM
Spamassassin setup with Postfix, Dovecot and Amavisd snurckle Linux - General 2 04-07-2005 12:16 PM
Fedora & Postfix & SpamAssassin bigdogg Linux - Software 20 09-16-2004 03:08 PM
Postfix & MySQL & POP3 on Redhat.. hct224 Linux - Newbie 0 05-20-2004 03:15 PM > Forums > Linux Forums > Linux - Distributions > Fedora

All times are GMT -5. The time now is 07:29 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration