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.  You will be able to provide the users with the credentials and web URL.  

…

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

A List of Git Books

0 Comments

19 Git Tips for Everyday Use by Alex Kras
The Beginner’s Guide to GitHub by Thomas Mailund
Building Tools with GitHub: Customize Your Workflow by Chris Dawson and Ben Straub
Distributed Version Control with Git: Mastering the Git Command Line – Third Edition (vogella Series) by Lars Vogel and Alex Blewitt
Dive into GIT by James Ware
Eclipse 4.5 Git Course for Java Eclipse Developers by John R.

…

Continue reading “A List of Git Books”

How Do You Create a Table in a Specific Database Using a SQL Front-End GUI Application?

0 Comments

Problem scenario
You are using a SQL front end to query a Postgres database.  (To view directions for installing a free front-end GUI application, click here.) You have run various commands to prove the connection to the database server works.  

Running this query

select version();

shows

“PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by …”

You have used CREATE DATABASE successfully. 

…

Continue reading “How Do You Create a Table in a Specific Database Using a SQL Front-End GUI Application?”

A List of Apache Tomcat Books

0 Comments

Apache Jakarta-Tomcat by James Goodwill
Apache Tomcat 7 by Aleksa Vukotic and James Goodwill
Apache Tomcat 7 Essentials by Tanuj Khare
Apache Tomcat 7 User Guide by Apache Software Foundation
Apache TomEE Cookbook: Apache TomEE Administrator Cookbook by Mr Gurkan Erdogdu 
Beginning JSP, JSF and Tomcat: Java Web Development (Expert’s Voice in Java) by Giulio Zambon
Connection Pooling in a Java Web Application with Tomcat and NetBeans by Arthur Buliva
Deploying with JRuby 9k: Deliver Scalable Web Apps Using the JVM by Joe Kutner
Developing a Java Web Application in a Day: Step by step explanations with Eclipse Mars,

…

Continue reading “A List of Apache Tomcat Books”

How Do You Troubleshoot the Postgres Message “ERROR: permission denied to create database”?

0 Comments

Problem scenario
From a SQL front end you are connected to a Postgres database as user jdoe.  You try to create a database with the “create database verycool” SQL command.  You get this message: “ERROR: permission denied to create database.”

You try to enter the database from the back end, but you get ‘psql: FATAL: role “root” does not exist.’   Or you may even get the error “psql: FATAL:  Peer authentication failed for user” when trying to connect or log into Postgres. 

…

Continue reading “How Do You Troubleshoot the Postgres Message “ERROR: permission denied to create database”?”

How Do You Troubleshoot HAProxy when The Service Seems to Work on The Back-end but You Cannot Use It from The Front-end (via a web browser)?

0 Comments

Problem scenario
Your HAProxy server seems to be up, but it is not working (as a load balancer or otherwise).  You use nmap or a PowerShell port testing program (see “Using PowerShell Version 3, How Do You Determine If a Port Is Open for a given IP Address?“).  You find that there is activity on port 80 and/or the traffic is not blocked over port 80. 

…

Continue reading “How Do You Troubleshoot HAProxy when The Service Seems to Work on The Back-end but You Cannot Use It from The Front-end (via a web browser)?”

A List of Books About Website Performance, High Availability and Scalability

0 Comments

The Art of Scalability: Scalable Web Architecture, Processes, and Organizations for the Modern Enterprise (2nd Edition) by Martin L. Abbott and Michael T. Fisher 
Cloud Computing for Complete Beginners: Building and Scaling High-Performance Web Servers on the Amazon Cloud by Ikram Hawramani
Even Faster Web Sites: Performance Best Practices for Web Developers by Steve Souders
Getting Started with Memcached by Ahmed Soliman
High Performance Drupal: Fast and Scalable Designs by Jeff Sheltren,

…

Continue reading “A List of Books About Website Performance, High Availability and Scalability”

Can SSH Work between a Linux Server and a Windows Client When the Window’s Machine Has Inbound Port 22 Traffic Blocked?

0 Comments

Question
Can SSH work between a Linux server and a Windows client when the Window’s machine has inbound port 22 traffic blocked?

Answer
Yes.  Some VPN tunnels initiated on a Windows machine block inbound port 22 traffic (but not all).  Regardless of whether a firewall or VPN tunnel prevents inbound connections over port 22 to a Windows machine, you can make establish an  SSH connection over port 22 from a Windows machine.  

…

Continue reading “Can SSH Work between a Linux Server and a Windows Client When the Window’s Machine Has Inbound Port 22 Traffic Blocked?”

A List of Informatica Books

0 Comments

Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema by Lawrence Corr and Jim Stagnitto
Applying SOA Principles in Informatica: Applying Service Oriented Architecture (SOA) principles in Informatica PowerCenter by Mr Keshav Vadrevu
INFORMATICA INTERVIEW QUESTIONS & ANSWERS: Hands on tips & questions to crack the interview. by ks
Informatica Powercenter 9.x ETL Developer Including 20+ Hours of Online Video Tutorial by Rudrani Josh
Informatica PowerCenter – The Complete Reference: The one-stop guide for all Informatica Developers by Mr Keshav Vadrevu
Learn Informatica in 1 Day: Definitive Guide to Learn Informatica for Beginners by Krishna Rungta
Learning Informatica PowerCenter 9.x by Rahul Malewar
SAP and Informatica PowerCenter Internal Tables: Consultant Guide by Mirzakhmet Syzdykov

For a DevOps ETL quiz,

…

Continue reading “A List of Informatica Books”