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

0 Comments

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. 

…

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

How Do You Create Two Tables with a Shared Column between Them (e.g., Have a Foreign Key Constraint)?

0 Comments

Problem scenario
You want to create two tables in a Postgresql database.  You want the tables to share a column to relate to one another.  You want to implement a foreign key constraint to achieve this goal.  Is there an example of SQL statements to do this?

Solution
Run these two SQL commands that start with the words “CREATE TABLE”:

CREATE TABLE table1 (id integer,

…

Continue reading “How Do You Create Two Tables with a Shared Column between Them (e.g., Have a Foreign Key Constraint)?”

List of Flask (Web-Framework) Books

0 Comments

Beginning Web Development with Python: from prototype to production with flask, tornado and nginx by Andrei Dan
Building Web Applications with Flask by Italo Maia
Data Visualization with Python and JavaScript: Scrape, Clean, Explore & Transform Your Data by Kyran Dale  
Flask Blueprints by Joel Perras
Flask By Example by Gareth Dwyer
Flask Framework Cookbook by Shalabh Aggarwal
Flask Web Development: Developing Web Applications with Python by Miguel Grinberg
Instant Flask Web Development by Ron DuPlain
Learning Flask Framework by Matt Copperwaite and Charles Leifer
Mastering Flask by Jack Stouffer
Python in 24 Hours,

…

Continue reading “List of Flask (Web-Framework) Books”

How Do You Troubleshoot a Syntax Error When Trying to Create a Table with a Primary Key in SQL?

0 Comments

Problem scenario
You are trying to create a table using SQL.  You use the keywords “CONSTRAINT” and “PRIMARY KEY.”  For example, your query (or SQL DML command) looks like this:

create table contint ( specialcode char(6) CONSTRAINT PRIMARY KEY, title varchar(40)) ;

When you run the SQL command you get the message ‘…syntax error at or near “PRIMARY” LINE…’  What should you do to fix this?

…

Continue reading “How Do You Troubleshoot a Syntax Error When Trying to Create a Table with a Primary Key in SQL?”

How Do You Fix The Ansible Error “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013”?

0 Comments

Problem scenario
You are using Ansible, and you receive an error like this:

coolserver.com | UNREACHABLE! => {
    “changed”: false,
    “msg”: “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013\r\ndebug1: Reading configuration data /etc/ssh/ssh_config\r\ndebug1: /etc/ssh/ssh_config line 56: Applying options for *\r\npercent_expand: unknown key %C\r\n”,
    “unreachable”: true

How do you fix this?

…

Continue reading “How Do You Fix The Ansible Error “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013”?”

How Do You Deploy LAPP with Frontend User Authentication?

0 Comments

Problem scenario
You want a web page that asks for a username and password (e.g., to log in).  The users will not know if the authentication is done via Apache or Postgres.  You happen want the authentication to be challenged against a Postgres database.  This way if you have backend access to the Postgres database, you can use “CREATE ROLE” or “CREATE ROLE jane PASSWORD ‘veryfun’ LOGIN” to create users.  

…

Continue reading “How Do You Deploy LAPP with Frontend User Authentication?”