By the way, i inserted correct birthday for testing, for example, '2025-03-22'.

Sorry i missed one log line, the full log with DATE type column is:

2025-03-22 11:23:14.657 sogod[4076:4076] WARNING(-[NSCalendarDate(MySQL4Values) initWithMySQL4Field:value:length:]): got no value for string '1999-02-03' format '%y%m%d%H%M'.
2025-03-22 11:23:14.657 sogod[4076:4076] ERROR(-[MySQL4Channel primaryFetchAttributes:withZone:]): <MySQL4Channel[0x0xaaaada4c6520] connection=0x0xaaaada44a060>: got no value for column: attribute=birthday
valueClass=NSCalendarDate
type=DATE

Also, it doesn't display first name and last name too.

SQL table:

CREATE TABLE IF NOT EXISTS mailbox (
    first_name VARCHAR(255) NOT NULL DEFAULT '',
    last_name VARCHAR(255) NOT NULL DEFAULT '',
    birthday DATE NOT NULL DEFAULT '0001-01-01',
    -- Omit other columns here
);

Create VIEW for SOGo:

CREATE OR REPLACE VIEW users (
givenname,
sn,
birthday,
-- Omit other columns here
)
AS SELECT
first_name,
last_name,
birthday,
-- Omit other columns here
FROM vmail.mailbox
WHERE ...;

Hello, its seems that with a sql usersource you will need three int columns:

• birthyear
• birthmonth
• birthday

Hi @qhivert,

Thanks for helping. You're correct.

For MariaDB, i have to create view with sql command like below:

CREATE OR REPLACE VIEW users (
    ...,
    birthyear,
    birthmonth,
    birthday
    )
    AS SELECT 
              ...,
              DATE_FORMAT(birthday, "%Y"),
              DATE_FORMAT(birthday, "%m"),
              DATE_FORMAT(birthday, "%d")
         FROM ...
        WHERE ...

For PostgreSQL:

CREATE OR REPLACE VIEW users AS
     SELECT
            ...,
            to_char(birthday, 'YYYY')::integer AS birthyear,
            to_char(birthday, 'MM')::integer AS birthmonth,
            to_char(birthday, 'DD')::integer AS birthday
       FROM ...
      WHERE ...