deanbruhn
commented
1 week ago
### Steps to reproduce
1. Upload and run update through web console, no errors appear.
2. After initial upgrade all data will be there.
3. Wait one day so overnight tasks can run
4. Items will no longer be accessible in TeamPass.
5. The items still appear in the database on my test system.
6. I have the item counts enabled on the directories and the counts still reflect the missing items.
### Expected behaviour
Tell us what should happen
The Items should still be in the system and accessible.
### Actual behaviour
Tell us what happens instead
They are no longer in the UI
### Server configuration
**Operating system**:
Debian 11.7
**Web server:**
Server version: Apache/2.4.56 (Debian)
Server built: 2023-04-02T03:06:01
**Database:**
mariadb Ver 15.1 Distrib 10.7.8-MariaDB, for debian-linux-gnu (x86_64) using readline EditLine wrapper
**PHP version:**
PHP 8.2.14 (cli) (built: Dec 21 2023 20:18:00) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.14, Copyright (c) Zend Technologies
with Zend OPcache v8.2.14, Copyright (c), by Zend Technologies
**Teampass version:**
Original - 3.1.1.60
Upgraded - 3.1.2.45
**Teampass configuration file:**
'10',
'enable_favourites' => '1',
'show_last_items' => '1',
'enable_pf_feature' => '1',
'log_connections' => '0',
'log_accessed' => '1',
'time_format' => 'H:i:s',
'date_format' => 'm/d/Y',
'duplicate_folder' => '1',
'item_duplicate_in_same_folder' => '1',
'duplicate_item' => '1',
'number_of_used_pw' => '6',
'manager_edit' => '1',
'cpassman_dir' => '/var/www/html',
'cpassman_url' => 'https:///',
'favicon' => 'https:///index.php/s/yFEYxP8gXeLfFCs/download/favicon.ico',
'path_to_upload_folder' => '/var/www/html/upload',
'url_to_upload_folder' => 'https:///upload',
'path_to_files_folder' => '/var/www/html/files',
'url_to_files_folder' => 'https:///files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'enable_sts' => '0',
'encryptClientServer' => '1',
'cpassman_version' => '2.1.27',
'ldap_mode' => '0',
'ldap_type' => '0',
'ldap_suffix' => '0',
'ldap_domain_dn' => '0',
'ldap_domain_controler' => '0',
'ldap_user_attribute' => '0',
'ldap_ssl' => '0',
'ldap_tls' => '0',
'richtext' => '0',
'allow_print' => '1',
'roles_allowed_to_print' => '["["["["["1","2"]"]"]"]"]',
'show_description' => '1',
'anyone_can_modify' => '0',
'anyone_can_modify_bydefault' => '0',
'nb_bad_authentication' => '0',
'utf8_enabled' => '1',
'restricted_to' => '0',
'restricted_to_roles' => '0',
'enable_send_email_on_user_login' => '0',
'enable_user_can_create_folders' => '1',
'insert_manual_entry_item_history' => '0',
'enable_kb' => '0',
'enable_email_notification_on_item_shown' => '0',
'enable_email_notification_on_user_pw_change' => '0',
'custom_logo' => 'https:///index.php/s/K6xY9KgRcS7KpwM/download/Nested%20C%20600x600.png',
'custom_login_text' => '',
'default_language' => 'english',
'send_stats' => '1',
'get_tp_info' => '1',
'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' => '0',
'email_smtp_server' => 'smtp.office365.com',
'email_smtp_auth' => '1',
'email_auth_username' => '',
'email_auth_pwd' => '',
'email_port' => '587',
'email_security' => 'tls',
'email_server_url' => 'https://',
'email_from' => '',
'email_from_name' => '',
'pwd_maximum_length' => '40',
'delay_item_edition' => '1',
'allow_import' => '0',
'proxy_ip' => '',
'proxy_port' => '',
'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',
'use_md5_password_as_salt' => '0',
'ga_website_name' => '',
'api' => '0',
'subfolder_rights_as_parent' => '1',
'show_only_accessible_folders' => '0',
'enable_suggestion' => '1',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '500',
'duo' => '0',
'send_stats_time' => '0',
'tree_counters' => '1',
'item_extra_fields' => '0',
'enable_attachment_encryption' => '1',
'copy_to_clipboard_small_icons' => '1',
'settings_offline_mode' => '0',
'offline_key_level' => '0',
'bck_script_filename' => 'bck_cpassman',
'bck_script_path' => '/var/www/html//backups',
'can_create_root_folder' => '0',
'encryption_protocol' => 'ctr',
'menu_type' => 'context',
'google_authentication' => '1',
'enable_server_password_change' => '0',
'syslog_enable' => '0',
'syslog_host' => 'localhost',
'syslog_port' => '514',
'saltkey_ante_2127' => '13',
'teampass_version' => '3.1.2',
'migration_to_2127' => 'done',
'manager_move_item' => '0',
'create_item_without_password' => '0',
'agses_authentication_enabled' => '0',
'timezone' => 'America/Chicago',
'personal_saltkey_security_level' => '0',
'ldap_new_user_is_administrated_by' => '0',
'ldap_port' => '389',
'enable_http_request_login' => '0',
'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',
'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_2fa;stat_agses;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;',
'admin_2fa_required' => '0',
'password_overview_delay' => '10',
'roles_allowed_to_print_select' => '',
'clipboard_life_duration' => '0',
'mfa_for_roles' => '',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '0',
'email_debug_level' => '0',
'ga_reset_by_user' => '1',
'onthefly-backup-key' => '',
'onthefly-restore-key' => '',
'ldap_user_dn_attribute' => '',
'ldap_dn_additional_user_dn' => '',
'ldap_user_object_filter' => '',
'ldap_bdn' => '',
'ldap_hosts' => '',
'ldap_password' => '',
'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_users_with_ad_groups' => '0',
'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' => '5',
'reload_cache_table_task' => 'hourly;04:00',
'rebuild_config_file' => '',
'purge_temporary_files_task' => 'daily;14:00',
'clean_orphan_objects_task' => 'daily;01:00',
'users_personal_folder_task' => 'hourly;17:00',
'maximum_session_expiration_time' => '60',
'items_ops_job_frequency' => '1',
'upgrade_timestamp' => '1718907872',
'enable_refresh_task_last_execution' => '1',
'ldap_group_objectclasses_attibute' => 'top,groupofuniquenames',
'max_last_items' => '20',
'rebuild_config_file_task' => 'daily;03:00',
'pwd_default_length' => '16',
'tasks_log_retention_delay' => '3650',
'oauth2_enabled' => '0',
'oauth2_client_appname' => 'Login with Azure',
'oauth2_client_scopes' => 'openid,profile,email',
);
**Updated from an older Teampass or fresh install:**
PLEASE attach to this issue the file `/includes/config/tp.config.php`.
### Client configuration
**Browser:**
Safari
Firefox
**Operating system:**
macOS Sonoma 14.5
Debian 12.5
### Logs
#### Web server error log
[Thu Jun 20 12:55:15.213479 2024] [mpm_prefork:notice] [pid 582] AH00163: Apache/2.4.56 (Debian) OpenSSL/1.1.1w configured -- resuming normal operations
[Thu Jun 20 12:55:15.213562 2024] [core:notice] [pid 582] AH00094: Command line: '/usr/sbin/apache2'
[Thu Jun 20 13:23:33.515139 2024] [proxy_fcgi:error] [pid 615] [client 10.10.200.12:51667] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92'
[Thu Jun 20 13:23:45.562653 2024] [proxy_fcgi:error] [pid 616] [client 10.10.200.12:51675] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92', referer: https:///install/upgrade.php
[Thu Jun 20 13:23:50.281598 2024] [proxy_fcgi:error] [pid 616] [client 10.10.200.12:51675] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92', referer: https:///install/upgrade.php
[Thu Jun 20 13:23:59.195224 2024] [proxy_fcgi:error] [pid 613] [client 10.10.200.12:51676] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92', referer: https:///install/upgrade.php
[Thu Jun 20 13:24:59.652044 2024] [proxy_fcgi:error] [pid 614] [client 10.10.200.12:51687] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92', referer: https:///install/upgrade.php
[Thu Jun 20 13:25:03.682809 2024] [proxy_fcgi:error] [pid 614] [client 10.10.200.12:51687] AH01071: Got error 'PHP message: PHP Warning: Constant SECUREPATH already defined in /var/www/html/install/upgrade.php on line 92', referer: https:///install/upgrade.php
[Fri Jun 21 00:00:02.037852 2024] [mpm_prefork:notice] [pid 582] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
Insert your webserver log here
```
#### Log from the web-browser developer console (CTRL + SHIFT + i)
All web consol logs are showing are 200 OK
Insert the log here and especially the answer of the query that failed.
```