Disable SSL and HTTP security

Hello, Why isn't a new index being created? I think this error related HTTP and SSL security in my elasticsearch.yml. The second picture is security configuration in elasticsearch.yml. When i disable them kibana doesn't work on browser. how to disable them correctly?


HI @Oyuka, Welcome to the Elastic community.

Is it showing any error related to certificate? It seem you're trying to import the data from kibana.

No. I'm trying to upload a jsonl file from my computer to elasticsearch, but it's giving me an error when creating an index. How can I fix this?

Could you share the sample json file? Because I can't see any error in your screenshot.

{"object_id":"646449528","event_time":"1/2/24 0:19","action_id":"538988106","object_name":"tbSystemConfig","statement":"update tbSystemConfig set SystemYear = '2024', BalanceDate = '2024-01-01'","action_name":"UPDATE","duration_milliseconds":"462","response_rows":"0","additional_information":"","affected_rows":"1","application_name":"azdata","audit_schema_version":"1","class_type":"8277","class_type_desc":"TABLE","client_ip":"local machine","client_tls_version":"1","client_tls_version_name":"","connection_id":"31016E1A-248E-43D2-AFBC-AE608C762957","data_sensitivity_information":"","database_name":"CBS_Production","database_principal_id":"1","database_principal_name":"dbo","database_transaction_id":"186785643","external_policy_permissions_checked":"","host_name":"WIN-RA6I9","is_column_permission":"TRUE","ledger_start_sequence_number":"2","permission_bitmask":"0x00000000000000000000000000000002","schema_name":"dbo","sequence_group_id":"23D47B7C-C4E0-4584-90F2-2C62D77","sequence_number":"9","server_instance_name":"WIN-RA6I9GN011N","server_principal_id":"259","server_principal_name":"WIN-RA6I9GN011N\Administrator","server_principal_sid":"0x0105000000000005150000007A817F505A15ADEC997608A3F40","session_context":"","session_id":"105","session_server_principal_name":"WIN-RA6IN\Administrator","succeeded":"TRUE","target_database_principal_id":"0","target_database_principal_name":"","target_server_principal_id":"0","target_server_principal_name":"","target_server_principal_sid":"0x","transaction_id":"10548826","user_defined_event_id":"0","user_defined_information":""}
This is one sample line in json file. I think this error is not related to the Json file because I tried to include other files but the error still occurs on create index.

Convert your json to nd-json (Newline Delimited JSON) format. Below worked for me by adding new line at the end.

{"object_id":"646449528","event_time":"1/2/24 0:19","action_id":"538988106","object_name":"tbSystemConfig","statement":"update tbSystemConfig set SystemYear = '2024', BalanceDate = '2024-01-01'","action_name":"UPDATE","duration_milliseconds":"462","response_rows":"0","additional_information":"","affected_rows":"1","application_name":"azdata","audit_schema_version":"1","class_type":"8277","class_type_desc":"TABLE","client_ip":"local machine","client_tls_version":"1","client_tls_version_name":"","connection_id":"31016E1A-248E-43D2-AFBC-AE608C762957","data_sensitivity_information":"","database_name":"CBS_Production","database_principal_id":"1","database_principal_name":"dbo","database_transaction_id":"186785643","external_policy_permissions_checked":"","host_name":"WIN-RA6I9","is_column_permission":"TRUE","ledger_start_sequence_number":"2","permission_bitmask":"0x00000000000000000000000000000002","schema_name":"dbo","sequence_group_id":"23D47B7C-C4E0-4584-90F2-2C62D77","sequence_number":"9","server_instance_name":"WIN-RA6I9GN011N","server_principal_id":"259","server_principal_name":"WIN-RA6I9GN011N\\Administrator","server_principal_sid":"0x0105000000000005150000007A817F505A15ADEC997608A3F40","session_context":"","session_id":"105","session_server_principal_name":"WIN-RA6IN\\Administrator","succeeded":"TRUE","target_database_principal_id":"0","target_database_principal_name":"","target_server_principal_id":"0","target_server_principal_name":"","target_server_principal_sid":"0x","transaction_id":"10548826","user_defined_event_id":"0","user_defined_information":""}



thanks, i converted json to nd-json format but still getting error in create index. Is this error related to something else?

  1. Which Elastic version are you using ?
  2. Can you enable kibana logs to check if it is throwing any error ?
  1. I am using version 8.17.0
  2. If i enable the log kibana doesn't work

logging:
dest: /var/log/kibana/kibana.log
level: debug
is it correct to enable kibana log in kibana.yml file

Oh, It works. I increased elasticsearch capacity and restarted it. After that it works. But the capacity was not full and maybe a restart was needed. Thanks for your help.