Messaging Gateway

 View Only
Expand all | Collapse all

SBG Host Unknown

Migration User

Migration UserSep 10, 2010 01:57 PM

Migration User

Migration UserSep 10, 2010 02:41 PM

  • 1.  SBG Host Unknown

    Posted Sep 09, 2010 09:49 AM
    I started to receive these emails and long after the date in them. Anyone have any Ideas?
    TIA Dave User preference replication errors: Host Start Status --------------------------------------------------------------------------- Unknown Tuesday, Aug 25, 2009 02:37:50 AM EDTFailed


  • 2.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 09, 2010 04:00 PM

    This can happen after upgrading to SBG 9

    If the dates shown in the alert are not recent, it means that there is some old data stuck in the mysql DB about a failure in replication. Deleting the historical data will make the notifications stop.

    In order to check it, do the following:

    access to control center as support user (Use the set-support command to set the password)

    Run these commands:

    cd /opt/Symantec/Brightmail/mysql/bin


    mysql -h127.0.0.1 -ubrightmailuser -p`cat /data/etc/.brightmailuser` brightmail

    select * from status_user_pref;


    Delete the lines with failed status using the command:

    delete  from status_user_pref where id=x;


    As you can see the timestamp of the failed replications are the same as in the alert email.



  • 3.  RE: SBG Host Unknown

    Posted Sep 09, 2010 04:31 PM

    Thanks, I set/reset the pw.  When I give it a logout cmd on the cli I get a There are stopped jobs message and then back to the prompt.  Also the emails are generated every 12 hours per my alert frequency.

    Thanks,
    Dave



  • 4.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 09, 2010 04:43 PM
    You need to run the 'fg' command and it will bring your stopped job back to the front. You may have accidentally pressed 'ctrl-z' as some point which will suspend your current job in the background.


  • 5.  RE: SBG Host Unknown

    Posted Sep 10, 2010 08:29 AM
    Thanks, all I get with fg is -rbash: fg: command not found...


  • 6.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 10, 2010 11:23 AM

    Using 'exit' worked for me, try that. Apparently rbash does not include fg.



  • 7.  RE: SBG Host Unknown

    Posted Sep 10, 2010 11:55 AM

    Thanks again, the first exit and it said something about jobs running and logout

    The second exit logged me out, I'm logged back in now...

    It still doesnt know the fg command.



  • 8.  RE: SBG Host Unknown

    Posted Sep 10, 2010 01:26 PM

    Ok, logged in as support and giving it the 1st mysql command from yesterday returns nothing...



  • 9.  RE: SBG Host Unknown

    Posted Sep 10, 2010 01:27 PM

    I guess nothing other than I am now in the bin dir instead of the support dir.



  • 10.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 10, 2010 01:41 PM

    Please provide a screen shot if you can so I can better understand what you are seeing.



  • 11.  RE: SBG Host Unknown

    Posted Sep 10, 2010 01:57 PM
      |   view attached

    Sure, here you are.



  • 12.  RE: SBG Host Unknown

    Posted Sep 10, 2010 02:41 PM

    deleted - pebkac



  • 13.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 10, 2010 02:43 PM

    The three commands need to be run seperately, not as a single line.

     

    cd /opt/Symantec/Brightmail/mysql/bin<enter key>

    mysql -h127.0.0.1 -ubrightmailuser -p`cat /data/etc/.brightmailuser` brightmail<enter key>

    select * from status_user_pref; <enter key>



  • 14.  RE: SBG Host Unknown

    Posted Sep 10, 2010 03:13 PM

    Super, done. there are also 2 other hosts listed as failed/ size 0/ enddate null.  I have not delete them.  I have one scanner which is going to a remote site, some things don't try to report it some do, thru the cc.  There is another id local scanner with todays date null size 0.

    Should I do anything with them or leave alone.

    Thanks much, and I'll post back tonight if the unknown host is reported again around 1845.



  • 15.  RE: SBG Host Unknown

    Broadcom Employee
    Posted Sep 10, 2010 03:56 PM

    You should delete any marked failed and then the messages will cease coming in



  • 16.  RE: SBG Host Unknown

    Posted Sep 10, 2010 04:23 PM

    Ok, its a Friday and I'm feeling lucky, I wacked the other 2 failed entries as suggested.

    Thanks again.