Messaging Gateway

 View Only

  • 1.  ERROR - Cannot backup the database on the remote host

    Posted Jun 25, 2012 02:20 PM

    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!
     


  • 2.  RE: ERROR - Cannot backup the database on the remote host

    Broadcom Employee
    Posted Jun 27, 2012 01:42 AM
    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.


  • 3.  RE: ERROR - Cannot backup the database on the remote host

    Posted Jun 27, 2012 09:08 AM

    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.

     

     



  • 4.  RE: ERROR - Cannot backup the database on the remote host

    Broadcom Employee
    Posted Jun 27, 2012 12:59 PM

    .



  • 5.  RE: ERROR - Cannot backup the database on the remote host

    Posted Jun 28, 2012 08:20 PM

    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!


  • 6.  RE: ERROR - Cannot backup the database on the remote host

    Posted Jul 07, 2012 05:07 AM

    We need iis logs.

    Nothing would be better than sniffing the packets though.