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. John Guthrie [EMAIL PROTECTED] _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
