Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-16-2011, 10:19 PM
luarit luarit is offline
Junior Member
 
Join Date: Dec 2011
Posts: 12
Default Failed to connect to SMTP

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
Reply With Quote
  #2  
Old 12-17-2011, 05:53 AM
Mike Donovan Mike Donovan is offline
Dbvisit Team
 
Join Date: May 2008
Posts: 201
Default RE: Failed to connect to SMTP

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.
Reply With Quote
  #3  
Old 12-17-2011, 11:07 AM
luarit luarit is offline
Junior Member
 
Join Date: Dec 2011
Posts: 12
Default

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
Reply With Quote
  #4  
Old 12-17-2011, 08:04 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

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,
Reply With Quote
  #5  
Old 12-17-2011, 10:27 PM
luarit luarit is offline
Junior Member
 
Join Date: Dec 2011
Posts: 12
Default

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
Reply With Quote
  #6  
Old 12-18-2011, 03:40 AM
luarit luarit is offline
Junior Member
 
Join Date: Dec 2011
Posts: 12
Default

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
Reply With Quote
  #7  
Old 12-18-2011, 06:44 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

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,
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 11:14 AM.