search

nilsteampassnet / TeamPass

Collaborative Passwords Manager
https://www.teampass.net
1.65k stars 539 forks source link

Not able see Users and Ldap not working #4331

Open Nathu2018 opened 3 days ago

Nathu2018 commented 3 days ago
### Steps to reproduce 1. 2. 3. ### Expected behaviour Tell us what should happen ### Actual behaviour Tell us what happens instead ### Server configuration **Operating system**: **Web server:** **Database:** **PHP version:** **Teampass version:** **Teampass configuration file:** **Updated from an older Teampass or fresh install:** PLEASE attach to this issue the file `/includes/config/tp.config.php`. ### Client configuration **Browser:** **Operating system:** ### Logs #### Web server error log ``` Insert your webserver log here ``` #### Log from the web-browser developer console (CTRL + SHIFT + i) ``` Insert the log here and especially the answer of the query that failed. ```
Nathu2018 commented 3 days ago

Page on which it happened

Steps to reproduce

1. 2. 3.

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' => '1',
'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' => 'samaccountname',
'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/ACI_logo.png',
'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' => '0',
'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' => '16',
'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' => 'distinguishedname',
'ldap_dn_additional_user_dn' => '',
'ldap_user_object_filter' => '',
'ldap_bdn' => 'OU=TeamPass,OU=UserAccounts,DC=am,DC=tsacorp,DC=com',
'ldap_hosts' => '<removed>'
'ldap_password' => '<removed>'
'ldap_username' => 'CN=svc_vcenter,OU=Service Accounts,DC=am,DC=tsacorp,DC=com',
'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 commented 3 days ago

Screenshot 2024-09-17 171237

Nathu2018 commented 3 days ago

Not able see users as well Ldap not working

JanuszU commented 1 day ago

seams like the same as #4177 & #4217