Notes on Java, Solaris, PHP, LDAP…

November 18, 2007

Notes on MySQL, Novell eDirectory LDAP ACLs, XSLT, Mailtrap

Filed under: Uncategorized — negev @ 12:12 pm
Tags: ,

9 Aug 07
MySQL Select & GROUP records with minimum value of a chosen column
SELECT offices.id, disposition, count(positions.id) num_positions FROM offices, positions WHERE condition-on-office AND offices.id=positions.office_id GROUP BY offices.id ORDER BY num_positions ASC LIMIT 8;

Novell eDirectory
– schema and attribute names
http://developer.novell.com/documentation/ndslib/index.html?page=/documentation/ndslib/schm_enu/data/sdk738.html#sdk738
– how to change [ROOT] permissions to more specific permissions:
— When replacing [ROOT] by a specific DN, then remove [] brackets
— so instead of “2#entry#[ROOT]#member” you use “2#entry#o=MyCompanyName#member”

XSLT to concatenate strings
– use concat( first, second…) rather than operator +. + works only for numbers
– don’t concatenate values/expressions with in-XML constants, because it will add spaces etc:
<xsl:value-of select=”$logoName” />.gif

Using JEdit with files that are hard-linked at multiple locations
– then in JEdit’s opetions unset: jEdit > General > Two-stage save (safer but resets file owner on Unix)

novell eDirectory weird ACLs – couldn’t modify LDAP ‘mail’ attribute
– that was because I had ACLs in ConsoleOne to EMail Address, not to ‘Internet EMail Address’ – and the second is NDS attribute respective to LDAP attribute ‘mail’
– so you need to set ACLs to ‘Internet EMail Address’ rather than ‘EMail Address’
– see NDS-LDAP attribute mappings in Console One > tree > Resources > Servers > LDAP Group – my server > Attribute Mappings

23 Oct 2007
Mailtrap – fake SMTP server that traps all emails and saves them to a file
http://matt.blogs.it/entries/00002655.html
– it uses Ruby

Universal USB Webcam driver for Mac OS X
http://webcam-osx.sourceforge.net

Advertisements

1 Comment »

  1. […] Notes on MySQL, Novell eDirectory LDAP ACLs, XSLT, Mailtrap … […]

    Pingback by Brasileiro disponibiliza um fanastico sistema: Edirectory ArcaSolutions Versão 6.1 Nulled « Téo Costa - Webdesigner Freela — December 6, 2008 @ 7:26 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: