Error Import from CSV

[bdelgadilloh]

Page on which it happened

Import

Steps to reproduce

1. Select option CSV
2. Upload CSV File
3. Push Perform Button

Expected behaviour

Import CSV saved passwords

Actual behaviour

Is an error with import.queries.php

Server configuration

Operating system: Linux vault 4.18.0-553.5.1.el8_10.x86_64 #1 SMP Wed Jun 5 09:12:13 EDT 2024 x86_64

Web server: Bare Metal mod_wsgi/4.9.4 Python/3.11

Database: 8.0.37

PHP version: 8.1.28

Teampass version: 3.1.0

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' => '1',
'duplicate_item' => '1',
'number_of_used_pw' => '3',
'manager_edit' => '1',
'cpassman_dir' => '/var/www/html/TeamPass',
'cpassman_url' => 'https://<anonym_url>
'favicon' => 'https://<anonym_url>/favicon.ico',
'path_to_upload_folder' => '/var/www/html/TeamPass/upload',
'path_to_files_folder' => '/var/www/html/TeamPass/files',
'url_to_files_folder' => 'https://<anonym_url>/files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'enable_sts' => '1',
'encryptClientServer' => '1',
'cpassman_version' => '3.0.0.20',
'ldap_mode' => '1',
'ldap_type' => 'ActiveDirectory',
'ldap_suffix' => '0',
'ldap_domain_dn' => '0',
'ldap_domain_controler' => '0',
'ldap_user_attribute' => 'samaccountname',
'ldap_ssl' => '0',
'ldap_tls' => '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' => '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://<anonym_url>/files/logo_choucair.png ',
'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' => '1665345303',
'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' => '1',
'email_auth_username' => '<removed>'
'email_auth_pwd' => '<removed>'
'email_port' => '587',
'email_security' => 'tls',
'email_server_url' => 'https://<anonym_url>',
'email_from' => '<removed>'
'email_from' => '<removed>'
'pwd_maximum_length' => '150',
'google_authentication' => '1',
'delay_item_edition' => '0',
'allow_import' => '1',
'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' => 'Bóveda de Contraseñas Choucair',
'api' => '0',
'subfolder_rights_as_parent' => '1',
'show_only_accessible_folders' => '1',
'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/html/TeamPass/backups',
'bck_script_filename' => 'bck_teampass',
'syslog_enable' => '0',
'syslog_host' => '<removed>'
'syslog_port' => '514',
'manager_move_item' => '0',
'create_item_without_password' => '0',
'otv_is_enabled' => '1',
'agses_authentication_enabled' => '0',
'item_extra_fields' => '0',
'saltkey_ante_2127' => 'none',
'migration_to_2127' => 'done',
'files_with_defuse' => 'done',
'timezone' => 'America/Bogota',
'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' => '1',
'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' => '3.1.0',
'roles_allowed_to_print_select' => '',
'clipboard_life_duration' => '15',
'mfa_for_roles' => '',
'tree_counters' => '1',
'settings_offline_mode' => '0',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '1',
'email_debug_level' => '0',
'ga_reset_by_user' => '0',
'onthefly-backup-key' => '<removed>'
'onthefly-restore-key' => '<removed>'
'ldap_user_dn_attribute' => 'distinguishedname',
'ldap_dn_additional_user_dn' => 'ou=Usuarios Choucair',
'ldap_user_object_filter' => '(sAMAccountName=*)',
'ldap_bdn' => 'dc=corp,dc=choucairtesting,dc=local',
'ldap_hosts' => '<removed>'
'ldap_password' => '<removed>'
'ldap_username' => 'cn=AuthLdap,ou=Gestion,ou=Colombia,ou=Usuarios Choucair,dc=corp,dc=choucairtesting,dc=local',
'api_token_duration' => '60',
'enable_tasks_manager' => '1',
'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_TRY',
'ldap_new_user_role' => '1',
'enable_tasks_log' => '0',
'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' => '2',
'user_keys_job_frequency' => '1',
'items_statistics_job_frequency' => '5',
'reload_cache_table_task' => 'daily;03:00',
'rebuild_config_file' => '',
'purge_temporary_files_task' => 'daily;02:00',
'clean_orphan_objects_task' => 'daily;01:00',
'users_personal_folder_task' => '',
'upgrade_timestamp' => '1714774461',
'maximum_session_expiration_time' => '60',
'items_ops_job_frequency' => '1',
'enable_refresh_task_last_execution' => '1',

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)

Insert the log here and especially the answer of the query that failed.

import.queries.php

### Header
URL De La Solicitud:
https://teampass.choucairtesting.com/sources/import.queries.php
Método De Solicitud:
POST
Código De Estado:
500 Internal Server Error
Dirección Remota:
201.234.190.155:443
Directiva De Sitio De Referencia:
strict-origin
Cache-Control:
max-age=84600, public
Connection:
close
Content-Length:
0
Content-Security-Policy:
default-src https://cdn.jsdelivr.net https://cdnjs.cloudflare.com https://cdn.datatables.net https://code.jquery.com 'self' 'unsafe-inline' 'unsafe-eval' data: blob:; frame-ancestors 'self'; form-action 'self', style-src https://cdn.jsdelivr.net https://cdnjs.cloudflare.com https://cdn.datatables.net 'self' 'strict-dynamic' 'unsafe-inline'
Content-Type:
text/html; charset=utf-8
Cross-Origin-Embedder-Policy:
*
Cross-Origin-Opener-Policy:
same-origin
Cross-Origin-Resource-Policy:
same-origin
Date:
Wed, 10 Jul 2024 16:37:36 GMT
Expires:
Thu, 19 Nov 1981 08:52:00 GMT
Permissions-Policy:
geolocation=(self),midi=(self),sync-xhr=(self),microphone=(self),camera=(self),magnetometer=(self),gyroscope=(self),fullscreen=(self),payment=(self)
Pragma:
no-cache
Referrer-Policy:
strict-origin
Server:
Bare Metal mod_wsgi/4.9.4 Python/3.11
Strict-Transport-Security:
max-age=31536000; includeSubDomains; preload
X-Content-Type-Options:
nosniff
X-Frame-Options:
SAMEORIGIN
X-Permitted-Cross-Domain-Policies:
none
X-Xss-Protection:
1; mode=block
Accept:
*/*
Accept-Encoding:
gzip, deflate, br, zstd
Accept-Language:
es,es-ES;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6,es-419;q=0.5,es-CO;q=0.4
Connection:
keep-alive
Content-Length:
17772
Content-Type:
application/x-www-form-urlencoded; charset=UTF-8
Cookie:
jstree_select=794; teampass_session=6s1cis0a9skfq520t26di83pjp; 850d26a54322ccfb0933bdc2ac96759fe5c5bb43729cba895a=a2a357c9751cb778aea6131e61e53bfa65e20b78b01270dcf7
Host:
teampass.choucairtesting.com
Origin:
https://teampass.choucairtesting.com
Referer:
https://teampass.choucairtesting.com/
Sec-Ch-Ua:
"Not/A)Brand";v="8", "Chromium";v="126", "Microsoft Edge";v="126"
Sec-Ch-Ua-Mobile:
?0
Sec-Ch-Ua-Platform:
"Windows"
Sec-Fetch-Dest:
empty
Sec-Fetch-Mode:
cors
Sec-Fetch-Site:
same-origin
User-Agent:
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0
X-Requested-With:
XMLHttpRequest

Payload

type=import_items&data=eyJjaXBoZXJ0ZXh0IjoiQThoR1R6b2I5a3U2UENIZGp1RE1qUy9DTlJ6SUFWQ0cyaUtlak55c1M2cXAvYzhDMFNmNFlISVA2Y1o2RWdCVThkZ2pvNWZnTG5zKzVyMS8yYVhYUlJndUF0TWFxeUE2WWVhcnNzY1pzTUR3M3grVTNSd1JrL1BYcDNyLzVKbGNJSU8wSkk4bG5IbnFEZHVUS1FsMVcvZmdCRXdxb3lpZDZDR2d4cnBwUjZOK3VDcGVzeUFETm5LNWZ6c1ZWZmYxK2FodjNQdVl2cmtaZTdLYjFLUWkrUGt6a2VuU2hNUDJGRTVyejF5R0ZsNkNOdWEyOTlaUDNuTmRWSFJXc2c1ODVCZ3VUYVRpemY0VG9naGFlTmV5OTZucmRKN1R0Z0oxL05TQXBQTGplMW94K29MbG1xSlRWdHVlZ04rS3FHQ2Z1eWlyOVhlRHFRUlVDc2hsc3U4YTZCY2wvUnhGUEp4SjhYb0ZHaFpNcDFNRXRSNWFRZzNLcVVKT1BLYzVHcE01M1BrNGpjRy9FSXNBK1ZqYXpyazZodkJDZVkxTERTc09OVUtlT01IdWFFRzNrVU9FdXJGNThZSEFITmNPOUtiaWJpcUtGMG5kdjdyeit4eTU5ZUR6QzByVExkUCtNSnlNc2prZ1dONU55OWVuTWFiRE82Wnh0akFOSkJiaTFyWlhwUHFzbVorVjhiWVo1MXc4THgyTS9zZFV6ak1uWmtyS3pEWk04K01LSmcwVGJjL3JaK2NJNWFnYXBnRVNSSHhsY0lzbnozSXJ6VzV3M2Y4c1FQS0s1amNQcThUWk9PTjJjRDFnTVhvUFpvVGd5bVdEai83UVJVZ2htemF3OGlrVS9TV1B2YVBqUG1zMG5XcGVNMldyeG9qcjQ3b01relpVQWFjajNRREt3K1VxYy9jTHJNZGN0eTR5UlNPdTBhblJFVS9vZktvVFowcklZVE5RbElwT05TZyt2ZjZKeCtzYmdXVm1uWFFOZVVEWEkyUjFHaEZzdEJNcGtIV1ExMSs4UnlIbzFlcU9iU05OamRPWXF4Umt3RDNDNDI4bjcxTDEwUmtGUkxmVzVVUWZRZVI1WWR5SVZBZlRoRnA4Y2ppZk5JcTRZYnl4YzdZWFdXdEhBcjVhU2hic3ovUEo2ZFFzR0xHZkhUV0d5dGp2M2tmdXRreU5zamQ4RzFnSmZzUTcrZVh0STFQTmtQMjJjYkt6Q1NBYmJVQmpFNWlnZEtxTWNSUm9JT2NRdE1ZbHp5d2pFQzk5Vnc3SEtrV3ZXalJlMThPd1BabUxEamg4UHBMZkV3Z2ZwWGF3bzZuWnZydHhqUjN6NFpDYnAxMXZEbmZPRE9pNFVFN2krRE9VWDZXd2Fuck43ck15dDFYOVRlTys5QTFlNEVLUENDT1Z0cnhmaHBwdlNLRlhRMmE2RkFzeUwvVGFyK2h0dDJ2Y0ZlNmNxeHE0SG1OdkljV0hGZnJHcDlQT2tHbWpRKzVWRkJobHd4N2daSDZlZGVkREdGdGxodThmMk84UE1XWnk0R2ovMXhrb3VTT0gxSDZuNzBiaWRRZUhsa3pzZkJuWmx3aXgvT0dYZ0gxOUluanp4TFFlZzdmQ2hHWmthS2V1QURZbEkzNGhYMlErZWtaclg1UzFGV01iaWpPWVM5ZENyOEEyTzVOSnY3R2RSOHVpajVFT042QUZhelVrWnVBYXNkdldwK28reUtOUkZyNm0rRzdUVlpRd1p2d0FDdjlEaWQrTVhGRFNLRG0yL0pVYU1RMEs4YlVnU001N2Y1MU1kS3ZUaDdOcDZxWFhOUWVMeGxqZWt1c0hvdUk2bWs4ZVFaWDdXdHBMdzUyTng1ZXlpT0lhdTNNVkRCNm8zTUVEbTJGT09lbGswS2d4L0dUTStyV2NOK3lIYmhQNTllUlBvNzQ3Y3pMVmZnV0xOaXAxYTJiN3JqZVg2dXBROFRVeUJJM25vRVdKcnlLZnF1Nk1PcmZTYnE2ajJTWTRWZ1llU2xzY1I0QVhUai94L29ZQXRyWU9LRzRlWENyZUcvNEl4emJwazZWNXFCSzIxSGdaMTZQVGZKZjVETnkxeWxIdkg2dk5hSnYyRGRjbVpQd0dGTWJwOElITXVQTUs1QjRiemRFMEx2bERselp3Tk16aHRwSytSQkdZUy9lME43K2FWU0lqeUtZY1hVMENtdTZYbGllT2dqNjgxaUhxa2UvMmtkd0pSRW1GTkdHdFcyemdQRkdSVWNNRjJBYU5WdXVuK09STEhuWTVjWjNLV0F1QUpiMWdBZS8vMmNRWWgvWDdOYU0ycWQ2K3MrK2U1TWhwYmJzSGFSVTZDTVdUMk10Znc1NkpSRXhyNFh3VzA5dWdMbW5OZFZBM3RVcTRoLzU0UHhqRVc2SnBaUTVPWjV1OFRjNGNYOTRTZ3dxK3pzUlBwWFlMTG5NTzFLK0cycHJiYlA4SHVnMG1zZXVQb1VneHpidE9vQytQN1Fhc2tyQ3dlUmZrMUQyVytsVkV4RkJBNm11YjdLdUdXZGZpVE5Vd0lKOUJNTXRaeEJKUXhnL0U0R2FIUnR1bWRFSmMzdWdyNStxbkN4UXZnWm13WE1vTEh1MjBqa0JWK3p6MEF5VkNzY1d4K3IrcmxqY1pUUm13dkZPRm9LV29iNWZqLzZQbk9WQW5KOWlITG82bTM5V051RHJ0LzUwMU9oUjhOV2xwNFNQOHRHMEUySFg2TXQ2RG9ieTd5VjZSZDVVdG1PSHNoSFNNNVgxVU4wM0h2TFBVRmo0OTVKNUZDdlZvLzZXcFhIb3JSZWVlNWYyN0plM0dldGhnZG8vYTRMb3ROTVdOaE9iYy9vUzUyd2FXazk5b0pOK0dYNjhxc0JobWhTVUF0Um1Ib0Q5RFFCRmhkSXM3cGhCaklQb2h4MDI0Mkxhcnd1SVhZTFMvY0hMWmMvcDl2VHdtazJLcjFmejJlTMostrar más