Dist,
I figured out my own issue!  Essentially 'username' is not an attribute 
defined in any of the schema files that I have slapd load; therefor I 
changed it to 'displayname' which is an attribute in the inetorgperson 
schema, adjusted the appropriate settings in the postgresql tables, and 
voila... slapd was happy, I was happy, happiness now shared with you ;)
By the way, openldap kicks some major but on Solaris!!!!  Especially 
tieing into PostgreSQL(arguably the best opensource RDBMS - sorry don't 
want a flamewar ;) )
I hope this info helps someone else too.
On Fri, 22 Jun 2007, gonzales@linuxlouis.net wrote:
> Hello Resident Experts,
> Solaris 10, openldap 2.3.35, postgresql 8.0.1, unixODBC 2.2.12
>
> There are the template test sql files for the Postgresql RDBMS that come with 
> the openldap source code.  I've compiled everything correctly, evertyhing is 
> working OOTB, I can create new users and search using ldapmodify and 
> ldapsearch respectively, all of the information in the 'persons' postgresql 
> table is getting updated.
>
> I've added an additional attribute to persons table 'mail' and made the 
> appropriate ldap_attr_mappings entry, so I can ldapmodify and add mail values 
> to the users in the database.  However, when I attempt to add one more 
> additional attribute 'username' with the following ldap_attr_mappings
>
> insert into ldap_attr_mappings 
> (id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_retur
> n) values (16,1,'username','persons.username','persons','persons.username IS 
> NOT NULL','UPDATE persons SET username=? WHERE i
> d=?','UPDATE persons SET username=NULL WHERE username=? AND id=?',3,0);
>
> and attempt to restart openldap, I get the following error:
>
> bash-3.00# /usr/local/libexec/slapd -f /usr/local/etc/openldap/slapd.conf -h 
> ldap://bandaboo1.bandaboo.com:81/ -d 256
> @(#) $OpenLDAP: slapd 2.3.35 (May 26 2007 23:48:09) $
>        root@bandaboo1:/usr/local/downloads/openldap-2.3.35/servers/slapd
> WARNING: No dynamic config support for database sql.
> backend_startup_one: bi_db_open failed! (1)
> slapd stopped.
> connections_destroy: nothing to destroy.
>
>
>
>
>
-- Louis Gonzales louis.gonzales@linuxlouis.net http://www.linuxlouis.netReceived on Fri Jun 22 2007 - 01:54:03 MDT
This archive was generated by hypermail pre-2.1.9 : Sun Jul 01 2007 - 12:00:04 MDT