Archive for category IT

Oracle 10 Client on Windows 7

Posted by on Tuesday, 17 August, 2010

If you need the full Oracle Client on your Win7 machine, you are in a bit of trouble.

Windows 7 is internal windows 6.1 and the setup routine checks for windows 5, 5.someting and 6.0. So no Windows 7.

But there is a hack: turn off the system check with the flag -ignoreSysPrereqs

so running

setup.exe -ignoreSysPrereqs

form a cmd does the trick. You’ll have to overwrite the error later in the setup routine by clicking the failed checkbox.

Remotly killing a RDP Session

Posted by on Wednesday, 2 June, 2010

Server full, or a session handing .. you know it’s a pain. But how to remotly get you a free session?

First check the sessions

qwinsta /server:<servername>

console                        0                                     Verbunden                                    wdcon
rdp-tcp                     65536                              Bereit                                               rdpwd
rdp-tcp#5               xxchr95                         2                                      Aktiv       rdpwd
rdp-tcp#13            xxkla19                           1                                     Aktiv        rdpwd

Then, kick a sesson

rwinsta 2 /server:<servername>

Where 2 is the Session Id from the qwinsta command

Or, if you happen to be admin on the target machine take over the console RDP session

mstsc /console /v:<server>

Find out what mysql queries are slow

Posted by on Wednesday, 2 June, 2010

So you are using mysql and have some data in your DB … say 2 million rows or something.  Not it’s about time to see how your SQL queries are doing, do some profiling, but … but how to you find out what sql queries are slow? Where you are missing that index? Try the following in your mysql.ini

#enable slow query logs
log-slow-queries = d:/your/path/to/log/slow.log
# default of “slow” is 10 seconds, set it to 1
long_query_time = 1
# log *EACH AND ANY* query not using an index (this may be a lot till you fix it)

Then you see where you’re not using the index, where you forgot it. Maybe use EXPLAIN on some of your longer queries to find out how to improve them

#enable slow query logs
log-slow-queries = d:/phpapps/xampp/mysql/log/slow.log
# default of "slow" is 10 seconds, set it to 1
long_query_time = 1
# log *EACH AND ANY* query not using an index (this may be a lot till you fix it)

IIS and Apache both on Port 80

Posted by on Wednesday, 5 May, 2010

IIS takes up all IP adresses by default.

Use programm httpcfg ( part of MS 2003 support tools) to solve the problem

net stop http /y
net stop w3proxy
httpcfg delete iplisten -i
httpcfg set iplisten -i xx.xx.xx.xx
net start http
net start w3svc
net start w3proxy

mysqldump on other host – an example

Posted by on Monday, 15 March, 2010

Just so i do not forget it:

mysqldump -hservername –user=backupuser –password=backupuserpassword –verbose databasename > backupfile.dmp

-h<servername> has no space between the -h flag and the hostname. No idea how they came to that idea.
<backupuser> has to has loginrights from any host or from your host table (the usual local user will not work)
<backupuser> needs LOCK TABLE permission for that DB
–verbose makes your live much easier

Importing a SVN dump it a new repository

Posted by on Wednesday, 13 January, 2010

Do the dumping on the old repository

svnadmin dump /var/oforge/svn/PROJJECT_NAME > DUMPFILE

Importing in the new repository

svnadmin load /data1/svnroot/grz_yy_test/ < DUMPFILE

Note that the whole structure in imported/exported, so mind existing /trunk directories

Longtail Flash Video player Error 2032

Posted by on Tuesday, 3 November, 2009

Longtail is one of the best flv players out there, but it has some shortcommings:

Missing callback function closeplayer

Internt Explorer has currently problems with IE 8 (IE 6 confirmed). This results from a missing callback function. Solution in wordpress enviroment:

<span id="flashholder">
<span id="mplayer">
<!-- here's your standard flash link, the rest does the magic -->


function closeplayer() {



Found at longtail support forums

Accessing XML playlists over SSL may cause problems

Restrictive session settings cause IE to keep flash from accessing the downloaded xml file myextractXML.php.

Bad HTTP headers:

Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache

Good HTTP Headers

Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: private, max-age=-1 pre-check=-1
Pragma: public

You can experiment with php.ini configs
session.cache_limiter = private

But you’ll experience IE 6 chaching problems (IE 6 must die).

Best to set the headers correctly in the files you deliver. In wordtube it’s myextractXML.php

Using wget with proxy on windows

Posted by on Wednesday, 7 October, 2009
If the enviroment variable http_proxy is set wget will automaticly use it

set http_proxy=
wget -proxy on
set http_proxy=

Using rsync with proxy on windows

Posted by on Tuesday, 6 October, 2009

If you need to use rsync with a proxy:

set enviroent variable RSYNC_PROXY, if this is set rsync automaticly uses this proxy on port 873

rsync -auv –delete –stats  /cygdrive/c/source/directory username@hostname::rsync_share

If you are using an apache as proxy your config should be looking a bit like this

LoadModule proxy_module modules/
LoadModule proxy_connect_module modules/

<IfModule mod_proxy.c>
AllowCONNECT 873

Making sense of ECM acronyms

Posted by on Friday, 2 October, 2009

What’s behind the Few Letter Acronyms

ECM: A really big and really expensive document management system

BPM: A really expensive workflow system

SharePoint: A big collection of lots of little document management systems

RM: The art of legally deleting most files while keeping the rest for a really long time

WCMS: Web-team Creates More Stuff

E2.0: Facebook without the fun

Enterprise Portal: A way of assembling all of your ugly and annoying applications in one place

DAM: A way of assembling all your ugly and annoying images in one place

E-mail Archiving: Er….well, mercifully no acronym yet

First published by CMS Watch