Postfix Usuarios Virtuales en MySQL

Bienvenido(a) a Alcance Libre 23/10/2025, 05:19

Alcance Libre Foros

	Índice del foro > Todo acerca de Linux > Redes y Servidores	New Topic Post Reply
Postfix Usuarios Virtuales en MySQL

Santiago Fernandez

27/04/07 02:07 (Leído 4,361 veces)

Participa poco

Estado: desconectado

Identificado: 30/03/07
Mensajes: 27
Localización:Hurlingham Buenos Aires Argentina

Buenas chicos. Tengo problemas con el recibo de correos para usuarios virtuales, con los del sistema no tengo problemas.

Por lo que vi del log del MySQL el QUERY se realiza pero no encuentra la tabla.

Se que algo esta mal pero no que...los rechazos de los mail que envio a mis usuarios me dicen que el usuario no existe.

Les posteo los logs a ver que me dicen y la estructura de la tabla passwd donde contienen los usuarios

Tabla

mysql> use mail
Database changed
mysql> show tables;
+----------------+
| Tables_in_mail |
+----------------+
| passwd |
+----------------+
1 row in set (0.00 sec)

mysql> select * from passwd
-> ;
+---------------------------+----------+------+------+-----+------+---------------------+
| id | clear | name | uid | gid | home | maildir |
+---------------------------+----------+------+------+-----+------+---------------------+
| usr1@coordenadaweb.com.ar | usr1pass | usr1 | 1003 | 8 | / | /path/usr1/Maildir/ |
| usr2@coordenadaweb.com.ar | usr2pass | usr2 | 1002 | 8 | / | /path/usr2/Maildir/ |
| usr3@coordenadaweb.com.ar | usr3pass | usr3 | 1004 | 8 | / | /path/usr3/Maildir/ |
| usr3@example.net | usr3pass | usr3 | 1004 | 8 | / | / |
| usr3@coordenadaweb.com.ar | usr3pass | usr3 | 1004 | 8 | / | / |
+---------------------------+----------+------+------+-----+------+---------------------+
5 rows in set (0.00 sec)

/var/log/mail.log

or directory
Apr 27 12:58:12 localhost postfix/master[1082]: warning: process /usr/lib/postfix/virtual pid 2955 exit status 1
Apr 27 12:58:12 localhost postfix/master[1082]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
Apr 27 12:59:12 localhost postfix/virtual[2956]: fatal: open /etc/postfix/gids.cf: No such file or directory
Apr 27 12:59:13 localhost postfix/master[1082]: warning: process /usr/lib/postfix/virtual pid 2956 exit status 1
Apr 27 12:59:13 localhost postfix/master[1082]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
Apr 27 12:59:37 localhost postfix/smtpd[2957]: connect from nz-out-0506.google.com[64.233.162.236]
Apr 27 12:59:38 localhost postfix/smtpd[2957]: NOQUEUE: reject: RCPT from nz-out-0506.google.com[64.233.162.236]: 550 5.1.1 <usr1@coordenadaweb.com.ar>: Recipient address rejected: User unknown in local recipient table; from=<santiagoagustinfernandez@gmail.com> to=<usr1@coordenadaweb.com.ar> proto=ESMTP helo=<nz-out-0506.google.com>
Apr 27 12:59:38 localhost postfix/smtpd[2957]: disconnect from nz-out-0506.google.com[64.233.162.236]

MySQL log;

14 Init DB mail
070427 12:58:25 14 Query show tables
070427 12:58:51 14 Query select * from passwd
070427 12:59:03 14 Quit
070427 12:59:38 15 Connect postfix@localhost on mail
15 Query SELECT maildir FROM passwd WHERE id='gmail.com'
15 Query SELECT maildir FROM passwd WHERE id='coordenadaweb.com.ar'
070427 13:00:38 15 Quit

Seguramente es algo mal puesto en la tabla pero no logro desifrar que?

Los posteo el main.cf del Postfix

# See /usr/share/postfix/main.cf.dist for a commented, more complete version

# Debian specific: Specifying a file name will cause the first
# line of that file to be used as the name. The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

# TLS parameters
#smtpd_tls_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem
#smtpd_tls_key_file=/etc/ssl/private/ssl-cert-snakeoil.key
#smtpd_use_tls=yes
#smtpd_tls_session_cache_database = btree:${queue_directory}/smtpd_scache
#smtp_tls_session_cache_database = btree:${queue_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
mail_owner = postfix
myhostname = coordenadaweb.com.ar
myorigin = /etc/mailname
mydestination = coordenadaweb.com.ar, localhost.com.ar, , localhost
relay_domains = $mydestination
mynetworks = 192.168.0.0/24
smtpd_banner = $myhostname ESMTP $mail_name
debug_peer_level = 2
debugger_command = PATH=/usr/bin:/usr/X11R6/bin xxgdb $daemon_directory/$process_name $process_id & sleep 5
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
virtual_uid_maps=mysql:/etc/postfix/ids.cf
virtual_gid_maps=mysql:/etc/postfix/gids.cf
virtual_mailbox_base=/
virtual_mailbox_maps=mysql:/etc/postfix/mysql_virt.cf
local_transport = virtual
program_directory = /usr/lib/postfix
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

Desde ya gracias por su tiempo. Y espero que me puedan ayudar.

Profile