How Do You Read in User Input with Golang?

0 Comments

Problem scenario
You want to read in user input with Golang. What should you do?

Solution
This program will illustrate how you accept user input with a Golang program:

package main

import (
“bufio”
“fmt”
“os”
)

func main() {
fmt.Println(“Please enter some text:”)
reader := bufio.NewReader(os.Stdin)
text, _ := reader.ReadString(‘\n’)
fmt.Println(“The text you entered was this: “, text)
} …

Continue reading “How Do You Read in User Input with Golang?”

How Do You Create a GCP VM to Be a Web Server?

0 Comments

Problem scenario
You have a GCP server. You can run curl commands to its URL via localhost. But with a URL constructed with the server’s external IP address the curl command times out. You cannot reach the URL from your workstation. How do you get the GCP server to present the web service to other machines?

Solution
Modify the firewall rule by following these steps below.

…

Continue reading “How Do You Create a GCP VM to Be a Web Server?”

How Do You Install Firefox on a Windows Server with PowerShell?

0 Comments

Problem scenario
You want to install Firefox on a Windows server without using the traditional GUI method. What should you do?

Solution
Updated on 5/16/21
1. Open PowerShell ISE as Administrator (right click it, go to More -Run as Administrator).
2. Run this script (e.g., firefox.ps1):

# This script was mostly taken from https://forum.pulseway.com/topic/1940-install-firefox-with-powershell/

# www.continualintegration.com changed the version number of Firefox and added some comments
# Silent Install Firefox

# Download URL: https://www.mozilla.org/en-US/firefox/all/

# Path for the workdir
$workdir = “c:\installer\”

# Check if work directory exists if not create it

If (Test-Path -Path $workdir -PathType Container)
{ Write-Host “$workdir already exists” -ForegroundColor Red}
ELSE
{ New-Item -Path $workdir -ItemType directory }

# Download the installer

$source = “https://download.mozilla.org/?product=firefox-88.0.1-SSL&os=win64&lang=en-US”
$destination = “$workdir\firefox.exe”

# Check if Invoke-Webrequest exists otherwise execute WebClient

if (Get-Command ‘Invoke-Webrequest’)
{
Invoke-WebRequest $source -OutFile $destination
}
else
{
$WebClient = New-Object System.Net.WebClient
$webclient.DownloadFile($source, …

Continue reading “How Do You Install Firefox on a Windows Server with PowerShell?”

How Do You Delete an Aurora Database when You Get an Error about It Not Being Started?

0 Comments

Problem scenario
You are trying to delete an Aurora database but you get this error: “This database is not started.” What do you do?

Possible Solution #1 (with the web console)
1. Log into the web console.
2. Go to “Amazon RDS”.
3. Go to “Databases”
4. Click on the Aurora cluster of the database you want to delete or its parent.

…

Continue reading “How Do You Delete an Aurora Database when You Get an Error about It Not Being Started?”

How Do You Find the Default Directory for Tomcat when It Acts as a Web Server?

0 Comments

Problem scenario
Your Tomcat server is has been configured to serve as a web server. You have access to the back-end Linux server. But you do not know what directory corresponds with the URL of the host. How do you find what the default directory is for files that are presented on the web?

Solution
From the back-end, run this: sudo find / -name index.html | grep tomcat

Look for a WEB-INF or webapps directory.

…

Continue reading “How Do You Find the Default Directory for Tomcat when It Acts as a Web Server?”

How Do You Troubleshoot an Error Such as “UnboundLocalError: local variable ‘foobar’ referenced before assignment”?

0 Comments

Problem scenario
You run a Python program. You receive this message: “UnboundLocalError: local variable ‘foobar’ referenced before assignment”

What should you do?

Solution
Initialize the variable (e.g., foobar = 0). If you do so inside a function wherein foobar is called, that may work. If you want it to be available globally throughout your program, you will initialize it outside of a function.

…

Continue reading “How Do You Troubleshoot an Error Such as “UnboundLocalError: local variable ‘foobar’ referenced before assignment”?”

How Do You Troubleshoot Golang Using Hexademical Values?

0 Comments

Problem scenario
Your Golang program has variables with values that look like this:

{0xc4200457e8 [97 49]}

You think the that underlying variables should have regular alphabetic string values. What should you do?

Solution
Use the .string() function.

When you use strings.Builder for a variable, the value will be a hexadecimal value. To retrieve the string value that you intend,

…

Continue reading “How Do You Troubleshoot Golang Using Hexademical Values?”

What Are Some Free SQL Front-end Applications to Install on a Windows Desktop?

0 Comments

Problem scenario
You want a free trial or a completely open source (always free) graphical user interface application to install on your Windows desktop or laptop. What options do you have for a free front-end?

Answer
These GUIs are free or free to start out with an initial trial:

https://www.aquafold.com/aquadatastudio/trialregform
https://www.heidisql.com/
https://dbeaver.io/
https://www.devart.com/dbforge/postgresql/studio/
https://www.pgadmin.org/
https://omnidb.org/
Team SQL (formerly at https://teamsql.io/)
https://download.cnet.com/DbVisualizer/3000-10254_4-10202406.html
https://fishcodelib.com/database.htm

…

Continue reading “What Are Some Free SQL Front-end Applications to Install on a Windows Desktop?”