search

nilsteampassnet / TeamPass

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

Error when trying to update to latest version #3808

Open scorpionukr opened 1 year ago

scorpionukr commented 1 year ago

Steps to reproduce

  1. Clone latest release from GitHub
  2. Copy config files and avatars, files, uploads from old teampass
  3. Applying chmod and chown
  4. Open teampass in browser

Expected behaviour

Updated teampass to latest version

Actual behaviour

Teampass returned an error: "Teampass database is not up to date. Some inconsistencies have been identified between files and configuration, Your administrator should perform upgrade process before you continue."

Server configuration

Operating system: Linux teampass0 5.15.0-1041-azure #48~20.04.1-Ubuntu SMP Wed Jun 21 15:03:04 UTC 2023 x86_64

Web server: Apache/2.4.41 (Ubuntu)

Database: 8.0.32

PHP version: 7.4.33

Teampass version: 2.1.27.36

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' => '/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',
'enable_sts' => '0',
'encryptClientServer' => '1',
'cpassman_version' => '2.1.27',
'ldap_mode' => '1',
'ldap_type' => 'windows',
'ldap_suffix' => '@datasoft.local',
'ldap_domain_dn' => 'dc=datasoft,dc=local',
'ldap_domain_controler' => 'dc3.datasoft.local',
'ldap_user_attribute' => '0',
'ldap_ssl' => '0',
'ldap_tls' => '0',
'ldap_elusers' => '0',
'ldap_search_base' => '0',
'ldap_port' => '389',
'richtext' => '0',
'allow_print' => '0',
'roles_allowed_to_print' => '0',
'show_description' => '1',
'anyone_can_modify' => '0',
'anyone_can_modify_bydefault' => '0',
'nb_bad_authentication' => '5',
'utf8_enabled' => '1',
'restricted_to' => '0',
'restricted_to_roles' => '1',
'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://upload.wikimedia.org/wikipedia/commons/9/91/Devart.png',
'custom_login_text' => '',
'default_language' => 'russian',
'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_2fa;stat_agses;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;',
'send_stats_time' => '1553348176',
'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' => '31',
'email_smtp_server' => 'smtp.office365.com',
'email_smtp_auth' => '1',
'email_auth_username' => 'itservices@devart.com',
'email_auth_pwd' => '<removed>'
'email_port' => '587',
'email_security' => 'tls',
'email_server_url' => '',
'email_from' => 'itservices@devart.com',
'email_from_name' => 'Teampass',
'pwd_maximum_length' => '40',
'google_authentication' => '0',
'delay_item_edition' => '0',
'allow_import' => '0',
'proxy_ip' => '',
'proxy_port' => '',
'upload_maxfilesize' => '10mb',
'upload_docext' => 'xls,xlsx,xltx,rtf,csv,txt,pdf,ppt,pptx,xltx,ppk,json,pem,key,cert,pfx',
'upload_imagesext' => 'jpg,jpeg,gif,png',
'upload_pkgext' => '7z,rar,tar,zip',
'upload_otherext' => 'sql,xml,ovpn',
'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' => '0',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '120',
'duo' => '0',
'enable_server_password_change' => '0',
'ldap_object_class' => '0',
'bck_script_path' => '/var/www/teampass/backups',
'bck_script_filename' => 'bck_teampass',
'syslog_enable' => '0',
'syslog_host' => 'localhost',
'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' => 'Europe/Kiev',
'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' => '0',
'secure_display_image' => '1',
'upload_zero_byte_file' => '0',
'upload_all_extensions_file' => '0',
'bck_script_passkey' => '<removed>'
'admin_2fa_required' => '1',
'enable_massive_move_delete' => '1',

Updated from an older Teampass or fresh install: Update from version 2.1.27.36

Client configuration

Browser: Firefox - 115.0

Operating system: Windows - 64bits

Logs

Web server error log

[Fri Aug 04 15:24:11.981693 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PASSWD - assumed 'DB_PASSWD' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 102
[Fri Aug 04 15:24:11.981722 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_HOST - assumed 'DB_HOST' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 104
[Fri Aug 04 15:24:11.981726 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_USER - assumed 'DB_USER' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 105
[Fri Aug 04 15:24:11.981730 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_NAME - assumed 'DB_NAME' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 107
[Fri Aug 04 15:24:11.981734 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PORT - assumed 'DB_PORT' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 108
[Fri Aug 04 15:24:11.981743 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_ENCODING - assumed 'DB_ENCODING' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 109
[Fri Aug 04 15:24:11.981747 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_SSL - assumed 'DB_SSL' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 110
[Fri Aug 04 15:24:11.981751 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_CONNECT_OPTIONS - assumed 'DB_CONNECT_OPTIONS' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/index.php on line 111
[Fri Aug 04 15:24:11.981798 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PREFIX - assumed 'DB_PREFIX' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/sources/main.functions.php on line 1671
[Fri Aug 04 15:24:11.981838 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'key' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 183
[Fri Aug 04 15:24:11.981843 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'key' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 184
[Fri Aug 04 15:24:11.981846 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'cert' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 184
[Fri Aug 04 15:24:11.981850 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'ca_cert' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 184
[Fri Aug 04 15:24:11.981853 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'ca_path' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 184
[Fri Aug 04 15:24:11.981856 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Illegal string offset 'cipher' in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 184
[Fri Aug 04 15:24:11.981867 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Invalid argument supplied for foreach() in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 187
[Fri Aug 04 15:24:11.981876 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::set_charset(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 198
[Fri Aug 04 15:24:11.981883 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::get(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 200
[Fri Aug 04 15:24:11.981907 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 520
[Fri Aug 04 15:24:11.981913 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 520
[Fri Aug 04 15:24:11.981918 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 682
[Fri Aug 04 15:24:11.981924 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 716
[Fri Aug 04 15:24:11.981931 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 717
[Fri Aug 04 15:24:11.981939 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PREFIX - assumed 'DB_PREFIX' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/sources/main.functions.php on line 1671
[Fri Aug 04 15:24:11.981948 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 682
[Fri Aug 04 15:24:11.981952 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 716
[Fri Aug 04 15:24:11.981955 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 717
[Fri Aug 04 15:24:11.981959 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Invalid argument supplied for foreach() in /var/www/teampass.devart.com/sources/core.php on line 179
[Fri Aug 04 15:24:11.982097 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PREFIX - assumed 'DB_PREFIX' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/sources/main.functions.php on line 1671
[Fri Aug 04 15:24:11.982114 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 682
[Fri Aug 04 15:24:11.982119 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 716
[Fri Aug 04 15:24:11.982122 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 717
[Fri Aug 04 15:24:11.982309 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  Use of undefined constant DB_PREFIX - assumed 'DB_PREFIX' (this will throw an Error in a future version of PHP) in /var/www/teampass.devart.com/sources/main.functions.php on line 1671
[Fri Aug 04 15:24:11.982325 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 520
[Fri Aug 04 15:24:11.982331 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 520
[Fri Aug 04 15:24:11.982335 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 682
[Fri Aug 04 15:24:11.982339 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 716
[Fri Aug 04 15:24:11.982343 2023] [php7:warn] [pid 1141] [client 194.29.62.118:44984] PHP Warning:  MeekroDB::queryHelper(): Property access is not allowed yet in /var/www/teampass.devart.com/includes/libraries/Database/Meekrodb/db.class.php on line 717
ismaelvillalba commented 1 year ago

Hi @scorpionukr Were you able to resolve the issue with the database? I managed to configure everything, but I'm still encountering the same error. I'm uncertain about what needs to be adjusted on the server side.

kikimora52 commented 1 year ago

I just started seeing this as well. I noticed it after I added a rproxy. What did I screw up?

dmartinfhlc commented 2 months ago

Hi all,

The same issue here, upgrading from 3.1.2.45 to 3.1.2.73

When we run upgrade.php manually we have following errors:

PHP Warning: require_once(./libs/SecureHandler.php): Failed to open stream: No such file or directory in /var/www/html/TeamPass/install/upgrade.php on line 44 PHP Fatal error: Uncaught Error: Failed opening required './libs/SecureHandler.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/TeamPass/install/upgrade.php:44 Stack trace:

0 {main}

thrown in /var/www/html/TeamPass/install/upgrade.php on line 44

If we comment line 44 and launch again:

PHP Fatal error: Uncaught Error: Undefined constant "MIN_PHP_VERSION" in /var/www/html/TeamPass/install/upgrade.php:85 Stack trace:

0 {main}

thrown in /var/www/html/TeamPass/install/upgrade.php on line 85

then upgrade page is shown, but START button not working

MarcoStagno commented 3 weeks ago

Same issue, upgrading from 3.1.2.45 to 3.1.2.141 I changed the path in /var/www/html/TeamPass/install/upgrade.phpon line 44 to /var/www/TeamPass/vendor/ezimuel/php-secure-session/src/SecureHandler.php ; there are no more errors but the but START button doesn't work