View Single Post
  #6  
Old 25th January 2008, 05:13
doronkeller doronkeller is offline
Junior Member
 
Join Date: Jan 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy still stuck

Hi,

I'm still perplexed by this one .
I attached this time some more information including the mysql log (which looks OK to me) and some postfix definition files. My postfix version is postfix-2.4.5-2.fc8.

Thanks...

sudo cat /etc/postfix/mysql-virtual_transports.cf
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT transport FROM transport WHERE domain='%s'
hosts = 127.0.0.1

sudo cat /etc/postfix/mysql-virtual_mailboxes.cf
user = mail_admin
password = mail_admin_password
dbname = mail

sudo cat /etc/postfix/mysql-virtual_mailbox_limit_maps.cf
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT quota FROM users WHERE email='%s'
hosts = 127.0.0.1
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
hosts = 127.0.0.1

sudo cat /etc/postfix/mysql-virtual_forwardings.cf
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT destination FROM forwardings WHERE source='%s'
hosts = 127.0.0.1

sudo cat /etc/postfix/mysql-virtual_email2email.cf
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = 127.0.0.1


sudo cat /etc/postfix/mysql-virtual_domains.cf
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1

mysql tables:
-------------
mysql> use mail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from domains;
+-------------+
| domain |
+-------------+
| example.com |
+-------------+
1 row in set (0.00 sec)

mysql> select * from users;
+-------------------+---------------+----------+
| email | password | quota |
+-------------------+---------------+----------+
| doron@example.com | bnTyKaRCPOvbA | 10485760 |
+-------------------+---------------+----------+
1 row in set (0.02 sec)

mysql> select * from forwardings;
Empty set (0.00 sec)

mysql> select * from transport;
Empty set (0.00 sec)

my.cnf:
-------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

bind-address = 127.0.0.1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


The mysql log:
--------------
/usr/libexec/mysqld, Version: 5.0.45-log (Source distribution). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
080124 19:33:23 1 Connect Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: NO)
080124 19:39:01 2 Connect mail_admin@localhost on mail
2 Query SELECT transport FROM transport WHERE domain='*'
2 Query SELECT transport FROM transport WHERE domain='*'
3 Connect mail_admin@localhost on mail
3 Query SELECT domain AS virtual FROM domains WHERE domain='mySender.com'
2 Query SELECT transport FROM transport WHERE domain='dkeller@mySender.com'
2 Query SELECT transport FROM transport WHERE domain='mySender.com'
2 Query SELECT transport FROM transport WHERE domain='.com'
3 Query SELECT domain AS virtual FROM domains WHERE domain='example.com'
2 Query SELECT transport FROM transport WHERE domain='doron@example.com'
2 Query SELECT transport FROM transport WHERE domain='example.com'
2 Query SELECT transport FROM transport WHERE domain='.us'
4 Connect mail_admin@localhost on mail
4 Query SELECT destination FROM forwardings WHERE source='doron@example.com'
5 Connect mail_admin@localhost on mail
5 Query SELECT email FROM users WHERE email='doron@example.com'
080124 19:39:09 6 Connect mail_admin@localhost on mail
6 Query set autocommit=1
6 Query SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN ('doron@example.com','@example.com','@.example.com ','@.us','@.')
080124 19:39:54 7 Connect mail_admin@localhost on mail
7 Query SELECT transport FROM transport WHERE domain='*'
7 Query SELECT transport FROM transport WHERE domain='*'
8 Connect mail_admin@localhost on mail
8 Query SELECT domain AS virtual FROM domains WHERE domain='mySender.com'
7 Query SELECT transport FROM transport WHERE domain='dkeller@mySender.com'
7 Query SELECT transport FROM transport WHERE domain='mySender.com'
7 Query SELECT transport FROM transport WHERE domain='.com'
8 Query SELECT domain AS virtual FROM domains WHERE domain='example.com'
7 Query SELECT transport FROM transport WHERE domain='doron@example.com'
7 Query SELECT transport FROM transport WHERE domain='example.com'
7 Query SELECT transport FROM transport WHERE domain='.us'
9 Connect mail_admin@localhost on mail
9 Query SELECT destination FROM forwardings WHERE source='doron@example.com'
080124 19:39:55 10 Connect mail_admin@localhost on mail
10 Query SELECT email FROM users WHERE email='doron@example.com'
7 Query SELECT transport FROM transport WHERE domain='*'
8 Query SELECT domain AS virtual FROM domains WHERE domain='example.com'
7 Query SELECT transport FROM transport WHERE domain='doron@example.com'
7 Query SELECT transport FROM transport WHERE domain='example.com'
7 Query SELECT transport FROM transport WHERE domain='.us'
7 Query SELECT transport FROM transport WHERE domain='*'
9 Query SELECT destination FROM forwardings WHERE source='dkeller@mySender.com'
10 Query SELECT email FROM users WHERE email='dkeller@mySender.com'
9 Query SELECT destination FROM forwardings WHERE source='@mySender.com'
10 Query SELECT email FROM users WHERE email='@mySender.com'
080124 19:39:56 8 Query SELECT domain AS virtual FROM domains WHERE domain='mySender.com'
7 Query SELECT transport FROM transport WHERE domain='dkeller@mySender.com'
7 Query SELECT transport FROM transport WHERE domain='mySender.com'
7 Query SELECT transport FROM transport WHERE domain='.com'
080124 19:40:01 5 Quit
080124 19:40:55 10 Quit


Postfix Log:
------------
Jan 24 19:39:00 web postfix/smtpd[2657]: connect from mail.mySender.com[1.2.3.4]
Jan 24 19:39:01 web postfix/smtpd[2657]: C3CA8429F: client=mail.mySender.com[1.2.3.4]
Jan 24 19:39:02 web postfix/cleanup[2666]: C3CA8429F: message-id=<F7A41358F8C60649845896DA64953A16916822@mySende r14.mySender.com>
Jan 24 19:39:02 web postfix/smtpd[2657]: disconnect from mail.mySender.com[1.2.3.4]
Jan 24 19:39:02 web postfix/qmgr[1772]: C3CA8429F: from=<dkeller@mySender.com>, size=11597, nrcpt=1 (queue active)
Jan 24 19:39:12 web clamd[1669]: No stats for Database check - forcing reload
Jan 24 19:39:12 web clamd[1669]: Reading databases from /var/lib/clamav
Jan 24 19:39:47 web clamd[1669]: Database correctly reloaded (364783 signatures)
Jan 24 19:39:54 web postfix/smtpd[2675]: connect from unknown[127.0.0.1]
Jan 25 03:39:54 web postfix/smtpd[2675]: E2D7442A0: client=unknown[127.0.0.1]
Jan 24 19:39:55 web postfix/cleanup[2666]: E2D7442A0: message-id=<F7A41358F8C60649845896DA64953A16916822@mySende r14.mySender.com>
Jan 24 19:39:55 web postfix/qmgr[1772]: E2D7442A0: from=<dkeller@mySender.com>, size=12019, nrcpt=1 (queue active)
Jan 25 03:39:55 web postfix/smtpd[2675]: disconnect from unknown[127.0.0.1]
Jan 24 19:39:55 web amavis[2165]: (02165-01) Passed CLEAN, [1.2.3.4] [1.2.3.4] <dkeller@mySender.com> -> <doron@example.com>, Message-ID: <F7A41358F8C60649845896DA64953A16916822@mySender14 .mySender.com>, mail_id: WTQ22l3CWd9H, Hits: -2.199, size: 11597, queued_as: E2D7442A0, 50864 ms
Jan 24 19:39:55 web postfix/smtp[2667]: C3CA8429F: to=<doron@example.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=54, delays=0.72/0.19/5/48, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as E2D7442A0)
Jan 24 19:39:55 web postfix/qmgr[1772]: C3CA8429F: removed
Jan 24 19:39:55 web postfix/virtual[2683]: E2D7442A0: to=<doron@example.com>, relay=virtual, delay=1.1, delays=0.19/0.56/0/0.29, dsn=5.1.1, status=bounced (unknown user: "doron@example.com")
Jan 24 19:39:55 web postfix/cleanup[2666]: EB762429F: message-id=<20080125033955.EB762429F@web.example.com>
Jan 24 19:39:56 web postfix/qmgr[1772]: EB762429F: from=<>, size=13821, nrcpt=1 (queue active)
Jan 24 19:39:56 web postfix/bounce[2684]: E2D7442A0: sender non-delivery notification: EB762429F
Jan 24 19:39:56 web postfix/qmgr[1772]: E2D7442A0: removed
Jan 24 19:39:56 web postfix/smtp[2685]: EB762429F: to=<dkeller@mySender.com>, relay=mail.mySender.com[1.2.3.4]:25, delay=0.72, delays=0.17/0.1/0.14/0.31, dsn=2.0.0, status=sent (250 +OK message queued for delivery.)
Jan 24 19:39:56 web postfix/qmgr[1772]: EB762429F: removed
Jan 24 19:42:22 web postfix/anvil[2660]: statistics: max connection rate 1/60s for (smtp:1.2.3.4) at Jan 24 19:39:00
Jan 24 19:42:22 web postfix/anvil[2660]: statistics: max connection count 1 for (smtp:1.2.3.4) at Jan 24 19:39:00
Jan 24 19:42:22 web postfix/anvil[2660]: statistics: max cache size 1 at Jan 24 19:39:00
Reply With Quote