search

nilsteampassnet / TeamPass

Collaborative Passwords Manager
https://www.teampass.net
1.67k stars 546 forks source link

Some passwords are lost after updating #4307

Open michaelSoluris opened 1 month ago

michaelSoluris commented 1 month ago

Page on which it happened

This issue occurred following the upgrade from Teampass v2.1.26 to v3.0.10 (following the documentation and going through the intermediate versions);

Some passwords are no longer visible in the web interface. However, these passwords are still present in the database (table teampass_items).

For example, the password labeled "ciril (Linux)" is one such case.

Screen tempass v2.1.26 (before update) : image

Screen temapss v3.0.10 (after update) : image

BDD : +------+---------------+------------------------------------------------------------+--------------------------+------+---------+-------+-------+---------+---------------+-------------------+-------+--------------+-----------+------------------+-------+--------+---------------------------+---------------------------+-----------------+---------+----------------------------------------------------+------------+------------+------------+ | id | label | description | pw | url | id_tree | perso | login | inactif | restricted_to | anyone_can_modify | email | notification | viewed_no | complexity_level | pw_iv | pw_len | auto_update_pwd_frequency | auto_update_pwd_next_date | encryption_type | fa_icon | item_key | created_at | updated_at | deleted_at | +------+---------------+------------------------------------------------------------+--------------------------+------+---------+-------+-------+---------+---------------+-------------------+-------+--------------+-----------+------------------+-------+--------+---------------------------+---------------------------+-----------------+---------+----------------------------------------------------+------------+------------+------------+ | 3085 | ciril (Linux) | Utilisateur permettant de se connecter via Putty ou Winscp | XXXXXXXXXXXXXXXXXXXXXX== | | 1009 | 0 | ciril | 0 | | 1 | | NULL | 296 | 38 | | 0 | 0 | 0 | teampass_aes | NULL | c25087f27279e9b0db81704b1b2aa869c0ffb5f94eddba33a3 | 1511857587 | 1524038375 | NULL | +------+---------------+------------------------------------------------------------+--------------------------+------+---------+-------+-------+---------+---------------+-------------------+-------+--------------+-----------+------------------+-------+--------+---------------------------+---------------------------+-----------------+---------+----------------------------------------------------+------------+------------+------------+

Server configuration

Operating system: Linux teampass 6.1.0-23-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.99-1 (2024-07-15) x86_64

Web server: Apache

Database: 5.5.5-10.11.6-MariaDB-0+deb12u1

PHP version: 7.4.33

Teampass version: 3.0.10

Teampass configuration file:

'max_latest_items' => '10',
'enable_favourites' => '1',
'show_last_items' => '1',
'enable_pf_feature' => '1',
'log_connections' => '1',
'log_accessed' => '0',
'time_format' => 'H:i:s',
'date_format' => 'd-M-Y',
'duplicate_folder' => '1',
'duplicate_item' => '1',
'number_of_used_pw' => '3',
'manager_edit' => '1',
'cpassman_dir' => '/var/www/teampass',
'cpassman_url' => 'https://<anonym_url>
'favicon' => 'https://<anonym_url>/favicon.ico',
'path_to_upload_folder' => '/var/www/teampass/upload',
'url_to_upload_folder' => 'https://<anonym_url>/upload',
'path_to_files_folder' => '/var/www/teampass/files',
'url_to_files_folder' => 'https://<anonym_url>/files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'cpassman_version' => '2.1.27',
'ldap_mode' => '0',
'richtext' => '0',
'allow_print' => '1',
'show_description' => '1',
'anyone_can_modify' => '1',
'nb_bad_authentication' => '3',
'utf8_enabled' => '1',
'restricted_to' => '0',
'restricted_to_roles' => '0',
'custom_logo' => '',
'custom_login_text' => 'Bienvenue dans le gestionnaire de mots de passe de SOLURIS',
'default_language' => 'french',
'send_stats' => '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' => '31',
'email_smtp_server' => '<removed>'
'email_smtp_auth' => 'false',
'email_auth_username' => '<removed>'
'email_auth_pwd' => '<removed>'
'email_port' => '25',
'email_from' => '<removed>'
'email_from' => '<removed>'
'pwd_maximum_length' => '40',
'delay_item_edition' => '0',
'send_stats_time' => '0',
'ldap_suffix' => '@dc=si17,dc=lan',
'ldap_domain_dn' => 'ou=Users,dc=si17,dc=lan',
'ldap_domain_controler' => '192.168.32.202',
'ldap_ssl' => '0',
'ldap_tls' => '0',
'enable_kb' => '0',
'copy_to_clipboard_small_icons' => '1',
'enable_user_can_create_folders' => '0',
'enable_send_email_on_user_login' => '0',
'enable_email_notification_on_item_shown' => '0',
'insert_manual_entry_item_history' => '0',
'timezone' => 'Europe/Paris',
'menu_type' => 'context',
'item_duplicate_in_same_folder' => '0',
'ldap_type' => '0',
'ldap_user_attribute' => '0',
'enable_ad_users_with_ad_groups' => '0',
'roles_allowed_to_print' => '0',
'anyone_can_modify_bydefault' => '0',
'get_tp_info' => '1',
'ga_website_name' => 'TeamPass for ChangeMe',
'email_security' => '',
'allow_import' => '0',
'proxy_port' => '0',
'upload_maxfilesize' => '10mb',
'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',
'enable_email_notification_on_user_pw_change' => '0',
'enable_sts' => '0',
'encryptClientServer' => '1',
'use_md5_password_as_salt' => '0',
'api' => '0',
'subfolder_rights_as_parent' => '0',
'show_only_accessible_folders' => '0',
'enable_suggestion' => '0',
'email_server_url' => '',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '600',
'duo' => '0',
'google_authentication' => '0',
'enable_server_password_change' => '0',
'bck_script_path' => '/backups',
'bck_script_filename' => 'bck_cpassman',
'syslog_enable' => '0',
'syslog_host' => '<removed>'
'syslog_port' => '514',
'ldap_object_class' => '0',
'saltkey_ante_2127' => '6dKGXx0myKzV6IzBKA0c8EHy',
'teampass_version' => '3.0.10',
'migration_to_2127' => 'done',
'manager_move_item' => '0',
'create_item_without_password' => '0',
'send_statistics_items' => 'stat_country;stat_users;stat_items;stat_items_shared;stat_folders;stat_folders_shared;stat_admins;st',
'agses_authentication_enabled' => '0',
'personal_saltkey_security_level' => '0',
'item_extra_fields' => '0',
'ldap_new_user_is_administrated_by' => '0',
'ldap_port' => '389',
'offline_key_level' => '0',
'enable_http_request_login' => '0',
'admin_2fa_required' => '1',
'otv_is_enabled' => '0',
'ldap_and_local_authentication' => '0',
'secure_display_image' => '1',
'upload_zero_byte_file' => '0',
'upload_all_extensions_file' => '0',
'files_with_defuse' => 'done',
'password_overview_delay' => '20',
'roles_allowed_to_print_select' => '[1,7]',
'clipboard_life_duration' => '30',
'mfa_for_roles' => '',
'tree_counters' => '0',
'settings_offline_mode' => '0',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '0',
'email_debug_level' => '3',
'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' => '1',
'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' => '1',
'enable_ad_user_auto_creation' => '0',
'ldap_group_object_filter' => '',
'ldap_guid_attibute' => 'objectguid',
'sending_emails_job_frequency' => '1',
'user_keys_job_frequency' => '1',
'items_statistics_job_frequency' => '11',
'reload_cache_table_task' => '',
'rebuild_config_file' => '',
'purge_temporary_files_task' => '',
'clean_orphan_objects_task' => '',
'users_personal_folder_task' => '',
'maximum_session_expiration_time' => '600',
'items_ops_job_frequency' => '2',
'upgrade_timestamp' => '1723046750',

Updated from an older Teampass or fresh install:

Client configuration

Browser: -

Operating system: - bits

Logs

Web server error log

no error

Teampass 10 last system errors

no error

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

no error
deanbruhn commented 1 month ago

I wonder if you're having a similar issue to what I was having. Here is my ticket on how I resolved it.

https://github.com/nilsteampassnet/TeamPass/issues/4229

michaelSoluris commented 1 month ago

I wonder if you're having a similar issue to what I was having. Here is my ticket on how I resolved it.

4229

Can you try this :

SET @increment_start = 9000000; INSERT INTO teampass_log_items (id_item, date, id_user, action, raison, old_value, increment_id, encryption_type) SELECT t.id, '1357923056', 3, 'at_creation', '', NULL, @increment_start := @increment_start + 1, 'not_set' FROM teampass_items t WHERE t.inactif = 0 AND NOT EXISTS ( SELECT 1 FROM teampass_log_items l WHERE l.id_item = t.id AND l.action = 'at_creation' );