Download Latest Version MySQL _ MariaDB Portable source code.tar.gz (5.8 MB)
Email in envelope

Get an email when there's a new version of apache-logs-to-mysql

Home / v2.1.2
Name Modified Size InfoDownloads / Week
Parent folder
README.md 2024-12-21 1.9 kB
0
v2.1.2 source code.tar.gz 2024-12-21 4.9 MB
0
v2.1.2 source code.zip 2024-12-21 4.9 MB
0
Totals: 3 Items   9.8 MB 0
  • [2.1.2] modify TABLE access_log ADD CONSTRAINT F_access_requestlogid FOREIGN KEY (requestlogid) REFERENCES log_requestlogid(id)
  • [2.1.2] modify TABLE error_log ADD index CONSTRAINT F_error_requestlogid FOREIGN KEY (requestlogid) REFERENCES log_requestlogid(id)
  • [2.1.2] add TABLE import_format for reporting and filtering features. Allows adjusted File Format names in tables rather than hardcoding. Also enables addtional formats,
  • [2.1.2] add COLUMN importformatid to TABLE import_file for reporting and filtering features. This is FOREIGN KEY to import_format TABLE.
  • [2.1.2] modify process_access_parse and process_error_parse - WHERE CLAUSE for parameter ALL to select ONLY completed LOAD processes.
  • [2.1.2] modify importFileID STORED FUNCTION to add fileformat PARAMETER.
  • [2.1.2] modify apacheLog2MySQL.py to pass importFileID parameters 2=common and combined OR 5=error_default and error_vhost. Does not determine format difference here.
  • [2.1.2] modify process_access_parse and process_error_parse - to SET 'Import File Format - 1=common,2=combined,3=vhost,4=csv2mysql,5=error_default,6=error_vhost'
  • [2.1.2] modify process_access_parse and process_error_parse - WHERE CLAUSE for parameter ALL to select ONLY completed LOAD processes.
  • [2.1.2] reformatted SQL statements in all 66 schema views for code standardization in SQL files used to create apacheLogs2MySQL.sql
  • [2.1.2] modify all 11 access_ua_ views SQL statements FROM apache_logs.access_log_ua ln INNER JOIN apache_logs.access_log_useragent lua INNER JOIN apache_logs.access_log
  • [2.1.2] created new entity_relationship_diagram.png to reflect database changes.

Download ApacheLogs2MySQL

Source: README.md, updated 2024-12-21