Trouble setting up local CSV connector

Hi, Hello, I’m attempting to run a basic local case to test my playbook, but I’m having trouble setting up my local csv connector. Can someone assist me with this error? thanks a lot.
[13:48:29,000 INFO] Csv Folder Path: /root/conantest.csv
[13:48:29,000 INFO] CSV Limit: 10
[13:48:29,000 INFO] DeviceProductField: device_product
[13:48:29,000 INFO] Time Field Name: timestamp
[13:48:29,000 INFO] Time Field Timezone: UTC
[13:48:29,000 INFO] Environment Field Name: conantest
[13:48:29,000 INFO] Environment Regex Pattern: .*
[13:48:29,000 INFO] Rule Generator Field Name: conantest
[13:48:29,000 INFO] CSV Has Header: true
[13:48:29,000 INFO] File Encoding Types: utf-8, latin-1, iso-8859-1
[13:48:29,000 INFO] Alert Field Name: conantest
[13:48:29,000 INFO] Severity Field Name: 10
[13:48:29,000 ERROR] Unable to create folder: [Errno 13] Permission denied: '/root/conantest.csv'
LOGGER: loadConfigFromFile FAILED[13:48:29,000 ERROR] [Errno 13] Permission denied: '/root/conantest.csv'
Traceback (most recent call last):
File "/opt/siemplify/siemplify_server/bin/Scripting/PythonSDK/IntegrationsVirtualEnvironment/CSV_V25.0/3twy1pl0.tbu/idr0w4ai.wh1.py", line 192, in create_folders_if_not_exist
os.makedirs(folder_to_create)
File "/opt/siemplify/siemplify_server/bin/Scripting/PythonSDK/IntegrationsVirtualEnvironment/CSV_V25.0/lib/python3.7/os.py", line 211, in makedirs
makedirs(head, exist_ok=exist_ok)
File "/opt/siemplify/siemplify_server/bin/Scripting/PythonSDK/IntegrationsVirtualEnvironment/CSV_V25.0/lib/python3.7/os.py", line 221, in makedirs
mkdir(name, mode)
PermissionError: [Errno 13] Permission denied: '/root/conantest.csv'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/opt/siemplify/siemplify_server/bin/Scripting/PythonSDK/IntegrationsVirtualEnvironment/CSV_V25.0/3twy1pl0.tbu/idr0w4ai.wh1.py", line 79, in main
create_folders_if_not_exist(siemplify, csv_folder_path)
File "/opt/siemplify/siemplify_server/bin/Scripting/PythonSDK/IntegrationsVirtualEnvironment/CSV_V25.0/3twy1pl0.tbu/idr0w4ai.wh1.py", line 196, in create_folders_if_not_exist
raise CSVConnectorException(e)
exceptions.CSVConnectorException: [Errno 13] Permission denied: '/root/conantest.csv'

Dynamic script connector returned unexpected output. No cases created.
Value cannot be null. (Parameter 'value')
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
at Siemplify.Connectors.DynamicScriptConnector.DynamicScriptCaseConnector.RunConnector(ConnectorContext context) in /home/ubuntu/myagent3/_work/5/s/Connectors/Siemplify.Connectors.DynamicScriptConnector/DynamicScriptCaseConnector.cs:line 164 I assumed there was a problem with my file permissions, but since my file is already for siemplifyadmin, I didn’t know what to do.

View files in slack

0 3 139
3 REPLIES 3

Looks like siemplifyadmin does have access to the file but maybe not the directory?

I would suggest moving out of /root and into a different folder like /opt. And then make a folder that belongs to siemplifyadmin:siemplifyadmin, and adjust permissions on the file as well.

Seems like your account is not allowed to access the file so that's the steps I would take.

I find the csv Doc.
chown scripting:scripting “directory_path” help me.

thanks,
this command help me.
chown scripting:scripting directory_path help me.