Failed to connect to SMTP

[luarit]

Hello all,

when I run dbvisit in primaty db (dbvisit oracledb) I have this issue

Failed to connect to SMTP server relay.skynet.be on port 25.
Please Check MAILCFG settings in Dbvisit Database configuration (DDC) file
dbv_oracledb.env.

relay.skynet.be is a free external server. Do you know how can I fix it?

Firewall is stopped.

Thx

[Mike Donovan]

Hello luarit,

Do you have the following set in your DDC file so that Dbvisit uses its internal smtp server?
MAILCFG_MAIL_CLIENT = dbvisit

Please see the following post which has information about debugging mail issues - can you try and let us know what messages are returned?
http://www.dbvisit.com/forums/showthread.php?t=835

Also can you confirm that this mail service allows this type of relay connection?

Kind regards.

[luarit]

hello,

I dont have more information with that...


C:\Program Files\Dbvisit>dbv_functions -m VEND
================================================== ===========
Dbvisit Standby Database Technology (5.3.08.5559) (pid 736)
dbv_functions.exe started on VENDOR: Fri Dec 16 11:20:36 2011
================================================== ===========

Sending schedular heartbeat message.

201112161120 - Failed to connect to SMTP server relay.skynet.be on port 25.
Please Check MAILCFG settings in Dbvisit Database configuration (DDC) file
dbv_VEND.env.
Dbvisit terminated.
Return code = 766

(Tracefile required if contacting Dbvisit support:
C:\dbvisit_temp\736_dbv_functions_VEND_20111216112 0.trc (server:VENDOR))

Return code = 766

C:\Program Files\Dbvisit>

------------------------------------------------------------------------

my .env is:

[40 Mail Settings]
MAILCFG_MAIL_CLIENT = dbvisit
SUCCESSMAIL = Yes
SUCCESSMAIL_DR = Yes
ADMINS = luarit@gmail.com
MAILCFG_FROM = dbvisit1968@gmail.com
MAILCFG_FROM_DR = dbvisit19682@gmail.com
MAILCFG_SMTP_SERVER = relay.skynet.be
MAILCFG_SMTP_SERVER_DR = relay.skynet.be
------------------------------------------------

I tried MAILCFG_MAIL_CLIENT = dbvisit1968@gmail.com and i have same error

I tried other smtp server: smtp.gmail.com and I have this error:

Sending schedular heartbeat message.
MIME::Lite::SMTP>>> MIME::Lite::SMTP
MIME::Lite::SMTP>>> Net::SMTP(2.31)
MIME::Lite::SMTP>>> Net::Cmd(2.29)
MIME::Lite::SMTP>>> Exporter(5.62)
MIME::Lite::SMTP>>> IO::Socket::INET(1.31)
MIME::Lite::SMTP>>> IO::Socket(1.31)
MIME::Lite::SMTP>>> IO::Handle(1.28)
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 220 mx.google.com ESMTP z54sm3709435eeh.5
MIME::Lite::SMTP=GLOB(0x333baa4)>>> EHLO localhost.localdomain
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 250-mx.google.com at your service, [82.66.11
0.123]
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 250-SIZE 35882577
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 250-8BITMIME
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 250-STARTTLS
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 250 ENHANCEDSTATUSCODES
MIME::Lite::SMTP=GLOB(0x333baa4)>>> MAIL FROM:<dbvisit1968@gmail.com>
MIME::Lite::SMTP=GLOB(0x333baa4)<<< 530 5.7.0 Must issue a STARTTLS command firs
t. z54sm3709435eeh.5

201112161113 - Error sending mail, please check MAILCFG settings in Dbvisit
Database configuration (DDC) file dbv_VEND.env.

SMTP mail() command failed:
5.7.0 Must issue a STARTTLS command first. z54sm3709435eeh.5


Dbvisit terminated.
Return code = 770

(Tracefile required if contacting Dbvisit support:
C:\dbvisit_temp\940_dbvisit_VEND_201112161113.trc (server:VENDOR))

Return code = 770

--------------------------------------------------------------------

any idea?

thank you

[Arjen Visser]

Hello,

Unfortunately currently we do not support SSL/TLS to be able to use gmail.

We would suggest that you try port 26 instead of port 25 for relay.skynet.be.

The following settings are available for mail:

MAILCFG_AUTH_USER=
MAILCFG_AUTH_PASSWD=
MAILCFG_CC=
MAILCFG_BCC=
MAILCFG_ATTACH_TRACEFILE=
MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES=
MAILCFG_SENDMAIL_CLIENT=
MAILCFG_PORT=
MAILCFG_DEBUG=
MAILCFG_TIME_OUT=

You can also turn off email, although then you will need another method for notification such as monitoring the Dbvisit Standby logs.
To turn off email set:
SEND_MAIL_FLAG=No
SEND_MAIL_FLAG_DR=No


The location of the Dbvisit Standby logs are set by:
LOGDIR
LOGDIR_DR


Kind regards,

[luarit]

I disable mails, because it doesnt work in port 25, neither in 26...and now I have this problem. I dont know why:


Log file(s) for VEND will be transferred from VENDOR to VENDORSB...
201112161324 - Dbvisit cannot obtain the archive log destination
(log_archive_dest) from the database. Please ensure that one of the
log_archive_dest parameters are set in the database, else please contact Dbvisit

support.
Dbvisit terminated.
Return code = 424

Any idea? Thanks again

[luarit]

I solved last problem...

ALTER SYSTEM set archive_log_dest='c:\archive_logs'

But I have same problem with mails, any free smtp server to send mails and that works with dbvisit?

Thx

[Arjen Visser]

Usually your local ISP provides a free smtp server that you can use.
We are working on providing SSL/TLS compatibility for gmail but do not have a release date for this yet.

Kind regards,