Unable to log in after upgrading to development/19f93d6 (encrypted database password in settings.php)

[wirerydr]

Steps to reproduce

1. Start from a working 2.1.27 commit prior to this one (e.g. development/cdf1327).
2. Install development/19f93d6, and follow upgrade instructions at https://teampass.readthedocs.io/en/latest/install/upgrade/
3. After upgrade completes successfully, observe that the password in settings.php has changed to a (much-longer) encrypted form.
4. Clear browser, and restart httpd
5. Attempt login to any ID (including administrator).

Note: This also happens on a fresh install of development/19f93d6, with a fresh database.

Expected behaviour

Successful login

Actual behaviour

The rotating gear appears beside "Please Identify Yourself", and then nothing else. If ENTER is clicked several times in succession then it warns about invalid login and instructs to wait 10 sec. The gear continues to rotate indefinitely, but no meaningful errors/warnings are emitted to the apache logs.

Server configuration

Operating system: Fedora 26 (x86_64)

Web server: Apache 2.4.27

Database: MariaDB 10.1.25

PHP version: 7.1.7

Teampass version: development/19f93d6

Teampass configuration file:

**Upgraded from development/cdf1327

<?php
global $SETTINGS;
$SETTINGS = array (
    'max_latest_items' => '10',
    'enable_favourites' => '1',
    'show_last_items' => '1',
    'enable_pf_feature' => '0',
    'log_connections' => '0',
    'log_accessed' => '1',
    'time_format' => 'H:i:s',
    'date_format' => 'Y-m-d',
    'duplicate_folder' => '0',
    'item_duplicate_in_same_folder' => '0',
    'duplicate_item' => '0',
    'number_of_used_pw' => '0',
    'manager_edit' => '1',
    'cpassman_dir' => '/opt/teampass/teampass-current',
    'cpassman_url' => 'https://www.example.com/tp',
    'favicon' => 'https://www.example.com/tp/favicon.ico',
    'path_to_upload_folder' => '/opt/teampass/teampass-current/upload',
    'url_to_upload_folder' => 'https://www.example.com/tp/upload',
    'path_to_files_folder' => '/opt/teampass/teampass-current/files',
    'url_to_files_folder' => 'https://www.example.com/tp/files',
    'activate_expiration' => '0',
    'pw_life_duration' => '0',
    'maintenance_mode' => '0',
    'enable_sts' => '1',
    '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',
    'ldap_elusers' => '0',
    'ldap_search_base' => '0',
    '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' => '0',
    'utf8_enabled' => '1',
    'restricted_to' => '0',
    'restricted_to_roles' => '0',
    'enable_send_email_on_user_login' => '0',
    'enable_user_can_create_folders' => '0',
    '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' => '',
    'custom_login_text' => '',
    'default_language' => 'english',
    'send_stats' => '0',
    'send_statistics_items' => '',
    'send_stats_time' => '1495172060',
    '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' => '',
    'email_smtp_auth' => '',
    'email_auth_username' => '',
    'email_auth_pwd' => '',
    'email_port' => '',
    'email_security' => '',
    'email_server_url' => '',
    'email_from' => '',
    'email_from_name' => '',
    'pwd_maximum_length' => '40',
    'google_authentication' => '0',
    'delay_item_edition' => '0',
    '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' => 'TeamPass for ChangeMe',
    'api' => '0',
    'subfolder_rights_as_parent' => '0',
    'show_only_accessible_folders' => '0',
    'enable_suggestion' => '0',
    'otv_expiration_period' => '7',
    'default_session_expiration_time' => '60',
    'duo' => '0',
    'enable_server_password_change' => '0',
    'ldap_object_class' => '0',
    'bck_script_path' => '/opt/teampass/teampass-current/backups',
    'bck_script_filename' => 'bck_teampass',
    'syslog_enable' => '1',
    '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' => '1',
    'saltkey_ante_2127' => 'none',
    'migration_to_2127' => 'done',
    'timezone' => 'America/Toronto',
    'can_create_root_folder' => '1',
    'menu_type' => 'context',
    'teampass_version' => '2.1.27',
    'syslog_enable' => '1',
    'syslog_host' => 'localhost',
    'syslog_port' => '514',
    'syslog_enable' => '1',
    'syslog_host' => 'localhost',
    'syslog_port' => '514',
    'syslog_enable' => '1',
    'syslog_host' => 'localhost',
    'syslog_port' => '514'
);

Client configuration

**Browser: Firefox 54.0.1 (64-bit)

Operating system: Windows 10

Logs

Web server error log

No meaningful errors/warnings emitted. The following line is the only line emitted after ENTER is clicked:

192.168.240.120 - - [08/Aug/2017:01:17:42 -0400] "POST /tp/sources/identify.php HTTP/1.1" 500 - "https://www.example.com/tp/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:54.0) Gecko/20100101 Firefox/54.0"

Firebug log (How to?)

Link dead - if desired then please provide quick instructions

[nilsteampassnet]

What happens if you take the latest from yesterday?

[wirerydr]

Actually, I was originally trying to test commit 922455c when I started having problems. I then backtracked through the commits on development until I hit one that worked. The last one that worked was the one I was already upgrading from: cdf1327.

However upgrading directly from cdf1327 to 922455c throws a different error - different enough that I suspect it is unrelated to this bug report. I have opened it up as separate issue #1856.

I cannot tell if that latest commit fixes the issue described here because the upgrade process doesn't actually complete against the latest commit.

[wirerydr]

With your permission I'm going to close this issue. I've been able to successfully upgrade from release 2.1.27.7 to 2.1.27.8, and therefore it probably doesn't make much sense anymore to track upgrading from one development commit to another. I'm pretty confident that somewhere along the way this issue got addressed.