September 29

Software: Libre Office – Fixing the Restore Windows Bug in OSX

When using Libre Office it appears that if you “force” quite Libre, you can also plan on seeing a “Restore Windows” pop-up that will not go away.

To fix this:

  1. Got to “Finder”
  2. Click Go
  3. Press your “option” key and the word “Library” will appear
  4. Click on Library
  5. Scroll down to “Saved Application state” and Click Double Click
  6. Find “org.libreoffice.script.savedState” and move it to the Trash Can
Also, you can write an applet in Apple Script to do this for you by replacing “IDENTIFER” with the identifier of the application:
do shell script “rm ‘~/Library/Saved Application State/”IDENTIFER”.savedState'”
Category: Software | Comments Off on Software: Libre Office – Fixing the Restore Windows Bug in OSX
September 28

Exchange: A configuration error in the e-mail system caused the message to bounce between two servers or to be forwarded between two recipients.

We were having an issue with John Smith exchange setup. John was unable to receive email and received the following error:

The following recipient(s) cannot be reached:
Smith, John on 01/15/2010 10:05
A configuration error in the e-mail system caused the message to bounce between two servers or to be forwarded between two recipients.
Contact your administrator.
<mailserver01.someserver.internal #5.4.6>

I looked into the Exchange settings on mailserver01. He was not in the mailbox list on the Exchange server. I pulled up AD Users and Computers and did a “Find”. John was listed as a Domain user, but not an Exchange User. I discovered that for whatever reason he was created an external user. I deleted his external Exchange mail account and recreated it to have a mailbox on the system. Once created, I had to manually add the mailbox types MS, SMTP, and X400.

Category: Software | Comments Off on Exchange: A configuration error in the e-mail system caused the message to bounce between two servers or to be forwarded between two recipients.
September 22

Citrix: Reducing the RMSummaryDatabase Size

Once you’ve backed up the RM summary Database, you can run a manual purge on the prod database to get rid of what was backed up. Here’s the query (to be run from Query Analyzer):

**********

**********************************
DECLARE @farmName nvarchar(255)
DECLARE @sCutoffDate datetime
SELECT @farmName = N’EnterYourFarmName’
SELECT @sCutoffDate = ‘2007-03-05 16:20:00′ <= Enter the relevant date.
EXEC PurgeUnbilledSessProc @farmName, @sCutoffDate
EXEC Purgeevents @farmName, @sCutoffDate
EXEC Purgemetrics @farmName, @sCutoffDate
********************************************Note: If your customer is using billing, you will need to add this line as well:

********************************************
EXEC PurgeBilledSessProc @farmName, @sCutoffDate
********************************************

Note2: Is your customer using web interface? If so, you might want to get rid of randomly generated client name from the LU_CLIENT table that will not be used anymore:

********************************************
Delete FROM LU_client WHERE PK_clientID NOT IN ( SELECT FK_clientID FROM SDB_session )
and PK_clientID NOT IN ( SELECT FK_clientID FROM SDB_process )
and PK_clientID NOT IN ( SELECT FK_clientID FROM SDB_clienthistory )
********************************************

Note3: Same thing for the LU_USER table:

********************************************
Delete FROM LU_USER WHERE PK_userID NOT IN ( SELECT FK_userid FROM SDB_process )
and PK_userID NOT IN ( SELECT FK_userid FROM SDB_session )
********************************************
There are many ways to reduce the size of the RMDB but it all depends on what is expected from it so, unless the storage for backup is not an issue, you might need to understand what it is used for (billing, report types, etc).

By Vincent

 

Category: Software | Comments Off on Citrix: Reducing the RMSummaryDatabase Size