Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 6135 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sophos Reporting Interface - Issues arising

tdubb

[For ease of use Mod has moved this post to start a new thread with a new title]

when i run this sql command, I get the error

msg 208, Level 16, State 1, Line 1
Invalid object name 'SOPHOS50.Sophos Reporting Interface.vComputerHostData'.

:45409


This thread was automatically locked due to age.
  • 0

    also on my SEC server when the log writer is installed, I am seeing these errors in the event log

    Log Name: Application
    Source: Sophos Reporting Log Writer
    Date: 11/23/2013 1:42:49 PM
    Event ID: 0
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: sophos.xxx.xxx
    Description:
    System.Data.SqlClient.SqlException - Login failed for user 'domain\SOPHOS$'.. The DefaultCommonEvents call did not execute correctly.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="Sophos Reporting Log Writer" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-11-23T21:42:49.000000000Z" />
    <EventRecordID>22622</EventRecordID>
    <Channel>Application</Channel>
    <Computer>sophos.xxx.xxx</Computer>
    <Security />
    </System>
    <EventData>
    <Data>System.Data.SqlClient.SqlException - Login failed for user 'domain\SOPHOS$'.. The DefaultCommonEvents call did not execute correctly.</Data>
    </EventData>
    </Event>

    :45411
  • 0

    i changed the use in which logwriter runs as to a user part of the sophos db admin group and now I am seeing this error in the app log

    Log Name: Application
    Source: Sophos Reporting Log Writer
    Date: 11/23/2013 1:57:59 PM
    Event ID: 0
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: sophos.xxx.xxx
    Description:
    System.Data.SqlClient.SqlException - Could not find stored procedure 'Sophos LogWriter.EventsCommonData'.. The DefaultCommonEvents call did not execute correctly.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="Sophos Reporting Log Writer" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-11-23T21:57:59.000000000Z" />
    <EventRecordID>22658</EventRecordID>
    <Channel>Application</Channel>
    <Computer>sophos.xxx.xxx</Computer>
    <Security />
    </System>
    <EventData>
    <Data>System.Data.SqlClient.SqlException - Could not find stored procedure 'Sophos LogWriter.EventsCommonData'.. The DefaultCommonEvents call did not execute correctly.</Data>
    </EventData>
    </Event>

    :45413
  • 0

    ok I got it working now with the 50 version. I started the log writer service and saw 2 files under logs. I also changed the xml config file to point to my database server. Does this mean it will no longer write to the log files and store it in the database?

    I need to keep it in the log file so that i can export the info to a syslog server

    :45415