Personal

Posterous

Trying out a new posting service…. just because I can

Personal

Optiplex 760 Network Issue on SUSE 11.2

There seems to be an issue with the network driver for the Dell Optiplex 760 and Suse 11.2 This problem resides in the e1000e driver that is supposed to superceede the e1000 driver. What needs to be done is blacklist the e1000e driver and revert back to the e1000 driver that does work with this network card.

Edit the File /etc/modprobe.d/50-blacklist.conf

Add a the line to the bottom of the file

blacklist e1000e

Then still as root run these commands
#rmmod e1000e
#modprobe e1000
#rcnetwork restart

should only show on module loaded.
#lsmod | grep -i e1000

If it shows multiple then reboot, you should be able to configure the network card via Yast2 now.

Tech

Drop All Tables in a Postgress Database

I came across an interesting technique for dropping all the tables in a PostgreSQL Database without dropping the whole database.  Just drop this little piece of code into the database and the returning set is a list of sql that can be coppied and pasted right back into the database.

[code]SELECT
‘DROP TABLE ‘||c.relname ||’ CASCADE;’
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN (‘r’,”)
AND n.nspname NOT IN (‘pg_catalog’, ‘pg_toast’)
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1;[/code]

I pulled this snipped of code from http://antydba.blogspot.com/2009/10/how-to-drop-all-tables-from-database.html Many Thanks!

Personal

Lightroom3 Beta

I got to play with Adobe’s Lightroom 3 Beta.  I took a picture that I really liked that I took with my camera phone.  I did some simple processing on it and this is what I came up with.  Can you guess which one is which?

Public Key Infrastructure ( PKI ), Tech

DER vs. CRT vs. CER vs. PEM Certificates

Certificates and Encodings

At its core an X.509 certificate is a digital document that has been encoded and/or digitally signed according to RFC 5280.

In fact, the term X.509 certificate usually refers to the IETF’s PKIX Certificate and CRL Profile of the X.509 v3 certificate standard, as specified in RFC 5280, commonly referred to as PKIX for Public Key Infrastructure (X.509).

X509 File Extensions

The first thing we have to understand is what each type of file extension is.   There is a lot of confusion about what DER, PEM, CRT, and CER are and many have incorrectly said that they are all interchangeable.  While in certain cases some can be interchanged the best practice is to identify how your certificate is encoded and then label it correctly.  Correctly labeled certificates will be much easier to manipulat

Encodings (also used as extensions)

  • .DER = The DER extension is used for binary DER encoded certificates. These files may also bear the CER or the CRT extension.   Proper English usage would be “I have a DER encoded certificate” not “I have a DER certificate”.
  • .PEM = The PEM extension is used for different types of X.509v3 files which contain ASCII (Base64) armored data prefixed with a “—– BEGIN …” line.

Common Extensions

  • .CRT = The CRT extension is used for certificates. The certificates may be encoded as binary DER or as ASCII PEM. The CER and CRT extensions are nearly synonymous.  Most common among *nix systems
  • CER = alternate form of .crt (Microsoft Convention) You can use MS to convert .crt to .cer (.both DER encoded .cer, or base64[PEM] encoded .cer)  The .cer file extension is also recognized by IE as a command to run a MS cryptoAPI command (specifically rundll32.exe cryptext.dll,CryptExtOpenCER) which displays a dialogue for importing and/or viewing certificate contents.
  • .KEY = The KEY extension is used both for public and private PKCS#8 keys. The keys may be encoded as binary DER or as ASCII PEM.

The only time CRT and CER can safely be interchanged is when the encoding type can be identical.  (ie  PEM encoded CRT = PEM encoded CER)

Common OpenSSL Certificate Manipulations

There are four basic types of certificate manipulations. View, Transform, Combination , and Extraction

View

Even though PEM encoded certificates are ASCII they are not human readable.  Here are some commands that will let you output the contents of a certificate in human readable form;

View PEM encoded certificate

Use the command that has the extension of your certificate replacing cert.xxx with the name of your certificate

openssl x509 -in cert.pem -text -noout
openssl x509 -in cert.cer -text -noout
openssl x509 -in cert.crt -text -noout

If you get the folowing error it means that you are trying to view a DER encoded certifciate and need to use the commands in the “View DER encoded certificate  below”

unable to load certificate
12626:error:0906D06C:PEM routines:PEM_read_bio:no start line:pem_lib.c:647:Expecting: TRUSTED CERTIFICATE

View DER encoded Certificate

openssl x509 -in certificate.der -inform der -text -noout

If you get the following error it means that you are trying to view a PEM encoded certificate with a command meant for DER encoded certs. Use a command in the “View PEM encoded certificate above

unable to load certificate
13978:error:0D0680A8:asn1 encoding routines:ASN1_CHECK_TLEN:wrong tag:tasn_dec.c:1306:
13978:error:0D07803A:asn1 encoding routines:ASN1_ITEM_EX_D2I:nested asn1 error:tasn_dec.c:380:Type=X509

Transform

Transforms can take one type of encoded certificate to another. (ie. PEM To DER conversion)

PEM to DER

openssl x509 -in cert.crt -outform der -out cert.der

DER to PEM

openssl x509 -in cert.crt -inform der -outform pem -out cert.pem

Combination

In some cases it is advantageous to combine multiple pieces of the X.509 infrastructure into a single file.  One common example would be to combine both the private key and public key into the same certificate.

The easiest way to combine certs keys and chains is to convert each to a PEM encoded certificate then simple copy the contents of each file into a new file.   This is suitable for combining files to use in applications lie Apache.

Extraction

Some certs will come in a combined form.  Where one file can contain any one of: Certificate, Private Key, Public Key, Signed Certificate, Certificate Authority (CA), and/or Authority Chain.

Personal

Cute Picture of Kaelum

When you hold a baby near to your face all the time you kind of loose track on how small he really is.   My wife is the one that took this picture so I have to give credit to her.  Kaelum is just so TINY, I couldn’t help but send this picture.

You can see it at her blog: Devilsangels.net

Personal

The Future of My Son

[mudslide:picasa,0,markgard,5432399194876489713,1,400,center]

So Kaelum decided today that I wasn’t paying enough attention to him and proceed to Munch on My Mac.   I often wonder what he will be interested in when he’s older.  Only time will tell.

[mudslide:picasa,0,markgard,5432399194876489713,2,400,center]

Tech

Blog Integration

I’ve been trying for some time now to get wordpress to integrate more tightly with Facebook and Twitter.   The Few times I’ve tried this before has provided sub optimal results.   Right now it’s all working using two different plugins that seem to give me more functionality than I really need.

For Twitter i’m using http://www.joedolson.com/articles/wp-to-twitter/ this enables me to post to twitter, and bit.ly for tracking.

The facebook plugin I’m using is much more complicated than just posting to my wall.  It has a much tighter integration with FB.  In fact you have to go get a developer’s key to get this to work.  The name of this plugin is WPBook.  This plugin really embeds WordPress into the facebook canvas.

I hope to be able to share my blog more.  I’ve seen how much my wife loves blogging.  I hope that I can contribute something more useful than m my usual ramblings of an idiot.