Bits of Wisdom

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.

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>

SITZUNGSNAME   BENUTZERNAME      KENNUNG STATUS  TYP         GERÄT
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>

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

[mysqld]
#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)
log-queries-not-using-indexes

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

[mysqld] 
#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)
log-queries-not-using-indexes

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 0.0.0.0
httpcfg set iplisten -i xx.xx.xx.xx
net start http
net start w3svc
net start w3proxy

Just so i do not forget it:

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

notes:
-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

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 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 -->
</span>
</span>

<script>

function closeplayer() {
document.getElementById(‘flashholder’).removeChild(document.getElementById(‘myplayer’));
}

window.onbeforeunload=’closeplayer()’

</script>

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
session.cache_expire

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

If the enviroment variable http_proxy is set wget will automaticly use it

set http_proxy=http://12.34.56.78
wget -proxy on http://iserver09.example.com/
set http_proxy=

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

set RSYNC_PROXY=12.34.56.78:80
rsync -auv –delete –stats  /cygdrive/c/source/directory username@hostname::rsync_share
set RSYNC_PROXY=

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

LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
…
<IfModule mod_proxy.c>
AllowCONNECT 873
</IfModule>

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