Am 2014-03-29 02:50, schrieb Thomas Harold: > We have what is a pretty common setup: Postfix & Dovecot both > authenticating against a PostfixAdmin database (called "mails") stored > in PostgreSQL running on the localhost. > > For SOGo to authenticate against a database, we setup the following view > against the "mailbox" table in our "mails" database. > < ... > > I have figured out that if I add the following field to the "mailbox" > table and export in the view without the "x_sogo_" prefix, it shows up > in the SOGo Web client address book as the work number. > > x_sogo_c_telephonenumber character varying(255) -> c_telephonenumber (in > the VIEW) > > The question I have is this, if we want to add other fields to the > mailbox table (and the "sogo_authentication" view), is there a list > somewhere of what field name and data type that SOGo is expecting for > each new field? >
I don't use SQL auth. I only know of the "LDAP Attribute Mapping" list in the "SOGo Installation Guide" page 25. But perhaps you can use these attribute names with a "c_" prefix. You could try to use e.g. c_mozillanickname for the nickname. As for the data type, with the "c_" prefix it should be character varying(255). But as I said, you have to test this yourself. Kind regards, Christian Mack -- Christian Mack Abteilung Basisdienste KIM IT-Services Universität Konstanz
smime.p7s
Description: S/MIME Cryptographic Signature
