Malformed UTF-8 data Ldap

[Nathu2018]

Page on which it happened

Next error occurred
Error: Malformed UTF-8 data

Raw answer from server:

Warning: Illegal offset type in C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Connection.php on line 495
eyJjaXBoZXJ0ZXh0IjoiWDdONDMwNkViVkNsNDdQXC9lM1dJa1wvdk80eHl5MUdXZStYQ0JzbVF6cTBXU2NkejlwTVwvaTRhVVc3RTNycWJJYldEanFkd0RPVUdsMmMyVjFHUFc4YmxqN01GR1wvV3V6bm9zWTVrVU15MmQ2T3RBcEhGTGFUUXBhV0ZGTnhuemx6V3RkMnNaejE0dlJYdkhiS

Steps to reproduce

1. Post upgrade if user try login get above warning
2. if perfom test LDAP setting

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system: Windows NT NRC2TEAMPASSVM 10.0 build 14393 (Windows Server 2016) AMD64

Web server: Apache/2.4.27 (Win64) OpenSSL/1.1.0f PHP/7.4.33

Database: 5.7.19-log

PHP version: 7.4.33

Teampass version: 3.0.0.22

Teampass configuration file:

'max_latest_items' => '10',
'enable_favourites' => '1',
'show_last_items' => '1',
'enable_pf_feature' => '0',
'log_connections' => '1',
'log_accessed' => '1',
'time_format' => 'H:i:s',
'date_format' => 'd/m/Y',
'duplicate_folder' => '1',
'item_duplicate_in_same_folder' => '0',
'duplicate_item' => '1',
'number_of_used_pw' => '3',
'manager_edit' => '1',
'cpassman_dir' => 'C:/wamp64/www/Teampass',
'cpassman_url' => 'https://<anonym_url>/Teampass
'favicon' => 'https://<anonym_url>/Teampass/UP_icon.ico',
'path_to_upload_folder' => 'C:/wamp64/www/Teampass/upload',
'url_to_upload_folder' => 'https://<anonym_url>/Teampass/upload',
'path_to_files_folder' => 'C:/wamp64/www/Teampass/files',
'url_to_files_folder' => 'https://<anonym_url>/Teampass/files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'enable_sts' => '1',
'encryptClientServer' => '1',
'cpassman_version' => '3.0.0.22',
'ldap_mode' => '0',
'ldap_type' => 'ActiveDirectory',
'ldap_suffix' => '@am.tsacorp.com',
'ldap_domain_dn' => 'DC=am,DC=tsacorp,DC=com',
'ldap_domain_controler' => 'am.tsacorp.com',
'ldap_user_attribute' => '0',
'ldap_ssl' => '0',
'ldap_tls' => '0',
'ldap_search_base' => '0',
'ldap_port' => '389',
'richtext' => '0',
'allow_print' => '0',
'roles_allowed_to_print' => '["10","13","14"]',
'show_description' => '1',
'anyone_can_modify' => '0',
'anyone_can_modify_bydefault' => '0',
'nb_bad_authentication' => '15',
'utf8_enabled' => '1',
'restricted_to' => '1',
'restricted_to_roles' => '1',
'enable_send_email_on_user_login' => '0',
'enable_user_can_create_folders' => '1',
'insert_manual_entry_item_history' => '1',
'enable_kb' => '1',
'enable_email_notification_on_item_shown' => '0',
'enable_email_notification_on_user_pw_change' => '1',
'custom_logo' => 'https://<anonym_url>/Teampass/corp-logo',
'custom_login_text' => '',
'default_language' => 'english',
'send_stats' => '0',
'send_statistics_items' => 'stat_country;stat_users;stat_items;stat_items_shared;stat_folders;stat_folders_shared;stat_admins;stat_managers;stat_ro;stat_mysqlversion;stat_phpversion;stat_teampassversion;stat_languages;stat_kb;stat_suggestion;stat_customfields;stat_api;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;',
'send_stats_time' => '1518528157',
'get_tp_info' => '0',
'send_mail_on_user_login' => '0',
'nb_items_by_query' => 'auto',
'enable_delete_after_consultation' => '0',
'enable_personal_saltkey_cookie' => '0',
'personal_saltkey_cookie_duration' => '45',
'email_smtp_server' => '<removed>'
'email_smtp_auth' => '',
'email_auth_username' => '<removed>'
'email_auth_pwd' => '<removed>'
'email_port' => '25',
'email_security' => '',
'email_server_url' => '',
'email_from' => '<removed>'
'email_from' => '<removed>'
'pwd_maximum_length' => '30',
'google_authentication' => '0',
'delay_item_edition' => '0',
'allow_import' => '1',
'proxy_ip' => '<removed>'
'proxy_port' => '',
'upload_maxfilesize' => '20mb',
'upload_docext' => 'doc,docx,dotx,xls,xlsx,xltx,rtf,csv,txt,pdf,ppt,pptx,pot,dotx,xltx',
'upload_imagesext' => 'jpg,jpeg,gif,png',
'upload_pkgext' => '7z,rar,tar,zip',
'upload_otherext' => 'sql,xml',
'upload_imageresize_options' => '1',
'upload_imageresize_width' => '800',
'upload_imageresize_height' => '600',
'upload_imageresize_quality' => '90',
'use_md5_password_as_salt' => '0',
'ga_website_name' => 'TeamPass for ChangeMe',
'api' => '0',
'subfolder_rights_as_parent' => '1',
'show_only_accessible_folders' => '1',
'enable_suggestion' => '1',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '60',
'duo' => '0',
'enable_server_password_change' => '0',
'ldap_object_class' => '0',
'bck_script_path' => '\\am.tsacorp.com\fileshares\CorpIT\SFTWREPO\Teampass',
'bck_script_filename' => 'Bck_teampass',
'syslog_enable' => '0',
'syslog_host' => '<removed>'
'syslog_port' => '514',
'manager_move_item' => '1',
'create_item_without_password' => '0',
'otv_is_enabled' => '0',
'agses_authentication_enabled' => '0',
'item_extra_fields' => '1',
'saltkey_ante_2127' => 'none',
'migration_to_2127' => 'done',
'files_with_defuse' => 'done',
'timezone' => 'UTC',
'enable_attachment_encryption' => '1',
'personal_saltkey_security_level' => '50',
'ldap_new_user_is_administrated_by' => '0',
'disable_show_forgot_pwd_link' => '0',
'offline_key_level' => '0',
'enable_http_request_login' => '0',
'ldap_and_local_authentication' => '1',
'ldap_new_user_role' => '',
'ldap_allowed_usergroup' => '',
'can_create_root_folder' => '0',
'tree_counters' => '1',
'bck_script_passkey' => '<removed>'
'copy_to_clipboard_small_icons' => '1',
'teampass_version' => '2.1.27',
'admin_2fa_required' => '0',
'secure_display_image' => '1',
'upload_zero_byte_file' => '0',
'upload_all_extensions_file' => '0',
'password_overview_delay' => '4',
'roles_allowed_to_print_select' => '',
'clipboard_life_duration' => '30',
'mfa_for_roles' => '',
'settings_offline_mode' => '0',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '0',
'email_debug_level' => '0',
'ga_reset_by_user' => '',
'onthefly-backup-key' => '<removed>'
'onthefly-restore-key' => '<removed>'
'ldap_user_dn_attribute' => '',
'ldap_dn_additional_user_dn' => '',
'ldap_user_object_filter' => '',
'ldap_bdn' => '',
'ldap_hosts' => '<removed>'
'ldap_password' => '<removed>'
'ldap_username' => '',
'api_token_duration' => '60',
'enable_tasks_manager' => '0',
'task_maximum_run_time' => '300',
'maximum_number_of_items_to_treat' => '300',
'tasks_manager_refreshing_period' => '100',
'ldap_tls_certifacte_check' => 'LDAP_OPT_X_TLS_NEVER',
'enable_tasks_log' => '0',

Updated from an older Teampass or fresh install:

Client configuration

Browser: -

Operating system: - bits

Logs

Web server error log

 -  ()

Teampass 10 last system errors

 * 17/02/2023 05:54:22 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 17/02/2023 05:50:42 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 06/10/2022 03:03:18 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 25/10/2021 09:05:40 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /Teampass/index.php?page=kb * 24/08/2021 07:43:01 - Query: INSERT INTO `teampass_log_items` (`id_item`,`date`,`id_user`,`action`) VALUES ('', 1629790981, '1', 'at_restored')<br />Error: Incorrect integer value: '' for column 'id_item' at row 1<br />@ /teampass/sources/views.queries.php * 02/12/2020 18:37:15 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 13/07/2020 20:24:37 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 10/07/2020 15:46:11 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 25/11/2019 19:12:02 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
        i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
        l.date as date
    FROM teampass_items as i
    INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
    WHERE i.inactif = 0
    AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
    AND i.id_tree IN ()
    ORDER BY i.label ASC, l.date DESC<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 22/11/2018 05:55:40 - Query: SELECT i.id AS id, MIN(i.restricted_to) AS restricted_to, MIN(i.perso) AS perso,
                        MIN(i.label) AS label, MIN(i.description) AS description, MIN(i.pw) AS pw, MIN(i.login) AS login,
                        MIN(i.anyone_can_modify) AS anyone_can_modify, l.date AS date, i.id_tree AS tree_id,
                        MIN(n.renewal_period) AS renewal_period,
                        MIN(l.action) AS log_action, l.id_user AS log_user
                        FROM teampass_items AS i
                        INNER JOIN teampass_nested_tree AS n ON (i.id_tree = n.id)
                        INNER JOIN teampass_log_items AS l ON (i.id = l.id_item)
                        WHERE (i.id_tree=332) AND (i.inactif=0) AND (l.date=(SELECT date FROM teampass_log_items WHERE action IN ('at_creation', 'at_modification') AND id_item=i.id ORDER BY date DESC LIMIT 1))
                        GROUP BY i.id, l.date, l.id_user, l.action
                        ORDER BY i.label ASC, l.date DESC LIMIT 0,<br />Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11<br />@ /teampass/sources/items.queries.php

Log from the web-browser developer console (CTRL + SHIFT + i)

Insert the log here and especially the answer of the query that failed.

[Nathu2018]

Warning: Illegal offset type in C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Connection.php on line 495

Fatal error: Uncaught ErrorException: ldap_search(): Search: Operations error in C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Ldap.php:235 Stack trace: #0 [internal function]: LdapRecord\Ldap->LdapRecord{closure}(2, 'ldap_search(): ...', 'C:\wamp64\www\T...', 235, Array) #1 C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Ldap.php(235): ldap_search(Resource id #93, 'DC=am,DC=tsacor...', '(&(0=))', Array, false, 0, 0, 0) #2 C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\HandlesConnection.php(171): LdapRecord\Ldap->LdapRecord{closure}() #3 C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Ldap.php(237): LdapRecord\Ldap->executeFailableOperation(Object(Closure)) #4 C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Query\Builder.php(716): LdapRecord\Ldap->search('DC=am,DC=tsacor...', '(&(0=))', Array, false, 0) #5 C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\Connection.php(394): LdapRecord\Query\Builder->LdapRecord\Query{closure}(Object(LdapRecord\Ldap)) #6 C:\wamp64\www\TeamPass\includ in C:\wamp64\www\TeamPass\includes\libraries\LdapRecord\LdapRecordException.php on line 26

[Nathu2018]

When I getting same error for search Items Please help

[Nathu2018]

please help