A Technical I.T./DevOps Blog
Problem scenario
You are running an Ansible playbook in AWS, and you get this message:
TASK [metron-test: Create virtual private cloud] ******************************
fatal: [localhost]: FAILED! => {“changed”: false, “failed”: true, “msg”: “VpcLimitExceeded: The maximum number of VPCs has been reached.”}
to retry, use: –limit @/usr/bin/metron/metron-deployment/amazon-ec2/playbook.retry
Solution
You must have an AWS account with a special maximum of VPCs.
…
Problem scenario
Using PHP you want to connect to a specific database to run SQL queries. How do you do this?
Solution
Assuming you have installed PHP and Postgres on the same Ubuntu Linux server, install the php-pgsql package. Follow this link if you need assistance.
1. Create a file like this named contint.php:
<?php
$host
…
Continue reading “How Do You Connect to a Specific Database in Postgres Using PHP?”
Problem scenario
You want a web page with a text field to enter a single line of SQL code. You want this code (as opposed to some fixed, pre-written code) to execute. How do you do this?
Solution
This is more dangerous because SQL injection attacks are a serious problem. This link is how to have a PHP page execute fixed code.
…
5 Important Facts You Need to Know About Computer Forensics by Trisha Halfacre
The Art of Memory Forensics: Detecting Malware and Threats in Windows, Linux, and Mac Memory by Michael Hale Ligh, Andrew Case, Jamie Levy and AAron Walters
The Basics of Digital Forensics, Second Edition: The Primer for Getting Started in Digital Forensics by John Sammons
Computer Forensics by Marie-Helen Maras
Computer Forensics and Cyber Crime: An Introduction (3rd Edition) by Marjie T.
…
Problem scenario
How do you install Nginx on a Debian or Ubuntu Linux server?
Solution
Run these three commands:
sudo apt-get -y update
sudo apt-get -y install nginx
sudo systemctl restart nginx
…
Continue reading “How Do You Install Nginx on a Debian/Ubuntu Server?”
Problem scenario
You want to read in user input via a web page. You then want that user input to participate in an invocation of a SQL command. How do you get user input to be a variable in the construction of a SQL command that is automatically executed when a web-page button is clicked?
Solution
Warning
This does not prevent against SQL injection attacks.
…
Continue reading “How Can You Accept User Input with PHP and Use It in a SQL Command?”
Cloud Computing and Electronic Discovery (Wiley CIO) by James P. Martin and Harry Cendrowski
E-Discovery and Data Privacy: A Practical Guide by Catrien Noorda and Stefan Hanloser
E-Discovery and the Federal Rules of Civil Procedure: A Pocket Guide by Bradley Schaufenbuel
E-discovery: Creating and Managing an Enterprisewide Program – A Technical Guide to Digital Investigation and Litigation Support by Karen A. Schuler
e-Discovery: Current Trends and Cases by Ralph C.
…
Problem scenario
You want a REST call to invoke some SQL code on a Postgres database. How do you do this?
Solution
Install Apache web server, PHP, and the PHP-pgsql package on your Postgresql database server. This example assumes you have PHP, Apache web server, Postgres, and the php-pgsql package installed on your server. Assuming the web server is running and the default directory for web pages is still /var/www/html/ do the following.
…
Continue reading “How Do You Get a Web Page to Invoke a Postgres Command (e.g., for a RESTful API)?”
CentOS 6.2 Configuring Squid By Example (CentOS 6 By Example Book 5) by Mike Dittmeier
Squid: The Definitive Guide by Duane Wessels
Squid Proxy Server 3.1: Beginner’s Guide by Kulbir Saini
Web Proxy Cache Replacement Strategies: Simulation, Implementation, and Performance Evaluation (SpringerBriefs in Computer Science) by Hala ElAarag
…
Problem scenario
You want to extract data from a .csv file. In other words you want to transform data from a flat file and import it into a database. Is there an example of how to create a table, format a .csv file, and run a command to import the .csv file into the Postgresql database?
Solution
1. Here is how to create a table to target for the import or ETL (Extract,
…
Continue reading “How Do You Ingest (or Import) a CSV File into a Postgresql Database Table?”