From: Wietse Venema (wietseporcupine.org)
Date: Wed Apr 16 2003 - 07:48:54 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

If running chrooted, try using the proxy map feature:

virtual_alias_maps = proxy:mysql:/etc/postfix/confmysql/virtual.cf

        Wietse

S?bastien Eckert:
> Hi,
>
> i want install more than 1 domain name for mail on my computer.
> So i had choise to implement this with mysql (because we can so maintaint the user and domain database trough php and other application).
> I had a mysql server which is installed since 5 month and it work very good (we use it everyday), i had a postfix which is working very good to for 1 domain.
>
> Here is my problem:
>
> /var/log/mail/errors
> Apr 15 16:16:55 serveur postfix/trivial-rewrite[9160]: fatal: mysql:/etc/postfix/confmysql/virtual.cf: table lookup problem
> Apr 15 16:17:06 serveur postfix/trivial-rewrite[9161]: fatal: mysql:/etc/postfix/confmysql/virtual.cf: table lookup problem
>
> /var/log/mail/warnings
> Apr 16 07:16:41 serveur postfix/trivial-rewrite[31891]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (40)
> Apr 16 09:16:42 serveur postfix/master[31880]: warning: process /usr/lib/postfix/trivial-rewrite pid 31891 exit status 1
> Apr 16 09:16:42 serveur postfix/master[31880]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
> Apr 16 07:16:42 serveur postfix/smtpd[31889]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
>
> [rootserveur root]# postconf -n
> alias_database = hash:/etc/postfix/aliases
> alias_maps = hash:/etc/postfix/aliases
> command_directory = /usr/sbin
> config_directory = /etc/postfix
> daemon_directory = /usr/lib/postfix
> debug_peer_level = 2
> default_privs = nobody
> delay_warning_time = 4
> mail_owner = postfix
> mail_spool_directory = /var/spool/mail
> mailbox_command = /usr/bin/procmail -Y -a $DOMAIN
> mailq_path = /usr/bin/mailq
> manpage_directory = /usr/share/man
> mydestination = $myhostname, localhost.$mydomain $mydomain , $transport_maps
> mydomain = masterdomain.net
> myhostname = serveur.masterdomain.net
> myorigin = $mydomain
> newaliases_path = /usr/bin/newaliases
> queue_directory = /var/spool/postfix
> readme_directory = /usr/share/doc/postfix-1.1.11/README_FILES
> sample_directory = /usr/share/doc/postfix-1.1.11/samples
> sender_canonical_maps = hash:/etc/postfix/canonical
> sendmail_path = /usr/sbin/sendmail
> setgid_group = postdrop
> smtpd_banner = $myhostname ESMTP $mail_name ($mail_version) (Mandrake Linux)
> transport_maps = mysql:/etc/postfix/confmysql/transport.cf
> unknown_local_recipient_reject_code = 450
> virtual_gid_maps = mysql:/etc/postfix/confmysql/gids.cf
> virtual_mailbox_base = /var/spool/mail/virtual/
> virtual_mailbox_maps = mysql:/etc/postfix/confmysql/mysql_virt.cf
> virtual_uid_maps = mysql:/etc/postfix/confmysql/uids.cf
>
>
> [rootserveur root]# cat /etc/postfix/confmysql/virtual.cf
> hosts=localhost
> user = postfix
> password = mypassword
>
> dbname = postfix
>
> table = virtual
>
> select_field = goto
> where_field = address
>
> additional_conditions = and 1
>
>
> I had test to connect to the database with login pass from postfix and it work ....

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]