How Do You Create a Web Page That Issues Customized SQL Commands to a Database Behind-The-Scenes?

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.   This solution below is not a best practice but designed for illustrative purposes.

 » Read more..

A Long List of Computer Forensics Books

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.

 » Read more..

How Do You Install Nginx on a Debian/Ubuntu Server?

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

 » Read more..

How Can You Accept User Input with PHP and Use It in a SQL Command?

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.

 » Read more..

A List of E-Discovery Books

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.

 » Read more..

How Do You Get a Web Page to Invoke a Postgres Command (e.g., for a RESTful API)?

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.

 » Read more..

A List of Squid (the Web Proxy) Books

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

 » Read more..

How Do You Ingest (or Import) a CSV File into a Postgresql Database Table?

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,

 » Read more..

How Do You Give a Local Windows 2016 Server User Access to Remote into It?

Problem scenario
You have a local user account on a Windows 2016 server (e.g., jdoe).  You want to give it access to be able to start PowerShell sessions from other Windows servers.  What do you do?

Solution
1.  Open PowerShell as Administrator.
2.  Run this command:
Set-PSSessionConfiguration -ShowSecurityDescriptorUI -Name Microsoft.PowerShell
# This is an alternative command provided as a reference in case the above did not work:
# Set-PSSessionConfiguration -Name Microsoft.PowerShell -ShowSecurityDescriptorUI -Force

3. 

 » Read more..