- Digging in to Citrix Configuration Logging – Part 1
- Digging in to Citrix Configuration Logging: Setting up the Database
- Digging in to Citrix Configuration Logging: Setting up the Citrix XenApp farm for Configuration Logging
- Digging in to Citrix Configuration Logging: Reporting
- Digging in to Citrix Configuration Logging: Exploring the Database
I have presented on this topic in the past at BriForum and I wanted to share more about Citrix XenApp Configuration Logging here. This will be a multi-part series that inspects each aspect of Citrix Configuration Logging and some creative ways of extending Citrix Configuration Logging. So, let’s get started…
What is Citrix Configuration Logging?
According to the Citrix XenApp Administrator’s guide, “the Configuration Logging feature allows you to keep track of administrative changes made to your server farm environment. By generating the reports that this feature makes available, you can determine what changes were made to your server farm, when they were made, and which administrators made them. This is especially useful when multiple administrators are modifying the configuration of your server farm. It also facilitates the identification and, if necessary, reversion of administrative changes that may be causing problems for the server farm.” (emphasis added)
When I worked for Citrix, we had a load evaluator that had no available login times. If a server was acting up, we could apply this “unavailable” load evaluator to it and figure out what was going on. Oftentimes, we would discover that the “unavailable” load evaluator was applied to a new server and not know who did it or why they did it. So, we would have to resort to sending out an email asking why this server was assigned to the load evaluator. Now, Citrix XenApp Configuration Logging tells you who did what and when. That should be enough information to find out why.
Where are Changes Logged?
Changes that you make to the Citrix XenApp farm are logged to a database. The back end database can be:
- Microsoft SQL 2000 or Microsoft SQL 2005 (Microsoft SQL Express works too)
- Oracle 9.2 or 10.2
We will explore the details of the database schema in depth later on.
How are Changes Logged?
There are several ways to make changes to a Citrix XenApp Farm:
In order to facilitate logging changes made by any of these methods, Citrix introduced an IMA hook called CitrixLogServer.dll. As you know, any change made to the data store has to go through IMA first. So, introducing an IMA hook makes sense.
Here are the facts about CitrixLogServer.dll:
- Located in %ProgramFiles%\Citrix\System32
- it is a Microsoft .Net assembly
- it uses ADO.NET to write changes to the database. Once a connection is made to the database, it will automatically disconnect after 5 minutes of inactivity.
- Uses a XSD schema that is optimized for writes
Citrix XenApp Configuration Logging Architecture
When a change is submitted to IMA, the change is written via a transaction to the configuration logging database and data store. It is possible to require all changes be written to the configuration logging database before they are allowed to be written to the data store. This ensures all changes are logged. Since the change is written via a transaction, a failure writing to the logging database or data store rolls back the transaction and no change is made or logged.
Bonus tip: if you clone servers in your Citrix XenApp farm and cannot join the cloned server to the farm, you may have to disable configuration logging. Once the server joins the farm, you can re-enable configuration logging.