Lars Kneschke wrote: > Hello! > > I'm about to integrate dbmail with egroupware more closer. > > On thing we have in eGroupWare is a installation id for every single > installation. From the functionality this matches very much with client_idnr > from. Unfortunaly we use md5hash of something is id, while in dbmail this is > integer. > > Would it be possible to use a string instead integer as database field type?
Difficult. The client_idnr has gone unused for most of dbmail's existence. However, while finishing the Aaron's ldap code last year or so, I decided to use it as a gidNumber. And as such the authldap and authsql code now treat it, and dbmail-users allows management of it. > That would make the integration very simple. If it's not possible i need to > create the number from the string somehow. > > That would allow a esay mapping between egroupware account stored in sql > with dbmail accounts stored in sql too. > > > > On the other side we have also the ldap backend. > > It would be nice, if we could get the customer id from the ldap tree > somehow. Currently we can do this only reading some entry the users entry. > But if i use the group idnumber, i can not be sure that this group gets not > changed, as this information get's also used by some other ldap services. > If i have different tree's for different clients already, it would be very > easy to extract that info from the dn. Then i would not need another field > or schema extension. > > What do you think? I don't get it. Are you using ldap or are you using the sql user tables? If you're using authldap, the dbmail_users table is used for creating shadow entries. Only the user_idnr, userid and curmail_size values are actively used. The rest is supposed to be in the ldap tree (come to think of it, I don't know what's going on with maxsieve_size in case of authldap). So if you're on authldap, you're free to change dbmail_users.client_idnr to varchar if you prefer. But I guess you don't want to impose ldap as a requirement for egroupware, right? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
