Closed Esware80 closed 1 year ago
After a clean installation, some errors are displayed when a user is deleted
1.New Teampass Installation 2.Create User 3.Delete User
Once a user is deleted the site don´t display any information about user is deleted. An error 500 is displayed in Browser debug mode.
[Tue Jan 17 15:47:13.354488 2023] [php:error] [pid 2748] [client 10.140.48.70:55343] PHP Fatal error: Uncaught mysqli_sql_exception: FUNCTION teampassdb.JSON_EXTRACT does not exist in /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php:682\nStack trace:\n#0 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(682): mysqli->query()\n#1 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(637): MeekroDB->queryHelper()\n#2 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(638): MeekroDB->prependCall()\n#3 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(65): MeekroDB->query()\n#4 /var/www/TeamPass.3.0.0.20/sources/users.queries.php(438): DB::query()\n#5 {main}\n thrown in /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php on line 682, referer: https://teampass.mydomain.com/index.php?page=users
Operating system: Linux myserver. 3.10.0-1160.81.1.el7.x86_64 #1 SMP Fri Dec 16 17:29:43 UTC 2022 x86_64
Web server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/8.2.1
Database: 5.5.68-MariaDB
PHP version: 8.2.1
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' => '0', 'item_duplicate_in_same_folder' => '0', 'duplicate_item' => '0', '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/opt/TeamPass/upload', 'path_to_files_folder' => '/var/opt/TeamPass/files', 'url_to_files_folder' => 'http://teampass.mydomain.com/files', 'activate_expiration' => '0', 'pw_life_duration' => '0', 'maintenance_mode' => '0', 'enable_sts' => '1', 'encryptClientServer' => '1', 'cpassman_version' => '3.0.0.22', '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', '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' => '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' => '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' => '1670077119', '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' => '<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' => '40', 'google_authentication' => '0', 'delay_item_edition' => '0', 'allow_import' => '0', 'proxy_ip' => '<removed>' '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' => '1', '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' => '/var/www/TeamPass/backups', 'bck_script_filename' => 'bck_teampass', 'syslog_enable' => '0', 'syslog_host' => '<removed>' 'syslog_port' => '514', 'manager_move_item' => '0', 'create_item_without_password' => '1', '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/Madrid', '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', 'password_overview_delay' => '4', 'copy_to_clipboard_small_icons' => '1', 'duo_ikey' => '<removed>' 'duo_skey' => '<removed>' 'duo_host' => '<removed>' 'duo_failmode' => 'secure', 'teampass_version' => '', 'roles_allowed_to_print_select' => '', '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' => '0', 'task_maximum_run_time' => '300', 'tasks_manager_refreshing_period' => '20', 'maximum_number_of_items_to_treat' => '100', 'ldap_tls_certifacte_check' => 'LDAP_OPT_X_TLS_NEVER',
Updated from an older Teampass or fresh install:
Browser: -
Operating system: - bits
Constant FILTER_SANITIZE_STRING is deprecated - /var/www/TeamPass.3.0.0.20/sources/main.queries.php (119)
Insert the log here and especially the answer of the query that failed.
Error caused by mysql version. Some functions are not available in old versions.
Updated to MariaDB Ver 15.1 Distrib 10.8.6-MariaDB and works fine.
After a clean installation, some errors are displayed when a user is deleted
Steps to reproduce
1.New Teampass Installation 2.Create User 3.Delete User
Expected behaviour
Actual behaviour
Once a user is deleted the site don´t display any information about user is deleted. An error 500 is displayed in Browser debug mode.
Apache error log
[Tue Jan 17 15:47:13.354488 2023] [php:error] [pid 2748] [client 10.140.48.70:55343] PHP Fatal error: Uncaught mysqli_sql_exception: FUNCTION teampassdb.JSON_EXTRACT does not exist in /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php:682\nStack trace:\n#0 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(682): mysqli->query()\n#1 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(637): MeekroDB->queryHelper()\n#2 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(638): MeekroDB->prependCall()\n#3 /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php(65): MeekroDB->query()\n#4 /var/www/TeamPass.3.0.0.20/sources/users.queries.php(438): DB::query()\n#5 {main}\n thrown in /var/www/TeamPass.3.0.0.20/includes/libraries/Database/Meekrodb/db.class.php on line 682, referer: https://teampass.mydomain.com/index.php?page=users
Server configuration
Page on which it happened
Server configuration
Operating system: Linux myserver. 3.10.0-1160.81.1.el7.x86_64 #1 SMP Fri Dec 16 17:29:43 UTC 2022 x86_64
Web server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/8.2.1
Database: 5.5.68-MariaDB
PHP version: 8.2.1
Teampass version: 3.0.0.22
Teampass configuration file:
Updated from an older Teampass or fresh install:
Client configuration
Browser: -
Operating system: - bits
Logs
Web server error log
Teampass 10 last system errors
Log from the web-browser developer console (CTRL + SHIFT + i)