on 2012 Mar 26 10:43 AM
Hello,
we use smtp replication with dbremote 10.0.1.4239
Everything works smoothly, but now we did add a new remote to the replication and that one can't send back messages to the consolidate.
It always aborts with:
I. 2012-03-26 15:33:00. Nachricht wird an "outlet24" (0-0005534246-0005538674-0) gesendet I. 2012-03-26 15:33:06. Line is too long, buffer overflow I. 2012-03-26 15:33:11. Line is too long, buffer overflow I. 2012-03-26 15:33:16. Line is too long, buffer overflow I. 2012-03-26 15:33:21. Line is too long, buffer overflow I. 2012-03-26 15:33:27. Line is too long, buffer overflow E. 2012-03-26 15:33:32. Fehler beim Senden der Nachricht I. 2012-03-26 15:33:32. Anforderungen erneuter Sendungen werden in die Warteschlange gesetzt E. 2012-03-26 15:33:32. Senden von Nachrichten fehlgeschlagen I. 2012-03-26 15:33:33. Ausführung abgeschlossen
The problem turns out to be a "transparent" smtp proxy which listens on port 25 of the ISP and then stumbles over the smtp traffic of dbremote. They have this in place to prevent sending spam from dialup/dsl connections, and state that we should use another port than port 25... On our server side the mailserver also accepts port 587 (submission)
We did already try to decrease the length to the minimum of 10000 (-l 10000) but to no avail....
Is there a way to have dbremote with SMTP to connect to port 587 of the smtp server (Submission port) ?
André
Request clarification before answering.
Thank you for the feature request - I have opened an enhancement request support case and engineering case (#11728671 / CR #703130 respectively) for the options 'smtp_port' / 'pop3_port' ( http://dcx.sybase.com/index.html#1201/en/dbreference/set-remote-option-statement.html ) to be considered in a future release.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dbremote uses the standard port 25 to talk to the SMTP server. This port is hard coded and you cannot change it. You may be able to solve this problem by redirecting the network traffic from port 25 to port 587 using Java or Perl script, but I have never done this before.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here what the debug=on shows:
I. 2012-03-27 17:51:53. gethostname I. 2012-03-27 17:51:53. gethostbyname pos-058 I. 2012-03-27 17:51:53. gethostbyname smtp.aarboard.ch I. 2012-03-27 17:51:53. socket I. 2012-03-27 17:51:53. connect SMTP I. 2012-03-27 17:51:58. 220 zhhdzmsp-nwas16.bluewin.ch ESMTP Service (Swisscom Schweiz AG) ready I. 2012-03-27 17:51:58. EHLO pos-058 I. 2012-03-27 17:51:58. 250-zhhdzmsp-nwas16 says EHLO to 81.62.119.19:55582 I. 2012-03-27 17:51:58. 250-PIPELINING I. 2012-03-27 17:51:58. 250-8BITMIME I. 2012-03-27 17:51:58. 250-SIZE 26214400 I. 2012-03-27 17:51:58. 250-AUTH=LOGIN I. 2012-03-27 17:51:58. 250 AUTH LOGIN I. 2012-03-27 17:51:58. Authentication mech found: LOGIN I. 2012-03-27 17:51:58. AUTH LOGIN I. 2012-03-27 17:51:58. 334 ********* I. 2012-03-27 17:51:58. ************** I. 2012-03-27 17:51:58. 334 ************* I. 2012-03-27 17:51:58. *********** I. 2012-03-27 17:51:58. 235 Authed. Go on. I. 2012-03-27 17:51:58. MAIL FROM:<xxxxxxxxxxx@yyyyyy.ch> I. 2012-03-27 17:51:58. 250 MAIL FROM accepted I. 2012-03-27 17:51:58. RCPT TO:<zzzzzzzzzzz@yyyyyyyyyyy.ch> I. 2012-03-27 17:51:58. Line is too long, buffer overflow I. 2012-03-27 17:51:58. RSET I. 2012-03-27 17:51:58. ad of port 25. More information: www.swisscom.ch/p25. I. 2012-03-27 17:51:58. QUIT I. 2012-03-27 17:51:58. 250 RSET OK I. 2012-03-27 17:51:58. closesocket
In the meantime I did install a local postfix which is then forwarding the mails to the smarthost on port 587, so this works.
But a option to tell dbremote to use another smtp port would highly be appreciated, since in switzerland many ISP's block port 25
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may be able to try setting remote options for the SMTP, as there are a few settings (haven't tested, just posting). I'm thinking specifically smtp_host
, which might accept a port, not sure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The "debug" option may be helpful, as well...
The smtp_host option will not accept a port. Port 25 is hard coded into dbremote when using SMTP.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.