Skip to content

Instantly share code, notes, and snippets.

@KarimJedda

KarimJedda/init_sqlite_logger.sh

Created June 11, 2020 18:57
Show Gist options
  • Save KarimJedda/5f9ddff39613d7a46f027a7fc25c95f0 to your computer and use it in GitHub Desktop.
Save KarimJedda/5f9ddff39613d7a46f027a7fc25c95f0 to your computer and use it in GitHub Desktop.
Download ZIP
Create sqlite Database
Raw
init_sqlite_logger.sh
sqlite3 /home/logger/logs.db "create table todo (ip TEXT, timestamp TEXT, status_code TEXT, bytes_sent TEXT, request_method TEXT, request_url TEXT, request_protocol TEXT, referrer TEXT, user_agent TEXT);"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment