PostgreSQL+Postfix+Nginx+PHP+RoundCube+Dovecot+ SpamAssassin+Clamav+Spamd - Page 5

NuLL3rr0r · #**101** August 17th, 2012, 01:14

Quote:

Originally Posted by graudeejs

Do you have user (or alias) www in database?

Nope. this is my only user with two aliases

Code:

-- create user
INSERT INTO mailbox VALUES ('3rr0r','babaei.net','{#############################}');

-- create virtual aliases
INSERT INTO mailbox_aliases VALUES ('postmaster@babaei.net', '3rr0r', 'babaei.net');
INSERT INTO mailbox_aliases VALUES ('root@babaei.net', '3rr0r', 'babaei.net');

NuLL3rr0r · #**102** August 17th, 2012, 14:54

Delivery failure report by gmail

Code:

This is an automatically generated Delivery Status Notification

THIS IS A WARNING MESSAGE ONLY.

YOU DO NOT NEED TO RESEND YOUR MESSAGE.

Delivery to the following recipient has been delayed:

     root@babaei.net

Message will be retried for 2 more day(s)

Technical details of temporary failure:
The recipient server did not accept our requests to connect. Learn more at 
http://support.google.com/mail/bin/answer.py?answer=7720
[(10) mx.babaei.net. [199.48.133.134]:25: Connection dropped]
[(10) mail.babaei.net. [199.48.133.134]:25: Connection dropped]

graudeejs · #**103** August 17th, 2012, 16:16

Quote:

Originally Posted by NuLL3rr0r

Nope. this is my only user with two aliases

Code:

-- create user
INSERT INTO mailbox VALUES ('3rr0r','babaei.net','{#############################}');

-- create virtual aliases
INSERT INTO mailbox_aliases VALUES ('postmaster@babaei.net', '3rr0r', 'babaei.net');
INSERT INTO mailbox_aliases VALUES ('root@babaei.net', '3rr0r', 'babaei.net');

I think you need to

Code:

INSERT INTO mailbox_aliases VALUES ('www@babaei.net', '3rr0r', 'babaei.net');

P.S. I'm rusty on this. I don't have my own server for about year or so

NuLL3rr0r · #**104** August 18th, 2012, 21:28

Hi graudeejs,

tnx for the answer. I added www to mailbox_aliases. To check if it's added:
SELECT * FROM mailbox_aliases;

Code:

        address        | dest_username | dest_domain | active
-----------------------+---------------+-------------+--------
 postmaster@babaei.net | 3rr0r         | babaei.net  | t
 root@babaei.net       | 3rr0r         | babaei.net  | t
 www@babaei.net        | 3rr0r         | babaei.net  | t
(3 rows)

Still www is unknown user:

Code:

Aug 18 20:13:12 3rr0r postfix/smtpd[1543]: connect from mail-bk0-
f44.google.com[209.85.214.44]
Aug 18 20:14:00 3rr0r postfix/pickup[99224]: 1726BBA48: uid=80 from=<www>
Aug 18 20:14:00 3rr0r postfix/cleanup[85682]: 1726BBA48: message-id=<20120818201400.1726BBA48@babaei.net>
Aug 18 20:14:00 3rr0r postfix/qmgr[30223]: 1726BBA48: from=<www@babaei.net>, size=501, 
nrcpt=1 (queue active)
Aug 18 20:14:00 3rr0r dovecot: auth(default): prefetch(3rr0r@babaei.net): userdb lookup not 
possible with only userdb prefetch
Aug 18 20:14:00 3rr0r postfix/pipe[69649]: 1726BBA48: to=<3rr0r@babaei.net>, orig_to=<www>, 
relay=dovecot, delay=0.03, delays=0.01/0.01/0/0, dsn=5.1.1, status=bounced (user unknown)
Aug 18 20:14:00 3rr0r postfix/cleanup[95668]: 1CD9BBACA: message-id=
<20120818201400.1CD9BBACA@babaei.net>
Aug 18 20:14:00 3rr0r postfix/bounce[99157]: 1726BBA48: sender non-delivery notification: 
1CD9BBACA
Aug 18 20:14:00 3rr0r postfix/qmgr[30223]: 1CD9BBACA: from=<>, size=2168, nrcpt=1 (queue 
active)
Aug 18 20:14:00 3rr0r postfix/qmgr[30223]: 1726BBA48: removed
Aug 18 20:14:00 3rr0r dovecot: auth(default): prefetch(3rr0r@babaei.net): userdb lookup not 
possible with only userdb prefetch
Aug 18 20:14:00 3rr0r postfix/pipe[69652]: 1CD9BBACA: to=<3rr0r@babaei.net>, orig_to=
<www@babaei.net>, relay=dovecot, delay=0.01, delays=0.01/0/0/0, dsn=5.1.1, status=bounced 
(user unknown)
Aug 18 20:14:00 3rr0r postfix/qmgr[30223]: 1CD9BBACA: removed

Maybe I did something wrong. I'll try to do it from the begging to see what happens.

Cthulhux · #**105** April 9th, 2013, 21:41

Not sure if I made some mistake...

I own the mail address root@somedomain.org which runs on FreeBSD 9.1. I copied and pasted the commands to create the cert.pem and key.pem files and entered somedomain.org when it asked for "my name". Then I added the cert.pem certificate to my MUA.

Still it fails to fetch mails:

Code:

Apr  9 22:06:59 servername dovecot: imap-login: Disconnected (no auth attempts): rip=91.11.9.88, lip=46.38.239.230, TLS handshaking: SSL_accept() failed: error:14094419:SSL routines:SSL3_READ_BYTES:tlsv1 alert access denied

According to my MUA log, the domain does not match.

What has gone wrong here?

graudeejs · #**106** April 11th, 2013, 20:47

I haven't done this for quite a while now, But depending on your config, perhaps you needed to type

Code:

*.somedomain.org

just a guess.
If I remember correctly, this allows you to have subdomains, which you probably have (main.somedomain.org ?)

Cthulhux · #**107** April 11th, 2013, 20:51

No, I don't.

My Dovecot/Postfix entirely listen(s) to the somedomain.org domain, no subdomains of it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Solved] postfix: fatal: chdir(/usr/libexec/postfix): No such file or directory	Blodia	Web & Network Services	21	January 12th, 2010 15:54
FreeBSD 7.2 Freezing, Locking on Lighttpd+php fast-cgi!!	francisco	Web & Network Services	4	October 13th, 2009 18:43
[Solved] Sendmail/SpamAssassin/Procmail/Roundcube	Lego	Web & Network Services	32	September 19th, 2009 02:47
[Solved] Sendmail + Spam Assassin + Roundcube	Lego	Installation and Maintenance of FreeBSD Ports or Packages	27	September 14th, 2009 01:30
Lighttpd : PHP : Sqlite3	lordmor	Web & Network Services	6	April 19th, 2009 00:24

The Following User Says Thank You to graudeejs For This Useful Post:
NuLL3rr0r (August 18th, 2012)