Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oplog start_time and end_time format missing timezone offset. #433

Open
jd580 opened this issue May 10, 2024 · 1 comment
Open

Oplog start_time and end_time format missing timezone offset. #433

jd580 opened this issue May 10, 2024 · 1 comment
Assignees
Labels
bug Something isn't working stale

Comments

@jd580
Copy link

jd580 commented May 10, 2024

Describe the bug
Error when trying to upload oplogs that have start_date and end_date fields in the recommended format of YYYY-MM-DD HH:MM:SS.

To Reproduce
Steps to reproduce the behavior:

  1. Create a test_oplog.csv file with YYYY-MM-DD HH:MM:SS format with contents:
entry_identifier,start_date,end_date,source_ip,dest_ip,tool,user_context,command,description,output,comments,operator_name,tags
,2024-05-10 14:33:12.57,2024-05-10 14:33:13.57,,,,,,,,,admin,
  1. Go to https://<ghostwriter_url>/oplog/import
  2. Select a target log.
  3. Click on 'Choose csv file' and select the test_oplog.csv file.
  4. Click 'Upload'
  5. See error:
    'Great Failure
    There was an error in row 1: localtime() cannot be applied to a naive datetime'

Expected Behavior
I would like to upload custom oplogs. I noticed adding timezone offset to the start_time and end_time field allows this to work a bit.

Screenshots
great_failure

Server Specs:

  • OS: Ubuntu
  • Docker version 24.0.1, build 6802122 and docker-compose version 1.29.2,
  • Ghostwriter v4.1

Additional context
Add timezone offset to avoid.

@jd580 jd580 added the bug Something isn't working label May 10, 2024
Copy link

This issue has been labeled as stale because it has been open for 30 days with no activity.

@github-actions github-actions bot added the stale label Jun 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working stale
Projects
None yet
Development

No branches or pull requests

2 participants