| Description | The additional fields in my SQL auth table are not visible in any client that I use: Web and Thunderbird.
According to : https://sogo.nu/files/docs/SOGoInstallationGuide.html#_authentication_using_sql
it is stated that: "Other columns can exist and will actually be mapped automatically if they have the same name as popular LDAP attributes (such as givenName, sn, department, title, telephoneNumber, etc.)."
I have some extra columns, but in all above mentioned clients I can only see some of the required fields and some additional columns. |
|---|
| Additional Information | Table definition:
-- Table: sogo_auth
-- DROP TABLE sogo_auth;
CREATE TABLE sogo_auth
(
c_uid character varying NOT NULL,
c_name character varying,
c_password character varying,
c_cn character varying,
mail character varying,
"givenName" character varying,
sn character varying,
department character varying,
title character varying,
initials character varying,
"displayName" character varying,
description character varying,
"telephoneNumber" character varying,
"otherTelephone" character varying,
url character varying,
mobile character varying,
"Company" character varying,
"streetAddress" character varying,
c character varying,
"postalCode" character varying,
st character varying,
CONSTRAINT sogo_auth_pkey PRIMARY KEY (c_uid),
CONSTRAINT sogo_auth_c_name_key UNIQUE (c_name)
)
WITH (
OIDS=FALSE
);
ALTER TABLE sogo_auth
OWNER TO sogo;
In sogo.conf I have
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_auth";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = sha512-crypt;
displayName = "Employees";
}
);
In the postgresql logfile I see the query which retrieves every field:
SELECT * FROM sogo_auth WHERE (LOWER(c_cn) LIKE '%.%' OR LOWER(mail) LIKE '%.%') |
|---|
