network lab info

The network lab can currently use a gw of 137.142.110.254 and the 110 subnet. This should change soon.

postgresql and openoffice

Configured open office to work with postgresql.
The way it works is to download a package for postgresql (http://dba.openoffice.org/drivers/postgresql/) and then run open office and under tools go to the packagemanager and add the zip file.

Then in the connection manager you choose postgresql and use config options like
dbname=academic host=localhost

I'm not sure if I will use it a lot, but it is something I want to check out.

The other caveat, is that postgres connections can not go through, so I have to tunnel them
through using
ssh -L5432:localhost:5432

more ldap

wrote a script to do the merge, it will probably never be used again, but it appears to work.

I'll find out more in about an hour.

more ldap

I think I am going to create a new ldif file

1. First find all the new users who need home directories, grep the ldif
grep home ~hartdr/cs20060831.ldif | cut -c16- | xargs ls -ald
The error messages indicate new accounts

2. Create their directories

3. Now stop the slapd server and get the current version of the database

4. Now integrate the two, yuck

Oops, after step 2 I stopped the slapd, and su wants to check it.

Off to the lab.

ldap

Trying to figure out how to integrate the new data I got from CMS into the existing ldap entries.
I don't think I can just use slapadd