Author Topic: about new_user_identity  (Read 383 times)

Offline ishizaki

  • Newbie
  • *
  • Posts: 3
about new_user_identity
« on: July 27, 2022, 04:18:28 AM »
I am trying to get data from Active Directory using the new_user_identity plugin and set the display name at the first login with Roundcube.

Below are some data excerpts:
MariaDB [roundcubemail]> select * from users where created between '2022-06-01' and '2022-06-30';
+---------+-------------------+-----------+---------------------+---------------------+--------------+----------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user_id | username          | mail_host | created             | last_login          | failed_login | failed_login_counter | language | preferences                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+---------+-------------------+-----------+---------------------+---------------------+--------------+----------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|    2368 | taro.tanaka       | localhost | 2022-06-01 09:52:37 | 2022-07-07 23:29:00 | NULL         |                 NULL | ja_JP    | a:1:{s:11:"client_hash";s:16:"zpW4ALt3iu7BpsQm";}                                                                                                                                                                                                                                                                                                                                                                                                             |
|    2369 | jiro.suzuki       | localhost | 2022-06-01 09:52:44 | 2022-07-07 12:31:19 | NULL         |                 NULL | ja_JP    | a:1:{s:11:"client_hash";s:16:"lh6B5nNDtqpwVH0v";}   



MariaDB [roundcubemail]> select * from identities where user_id between 2368 and 2396;
+-------------+---------+---------------------+-----+----------+-----------------------+--------------+-------------------------------------+----------+-----+-----------+----------------+
| identity_id | user_id | changed             | del | standard | name                  | organization | email                               | reply-to | bcc | signature | html_signature |
+-------------+---------+---------------------+-----+----------+-----------------------+--------------+-------------------------------------+----------+-----+-----------+----------------+
|        2363 |    2368 | 2022-06-29 13:53:22 |   0 |        1 | 田中 太郎            |              | taro.tanaka@andersen-group.jp       |          |     |           |              0 |
|        2364 |    2369 | 2022-06-01 09:52:44 |   0 |        1 | jiro.suzuki           |              | jiro.suzuki@andersen-group.jp       |          |     | NULL      |              0 |


The information that the user jiro.suzuki can also get in Active Directory is entered as 鈴木 次郎.
I have confirmed that the above phenomenon occurs when it is not possible to connect with Active Directory, but in that case, a log that cannot connect to Active Directory is output.
There were no logs where the error occurred at the time the user information in the database was created.

Please tell me the reason why the normal value cannot be obtained from Active Directory when logging in for the first time.