Hello,
I am getting really close to have my server up and running. When I send an email from e.g. hotmail to the dbmail setup , the following is shown in my maillog. The message is rejected. Apr 27 15:09:37 fels postfix/smtpd[639]: connect from bay8-f10.bay8.hotmail.com[64.4.27.10] Apr 27 15:09:38 fels postfix/smtpd[639]: 1FFD920A7: client=bay8-f10.bay8.hotmail.com[64.4.27.10] Apr 27 15:09:38 fels postfix/smtpd[639]: 1FFD920A7: reject: RCPT from bay8-f10.bay8.hotmail.com[64.4.27.10]: 450 <[EMAIL PROTECTED]>: User unknown in local recipient table; from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]> proto=ESMTP helo=<hotmail.com> Apr 27 15:09:39 fels postfix/smtpd[639]: disconnect from bay8-f10.bay8.hotmail.com[64.4.27.10] Hereunder is proof that the user "jankees" does exist in mysql. This user is not present on the os level. Before I used dbmail, I simply used postfix and some pop daemon based on os users. Now, I have removed the osuser "jankees" and have set it up in mysql. mysql> select * from users; +-----------+---------+--------+-------------+--------------+--------------- --+---------------------+ | user_idnr | userid | passwd | client_idnr | maxmail_size | encryption_type | last_login | +-----------+---------+--------+-------------+--------------+--------------- --+---------------------+ | 1 | jankees | secret | 0 | 0 | | 2004-04-27 15:04:01 | | 2 | sharon | secret | 0 | 0 | | 2004-04-27 13:24:57 | +-----------+---------+--------+-------------+--------------+--------------- --+---------------------+ 2 rows in set (0.01 sec) mysql> select * from aliases; +------------+------------------------+------------+-------------+ | alias_idnr | alias | deliver_to | client_idnr | +------------+------------------------+------------+-------------+ | 1 | [EMAIL PROTECTED] | 1 | 0 | | 2 | [EMAIL PROTECTED] | 2 | 0 | +------------+------------------------+------------+-------------+ 2 rows in set (0.02 sec) Attached are some relevant files. Also, I don't have a good feeling about the dbmail-smtp. I don't see it listed in the ps- aux. Cheers, JK
transport
Description: Binary data
aliases
Description: Binary data
dbmail.conf
Description: Binary data
main.cf
Description: Binary data
master.cf
Description: Binary data
fels# ps -aux USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND root 11 97.9 0.0 0 12 ?? RL 2:52PM 4:27.70 (idle: cpu0) root 595 2.6 0.4 2360 1816 p0 Ss 2:56PM 0:00.06 -csh (csh) root 1 0.0 0.1 760 376 ?? ILs 2:52PM 0:00.02 /sbin/init -- root 17 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (irq6: fdc0) root 18 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (irq7: ppc0) root 21 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (irq10: rl0) root 23 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (irq12: uhci0) root 25 0.0 0.0 0 12 ?? WL 2:52PM 0:00.03 (irq14: ata0) root 26 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (irq15: ata1) root 27 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (swi1: net) root 28 0.0 0.0 0 12 ?? WL 2:52PM 0:00.43 (swi8: tty:sio clock) root 2 0.0 0.0 0 12 ?? DL 2:52PM 0:00.04 (g_event) root 3 0.0 0.0 0 12 ?? DL 2:52PM 0:00.12 (g_up) root 4 0.0 0.0 0 12 ?? DL 2:52PM 0:00.14 (g_down) root 30 0.0 0.0 0 12 ?? DL 2:52PM 0:00.04 (random) root 5 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (taskqueue) root 33 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (swi7: acpitaskq) root 36 0.0 0.0 0 12 ?? WL 2:52PM 0:00.00 (swi7: task queue) root 6 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (acpi_task0) root 7 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (acpi_task1) root 8 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (acpi_task2) root 37 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (usb0) root 38 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (usbtask) root 9 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (pagedaemon) root 40 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (vmdaemon) root 41 0.0 0.0 0 12 ?? DL 2:52PM 0:03.18 (pagezero) root 42 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (bufdaemon) root 43 0.0 0.0 0 12 ?? DL 2:52PM 0:00.02 (syncer) root 44 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (vnlru) root 45 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (nfsiod 0) root 46 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (nfsiod 1) root 47 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (nfsiod 2) root 48 0.0 0.0 0 12 ?? IL 2:52PM 0:00.00 (nfsiod 3) root 165 0.0 0.1 1180 644 ?? Is 2:52PM 0:00.00 adjkerntz -i root 257 0.0 0.2 1312 876 ?? Ss 2:52PM 0:00.06 /usr/sbin/syslogd -s root 359 0.0 0.1 1236 760 ?? Ss 2:52PM 0:00.00 /usr/sbin/usbd root 406 0.0 0.5 3488 2440 ?? Ss 2:52PM 0:00.27 /usr/sbin/sshd root 426 0.0 0.2 1336 1028 ?? Is 2:52PM 0:00.01 /usr/sbin/cron root 485 0.0 0.2 1120 940 ?? Is 2:52PM 0:00.05 /usr/local/libexec/postfix/master postfix 486 0.0 0.2 1140 948 ?? I 2:52PM 0:00.02 pickup -l -t fifo -u postfix 487 0.0 0.2 1176 980 ?? I 2:52PM 0:00.03 qmgr -l -t fifo -u root 493 0.0 0.4 2620 2124 ?? Ss 2:52PM 0:00.08 /usr/local/sbin/httpd root 497 0.0 0.1 924 636 con- I 2:52PM 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/ mysql 532 0.0 3.9 51856 20348 con- S 2:52PM 0:00.86 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/m www 533 0.0 0.4 2636 2152 ?? I 2:52PM 0:00.00 /usr/local/sbin/httpd www 534 0.0 0.4 2636 2152 ?? I 2:52PM 0:00.00 /usr/local/sbin/httpd www 535 0.0 0.4 2636 2152 ?? I 2:52PM 0:00.00 /usr/local/sbin/httpd www 536 0.0 0.4 2636 2152 ?? I 2:52PM 0:00.00 /usr/local/sbin/httpd www 537 0.0 0.4 2636 2152 ?? I 2:52PM 0:00.00 /usr/local/sbin/httpd root 565 0.0 0.2 1276 944 v0 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv0 root 566 0.0 0.2 1276 944 v1 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv1 root 567 0.0 0.2 1276 944 v2 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv2 root 568 0.0 0.2 1276 944 v3 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv3 root 569 0.0 0.2 1276 944 v4 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv4 root 570 0.0 0.2 1276 944 v5 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv5 root 571 0.0 0.2 1276 944 v6 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv6 root 572 0.0 0.2 1276 944 v7 Is+ 2:52PM 0:00.01 /usr/libexec/getty Pc ttyv7 root 593 0.1 0.6 6196 2852 ?? Ss 2:56PM 0:00.07 sshd: [EMAIL PROTECTED] (sshd) root 0 0.0 0.0 0 4 ?? DLs 2:52PM 0:00.00 (swapper) root 597 0.0 0.2 1388 884 p0 R+ 2:56PM 0:00.00 ps -aux root 10 0.0 0.0 0 12 ?? DL 2:52PM 0:00.00 (ktrace)
