+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
Windows Thread, Sophos console problems in Technical; Greeting . After tried for 2 weeks to solve some issues with Sophos Console 3.0 i now turn to this ...
  1. #1

    Join Date
    Nov 2007
    Location
    Aalborg, Denmark
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sophos console problems

    Greeting .
    After tried for 2 weeks to solve some issues with Sophos Console 3.0 i now turn to this board.

    My problem is, i've got 3 computers that won't communicate with the console, neither update, add policies or install(protect...).
    It is possible to install the client manually, but still same error as above.

    I've been through Sophos support site over and over, but neither helps..

    The computers have their firewalls turned off, can be seen and accessed by other console software (not anti-virus).

    Also, the console keep telling restart is needed for update on a big amout of machines. -The log says this error is dated 25-10-2007. But its still showing, even though the machines reboots every day at 5 am..

    The Console is on a Windows 2003 server.

    If other details are need, please post, and i will do my best to prodvide.

    -Its not all the machines that shows a error..

    A quick overview.
    -Old errors are still showing warnings. Even if they have been acknowled.

    -The console won't find some of the machines.

    -Server is MS 2003.

    -The clients are using windows XP sp2. -No firewalls / in a domain.

  2. #2
    KarlGoddard's Avatar
    Join Date
    Jul 2005
    Location
    Bolton, Lancashire
    Posts
    272
    Thank Post
    37
    Thanked 18 Times in 18 Posts
    Rep Power
    25

    Re: Sophos console problems

    On the PC's that won't communicate back to the console... check the system times on them.

    The only time I had this was when the PC system times were totally out of sync with my DC's. (don't ask why this happened they *should* sync I know!!)

    With regards to the numerous warnings about a restart being needed... this is one of the countless glitches I've come accross with the recent update to Sophos. If I remember right even the Sophos knowledgebase says you can 'ignore' these warnings, but for some reason you can't get rid of them from the console.

    This is where you have to delve into you sophos SQL database and remove them manually..

    This is the sql I use to remove the 'restart warnings'

    UPDATE ComputersAndDeletedComputers SET LastAUErrorAlert = NULL from computersanddeletedcomputers join errors on computersanddeletedcomputers.lastauerroralert = errors.id where errors.number = 109

    Use at your own risk. It works for me but please test it out in your environment or construct your own similar query.

    HTH

  3. #3

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,640
    Thank Post
    894
    Thanked 1,314 Times in 798 Posts
    Blog Entries
    1
    Rep Power
    441

    Re: Sophos console problems

    BTW you may not be aware but the reboot machines *may* have got this update:
    http://www.sophos.com/products/enter...g.html?lang=en

    It requires a reboot.

  4. #4
    KarlGoddard's Avatar
    Join Date
    Jul 2005
    Location
    Bolton, Lancashire
    Posts
    272
    Thank Post
    37
    Thanked 18 Times in 18 Posts
    Rep Power
    25

    Re: Sophos console problems

    yep and even after restarting - like the OP said - the warnings still show in the Console

  5. #5

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,640
    Thank Post
    894
    Thanked 1,314 Times in 798 Posts
    Blog Entries
    1
    Rep Power
    441

    Re: Sophos console problems

    Yeh but it may be a issue with v6-v7 causing the console to report it wrongly.
    Have you tried the sophos batch file that removes sophos completely?

  6. #6

    Join Date
    Nov 2007
    Location
    Aalborg, Denmark
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Sophos console problems

    shall the batchfile run on the client?
    ive tried to remove it by add/remove in windows.

    if i try the sql. could i please get a explanation on how to run it?

  7. #7
    KarlGoddard's Avatar
    Join Date
    Jul 2005
    Location
    Bolton, Lancashire
    Posts
    272
    Thank Post
    37
    Thanked 18 Times in 18 Posts
    Rep Power
    25

    Re: Sophos console problems

    you can use osql from the command line - have a look on the sophos knowledge base on how best to do that or you can use what I use - a utility called Query ExPlus. This allows you to query against any sql database you have.

    Far quicker and lighter to use than Enterprise Manager!!

  8. #8

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340

    Re: Sophos console problems

    This is the problem with Sophos. When it goes wrong, it can be a right pain in the *** to get it right again.

    As already recommended, run the removal scripts to completely remove Sophos. It's not necessary to uninstall manually via Add/Remove Programs, the script will do all this for you.

    I would also recommend you delete the "C:\Program Files\Sophos" directory (if it still exists) and also delete Sophos registry entries:

    HKEY_LOCAL_MACHINE > Software > Sophos

    Delete the whole Sophos folder and its contents. Reboot the machine, run the removal scripts again, then I'd recommend you run a manual install on the workstation pointing to the Interchk share.

    Two issues I had with Sophos recently - on an RM network, updating Sophos (new version, not identity files) caused problems. This was due to incorrect or no permissions set to 'write' the registry entries. Caused all kinds of weird and wonderful errors for me. It's isolated to RM and although I manually added the right permissions, I was unable to find the reason(s) behind it and neither were Sophos.

    The second recent problem, was the sweepupd account was disabled in Active Directory. This also creates a whole load of problems. Someone entered an invalid password more than 5 times, so Active Directory disabled the account!

  9. #9
    mrtechsystems's Avatar
    Join Date
    Jun 2005
    Location
    Yorkshire
    Posts
    424
    Thank Post
    96
    Thanked 22 Times in 22 Posts
    Rep Power
    25

    Re: Sophos console problems

    I do not want to sound cheeky have your enabled file sharing in the exceptions on the workstations

    http://www.sophos.com/support/knowle...cle/12837.html

  10. #10

    Join Date
    Nov 2007
    Location
    Aalborg, Denmark
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Sophos console problems

    Simpel Fileshareing is turned off. -Neither helps.
    Anyways, running the sql script was a success, eliminated 75 of the machine errors.
    -Thanks for that.

    New problem is a huge amout of machines now differs from policy :?.
    I will try to remove it by the Removal script today on the troublesome machines.

  11. #11
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    614
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: Sophos console problems

    I have had similar problems since updating to v3 of the console. More than half of the clients are greyed out and won't update or install from the console. I have always had the problem of clients not matching the policies even in v2 but with the clients that are connecting in v3, the policies keep failing to apply.

    I have been on to Sophos tech support and they have gone through the whole simple file share turned off, firewall turned off etc etc, but to no avail. However, if I manually install sophos from the share then the console picks it up and it works without any problems?????

    The other thing is, I thought simple file sharing was supposed to be off on xp PCs on a domain? All our PCs are XP and on the domain, yet on every PC I have looked at, simple file sharing is on????

    Anyway, looks like we will be doing a lot of manual installs over the next week!

  12. #12

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,621
    Thank Post
    49
    Thanked 451 Times in 334 Posts
    Rep Power
    137

    Re: Sophos console problems

    Check out my other post.

    http://www.edugeek.net/index.php?nam...wtopic&t=12905

    There might be a link between them. Worth a look.

  13. #13
    KarlGoddard's Avatar
    Join Date
    Jul 2005
    Location
    Bolton, Lancashire
    Posts
    272
    Thank Post
    37
    Thanked 18 Times in 18 Posts
    Rep Power
    25

    Re: Sophos console problems

    I must say that I'm not overly impressed with v3.... I seem to spend an ever increasing part of my day dealing with Sophos related probs...

  14. #14
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Re: Sophos console problems

    Symantec corporate v10 is very good, especially the managment options. And finally their 10.5x client is very stable.

  15. #15

    Join Date
    Nov 2007
    Location
    Aalborg, Denmark
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Sophos console problems

    I've found a solution to my earlier problem with machines that differs from policy.
    The errors that have been achknowledge, must also be se as authorized in the group policy.

    So i would like to summerise this topic.

    Subject: errors in Sophos Console v3.

    Problems: alot of computers are listed in "computers with error"

    -Many computeres are telling to reboot, even if the gets a reboot daily
    --Solution: Run this SQL command:

    Quote Originally Posted by sql command
    UPDATE ComputersAndDeletedComputers SET LastAUErrorAlert = NULL from computersanddeletedcomputers join errors on computersanddeletedcomputers.lastauerroralert = errors.id where errors.number = 109
    -Many computers differs from policy. / Showing error with files month or weeks old. (Even if the have been dealt with).
    --Solution: Achknowlegde the error, and remember to update group policy to allow or warn on the files that have been achknowledge.

    -Some Computers are out-of-date, and can't get Sophos Anti-V. installed from console / are awating policy from console.
    --Solution: *hoping to find a answer*

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 10
    Last Post: 10th October 2006, 03:09 PM
  2. Sophos v5 upgrade problems.
    By Geoff in forum Windows
    Replies: 68
    Last Post: 16th June 2006, 11:28 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •