All posts by roman

OpenOffice service init.d script for CentOS

This script will start soffice headless listening on port 8100. You can use it eg. with JODConverter.

#!/bin/bash
# openoffice.org headless server script
#
# chkconfig: 2345 80 30
# description: headless openoffice server script
# processname: openoffice
#
OOo_HOME=/usr/bin
SOFFICE_PATH=$OOo_HOME/soffice
PIDFILE=/var/run/openoffice-server.pid

set -e

case "$1" in
start)
if [ -f $PIDFILE ]; then
echo "OpenOffice headless server has already started."
sleep 5
exit
fi
echo "Starting OpenOffice headless server"
$SOFFICE_PATH -nologo -nodefault -norestore -nocrashreport -nolockcheck -headless -nofirststartwizard -accept="socket,host=localhost,port=8100;urp" & > /dev/null 2>&1
touch $PIDFILE
;;
stop)
if [ -f $PIDFILE ]; then
echo "Stopping OpenOffice headless server."
killall -9 soffice && killall -9 soffice.bin
rm -f $PIDFILE
exit
fi
echo "Openoffice headless server is not running."
exit
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac
exit 0

Hosting ClickOnce application on Amazon S3

When hosting ClickOnce applications on Amazon S3 you might notice download problems on some versions of Internet Explorer. Although other browsers does not have problems downloading ClickOnce .application file, Internet Explorer complains with “The requested site is either unavailable or cannot be found.”.

The problem is most probably in the Content-Type of the .application file. It is set to application/binary, but should be application/x-ms-application. To fix it, you have to connect to S3 Management Console and fix the Content-Type under file Properties.

IE9 bookmarks are not searched in address bar

Address bar in IE9 displays history and favorites results while you are typing by default. IE9 uses Windows Search to improve the results and also to shorten time necessary to get them. So the reason why favorites might not be displayed is because Favorites folder is not indexed. There are two solutions to fix this situation:

Disable use of Windows Search for these results. Go to Tools > Internet Options > Content tab > AutoComplete Settings button and unclick Use Windows Search for better results.

The second and better solution is to add Favorites to the Windows Search index locations. Go to Start and type Indexing Options, click on the Modify button and select Favorites folder under your Windows profile folder.

Diablo on Widows Vista / 7

If you would like to play this old but legendary game on new versions of Windows you may face some problems.

  1. The first problem is that on the start or during play, colors may get corrupted like on the picture above. But the solution is quite easy, just open the Screen Resolution dialog using context menu on Desktop and leave the dialog opened before you start the game 🙂
  2. IPX is not available since Windows Vista, so multiplayer on LAN does not work. But there is a IPXWrapper library which will wrap communication over UDP protocol. Just download it and copy all dll files from the package to the Diablo installation folder.
  3. Do not forget to use the latest patch available.

Check whether text is UPPER case in T-SQL

I have prepared small snippet which will help you check whether some text is UPPER case in T-SQL. I have not found any good example while Googling. You can easily update to code to check whether the text is lower case by replacing UPPER with LOWER in the snippet.

DECLARE @Name AS NVARCHAR(64)
SET @Name = 'NAME'

IF BINARY_CHECKSUM(@Name) = BINARY_CHECKSUM(UPPER(@Name))
SELECT 1;
ELSE
SELECT 0;

Remove old folders on Windows using batch script

I have found nice batch script which will remove all folders inside specific folder. This is good when you have some directory with automatic builds and want to remove old scripts from time to time.

ForFiles /P "BASE_FOLDER_PATH" /D -14 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE &RD /Q /S @FILE"

Replace BASE_FOLDER_PATH with folder containing automatic builds and 14 with maximum number of days. Older folder will be removed.