Link to home
Create AccountLog in
Citrix

Citrix

--

Questions

--

Followers

Top Experts

Avatar of krzywis
krzywis

Citrix Smart Auditor - unable to connect ot SmartAuditor Server
Hello

I am unable to connect to Smart Auditor Server using Policy Console from the same server

This is the error
 User generated image
Environment:
XenApp5 on Windows 2008

Auditor server Windows 2003 R2 64bit
Database SQL 2005 SP2 on Windows 2003 R2 64bit


I verified that:
The user I am using to connect has been granted Policy Administrator rights
Citrix Auditor Storage Manager service is running
SSL certificate is installed on IIS and root CA are imported to the server (under computer account), no issues here

All as per Citrix recommendations for remote SQL install
http://support.citrix.com/proddocs/index.jsp?topic=/xenapp5fp-w2k3/ps-sa-start-install-all.html

DOMAIN\CTXAUD01$ has db_owner rights on CitrixSmartAuditor  created automaticaly during installation of Smart Auditor Database components on SQL 2005 Std

MSMQ installed on Auditor server without Active Directory integration (was installed before but now removed) and with MSMQ HTTP support

Ports 80 and 443 are open and netstat shows that server is accepting connection from agent installed on one of test XenApp servers

Now, when I check logs on Auditor server I can see loads of the following entries:

Errors on CTXAUD01
Event Type:      Warning
Event Source:      Citrix SmartAuditor Storage Manager
Event Category:      None
Event ID:      0
Date:            11/06/2011
Time:            02:15:06
User:            N/A
Computer:      CTXAUD01
Description:
Exception caught while establishing database connection.

--- Exception Details ---
Type: System.Data.SqlClient.SqlException
Message: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Stack trace:
   at SmAudDatabaseProxy.DatabaseProxy.get_DatabaseConnection()
   at SmAudDatabaseProxy.DatabaseProxy.CheckSupportedSchemaVersion()
   at SmAudStorageManager.DataQueueConsumer.WaitConnectDatabase()


So I double checked that SQL 2005 Std is configured to accept remote connections (setting: Using TCP/IP only)


Can this be the database instance not specified properly?

Under [HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\SmartAuditor\Server] I have the SmAudDatabaseInstance key set to "SQLSERVER\CitrixSmartAuditor"

I have also tried "SQLSERVER" only and "SQLSERVER\MSSQLSERVER" as this is the default instance...

Any suggestions would be greatly appreciated!
Kris

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of krzywiskrzywis

ASKER

Additionaly after installing test agent on one of XenApp servers (as mentioned in original post) I noticed the following warnings on server with XenApp 5 installed

Log Name:      Application
Source:        Citrix SmartAuditor Agent
Date:          11/06/2011 13:04:50
Event ID:      0
Task Category: None
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      XA5.mydomain.com
Description:
Exception caught while obtaining session metadata or running record policy query.

--- Exception Details ---
Type: System.Runtime.Serialization.SerializationException
Message: The input stream is not a valid binary format. The starting contents (in bytes) are: 3C-68-74-6D-6C-3E-0D-0A-20-20-20-20-3C-68-65-61-64 ...
Stack trace:

Server stack trace:
   at System.Runtime.Serialization.Formatters.Binary.SerializationHeaderRecord.Read(__BinaryParser input)
   at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadSerializationHeaderRecord()
   at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
   at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
   at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
   at System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryResponseMessage(Stream inputStream, IMethodCallMessage reqMsg, Boolean bStrictBinding)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.DeserializeMessage(IMethodCallMessage mcm, ITransportHeaders headers, Stream stream)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at SmAudBroker.RecordPolicy.RunRecordPolicyQuery(RecordPolicyQuery query, RecordPolicyQueryResult& result)
   at y.a(h A_0)
   at y.a()


Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Citrix SmartAuditor Agent" />
    <EventID Qualifiers="0">0</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-06-11T12:04:50.000Z" />
    <EventRecordID>10826</EventRecordID>
    <Channel>Application</Channel>
    <Computer>XA5.mydomain.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Exception caught while obtaining session metadata or running record policy query.

--- Exception Details ---
Type: System.Runtime.Serialization.SerializationException
Message: The input stream is not a valid binary format. The starting contents (in bytes) are: 3C-68-74-6D-6C-3E-0D-0A-20-20-20-20-3C-68-65-61-64 ...
Stack trace:

Server stack trace:
   at System.Runtime.Serialization.Formatters.Binary.SerializationHeaderRecord.Read(__BinaryParser input)
   at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadSerializationHeaderRecord()
   at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
   at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
   at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
   at System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryResponseMessage(Stream inputStream, IMethodCallMessage reqMsg, Boolean bStrictBinding)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.DeserializeMessage(IMethodCallMessage mcm, ITransportHeaders headers, Stream stream)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&amp; msgData, Int32 type)
   at SmAudBroker.RecordPolicy.RunRecordPolicyQuery(RecordPolicyQuery query, RecordPolicyQueryResult&amp; result)
   at y.a(h A_0)
   at y.a()

</Data>
  </EventData>
</Event>



Netstat outcome (relevant connections only)

  Proto  Local Address          Foreign Address        State
  TCP    CTXAUD01:https         XA5.mydomain.com:53978  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53979  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53980  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53983  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53984  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53986  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53987  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53988  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53989  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53991  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53993  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53994  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53996  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:53997  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:54001  ESTABLISHED
  TCP    CTXAUD01:https         XA5.mydomain.com:54002  ESTABLISHED
  TCP    CTXAUD01:msmq          XA5.mydomain.com:53649  ESTABLISHED
  TCP    CTXAUD01:ms-wbt-server  XA5.mydomain.com:53667  ESTABLISHED

I checked the settings again as per http://support.citrix.com/proddocs/topic/xenapp5fp-w2k8/ps-sa-trouble-connect-verify.html
and all seems fine. The SmAudDatabaseInstance key is the one that's puzzling me... what should the correct entry be?


Also I forgot to mention that using https://ctxaud01.mydomain.com/SmartAuditorBroker/PolicyAdministration.rem?wsdl to test connectivity to IIS from Auditor server returns XML website
(as per http://support.citrix.com/proddocs/index.jsp?topic=/xenapp5fp-w2k8/ps-sa-trouble-connect-iis-testing.html)


Note. For obvious reasons mydomain.com string replaced my real domain name.

Avatar of joharderjoharder🇺🇸

Two ideas come to mind:
- Is the Citrix plug-in being used to administratively access the SmartAuditor records newer than that used for the recordings?  They should all be the same version.
- HTTPS has to be configured in four places: http://support.citrix.com/proddocs/topic/xenapp5fp-w2k8/ps-sa-trouble-protocol-change.html
ASKER CERTIFIED SOLUTION
Avatar of krzywiskrzywis

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of krzywiskrzywis

ASKER

No solution provided by EE members
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Citrix

Citrix

--

Questions

--

Followers

Top Experts

Citrix is the synonym for the virtualization and application infrastructure systems developed by the company of the same name. Main areas are application virtualization, Software-As-A-Service (SaaS), cloud-computing and networking. The two most well-known are Citrix XenApp or Citrix CloudPlatform.