LDAP Search

ldapsearch -x -h ldap.foo.com -b 'ou=active,ou=employees,ou=people,o=foo.com' -W

-x Use simple authentication instead of SASL.

-b Searchbase

-W Prompt for simple authentication

It turns out you can farkle the data dictionary in mysql by renaming a dB to something like db-OLD. You get an error like this:

091210 10:49:30 InnoDB: Error: table `crowd/hibernate_unique_key` already exists in InnoDB internal

InnoDB: data dictionary. Have you deleted the .frm file

InnoDB: and not used DROP TABLE? Have you used DROP DATABASE

InnoDB: for InnoDB tables in MySQL version <= 3.23.43?

InnoDB: See the Restrictions section of the InnoDB manual.

InnoDB: You can drop the orphaned table inside InnoDB by

InnoDB: creating an InnoDB table with the same name in another

InnoDB: database and copying the .frm file to the current database.

InnoDB: Then MySQL thinks the table exists, and DROP TABLE will

InnoDB: succeed.

InnoDB: You can look for further help from

InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html

"/var/log/mysqld.log" [Modified] 10449 lines --100%--

The fix is to remove the backup database.

BTW: If you name something blah -OLD in mysql, the mysql client can't deal with "-OLD" or at least I don't know how to quote / escape it. Didn't try \-OLD but that might have worked. I used mysqladmin drop blah-OLD.

Zenoss and Cisco ASA

It's pretty easy to set up Zenoss enterprise to monitor a Cisco ASA device. It's just SNMP, and you get the interfaces, which we've had trouble with in the office lately, and you also get the CPU and memory on the device which is pretty much good enough. I'd like to keep a log of changes to the device, but we more or less get that with Traps. I need to set up the the mib translations both to do it, and so we see better messages for the traps we get.

Today, i want to get Exchange set up and show it around and maybe WMware if Dave can help me with it.

I'm also setting up Ubuntu on my laptop. I'm setting up Cisco VPN client so I need to install the Linux headers so it can compile the module. I got Cisco vpn working with just the network vpn that came with Ubuntu. I imported the cisco.pcf and voila!

Exchange High Availability

We've run across two large customers. One runs many Exchange servers with a limit of 800 users per instance and the other runs large HA clusters. The latter has many outside domains it must maintain. I'm wondering about the differences in the two approaches. It's possible the non-HA customer implemented before HA was stable with Exchange. I'd like to compare and contrast the two techniques and get an idea of where each one fits in large IT organizations