Video Screencast Help

ERROR - Cannot backup the database on the remote host

Created: 25 Jun 2012 • Updated: 25 Jun 2012 | 5 comments
Esteban_E's picture

HI all,

 

 

I have implemented a client SMG 9.5.4-4, which is configured a FULL backup and backup reports / logs / etc intended to FTP on the LAN to run automatically.
 
The problem is detected when you run the backup schedule, and goes to an FTP folder, where there are previous backups. This task fails and sends it to the administrators of SMG the following notice:
 
 
Subject: Symantec Messaging Gateway Alert - Scheduled tasks Failures
 
Symantec Messaging Gateway Alert Notification for xxxxxx@xxxxxx.com
 
========================= ALERT NOTIFICATION =======================  =======
 
The Following Have Failed Scheduled Tasks:
 
   Task: Backup (Backup FULL Monthly)
   Host: xxxxxx.xxxxxx.xxx (10.xxx.2.xx)
   Last Run Time: Thursday, May 31, 2012 1:00:00 AM BST
 
   Task: Backup (Backup Logs, reports, weekly config)
   Host: xxxxx.xxxxx.xxxxx (10.xxx.2.xx)
   Last Run Time: Saturday, June 23, 2012 1:00:00 AM BST
 
Details about this failure to Have Been logged BrightmailLog.log. Access this Control Center console log on the Logs page of the Symantec Messaging Gateway Control Center.
 
===========================================================================
 
In reviewing the file BrightmailLog.log, detected the following error:
 
June 23, 2012 1:00:00 [BrightmailScheduler_Worker-13] ERROR - Can not backup the database on the remote host.
June 23, 2012 1:00:00 [BrightmailScheduler_Worker-13] ERROR - FTP: Can not transmit the file: Can not open data connection.ERROR: Unable to send to the Specified URL.
June 23, 2012 1:00:00 [BrightmailScheduler_Worker-13] ERROR - Error occurred while Attempting to execute scheduled backup.
 
By eliminating all previous backups on the FTP destination folder, the backup is performed correctly.
 
We reviewed user permissions for connecting to the FTP server, and this is OK.
The files, as we all know, are renamed with the date and time running.
 
Some of you did this happen?
 
Thank you all from now!
 

Comments 5 CommentsJump to latest comment

TSE-JDavis's picture

It sounds like the FTP space was full or over quota. You should check the logs on the sever to find out why it wouldn't allow the Messaging Gateway to upload the file. You might run a packet capture on the FTP server of this happens again so you can see the server's response when the Messaging Gateway issues the upload command.

Tariq Naik's picture

I agree either the ftp server is run out of space or the sapce alloted to the user doing the ftp must have got exhausted.

 

 

Esteban_E's picture

Today I received recently commented that the FTP server logs. From what I could see only an 425 error ..

 

To understand:
 
SMG Control Center IP: 10.150.2.97
FTP Server IP: 10.150.2.35
FTP Server: Microsoft Internet Information Services 7.0 on Windows 2008 STD
 
This log is the error that I detail in the BrightmailLog.log file:

 

2012-06-23 04:00:00 10.150.2.97 - 10.150.2.35 21 ControlChannelOpened - - 0 0 1a220eb3-11f1-4f0f-9588-17614016a7fd -
2012-06-23 04:00:00 10.150.2.97 - 10.150.2.35 21 user SEP_FTP 331 0 0 1a220eb3-11f1-4f0f-9588-17614016a7fd -
2012-06-23 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 PASS *** 230 0 0 1a220eb3-11f1-4f0f-9588-17614016a7fd /
2012-06-23 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 TYPE I 200 0 0 1a220eb3-11f1-4f0f-9588-17614016a7fd -
2012-06-23 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 PASV - 425 10013 0 1a220eb3-11f1-4f0f-9588-17614016a7fd -
2012-06-23 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 ControlChannelClosed - - 0 0 1a220eb3-11f1-4f0f-9588-17614016a7fd -
 
 
This is a record after having deleted all the backups in the FTP folder.
 
2012-06-02 04:00:00 10.150.2.97 - 10.150.2.35 21 ControlChannelOpened - - 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 - 10.150.2.35 21 user SEP_FTP 331 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 PASS *** 230 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 /
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 TYPE I 200 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 PASV - 227 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 49154 DataChannelOpened - - 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 49154 DataChannelClosed - - 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 STOR //SPC/db-backup.brightmail.Jun-02-12-01-00.config-incidents-reports-logs.weekly.tar.bz2 226 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 /SPC/db-backup.brightmail.Jun-02-12-01-00.config-incidents-reports-logs.weekly.tar.bz2
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 QUIT - 221 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:00 10.150.2.97 SEP_FTP 10.150.2.35 21 ControlChannelClosed - - 0 0 8d3598c2-45f0-482f-b7c0-c49a0ec05b13 -
2012-06-02 04:00:03 10.150.2.97 - 10.150.2.35 21 ControlChannelOpened - - 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 - 10.150.2.35 21 user SEP_FTP 331 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 PASS *** 230 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be /
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 TYPE I 200 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 ALLO 481061 200 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 PASV - 227 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 49155 DataChannelOpened - - 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 49155 DataChannelClosed - - 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 STOR //SPC/db-backup.brightmail.Jun-02-12-01-00.config-incidents-reports-logs.weekly.tar.bz2 226 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be /SPC/db-backup.brightmail.Jun-02-12-01-00.config-incidents-reports-logs.weekly.tar.bz2
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 QUIT - 221 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
2012-06-02 04:00:03 10.150.2.97 SEP_FTP 10.150.2.35 21 ControlChannelClosed - - 0 0 fb7e574c-e70f-4e17-9759-be70427cc8be -
 

 

If I understand, the  425 error is because the FTP server can not receive PASIVE mode connections. For all I know, SMG connections can only FTP Passive mode or enable the SCP  ....
 
But do not understand why I let him do it once? indecision
 
any comments or ideas are welcome!

 

 

 

 

 

Tariq Naik's picture

We need iis logs.

Nothing would be better than sniffing the packets though.