I wrote: > Hello all, > > I just tried updating a user_idnr in my DBMail postgres database to start > looking at an LDAP migration. The owner_idnr in the dbmail_mailboxes updated > correctly. However, when I looked at the dbmail_aliases table, I noticed that > the numbers that were listed in the deliver_to column had not updated. And > sure enough all of the user's aliases seem to have gone away when I check > with dbmail-users. I also noticed that all of the values in the client_idnr > column were set to zero. According to the schema, the deliver_to column is > supposed to be a VARCHAR type, so I'm kind of curious why the dbmail-users > program is storing only integers in that column. I'm also thinking that there > should be some kind of foreign key that references the user_idnr in the > dbmail_users table. I'd propose a patch, but I don't know if some of these > columns have been deprecated or something like that. > > The foreign key would be useful in the case where someone wants to migrate > an already existing database to LDAP authentication.
I made this statement based on the statement in the README.ldap file that says that the uidNumber in LDAP needs to be the same as dbmail_users.user_idnr. But looking at dbmail.schema, it says that dbmailUser in LDAP can also have a dbmailUID attribute. Does that attribute get used? If so, does it obviate the need to go around changing UIDs? Thanks. John Guthrie [EMAIL PROTECTED] _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
