jQuery and IE8 not the best of friends

So I've been pulling my hair out with IE8 ... again. I wrote some code that was working like a charm in FF and Chrome:

$(this).val().trim().match(match)

Sadly this code did not work in IE8 and I got the following error:

"Object doesn't support this property or method"

Changing it to the below did the trick:

jQuery.trim($(this).val()).match(match)

Another part of my life wasted debugging IE issues :(

Some of my old IT Textbooks

Wow what a find! Was digging around the house and found some really old textbooks. Check this out. Love the story about the CPU.

My Favourtie LDAP Tool

Just had to post this one, else I land up Googling between 1000s of LDAP tools.

http://www.novell.com/communities/node/8652/gawors-excellent-ldap-browsereditor-v282

One of my best CDs

http://www.kalahari.net/music/All-Comes-Round/19738/120249.aspx

Wow I forgot how good this CD was. It's really good to enjoy some old school SA music :)

Oracle Regex

Needed some regex to only leave a-z values.

This seemed to work for me:


select regexp_replace(ent_val,'[^a-zA-Z]','') from ac

Novell Null Driver vs Loopback Driver

FYI a loopback driver can perform a query operation. A null driver returns nothing to a query operation.

Also they are different drivers as they use different Java classes:

com.novell.nds.dirxml.driver.nulldriver.NullDriverShim

vs

com.novell.nds.dirxml.driver.loopback.LoopbackDriverShim

ldapsearch strange results

Always make sure you use the -h option when using ldapsearch on Linux. Else it defaults to what's in the local ldap config (/etc/ldap.conf) which can result in some strange and unexpected results.

Clearing a lock in Oracle

I've been using Oracle's SQLDeveloper now for a while and found you can easily lock a table by not committing an update. Coming from a MySQL and MSSQL world I'm pretty used to updates committing by themselves. Here is how I cleared the lock:


Run this SQL to see what's locking what:

SELECT SUBSTR(TO_CHAR(session_id),1,5) "SID",
       SUBSTR(lock_type,1,15) "Lock Type",
       SUBSTR(mode_held,1,15) "Mode Held",
       SUBSTR(blocking_others,1,15) "Blocking?"
  FROM dba_locks

Use this command to get the serial number of the session:

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';


Use this command to kill the session that's holding the lock:

ALTER SYSTEM KILL SESSION ',';
e.g.
ALTER SYSTEM KILL SESSION '126,19703';

Some good references:

http://www.oracle-base.com/articles/misc/KillingOracleSessions.php
http://www.broadh2o.net/docs/database/oracle/oracleLocks.html

Novell RBPM - How to fix %nrf-sod-root% error

Picked up the following error:

16/05/2011 12:41:38 ERROR [ObjectsLookup] Error encountered while executing the service com.novell.idm.nrf.ajaxservice.ObjectsLookup : Ldap error querying for results. Error: javax.naming.InvalidNameExcepti
on: %nrf-sod-root%: [LDAP: error code 34 - Invalid DN Syntax]; remaining name '%nrf-sod-root%'.
com.novell.srvprv.spi.vdata.exception.VirtualDataException: Ldap error querying for results. Error: javax.naming.InvalidNameException: %nrf-sod-root%: [LDAP: error code 34 - Invalid DN Syntax]; remaining na
me '%nrf-sod-root%'
 


16/05/2011 12:42:44 INFO  [STDOUT] DEBUG [com.novell.soa.af.impl.core.ProvisioningRequestManager:getValidAttribute] ***** %%%TOP%%% ProvisioningRequestManager.getValidAttribute*****
16/05/2011 12:42:44 INFO  [STDOUT] DEBUG [com.novell.soa.af.impl.core.ProvisioningRequestManager:getValidAttribute] going to return a value! values.get(0) = SoD Conflict Approval

Found that someone had deleted the SoDDefs Object.

How to Fix:

1) Recreate the SoDDefs Object.
2) Update the nrfSODContainer attribute on the configuration object under RoleConfig.
3) Flash the cache in the UA.
4) Happy days!

MySQL Select Random Row

Found a good post here: http://www.greggdev.com/web/articles.php?id=6 on this.
Basically you just add this to your query -> "order by rand() limit 1"
e.g. select saying from sayings order by rand() limit 1

Windows 7 - Copy and Paste Issue

So I've been using Windows 7 more since our clients make use of OCS (Office Communicator), which I must say is a really awesome piece of software. Sadly though Windows seems to have issues with copy and paste. First I thought I was going mad...I mean how can you break something as simple as Copy and Paste? Well I can confirm it has been done! I decided to Google the problem and to my surprise found a large number of people having similar issues. So I decided to download Total Commander and use my really old-school tool to copy my files from the one folder to another. A very sad day for Windows 7, else I must say they've come a long way since Vista.

Traffic and Inflation

I find it amazing that the inflation rate is more or less 5-10%. Which means when you get your annual increase it might be 5-10% to accommodate for inflation. The reality though hit me when I went to go buy some Ciro coffee. About 2 years ago I used to pay R26 for 200g of Ciro coffee. Now it costs R40. So sadly the inflation rate for coffee is not where near 5-10%.

Regarding traffic I was in the biggest traffic mess I've ever been in on Friday. It was 100km+ of traffic on the N3. It took us 2 hours to do about 100km. This was crazy and the last thing I felt like to start off the long weekend. After 100km I decided to take some back roads and to my surprise .... road works :( basically it took us 8 hours to get to our destination when it should have only taken 4.5.

Well at least we back at home safely now :)

Busy installing a nice new legal copy of Windows 7 for my new Media PC. I really hope it can play .flac files cause I ripped by whole CD collection to flac. Oh and if you wondering why I'm not using MythTV, gladly I don't have a whole week to waste trying to get it working with my sound card again. Some things should just work, although it is still really sad that Creative do not make proper Linux drivers.

XGR Webcam from CNA

So I lost my driver CD for my XGR webcam I bought at CNA.

After doing some googling I found these drivers which sadly did not work:

http://www.comstarsa.co.za/tmp/

I did however find out the the webcam is a Vimicro VC0321

And got the driver here:

http://download.cnet.com/Vimicro-USB-PC-Camera-VC0321/3000-2110_4-104729.html

LDAP DN Characters

Ok so I need to clean up a String that needed to be a DN.

This post proved very useful: http://www.rlmueller.net/CharactersEscaped.htm

Backup copy

Oracle SQL Developer 3 on Ubuntu

1) Download RPM from Oracle
2) Alien RPM with -k option
3) Install deb with dpkg -i
4) Create file .sqldeveloper/jdk
5) Put this in the file:
/usr/lib/jvm/java-6-sun
6) Make sure you have sun-java6-jdk installed

Run sqldeveloper :)