LinuxCBT PHP-II Edition
.MP4, AVC, 231 kbps, 1358x766 | English, AAC, 132 kbps, 2 Ch | 8 hours | 1.37 GB
Subject: PHP SHELL Automation
Focus: PHP SHELL Automation
System Requirements: Browser | HTML5 || Flash | JavaScript
User Agents: Chrome | Firefox | Safari | IE11+ | Opera
Mobile Platforms: Droid | IOS | Phones | Tablets
Anonymize Logs
Locate target logs for processing
Identify sensitive data
Write script to anonymize sensitive data
Work with Logs and Scripts in anonymized mode
Process N Logs
Discuss limitiations of default invocation
Force N number of CLI arguments
Confirm CLI arguments
Ensure existence of supplied input file(s)
Test input logic
Storage Check
Extend script to handle new functions
Calculate available storage
Ensure storage can support generated output
Test supplied input against available storage
Debug as needed
Fixed-Length Records
Create script to check input field lengths
Use Regular Expressions to check input
Except non-standard records
Process records
Identify mismatches
Integrate fixed-length checks into main script
Test and debug where applicable
Apache Timestamp Conversion
Examine default log entries
Compare with ISO standard and MySQL support
Test timestamp conversions
Alter script to transform timestamp to numeric ISO standard
Rearrange time values to match ISO standard
Confirm for MySQL
Apache Log Stats
Use Apache Logs as Database
Ascertain: Total Bytes
Summarize Largest Requests
Average Bytes across Requests
Top 5 Largest Requests
Most Frequent Status Codes
Top IPs
CSV Output | MySQL Import
Retrofit anonymize script to yield CSV
Enclose all fields with double quotes
Generate output (CSV) and confirm
Import CSV data into MySQL
Test efficacy
CLI Dynamic Queries
Alter script to handle variances
Test query of fields as needed
Return useful results
Limits | CLI Commas
Factor in limits
Process and evaluate
Handle additional delimiter
Ensure proper interpolation
Stats
Log Timespan
Summarize output
HTML Option
HTML Only
More Info