Re: First Insallation, Bouncing Emails

2011-10-22 Thread Jack Meagain 


From: Reindl Harald 
To: postfix-users@postfix.org
Sent: Saturday, October 22, 2011 6:06 AM
Subject: Re: First Insallation, Bouncing Emails

I am still getting the following errors:

Oct 22 07:26:28 13gems dovecot: pop3-login: Disconnected (tried to use disabled 
plaintext auth): rip=66.248.165.32, lip=209.216.9.56
Oct 22 07:26:41 13gems postfix/smtpd[1263]: connect from unknown[66.248.165.32]
Oct 22 07:26:41 13gems postfix/smtpd[1263]: lost connection after EHLO from 
unknown[66.248.165.32]
Oct 22 07:26:41 13gems postfix/smtpd[1263]: disconnect from 
unknown[66.248.165.32]
Oct 22 07:27:31 13gems dovecot: pop3-login: Disconnected (no auth attempts): 
rip=66.248.165.32, lip=209.216.9.56
Oct 22 07:27:51 13gems postfix/smtpd[1263]: connect from unknown[66.248.165.32]
Oct 22 07:27:51 13gems postfix/smtpd[1263]: lost connection after EHLO from 
unknown[66.248.165.32]
Oct 22
 07:27:51 13gems postfix/smtpd[1263]: disconnect from unknown[66.248.165.32]
Oct 22 07:28:51 13gems postfix/smtpd[1263]: connect from unknown[66.248.165.32]
Oct 22 07:28:51 13gems postfix/smtpd[1263]: lost connection after EHLO from 
unknown[66.248.165.32]
Oct 22 07:28:51 13gems postfix/smtpd[1263]: disconnect from 
unknown[66.248.165.32]
Oct 22 07:29:51 13gems postfix/smtpd[1263]: connect from unknown[66.248.165.32]
Oct 22 07:29:51 13gems postfix/smtpd[1263]: lost connection after EHLO from 
unknown[66.248.165.32]
Oct 22 07:29:51 13gems postfix/smtpd[1263]: disconnect from 
unknown[66.248.165.32]
Oct 22 07:30:31 13gems postfix/smtpd[1263]: connect from 
outbound5.eb.emediausa.com[184.106.21.203]
Oct 22 07:30:32 13gems postfix/smtpd[1263]: NOQUEUE: reject: RCPT from 
outbound5.eb.emediausa.com[184.106.21.203]: 554 5.7.1 
: Relay access denied; 
from=
 to= proto=ESMTP helo=
Oct 22 07:30:33 13gems postfix/anvil[30239]: statistics: max connection rate 
1/60s for (smtp:69.171.232.147) at Oct 22 07:20:52
Oct 22 07:30:33 13gems postfix/anvil[30239]: statistics: max connection count 1 
for (smtp:69.171.232.147) at Oct 22 07:20:52
Oct 22 07:30:33 13gems postfix/anvil[30239]: statistics: max cache size 2 at 
Oct 22 07:21:01

I don't know how to add pertinent user/domain data to my mysql tables. I'm 
going to look at the postfixadmin php files to try and figure out how to

Re: First Insallation, Bouncing Emails

2011-10-22 Thread Reindl Harald 


Am 22.10.2011 11:50, schrieb Bastian Blank:
> On Fri, Oct 21, 2011 at 04:39:28PM +0200, Reindl Harald wrote:
>> i bet this is a debian system and your postfix is chrooted
>> "-" and "y" in this column is yes - change it to n and if i am
>> right complain debian why these dumb maintainers do not stop
>> their chroot-default which leads to trouble most of time
> 
> Can you please explain how syntax errors within the never chrooted
> proxymap daemon can be caused by a chroot setup? 

if people start posting random logs without configurations and there
are "no such file or directory" messages i guess chroot is active

my answer is the result of posting without thinking a second becuase
if someone spits random logparts in his message it happens that the
only interesting ine with the mysql-syntax-error get overlooked

http://www.postfix.org/DEBUG_README.html
and no this instructions would not be needed if people start thinking
what informations someone needs if he want to help!

>>> Oct 20 10:13:15 example postfix/smtpd[30152]: warning: TLS library problem: 
>>> 30152:error:02001002:system
>>> library:fopen:No such file or 
>>> directory:bss_file.c:122:fopen('/etc/pki/tls/certs/cert.pem','r'):

> And please stop calling people "dumb" just because you don't conform with 
> their decisions

if people are dumb i call them dumb and the maintainers of debilian are dumb

what valid reason is there to be the only distribution using 
non-upstream-defaults
which are the reason for "hep me psotfix does not work" the most time on this 
list?



signature.asc
Description: OpenPGP digital signature

Re: First Insallation, Bouncing Emails

2011-10-22 Thread Bastian Blank 
On Fri, Oct 21, 2011 at 05:16:04PM -0400, beno - wrote:
> Oct 21 08:20:44 example postfix/smtpd[23702]: connect from
> host.peakskillmediacenters.com[50.7.6.219]
> Oct 21 08:20:45 example postfix/smtpd[23702]: NOQUEUE: reject: RCPT from
> host.peakskillmediacenters.com[50.7.6.219]: 554 5.7.1 <
> ddejo...@dejonghgroup.com>: Relay access denied; from=
> to= proto=ESMTP helo=
> Oct 21 08:20:45 example postfix/smtpd[23702]: too many errors after RCPT
> from host.peakskillmediacenters.com[50.7.6.219]

Is this server in stress mode?

> Looks like the same problem over and over again. Please advise. Will be
> offline for a few hours.

You should kill the complete config and start over. You don't understand
what it does. And use the _postfix_ documentation, which you can reach
via http://www.postfix.org/documentation.html.

Bastian

-- 
You're dead, Jim.
-- McCoy, "Amok Time", stardate 3372.7

Re: First Insallation, Bouncing Emails

2011-10-22 Thread Bastian Blank 
On Fri, Oct 21, 2011 at 04:39:28PM +0200, Reindl Harald wrote:
> i bet this is a debian system and your postfix is chrooted
> "-" and "y" in this column is yes - change it to n and if i am
> right complain debian why these dumb maintainers do not stop
> their chroot-default which leads to trouble most of time

Can you please explain how syntax errors within the never chrooted
proxymap daemon can be caused by a chroot setup? And please stop calling
people "dumb" just because you don't conform with their decisions.

Bastian

-- 
Immortality consists largely of boredom.
-- Zefrem Cochrane, "Metamorphosis", stardate 3219.8

Re: First Insallation, Bouncing Emails

2011-10-21 Thread beno - 
Hi;
For some reason, having trouble with my yahoo account. Using friend's...

From: Heiko Wundram 
To: postfix-users@postfix.org
Sent: Friday, October 21, 2011 11:01 AM
Subject: Re: First Insallation, Bouncing Emails

> Am 21.10.2011 16:52, schrieb Jack Fredrikson:
>> That error appears to come from a file called /etc/postfix/
mysql_virtual_alias_maps.cf that has this line:
>> SELECT goto FROM alias WHERE address = ‘%s’ AND active = 1
>> Therefore, the address has question marks in it. Looks like a hacker, no?
>
> No, the quotation marks in that file are broken. Use '' (simple marks),
and not some typographic variant of those (i.e., represented as three bytes
in
> UTF-8, which gets logged as ???).

Arrggg! That was a subtle error! Thanks!!! Here's the latest printout from
/var/log/maillog:

Oct 21 08:20:44 example postfix/smtpd[23702]: connect from
host.peakskillmediacenters.com[50.7.6.219]
Oct 21 08:20:45 example postfix/smtpd[23702]: NOQUEUE: reject: RCPT from
host.peakskillmediacenters.com[50.7.6.219]: 554 5.7.1 <
ddejo...@dejonghgroup.com>: Relay access denied; from=
to= proto=ESMTP helo=
Oct 21 08:20:45 example postfix/smtpd[23702]: too many errors after RCPT
from host.peakskillmediacenters.com[50.7.6.219]
Oct 21 08:20:45 example postfix/smtpd[23702]: disconnect from
host.peakskillmediacenters.com[50.7.6.219]
Oct 21 08:20:45 example postfix/smtpd[23706]: connect from
mta3.dealer.sel.sony.com[74.116.6.208]
Oct 21 08:20:45 example postfix/smtpd[23706]: NOQUEUE: reject: RCPT from
mta3.dealer.sel.sony.com[74.116.6.208]: 554 5.7.1 :
Relay access denied; from= to=<
ddejo...@dejonghgroup.com> proto=ESMTP helo=
Oct 21 08:20:45 example postfix/smtpd[23706]: too many errors after RCPT
from mta3.dealer.sel.sony.com[74.116.6.208]
Oct 21 08:20:45 example postfix/smtpd[23706]: disconnect from
mta3.dealer.sel.sony.com[74.116.6.208]
Oct 21 08:20:58 example postfix/smtpd[23683]: warning: 115.167.111.169:
hostname 115-167-111-169.wi-tribe.net.pk verification failed: Name or
service not known
Oct 21 08:20:58 example postfix/smtpd[23683]: connect from
unknown[115.167.111.169]
Oct 21 08:20:59 example postfix/smtpd[23683]: lost connection after MAIL
from unknown[115.167.111.169]
Oct 21 08:20:59 example postfix/smtpd[23683]: disconnect from
unknown[115.167.111.169]
Oct 21 08:20:59 example postfix/smtpd[23713]: connect from
mta52.mt-cloud.net[216.213.172.165]
Oct 21 08:20:59 example postfix/smtpd[23713]: lost connection after CONNECT
from mta52.mt-cloud.net[216.213.172.165]
Oct 21 08:20:59 example postfix/smtpd[23713]: disconnect from
mta52.mt-cloud.net[216.213.172.165]
Oct 21 08:20:59 example postfix/smtpd[23688]: connect from
server107d.exghost.com[204.232.236.207]
Oct 21 08:21:00 example postfix/smtpd[23688]: NOQUEUE: reject: RCPT from
server107d.exghost.com[204.232.236.207]: 554 5.7.1 <
rdejo...@dejonghgroup.com>: Relay access denied; from=<
jwickl...@whartonsmith.com> to= proto=ESMTP
helo=
Oct 21 08:21:00 example postfix/smtpd[23688]: too many errors after RCPT
from server107d.exghost.com[204.232.236.207]
Oct 21 08:21:00 example postfix/smtpd[23688]: disconnect from
server107d.exghost.com[204.232.236.207]
Oct 21 08:21:02 example postfix/smtpd[23704]: connect from
unknown[213.55.83.132]
Oct 21 08:21:03 example postfix/smtpd[23704]: NOQUEUE: reject: RCPT from
unknown[213.55.83.132]: 554 5.7.1 : Relay access
denied; from= to= proto=SMTP
helo=
Oct 21 08:21:03 example postfix/smtpd[23704]: too many errors after RCPT
from unknown[213.55.83.132]
Oct 21 08:21:03 example postfix/smtpd[23704]: disconnect from
unknown[213.55.83.132]
Oct 21 08:21:08 example postfix/smtpd[23711]: connect from
unknown[66.248.165.32]
Oct 21 08:21:09 example postfix/smtpd[23702]: connect from mail.nghia.vn
[116.109.128.19]
Oct 21 08:21:10 example postfix/smtpd[23701]: connect from
mta834.shop.josbank.com[63.236.77.173]
Oct 21 08:21:10 example postfix/smtpd[23711]: lost connection after EHLO
from unknown[66.248.165.32]
Oct 21 08:21:10 example postfix/smtpd[23711]: disconnect from
unknown[66.248.165.32]
Oct 21 08:21:11 example postfix/smtpd[23701]: NOQUEUE: reject: RCPT from
mta834.shop.josbank.com[63.236.77.173]: 554 5.7.1 :
Relay access denied; from=<
bo-bwtejugauwpkk5au7z7apbd7qr0...@b.shop.josbank.com> to=<
ddejo...@dejonghgroup.com> proto=SMTP helo=
Oct 21 08:21:11 example postfix/smtpd[23701]: too many errors after RCPT
from mta834.shop.josbank.com[63.236.77.173]
Oct 21 08:21:11 example postfix/smtpd[23701]: disconnect from
mta834.shop.josbank.com[63.236.77.173]
Oct 21 08:21:11 example postfix/smtpd[23707]: warning: 174.136.69.254:
hostname Hypv2483.appliedi.net verification failed: Name or service not
known
Oct 21 08:21:11 example postfix/smtpd[23707]: connect from
unknown[174.136.69.254]
Oct 21 08:21:11 example postfix/smtpd[23707]: NOQUEUE: reject: RCPT from
unknown[174.136.69.254]: 554 5.7.1 : Relay access
denied; from= to= proto=ESMTP
helo=
Oct 21 08:21:1

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Simon Brereton 
2011/10/21 Leslie León Sinclair :
> Something like:
>
> 
> user = user_for_db
> password = password_for_db
> hosts = localhost
> dbname = database_name
> query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
> 


Thanks.  But I think we should see what the OP has in his.  As someone
already pointed out, if it's not using the correct quote it will be
misinterpreted.

Simon

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Leslie León Sinclair 

Something like:


user = user_for_db
password = password_for_db
hosts = localhost
dbname = database_name
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'



What does /etc/postfix/mysql_virtual_alias_maps.cf look like?

Simon



Best regards.

--
/***
*Leslie León Sinclair
*Administrador de Redes
*Facultad de Ingenieria Electrica, CUJAE.
*Calle 114 #11901 e/ Ciclovía y Rotonda
*Marianao 19390, Ciudad de la Habana, Cuba
*Tel: (53 7) 266-3321
*Miembro de GUTL ->  
http://www.ecured.cu/index.php/Grupo_de_Usuarios_de_Tecnolog%C3%ADas_Libres_GUTL
*Another happy Slackware&  Debian GNU/Linux user
*Proud GNU/Linux User #445535 ->  http://counter.li.org/
*Katana yanai, otoko nanda.
/




Participe en Universidad 2012, del 13 al 17 de febrero de 2012.
Habana, Cuba: http://www.congresouniversidad.cu
Consulte la enciclopedia colaborativa cubana. http://www.ecured.cu

Participe en el Segundo Congreso Medio Ambiente Construido y 
Desarrollo Sustentable (MACDES 2011) del 6 al 9 de diciembre de 2011, 
Hotel Nacional, Habana, Cuba: http://macdes.cujae.edu.cu

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Simon Brereton 
On 21 October 2011 10:52, Jack Fredrikson  wrote:
> 
> From: Reindl Harald 
> To: postfix-users@postfix.org
> Sent: Friday, October 21, 2011 10:39 AM
> Subject: Re: First Insallation, Bouncing Emails
>
>
> I'm on CentOS, not Debian

>
> Ralf Hildebrandt writes:
>
>>> Oct 20 10:13:57 example postfix/proxymap[28446]: warning: mysql query
>>> failed: You have an error in your SQL syntax; check the manual that
>>> corresponds to your MySQL server version f
>>> or the right syntax to use near '??gifteatszone.com??? AND active = 1' at
>>> line 1
>>> Oct 20 10:13:57 example postfix/proxymap[28444]: warning: mysql query
>>> failed: You have an error in your SQL syntax; check the manual that
>>> corresponds to your MySQL server version f
>>> or the right syntax to use near '??awakelunch.info??? AND active = 1' at
>>> line 1
>
>> Check those
>
> That error appears to come from a file called
> /etc/postfix/mysql_virtual_alias_maps.cf that has this line:
> SELECT goto FROM alias WHERE address = ‘%s’ AND active = 1
> Therefore, the address has question marks in it. Looks like a hacker, no?

What does /etc/postfix/mysql_virtual_alias_maps.cf look like?

Simon

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Heiko Wundram 

Am 21.10.2011 16:52, schrieb Jack Fredrikson:

That error appears to come from a file called 
/etc/postfix/mysql_virtual_alias_maps.cf that has this line:
SELECT goto FROM alias WHERE address = ‘%s’ AND active = 1
Therefore, the address has question marks in it. Looks like a hacker, no?


No, the quotation marks in that file are broken. Use '' (simple marks), 
and not some typographic variant of those (i.e., represented as three 
bytes in UTF-8, which gets logged as ???).


--
--- Heiko.

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Jack Fredrikson 


From: Reindl Harald 
To: postfix-users@postfix.org
Sent: Friday, October 21, 2011 10:39 AM
Subject: Re: First Insallation, Bouncing Emails


I'm on CentOS, not Debian

[root@13gems postfix]# /usr/sbin/postconf -d | grep mail_version
mail_version = 2.8.5
milter_macro_v = $mail_name $mail_version
[root@13gems postfix]# /usr/sbin/postconf -n
alias_maps = hash:/etc/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = amavisfeed:[127.0.0.1]:10024
daemon_directory = /usr/libexec/postfix
data_directory = /var/lib/postfix
debug_peer_level = 2
debug_peer_list = 127.0.0.1
disable_vrfy_command = yes
home_mailbox = Mailbox
html_directory = no
inet_interfaces = localhost, $myhostname
invalid_hostname_reject_code = 450
local_transport = virtual
mail_owner = postfix
mail_spool_directory = /var/spool/mail
mailq_path = /usr/bin/mailq
manpage_directory = /usr/local/man
maps_rbl_reject_code = 450
mydestination = localhost.$mydomain, localhost, $myhostname
mydomain = 13gems.com
myhostname = 13gems.com
myorigin = $myhostname
newaliases_path = /usr/bin/newaliases
non_fqdn_reject_code = 450
queue_directory = /var/spool/postfix
readme_directory = no
sample_directory = /etc/postfix
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
show_user_unknown_table_name = no
smtpd_data_restrictions = reject_unauth_pipelining,    
reject_multi_recipient_bounce,    permit
smtpd_helo_required = yes
smtpd_recipient_restrictions = permit_sasl_authenticated    
reject_unauth_destination    reject_invalid_helo_hostname    
warn_if_reject reject_non_fqdn_helo_hostname    warn_if_reject 
reject_unknown_helo_hostname    warn_if_reject reject_unknown_client    
reject_non_fqdn_sender    reject_non_fqdn_recipient    
reject_unknown_sender_domain    reject_unknown_recipient_domain    
reject_rbl_client zen.spamhaus.org    reject_rbl_client 
bl.spamcop.net    reject_rbl_client dnsbl.sorbs.net=127.0.0.2    
reject_rbl_client dnsbl.sorbs.net=127.0.0.3    reject_rbl_client 
dnsbl.sorbs.net=127.0.0.4    reject_rbl_client 
dnsbl.sorbs.net=127.0.0.5    reject_rbl_client 
dnsbl.sorbs.net=127.0.0.7    reject_rbl_client 
dnsbl.sorbs.net=127.0.0.9    reject_rbl_client
 dnsbl.sorbs.net=127.0.0.11    reject_rbl_client 
dnsbl.sorbs.net=127.0.0.12    warn_if_reject reject_rhsbl_sender 
dsn.rfc-ignorant.org    warn_if_reject reject_rhsbl_sender 
abuse.rfc-ignorant.org    warn_if_reject reject_rhsbl_sender 
whois.rfc-ignorant.org    warn_if_reject reject_rhsbl_sender 
bogusmx.rfc-ignorant.org    warn_if_reject reject_rhsbl_sender 
postmaster.rfc-ignorant.org    permit
smtpd_sasl_auth_enable = yes
smtpd_sasl_path = /var/spool/postfix/private/auth
smtpd_sasl_security_options = noanonymous, nodictionary
smtpd_sasl_tls_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_tls_auth_only = yes
unknown_local_recipient_reject_code = 550
virtual_alias_maps = proxy:mysql:$config_directory/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:89
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = 
proxy:mysql:$config_directory/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = 
proxy:mysql:$config_directory/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 89
virtual_transport = dovecot
virtual_uid_maps = static:89


MASTER.CF
smtp  inet  n   -   n   -   -   smtpd
    -o content_filter=spamfilter:dummy
127.0.0.1:10025 inet n    -   n   -   - smtpd
    -o content_filter=
    -o smtpd_delay_reject=no
    -o smtpd_client_restrictions=permit_mynetworks,reject
    -o smtpd_helo_restrictions=
    -o smtpd_sender_restrictions=
    -o smtpd_recipient_restrictions=permit_mynetworks,reject
    -o smtpd_data_restrictions=reject_unauth_pipelining
    -o smtpd_end_of_data_restrictions=
    -o smtpd_restriction_classes=
    -o mynetworks=127.0.0.0/8
    -o smtpd_error_sleep_time=0
    -o smtpd_soft_error_limit=1001
    -o smtpd_hard_error_limit=1000
    -o smtpd_client_connection_count_limit=0
    -o smtpd_client_connection_rate_limit=0
    -o 
receive_override_options=no_header_body_checks,no_unknown_recipient_checks,no_milters,no_address_mappings
    -o local_header_rewrite_clients=
    -o smtpd_milters=
    -o local_recipient_maps=
    -o relay_recipient_maps=
amavisfeed unix    -   -   n    -  2 lmtp
    -o lmtp_data_done_timeout=1200
    -o lmtp_send_xforward_command=yes
    -o disable_dns_lookups=yes
    -o max_use=20
587 inet    n   -   n   -   -   smtpd
pickup    fifo  n   -   n   60  1   pickup
cleanup   unix  n   -   n   -   0   cleanup
qmgr  fifo  n   -   n   300 1   qmgr
tlsmgr    unix  -   -   n   1000?   1   tlsmgr
rewrite   unix  -   -   n   -   -   tr

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Reindl Harald 


Am 21.10.2011 16:32, schrieb Jack Fredrikson:
> Hi;
> I've been working on getting postfix and dovecot up and running all week 
> long. I'm bouncing emails all over hell's
> half acre and clients are going bizzerck. I've got the daemon running, but 
> there are a lot of errors

first: you are missing how to report problems
"postconf -n"

second: your are missing to build up a complex system step by step
instead writing big configurations and then start debugging

post your "master.cf"
i bet this is a debian system and your postfix is chrooted
"-" and "y" in this column is yes - change it to n and if i am
right complain debian why these dumb maintainers do not stop
their chroot-default which leads to trouble most of time

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm



signature.asc
Description: OpenPGP digital signature

Re: First Insallation, Bouncing Emails

2011-10-21 Thread Ralf Hildebrandt 
* Jack Fredrikson :

> Oct 20 10:13:57 example postfix/proxymap[28446]: warning: mysql query failed: 
> You have an error in your SQL syntax; check the manual that corresponds to 
> your MySQL server version f
> or the right syntax to use near '??gifteatszone.com??? AND active = 1' at 
> line 1
> Oct 20 10:13:57 example postfix/proxymap[28444]: warning: mysql query failed: 
> You have an error in your SQL syntax; check the manual that corresponds to 
> your MySQL server version f
> or the right syntax to use near '??awakelunch.info??? AND active = 1' at line 
> 1

Check those

-- 
Ralf Hildebrandt
  Geschäftsbereich IT | Abteilung Netzwerk
  Charité - Universitätsmedizin Berlin
  Campus Benjamin Franklin
  Hindenburgdamm 30 | D-12203 Berlin
  Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962
  ralf.hildebra...@charite.de | http://www.charite.de