Wiki - User contributions [en]

Openclaw

2026-04-17T16:20:14Z

Scott:

== Interactive Session ==
<pre>
openclaw tui
</pre>

== Routine Maintenance ==
(as non-root user)
<pre>
brew update
brew upgrade
openclaw update
openclaw doctor
openclaw gateway restart
</pre>

== Watching Quotas for Flat-Rate Plans ==
From the command line:
<pre>
openclaw status --usage (or just "openclaw status" for full details)
</pre>
From the interactive console:
<pre>
/status
</pre>

== List Cron Jobs ==
<pre>
openclaw cron list
</pre>

== Managing Models ==
NOTE: I don't use this any more. Openclaw allows you to configure a primary and a fallback. Also, removing the heartbeat.model setting tells openclaw to just use the default model for heartbeats, just as with active sessions.
current models:
* openai-codex/gpt-5.4
* anthropic/claude-opus-4-6

switch model:
<pre>
openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4
openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4
openclaw gateway restart
</pre>
<pre>
openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6
openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6
openclaw gateway restart
</pre>

Openclaw

2026-04-17T16:18:00Z

Scott:

== Interactive Session ==
<pre>
openclaw tui
</pre>

== Routine Maintenance ==
(as non-root user)
<pre>
brew update
brew upgrade
openclaw update
openclaw doctor
openclaw gateway restart
</pre>

== Watching Quotas for Flat-Rate Plans ==
From the command line:
<pre>
openclaw status --usage (or just "openclaw status" for full details)
</pre>
From the interactive console:
<pre>
/status
</pre>

== Managing Models ==
NOTE: I don't use this any more. Openclaw allows you to configure a primary and a fallback. Also, removing the heartbeat.model setting tells openclaw to just use the default model for heartbeats, just as with active sessions.
current models:
* openai-codex/gpt-5.4
* anthropic/claude-opus-4-6

switch model:
<pre>
openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4
openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4
openclaw gateway restart
</pre>
<pre>
openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6
openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6
openclaw gateway restart
</pre>

Openclaw

2026-04-17T15:53:58Z

Scott: /* Watching Quotas for Flat-Rate Plans */

== Interactive Session ==
<pre>
openclaw tui
</pre>

== Routine Maintenance ==
(as non-root user)
<pre>
brew update
brew upgrade
openclaw update
openclaw doctor
openclaw gateway restart
</pre>

== Watching Quotas for Flat-Rate Plans ==
From the command line:
<pre>
openclaw status --usage (or just "openclaw status" for full details)
</pre>
From the interactive console:
<pre>
/status
</pre>

== Managing Models ==
NOTE: I don't use this any more. Openclaw allows you to configure a primary and a fallback. Also, removing the heartbeat.model setting tells openclaw to just use the default model for heartbeats, just as with active sessions.
current models:
* openai-codex/gpt-5.4
* anthropic/claude-opus-4-6

switch model:
<pre>
openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4
openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4
openclaw gateway restart
</pre>
<pre>
openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6
openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6
openclaw gateway restart
</pre>

Openclaw

2026-04-17T15:39:15Z

Scott:

== Interactive Session ==
<pre>
openclaw tui
</pre>

== Routine Maintenance ==
(as non-root user)
<pre>
brew update
brew upgrade
openclaw update
openclaw doctor
openclaw gateway restart
</pre>

== Watching Quotas for Flat-Rate Plans ==
<pre>
openclaw status --usage
</pre>

== Managing Models ==
NOTE: I don't use this any more. Openclaw allows you to configure a primary and a fallback. Also, removing the heartbeat.model setting tells openclaw to just use the default model for heartbeats, just as with active sessions.
current models:
* openai-codex/gpt-5.4
* anthropic/claude-opus-4-6

switch model:
<pre>
openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4
openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4
openclaw gateway restart
</pre>
<pre>
openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6
openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6
openclaw gateway restart
</pre>

Openclaw

2026-04-15T19:35:59Z

Scott:

== Managing Models ==
current models:
* openai-codex/gpt-5.4
* anthropic/claude-opus-4-6

switch model:
<pre>
openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4
openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4
openclaw gateway restart
</pre>
<pre>
openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6
openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6
openclaw gateway restart
</pre>

== Routine Maintenance ==
(as non-root user)
<pre>
brew update
brew upgrade
openclaw update
openclaw doctor
openclaw gateway restart
</pre>

Openclaw

2026-04-15T19:34:38Z

Scott: Created page with "== Managing Models == current models: * openai-codex/gpt-5.4 * anthropic/claude-opus-4-6 switch model: <pre> openclaw config set agents.defaults.model.primary openai-codex/gpt-5.4 openclaw config set agents.defaults.heartbeat.model openai-codex/gpt-5.4 openclaw gateway restart </pre> <pre> openclaw config set agents.defaults.model.primary anthropic/claude-opus-4-6 openclaw config set agents.defaults.heartbeat.model anthropic/claude-sonnet-4-6 openclaw gateway restart <..."

Main Page

2026-04-15T19:32:01Z

Scott: /* Packages and Commands */

__NOTOC__
== Programming ==
{|
|width="120px"|
| |
|-
|'''bash'''
|[[bash|Notes]]
|-
|'''C/C++ '''
|[[C Basics]] | [[C++ Basics]] | [[C++ I/O]] | [[CUDA C]] | [[Objective C]] | [[iPhone]]
|-
|'''Go'''
|[[Go Basics|Basics]] | [[Go Strings|Strings]]
|-
|'''HTML and CSS'''
|[[HTML and CSS|Notes]]
|-
|'''Java'''
|[[Java Basics|Basics]] | [[Java I/O|I/O]] | [[Java Objects|Objects]] | [[Java Properties Files|Properties Files]] | [[Java System Calls|System Calls]] | [[log4j]]
|-
|'''JavaScript'''
|[[JavaScript Basics|Basics]] | [[AngularJS]] | [[jQuery]] | [[JavaScript mailto Trick]] | [[Dojo Basics]] | [[Dojo Data Stores]] | [[E4X]] | [[Prototype]]
|-
|'''Matlab'''
|[[Matlab|Basics]]
|-
|'''Perl'''
|[[Perl Basics|Basics]] | [[Perl I/O|I/O]] | [[Perl Command-Line Arguments|Command-Line Arguments]] | [[Perl Subroutines|Subroutines]] | [[Perl Regular Expressions|Regular Expressions]] | [[Installing Perl Modules|Installing Modules]] | [[Example Perl Scripts|Example Scripts]]
|-
|'''PHP'''
|[[PHP|Basics]]
|-
|'''Python'''
|[[Python Basics|Basics]] | [[Python I/O|I/O]] | [[Python Modules|Modules]] | [[Python Regular Expressions|Regular Expressions]] | [[Python Date and Time|Date and Time]] | [[Python System Calls|System Calls]] | [[matplotlib]] | [[scipy]] | [[Python Curses|curses]]
|-
|'''Python3'''
|[[Python3 Basics|Basics]] | [[Python 3 I/O|I/O]] | [[Python Cryptography Tools]]
|-
|'''R'''
|[[R Basics|Basics]] | [[R Graphics|Graphics]] | [[R I/O|I/O]] | [[R Packages|Packages]] | [[R Statistics|Statistics]]
|-
|'''Ruby'''
|[[Ruby Basics|Basics]] | [[Ruby Classes and Modules|Classes and Modules]] | [[Ruby Data Structures|Data Structures]] | [[Ruby I/O|I/O]] | [[RVM]]
|-
|'''Ruby on Rails'''
|[[Rails Basics|Basics]] | [[Rails Form Examples]] | [[Rails 4 Notes]] | [[Nginx, Passenger, and Rails]]
|-
|'''Rails 3'''
|[[Rails 3 Basics|Basics]] | [[Rails 3 Model|Model]] | [[Rails 3 View|View]] | [[Rails 3 Controller|Controller]]
|}

== Packages and Commands ==
[[7zip]] |
[[apache]] |
[[autofs]] |
[[awk]] |
[[awstats]] |
[[ccrypt]] |
[[certbot]] |
[[chkconfig]] |
[[crontab]] |
[[date]] |
[[dd]] |
[[diff]] |
[[dirvish]] |
[[docker]]

[[emacs]] |
[[fastcgi++]] |
[[find]] |
[[gimp]] |
[[git]] |
[[gnuplot]] |
[[goaccess]] |
[[gpg]] |
[[iozone]] |
[[iptables]] |
[[locate]] |
[[mail]] |
[[mediawiki]]

[[mercurial]] |
[[mtr]] |
[[mysql]] |
[[netplan]] |
[[nfs4]] |
[[nginx]] |
[[openclaw]] |
[[openssl]] |
[[pipenv]] |
[[postgresql]] |
[[ps]] |
[[quota]] |
[[rbenv]] |
[[rsync]]

[[screen]] |
[[sed]] |
[[smartctl]] |
[[sort]] |
[[split]] |
[[ssh]] |
[[Sublime Text|subl]] |
[[subversion]] |
[[supervisor]] |
[[systemd]] |
[[tar]] |
[[thin]] |
[[tr]]

[[ufw]] |
[[update-rc.d]] |
[[usermod]] |
[[vi]] |
[[virtualbox]] |
[[xargs]] |
[[xsendfile]] |
[[youtube]] |
[[yum]] |
[[zfs]] |
[[zip]]

== Linux How-To ==
[[How to set up two-factor authentication|2FA (two-factor authentication)]] |
[[How to add a new disk drive|add a new disk drive]] |
[[How to back up and restore a partition|back up and restore a partition]] |
[[How to burn a DVD|burn a DVD]]

[[How to change a server's hostname|change a server's hostname]] |
[[Linux file compression|compress/decompress files and directories]] |
[[How to create an ISO file from a CD-ROM|create an ISO file from a CD-ROM]]

[[How to find a MAC address|find a MAC address]] |
[[How to find an executable|find an executable]] |
[[How to free kernel memory|free kernel memory]] |
[[How to interrogate a computer's hardware|interrogate a computer's hardware]]

[[How to manage quotas|manage quotas]] |
[[How to monitor performance|monitor performance]] |
[[How to mount an ISO|mount an ISO]] |
[[How to mount an LVM partition|mount an LVM partition]] |
[[How to optimize a solid state drive|optimize a solid state drive]]

[[How to repair GRUB|repair GRUB]] |
[[How to re-create /dev/null|re-create <code>/dev/null</code>]] |
[[How to set up Ubuntu Server|set up Ubuntu Server]] |
[[How to set up Ubuntu Desktop|set up Ubuntu Desktop]] |
[[How to set up a VPS|set up VPS]]

[[Ubuntu keyboard shortcuts]] |
[[How to use a tape drive|use a tape drive]] |
[[How to wipe a hard drive|wipe a hard drive]]

== Mac and Windows ==
'''Mac'''

[[Mac Orientation]]

'''Windows'''

[[Windows access control lists|access control lists]] | [[Windows administrative login|administrative login]] | [[Windows file sharing|file sharing]] | [[Windows minimum hardware requirements|minimum hardware requirements]] | [[Windows offline files|offline files]]

[[Recover files from a non-booting Windows PC|recover files]] | [[Windows remote desktop|remote desktop]] | [[Windows security|security]] | [[Windows services|services]] | [[Windows shell programming|shell programming]] | [[Windows troubleshoot network connection|troubleshoot network connection]] | [[Windows wisdom|wisdom]]

== Math ==
[[Exponential Moving Average]] | [[Statistics]]

== Biology ==
[[Brain]] | [[MRI]] | [[fMRI]] | [[Bioinformatics]]

== Books ==
[[Guide to the Good Life]] | [[How We Decide]] | [[Logic of Life]] | [[New Abs Diet]] | [[Parenting]]

[[Power of Habit]] | [[Predictably Irrational]] | [[Run]] | [[Run Faster]] | [[Sapiens]] | [[Spark]] | [[Total Heart Rate Training]]

== Other ==
[[Wiki Formatting Cheat Sheet]] | [[Recipes]] | [[Diet]] | [[Quotes]] | [[Alberto Salazar's Ten Golden Rules]]
| [[Buddhism]] | [[Favorite Booze]]

How to set up two-factor authentication

2026-02-13T22:12:33Z

Scott: /* Public Key + 2FA */

https://vrealmatic.com/ubuntu-server/2fa-google-authenticator

OATH-TOTP (Open Authentication Time-Based One-Time Password) is an open protocol that generates a one-time use password, commonly a 6 digit number that is recycled every 30 seconds.

PREREQUISITE: Before setting this up, you need a smartphone or tablet with an OATH-TOTP app installed, like Google Authenticator or Authy.

== Install Google's PAM ==
<pre>
$ sudo apt install libpam-google-authenticator
</pre>
For each user that needs 2FA, run
<pre>
$ google-authenticator
</pre>
Answer "y" for yes to say that "you want authentication tokens to be time-based". A QR code will pop up in your terminal. Use the TOTP app on your phone to take a picture of this to add the account. Give reasonable answers to the rest of the questions. You should end up with a hidden <code>.google_authenticator</code> file in your home directory.

== Configure SSH ==
Edit <code>/etc/pam.d/sshd</code> to add this line at the end:
<pre>
auth required pam_google_authenticator.so nullok
</pre>
(skip <code>nullok</code> if ALL users must use 2FA)
Edit <code>/etc/ssh/sshd_config</code>. Look for <code>ChallengeResponseAuthentication</code> OR <code>KbdInteractiveAuthentication</code> and set its value to <code>yes</code>:
<pre>
. . .
# Change to yes to enable challenge-response passwords (beware issues with
# some PAM modules and threads)
ChallengeResponseAuthentication yes
# OR #
KbdInteractiveAuthentication yes
. . .
</pre>

Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

WARNING: Don't close your existing terminal until you know everything is working!

== Public Key OR Password+2FA ==
Open a new terminal and attempt to log in via SSH. If you've previously created an SSH key and are using it, you'll notice you didn't have to type in your user's password or the MFA verification code. This is because an SSH key overrides all other authentication options by default. Otherwise, you should have gotten a password and verification code prompt.

== Public Key + 2FA ==
If your SSH server doesn't allow passwords (with <code>PasswordAuthentication no</code> and you want to require BOTH public key AND 2FA:

Edit <code>/etc/pam.d/sshd</code> to comment out <code>@include common-auth</code>:
<pre>
. . .
# Standard Un*x authentication.
#@include common-auth
. . .
</pre>
Edit <code>/etc/ssh/sshd_config</code> to add a <code>Match User</code> section for users that need to use 2FA:
<pre>
Match User barney
AuthenticationMethods publickey,keyboard-interactive
</pre>
(skip the <code>Match User</code> line if everyone needs to use 2FA)
Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

Note: this won't affect password-use for sudo commands.

How to set up two-factor authentication

2026-02-13T22:10:18Z

Scott: /* Configure SSH */

https://vrealmatic.com/ubuntu-server/2fa-google-authenticator

OATH-TOTP (Open Authentication Time-Based One-Time Password) is an open protocol that generates a one-time use password, commonly a 6 digit number that is recycled every 30 seconds.

PREREQUISITE: Before setting this up, you need a smartphone or tablet with an OATH-TOTP app installed, like Google Authenticator or Authy.

== Install Google's PAM ==
<pre>
$ sudo apt install libpam-google-authenticator
</pre>
For each user that needs 2FA, run
<pre>
$ google-authenticator
</pre>
Answer "y" for yes to say that "you want authentication tokens to be time-based". A QR code will pop up in your terminal. Use the TOTP app on your phone to take a picture of this to add the account. Give reasonable answers to the rest of the questions. You should end up with a hidden <code>.google_authenticator</code> file in your home directory.

== Configure SSH ==
Edit <code>/etc/pam.d/sshd</code> to add this line at the end:
<pre>
auth required pam_google_authenticator.so nullok
</pre>
(skip <code>nullok</code> if ALL users must use 2FA)
Edit <code>/etc/ssh/sshd_config</code>. Look for <code>ChallengeResponseAuthentication</code> OR <code>KbdInteractiveAuthentication</code> and set its value to <code>yes</code>:
<pre>
. . .
# Change to yes to enable challenge-response passwords (beware issues with
# some PAM modules and threads)
ChallengeResponseAuthentication yes
# OR #
KbdInteractiveAuthentication yes
. . .
</pre>

Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

WARNING: Don't close your existing terminal until you know everything is working!

== Public Key OR Password+2FA ==
Open a new terminal and attempt to log in via SSH. If you've previously created an SSH key and are using it, you'll notice you didn't have to type in your user's password or the MFA verification code. This is because an SSH key overrides all other authentication options by default. Otherwise, you should have gotten a password and verification code prompt.

== Public Key + 2FA ==
If your SSH server doesn't allow passwords (with <code>PasswordAuthentication no</code> and you want to require BOTH public key AND 2FA:

Edit <code>/etc/pam.d/sshd</code> to comment out <code>@include common-auth</code>:
<pre>
. . .
# Standard Un*x authentication.
#@include common-auth
. . .
</pre>
Edit <code>/etc/ssh/sshd_config</code> to add a <code>Match User</code> section for users that need to use 2FA:
<pre>
Match User barney
AuthenticationMethods publickey,keyboard-interactive
</pre>
Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

How to set up two-factor authentication

2026-02-13T22:09:33Z

Scott: /* Configure SSH */

https://vrealmatic.com/ubuntu-server/2fa-google-authenticator

OATH-TOTP (Open Authentication Time-Based One-Time Password) is an open protocol that generates a one-time use password, commonly a 6 digit number that is recycled every 30 seconds.

PREREQUISITE: Before setting this up, you need a smartphone or tablet with an OATH-TOTP app installed, like Google Authenticator or Authy.

== Install Google's PAM ==
<pre>
$ sudo apt install libpam-google-authenticator
</pre>
For each user that needs 2FA, run
<pre>
$ google-authenticator
</pre>
Answer "y" for yes to say that "you want authentication tokens to be time-based". A QR code will pop up in your terminal. Use the TOTP app on your phone to take a picture of this to add the account. Give reasonable answers to the rest of the questions. You should end up with a hidden <code>.google_authenticator</code> file in your home directory.

== Configure SSH ==
Edit <code>/etc/pam.d/sshd</code> to add this line at the end:
<pre>
auth required pam_google_authenticator.so nullok
</pre>
(skip "nullok" if ALL users must use 2FA)
Edit <code>/etc/ssh/sshd_config</code>. Look for <code>ChallengeResponseAuthentication</code> OR <code>KbdInteractiveAuthentication</code> and set its value to <code>yes</code>:
<pre>
. . .
# Change to yes to enable challenge-response passwords (beware issues with
# some PAM modules and threads)
ChallengeResponseAuthentication yes
# OR #
KbdInteractiveAuthentication yes
. . .
</pre>

Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

WARNING: Don't close your existing terminal until you know everything is working!

== Public Key OR Password+2FA ==
Open a new terminal and attempt to log in via SSH. If you've previously created an SSH key and are using it, you'll notice you didn't have to type in your user's password or the MFA verification code. This is because an SSH key overrides all other authentication options by default. Otherwise, you should have gotten a password and verification code prompt.

== Public Key + 2FA ==
If your SSH server doesn't allow passwords (with <code>PasswordAuthentication no</code> and you want to require BOTH public key AND 2FA:

Edit <code>/etc/pam.d/sshd</code> to comment out <code>@include common-auth</code>:
<pre>
. . .
# Standard Un*x authentication.
#@include common-auth
. . .
</pre>
Edit <code>/etc/ssh/sshd_config</code> to add a <code>Match User</code> section for users that need to use 2FA:
<pre>
Match User barney
AuthenticationMethods publickey,keyboard-interactive
</pre>
Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

How to set up a VPS

2026-02-09T18:49:48Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port by editing <code>/lib/systemd/system/ssh.socket</code>, then restart ssh. Test it!
* Carefully deny root access
* set up firewall
* set up backups
* apt install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

Salt

2025-11-13T17:22:42Z

Scott:

== Salt Recipe #12 ==
* 84g table salt
* 28g potassium citrate
* 8g magnesium citrate

(100 servings, 1.2g/serving)

== Sports Drink ==
* 12g salt mix above
* 88g sucrose
* 175g dextrose

(10 servings of 27.5g, approx 100 calories)

Git

2025-04-25T22:50:03Z

Scott:

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Basics ==
<pre>
git init # create git repo inside current directory
git add . # add all changes to staging
git commit # commit staged changes to master branch
git commit --amend # redo/fix the commit you just did
</pre>

== Branches ==
<pre>
git branch # list branches (master is default, HEAD/* represents current)
git branch mybranch # create a new branch
git switch mybranch # switch to new branch
git checkout mybranch # switch to new branch
git switch -c mybranch # create new branch and switch to it
git checkout -b mybranch # create new branch and switch to it
git branch -d mybranch # delete branch
</pre>

== Merging Branches ==
Example: To merge the <code>bugfix</code> branch back into the <code>master</code> branch, switch to the master branch and then type
<pre>
git merge bugfix
</pre>
Three possible merge situations
# Fast-forward: <code>master</code> hasn't changed, only <code>bugfix</code> has
# No-conflict merge: both have changed, but not in a way that conflicts
# Conflict merge: the same line of some file has changed in different ways in the two branches.
Conflict text will appear in the affected file(s). Edit this as appropriate, then commit the change to master.
NOTE: the bugfix branch will still be different.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-04-25T22:09:00Z

Scott: /* Cheat Sheets */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

<pre>
git commit --amend # redo/fix the commit you just did
git branch # list branches (master is default, HEAD/* represents current)
git branch mybranch # create a new branch
git branch -d mybranch # delete branch
git switch mybranch # switch to new branch
git checkout mybranch # switch to new branch
git switch -c mybranch # create new branch and switch to it
git checkout -b mybranch # create new branch and switch to it
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-04-24T22:13:46Z

Scott: /* Cheat Sheets */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

<pre>
git commit --amend # redo/fix the commit you just did
git branch # list branches (master is default, HEAD/* represents current)
git branch mybranch # create a new branch
git branch -d mybranch # delete branch
git switch mybranch # switch to new branch
git switch -c mybranch # create new branch and switch to it
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-04-22T23:50:46Z

Scott: /* Cheat Sheets */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

<pre>
git commit --amend # redo/fix the commit you just did
git branch # list branches (master is default, HEAD/* represents current)
git branch mybranch # create a new branch
git switch mybranch # switch to new branch
git switch -c mybranch # create new branch and switch to it
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-04-22T23:40:34Z

Scott: /* Cheat Sheets */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

<pre>
git commit --amend # redo/fix the commit you just did
git branch # list branches (master is default, HEAD/* represents current)
git branch mybranch # make a new branch
git switch mybranch # switch to new branch
git switch -c mybranch # create new branch and switch to it
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-04-18T22:54:36Z

Scott: /* Cheat Sheets */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

<pre>
git commit --amend # redo/fix the commit you just did
</pre>

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2025-01-01T23:01:18Z

Scott: /* Overwrite local from repository */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git show-branch # to see whether branch is "master" or "main"
git reset --hard origin/master # (or "origin/main" as above)
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Sublime Text

2024-11-12T18:24:12Z

Scott:

Settings on Mac, Nov 2024:
<pre>
{
"font_size": 16,
"ignored_packages": ["Vintage",
],
"hot_exit": "only_on_quit",
"trim_trailing_white_space_on_save": "all",
"ensure_newline_at_eof_on_save": true,
"word_wrap": true,
"index_files": true,
}
</pre>

== Old ==
http://www.sublimetext.com/docs/3/index.html

== Moving around ==

=== Moving the cursor ===
* to beginning/end of current word: Ctrl-left/Ctrl-right

=== Moving the view ===
* up/down: Ctrl-up/Ctrl-down

=== Incremental Search ===
* Ctrl-I

=== Go to Anything ===
* Go to File (in project): Ctrl-P, type to fuzzy-search
* Go to Method (Code Outline): Ctrl-R to show code outline, type to fuzzy-search
* Go to Method in File: Ctrl-P, search for file, type "@", then search for method
* Go to Line: Ctrl-G (or Ctrl-P, type ":"), then line number

== Selecting ==

=== Column Select ===
* Shift + right-click + drag

=== Select instances of a word (multiple cursors) ===
* Ctrl-D to select current and next instances of word
* Ctrl-U to undo last
* Alt+F3 to select all occurrences

== Tools ==
* Command Pallette: Ctrl+Shift+P, type to fuzzy-search
* Code Outline: Ctrl+R

== Projects ==
http://www.sublimetext.com/docs/3/projects.html

Assume you've got a folder full of code called <code>myproject</code>. Go to '''Project -> Save Project As...''' and save the project just inside that folder. This will create <code>myproject.sublime-project</code> and <code>myproject.sublime-workspace</code> files.
As a general rule, the <code>sublime-project</code> file would be checked into version control, while the <code>sublime-workspace</code> file would not.

Add subfolders to the project with '''Project -> Add Folder to Project...'''

== Package Control ==
Must install Package Control manually:
https://sublime.wbond.net/installation

Then install the packages you want:
''Ctrl+Shift+P install ...''

== Customizing ==
* Open Default Settings (Preferences -> Settings -- Default) to find and copy the relevant setting.
* Open User Settings (Preferences -> Settings -- User) and paste in the line you want with the appropriate change.
<pre>
{
"color_scheme": "Packages/Color Scheme - Default/Solarized (Light).tmTheme",
"font_size": 11,
"ignored_packages":
[
"Vintage"
],
"word_wrap": true,
"hot_exit" : false
}
</pre>

== Copying your settings to another machine ==
All of the settings for Sublime Text live in <code>~/.config/sublime-text-3</code> on Ubuntu.

Pipenv

2024-11-06T20:18:11Z

Scott: /* Install */

== Install ==
<pre>
apt install python-is-python3 python3-pip python3-pkgconfig pipenv
</pre>

== Create Project ==
<pre>
mkdir -p new_project/app; cd new_project/app
pipenv install Flask # creates Pipfile, Pipfile.lock
...add some flask code...
pipenv run python app/main.py # to start testing the app
</pre>

To run in Docker, add this to the Dockerfile:
<pre>
pipenv install --deploy --system
</pre>

== Update Python Packages ==
<pre>
pipenv update
</pre>

Mysql

2024-11-05T22:12:51Z

Scott: /* Searching on three-character words */

== Ubuntu setup ==
Have a <code>mysql</code> root password ready to go.
<pre>
apt install mysql-server mysql-client libmysqlclient-dev
apt install python3-mysqldb # if using python to access mysql
mysql_secure_installation
</pre>

ERROR in UBUNTU 22.04 solved here:
https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233
<pre>
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SetRootPasswordHere';
</pre>

Log in as root to mysql database
<pre>
mysql -u root -p mysql
select * from user;
delete from user where host = 'myserver'; # not needed if secure installation completed above
create user barney@localhost identified by 'xxxxxxxx';
create database bookstore;
grant all privileges on bookstore.* to barney@localhost; # regular account
grant select on bookstore.* to barney@localhost; # read-only account
grant lock tables on bookstore.* to barney@localhost; # need lock tables to run mysqldump
grant file on *.* to barney@localhost; # write output to files
flush privileges;
</pre>

== Show Permissions ==
Logged in as root:
<pre>
show grants for barney@localhost;
</pre>

==File I/O==
You should have already granted "file" privileges to user:
<pre>
grant file on *.* to barney@localhost;
flush privileges;
</pre>

To execute SQL commands in a text file (from the command line):
<pre>
mysql -u barney -p bookstore < mycommands.sql
</pre>

To execute SQL commands in a text file (from the mysql prompt):
<pre>
mysql> use bookstore;
mysql> source /home/barney/sql/mycommands.sql;
</pre>

To read data out to a file (NOTE: The <code>mysql</code> user can only write to the <code>/var/lib/mysql-files/</code> directory):
<pre>
select ... into outfile "/var/lib/mysql-files/goodbooks.txt";
</pre>

To load a file into a table:
<pre>
load data local infile "/home/barney/sql/goodbooks.txt" into table books;
</pre>

Save into a CSV file:
<pre>
select * from users into outfile '/tmp/users.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\n';
</pre>

== Backing up and restoring a database ==
To back up the database "bookstore" to a file sq5.sql:
<pre>
export MYSQL_PWD=XXXXX
mysqldump --no-tablespaces --opt bookstore > bookstore.sql
</pre>
To restore a database from backup (overwrites any existing):
<pre>
mysql -u root -p bookstore < bookstore.sql
</pre>

== Searching on three-character words ==
* Edit <code>/etc/mysql/mysql.cnf</code> or <code>/etc/mysql/mysql.conf.d/mysqld.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
<pre>
[mysqld]
ft_min_word_len=3
</pre>
* Restart mysql.
* For each table you are doing a fulltext search on, run this command:
<pre>
repair table <table_name> quick;
</pre>
* Restart mysql and any dependent apps.

== Create database/table example ==
<pre>
drop database if exists edapt_quiz;
create database edapt_quiz;
use edapt_quiz;

drop table if exists quizzes;
create table quizzes (
id int unsigned not null auto_increment,
name varchar(64) not null,
primary key (id)
) engine=innodb;
insert into quizzes (name) values ('Prodromal Questionnaire – Brief Version');

drop table if exists questions;
create table questions (
id int unsigned not null auto_increment,
quiz_id int unsigned not null,
sort_order smallint,
text text,
primary key (id),
foreign key (quiz_id) references quizzes(id)
) engine=innodb;
</pre>

== Troubleshooting ==
When attempting to load a database from a mysqldump backup, you get
<blockquote>
'''ERROR 1227 (42000) at line 81: Access denied; you need (at least one of) the SUPER privilege(s) for this operation'''
</blockquote>
You need to remove all DEFINER lines from the mysqldump file:
<pre>
sed 's/DEFINER=[^*]*\*/\*/g' backup.sql > new_backup.sql
</pre>

IPhone

2024-10-25T22:31:41Z

Scott:

{{lowercase title}}
==Facts==
* iPhone Resolution: 320x480
* top status bar is 20px, bottom tab bar is 44px
* All images should be png

==Basic Setup==
* Start by launching <code>/Developer/Applications/Xcode</code>
* <code>File -> New Project -> View-Based Application</code>, choose name (e.g. <code>MyProject</code>)
* Edit Objective-C code in <code>Groups & FIles -> Classes</code> with Xcode
* Edit user interface with <code>Groups & Files -> Resources -> MyProjectViewController.xib</code> with Interface Builder. Drag elements from the Library window to the View window.
* Click Build and Run in Xcode to test.

==Application Icon==
# Create a 57x57 png file
# Drag from Finder to Xcode <code>Resources</code> folder
# Choose "<code>Copy</code>" to create a copy in the project directory
# Click the <code>Resources -> Info.plist</code> file
# Next to "<code>Icon File</code>", enter the name of the png.

==Interface Builder hints==
* The MyProjectViewController.xib window has three "View Mode" buttons. Use the middle one to drill down and select overlapped or hidden View elements.
* When a View element is selected, double click it or use Command-1 to edit attributes. (Command is the clover-shaped button)
* Hold the Option key when mousing over View elements to see more properties.
* If you have an existing element in the View that you want to duplicate, Option-drag it to get a copy.

==Outlet==
* Communicate from code to view with an IBOutlet. In header file:
<source lang="objc">
IBOutlet UILabel *statusText;
</source>
* An outlet must be defined in the header file before it can be accessed in Interface Builder.
* Control-drag from File's Owner to the element and choose the corresponding outlet.

==Action==
* Communicate from view to code with an IBAction. In header file:
<source lang="objc">
- (IBAction)doSomething:(id)sender;
</source>
* Select element and bring up connections inspector (Tools->Connections or Command-2).
* Choose the desired event by clicking the circle to the left of it.
* Drag circle to File's Owner and select the desired action.

==Basic Interaction Sample App==
MyProjectViewController.h:
<source lang="objc">
#import <UIKit/UIKit.h>
@interface MyProjectViewController : UIViewController {
IBOutlet UILabel *statusText;
}
@property (retain, nonatomic) UILabel *statusText;
-(IBAction)buttonPressed:(id)sender;
@end
</source>

MyProjectViewController.m:
<source lang="objc">
#import "MyProjectViewController.h"
@implementation MyProjectViewController
@synthesize statusText;
-(IBAction)buttonPressed:(id)sender {
NSString *title = [sender titleForState:UIControlStateNormal];
NSString *newText = [[NSString alloc] initWithFormat: @"%@ button pressed.", title];
statusText.text = newText;
[newText release];
}
...boilerplate...
-(void)dealloc {
[statusText release];
[super dealloc];
}
@end
</source>
======View:======

# Double-click MyProjectViewController.xib in the Resources directory.
# Create a Label with no text and two RoundRect buttons named "Left" and "Right".
# Control-click on "File's Owner" in the xib window and drag it to the Label object in the view window. Let go of the mouse button and choose "statusText" from the Outlets popup menu.
# Select the Left button by clicking it; then open the Connection Inspector from Tools menu.
# Find Events -> TouchUpInside
# Click the circle next to TouchUpInside and drag to the "File's Owner" icon. Select "buttonPressed" from the popup menu.
# Do the same for the Right button.
# Build and Run

==User Interface Elements==

======Label======

Has a "text" attribute that you can change with an outlet. See the example above.

======Image======

# Drag a png file from Finder to the Resources folder in Xcode to import the image.
# Drag an ImageView element into the View
# Open attributes and tell it which png file to use
# Select "Size to Fit" from the Layout menu so the ImageView object is the same size as the imported image.
# Choose Drawing->Opaque to speed up drawing if there is no background

======Text field======
In MyProjectViewController.h:
<source lang="objc">
#import <UIKit/UIKit.h>
@interface MyProjectViewController : UIViewController {
IBOutlet UITextField *nameField;
}
@property (nonatomic, retain) UITextField *nameField;
- (IBAction)textFieldDoneEditing:(id)sender; // make sure the text field gives up control when done editing
@end
</source>

In MyProjectViewController.m:
<source lang="objc">
...
@implementation MyProjectViewController
@synthesize nameField;
- (IBAction)textFieldDoneEditing:(id)sender { // make sure the text field gives up control when done editing
[sender resignFirstResponder];
}
...
</source>

In Interface Builder

Outlet: Control-drag from File's Owner to the text field and choose the corresponding outlet.

Action: Select text field and bring up connections inspector. Choose the "Did End on Exit" event. Drag circle to File's Owner and select "textFieldDoneEditing" action.

======Number field======

Same as text field but you need a background click action to allow the user to leave the field when done editing. Add the method declaration to both header and implementation file. Here is the implementation:
<source lang="objc">
- (IBAction)backgroundClick:(id)sender {
[numberField resignFirstResponder];
// add the same for any other edit fields that should lose focus
}
</source>

View:
# Use a Round Rect Button in the view and drag its edges to cover the entire screen.
# Use Layout->Send to Back to put it behind everything else.
# Then change its Type to Custom to make it disappear altogether.
# Tie the Touch Up Inside event to File's Owner backgroundClick action.

======Slider======
Use the "Value Changed" event to call the sliderChanged action. Access slider value with slider.value. Sample code:
<source lang="objc">
-(IBAction)sliderChanged:(id)sender {
UISlider *slider = (UISlider *)sender;
int progressAsInt = (int)(slider.value + 0.5f);
NSString *newText = [[NSString alloc] initWithFormat:@"%d", progressAsInt];
sliderLabel.text = newText;
[newText release];
}
</source>

======Switch======
Get value from <code>switch.isOn</code>. Use "Value Changed" event.

======Segmented Control======
Get value from <code>segmentedControl.selectedSegmentIndex</code>

======SubView======
Group elements inside a sub view. Hide all with <code>subview.hidden = YES</code>

======Action Sheet======
Modal dialog to force the user to choose an option. Use UIActionSheetDelegate protocol:
<source lang="objc">
...
@interface MyProjectViewController : UIViewController <UIActionSheetDelegate> {
...
</source>

Create an Action Sheet in an action method:
<source lang="objc">
UIActionSheet *actionSheet = [[UIActionSheet alloc]
initWithTitle:@"Are you sure?"
delegate:self
cancelButtonTitle:@"No way!"
destructiveButtonTitle:@"Yes, I'm sure!"
otherButtonTitles:nil];
[actionSheet showInView:self.view];
[actionSheet release];
</source>

Handle the action sheet response with this method:
<source lang="objc">
-(void)actionSheet:(UIActionSheet *)actionSheet didDismissWithButtonIndex:(NSInteger)buttonIndex {
if (buttonIndex == [actionSheet cancelButtonIndex] { /* do cancel action, if any */ }
else { /* do destructive (positive) action */}
}
</source>

======Custom Button======
To get nicer looking buttons, create a Round Rect button and then change its type to Custom. Download a nice looking button template from the web:

http://developer.apple.com/iphone/library/samplecode/UICatalog/index.html

Then implement the viewDidLoad method of UIViewController:
<source lang="objc">
-(void)viewDidLoad {
jmUIImage *buttonImage = [UIImage imageNamed:@"whiteButton.png"];
UIIMage *stretchableButtonImage = [buttonImage stretchableImageWithLeftCapWidth:12 topCapHeight:0];
[doSomethingButton setBackgroundImage:stretchableButtonImage forState:UIControlStateNormal];
}
</source>
Can also make the button change when pressed by using a different background image for state <code>UIControlStateHighlighted</code>

==Autorotation==
Controlled from the
<source lang="objc">
-(BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation {
return (interfaceOrientation == UIInterfaceOrientationPortrait);
}
</source>

Available orientations:
* UIInterfaceOrientationPortrait
* UIInterfaceOrientationPortraitUpsideDown
* UIInterfaceOrientationLandscapeLeft
* UIInterfaceOrientationLandscapeRight

There are three different approaches to autorotation:

=====Autosize=====
Give elements autosize properties using the size inspector (command-3).

=====Restructure=====
Create outlets for each element; then call something like <code><br /></code>
<source lang="objc">
element.frame = CGRectMake(x1, y1, width, height)
</source>
to resize/relocate each on rotation in the
<source lang="objc">
-(void)willAnimateSecondHalfOfRotationFromInterfaceOrientation
</source>
method using self.interfaceOrientation as the "to" orientation.

======Animating a rotation======
<source lang="objc">
[UIView beginAnimations:@"move buttons" context:nil];
... CGRectMake calls to move stuff around ...
[UIView commitAnimations];
</source>

=====Swap views=====
* Create portrait and landscape outlets in the .h file. Save.
* Delete the default view from the project.
* Drag two or more View elements from the library and give them names like "portrait" and "landscape".
* Use the size inspector to update the geometry (480x300 for landscape with top status bar).
* Control-drag from File's Owner to each view and choose the related outlet.
* Control-drag from File's Owner to portrait and choose the View outlet to choose it as default
* Create this method in the .m file:
<source lang="objc">
-(void)willAnimateFirstHalfOfRotationToInterfaceOrientation:(UIInterfaceOrientation)toInterfaceOrientation
duration:(NSTimeInterval)duration {
if (toOrientation == UIInterfaceOrientationPortrait){
self.view = self.portrait;
self.view.transform = CGAffineTransformIdentity;
self.view.transform = CGAffineTransformMakeRotation(0); // In radians
self.view.bounds = CGRectMake(0, 0, 300, 480);
...
</source>

* Transform angles are:
** 0 for portrait
** M_PI/2 for landscape right
** M_PI for upside down
** -M_PI/2 for landscape left
* Link in the CoreGraphics framework to support the transform:
** Click Frameworks under the Groups and Files pane
** Project -> Add to Project menu
** /Developer/Platforms/iPhoneSimulator/Developer/SDKs/iPhoneSimulator3.1.sdk/System/Library/Frameworks/CoreGraphics.framework
** uncheck "Copy items to destination..."
** Reference type should be "Relative to current SDK"

IPhone

2024-10-25T22:31:22Z

Scott: /* Facts */

{{lowercase title}}
==Facts==
* iPhone Resolution: 320x480
* top status bar is 20px, bottom tab bar is 44px
* All images should be png
* test

==Basic Setup==
* Start by launching <code>/Developer/Applications/Xcode</code>
* <code>File -> New Project -> View-Based Application</code>, choose name (e.g. <code>MyProject</code>)
* Edit Objective-C code in <code>Groups & FIles -> Classes</code> with Xcode
* Edit user interface with <code>Groups & Files -> Resources -> MyProjectViewController.xib</code> with Interface Builder. Drag elements from the Library window to the View window.
* Click Build and Run in Xcode to test.

==Application Icon==
# Create a 57x57 png file
# Drag from Finder to Xcode <code>Resources</code> folder
# Choose "<code>Copy</code>" to create a copy in the project directory
# Click the <code>Resources -> Info.plist</code> file
# Next to "<code>Icon File</code>", enter the name of the png.

==Interface Builder hints==
* The MyProjectViewController.xib window has three "View Mode" buttons. Use the middle one to drill down and select overlapped or hidden View elements.
* When a View element is selected, double click it or use Command-1 to edit attributes. (Command is the clover-shaped button)
* Hold the Option key when mousing over View elements to see more properties.
* If you have an existing element in the View that you want to duplicate, Option-drag it to get a copy.

==Outlet==
* Communicate from code to view with an IBOutlet. In header file:
<source lang="objc">
IBOutlet UILabel *statusText;
</source>
* An outlet must be defined in the header file before it can be accessed in Interface Builder.
* Control-drag from File's Owner to the element and choose the corresponding outlet.

==Action==
* Communicate from view to code with an IBAction. In header file:
<source lang="objc">
- (IBAction)doSomething:(id)sender;
</source>
* Select element and bring up connections inspector (Tools->Connections or Command-2).
* Choose the desired event by clicking the circle to the left of it.
* Drag circle to File's Owner and select the desired action.

==Basic Interaction Sample App==
MyProjectViewController.h:
<source lang="objc">
#import <UIKit/UIKit.h>
@interface MyProjectViewController : UIViewController {
IBOutlet UILabel *statusText;
}
@property (retain, nonatomic) UILabel *statusText;
-(IBAction)buttonPressed:(id)sender;
@end
</source>

MyProjectViewController.m:
<source lang="objc">
#import "MyProjectViewController.h"
@implementation MyProjectViewController
@synthesize statusText;
-(IBAction)buttonPressed:(id)sender {
NSString *title = [sender titleForState:UIControlStateNormal];
NSString *newText = [[NSString alloc] initWithFormat: @"%@ button pressed.", title];
statusText.text = newText;
[newText release];
}
...boilerplate...
-(void)dealloc {
[statusText release];
[super dealloc];
}
@end
</source>
======View:======

# Double-click MyProjectViewController.xib in the Resources directory.
# Create a Label with no text and two RoundRect buttons named "Left" and "Right".
# Control-click on "File's Owner" in the xib window and drag it to the Label object in the view window. Let go of the mouse button and choose "statusText" from the Outlets popup menu.
# Select the Left button by clicking it; then open the Connection Inspector from Tools menu.
# Find Events -> TouchUpInside
# Click the circle next to TouchUpInside and drag to the "File's Owner" icon. Select "buttonPressed" from the popup menu.
# Do the same for the Right button.
# Build and Run

==User Interface Elements==

======Label======

Has a "text" attribute that you can change with an outlet. See the example above.

======Image======

# Drag a png file from Finder to the Resources folder in Xcode to import the image.
# Drag an ImageView element into the View
# Open attributes and tell it which png file to use
# Select "Size to Fit" from the Layout menu so the ImageView object is the same size as the imported image.
# Choose Drawing->Opaque to speed up drawing if there is no background

======Text field======
In MyProjectViewController.h:
<source lang="objc">
#import <UIKit/UIKit.h>
@interface MyProjectViewController : UIViewController {
IBOutlet UITextField *nameField;
}
@property (nonatomic, retain) UITextField *nameField;
- (IBAction)textFieldDoneEditing:(id)sender; // make sure the text field gives up control when done editing
@end
</source>

In MyProjectViewController.m:
<source lang="objc">
...
@implementation MyProjectViewController
@synthesize nameField;
- (IBAction)textFieldDoneEditing:(id)sender { // make sure the text field gives up control when done editing
[sender resignFirstResponder];
}
...
</source>

In Interface Builder

Outlet: Control-drag from File's Owner to the text field and choose the corresponding outlet.

Action: Select text field and bring up connections inspector. Choose the "Did End on Exit" event. Drag circle to File's Owner and select "textFieldDoneEditing" action.

======Number field======

Same as text field but you need a background click action to allow the user to leave the field when done editing. Add the method declaration to both header and implementation file. Here is the implementation:
<source lang="objc">
- (IBAction)backgroundClick:(id)sender {
[numberField resignFirstResponder];
// add the same for any other edit fields that should lose focus
}
</source>

View:
# Use a Round Rect Button in the view and drag its edges to cover the entire screen.
# Use Layout->Send to Back to put it behind everything else.
# Then change its Type to Custom to make it disappear altogether.
# Tie the Touch Up Inside event to File's Owner backgroundClick action.

======Slider======
Use the "Value Changed" event to call the sliderChanged action. Access slider value with slider.value. Sample code:
<source lang="objc">
-(IBAction)sliderChanged:(id)sender {
UISlider *slider = (UISlider *)sender;
int progressAsInt = (int)(slider.value + 0.5f);
NSString *newText = [[NSString alloc] initWithFormat:@"%d", progressAsInt];
sliderLabel.text = newText;
[newText release];
}
</source>

======Switch======
Get value from <code>switch.isOn</code>. Use "Value Changed" event.

======Segmented Control======
Get value from <code>segmentedControl.selectedSegmentIndex</code>

======SubView======
Group elements inside a sub view. Hide all with <code>subview.hidden = YES</code>

======Action Sheet======
Modal dialog to force the user to choose an option. Use UIActionSheetDelegate protocol:
<source lang="objc">
...
@interface MyProjectViewController : UIViewController <UIActionSheetDelegate> {
...
</source>

Create an Action Sheet in an action method:
<source lang="objc">
UIActionSheet *actionSheet = [[UIActionSheet alloc]
initWithTitle:@"Are you sure?"
delegate:self
cancelButtonTitle:@"No way!"
destructiveButtonTitle:@"Yes, I'm sure!"
otherButtonTitles:nil];
[actionSheet showInView:self.view];
[actionSheet release];
</source>

Handle the action sheet response with this method:
<source lang="objc">
-(void)actionSheet:(UIActionSheet *)actionSheet didDismissWithButtonIndex:(NSInteger)buttonIndex {
if (buttonIndex == [actionSheet cancelButtonIndex] { /* do cancel action, if any */ }
else { /* do destructive (positive) action */}
}
</source>

======Custom Button======
To get nicer looking buttons, create a Round Rect button and then change its type to Custom. Download a nice looking button template from the web:

http://developer.apple.com/iphone/library/samplecode/UICatalog/index.html

Then implement the viewDidLoad method of UIViewController:
<source lang="objc">
-(void)viewDidLoad {
jmUIImage *buttonImage = [UIImage imageNamed:@"whiteButton.png"];
UIIMage *stretchableButtonImage = [buttonImage stretchableImageWithLeftCapWidth:12 topCapHeight:0];
[doSomethingButton setBackgroundImage:stretchableButtonImage forState:UIControlStateNormal];
}
</source>
Can also make the button change when pressed by using a different background image for state <code>UIControlStateHighlighted</code>

==Autorotation==
Controlled from the
<source lang="objc">
-(BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation {
return (interfaceOrientation == UIInterfaceOrientationPortrait);
}
</source>

Available orientations:
* UIInterfaceOrientationPortrait
* UIInterfaceOrientationPortraitUpsideDown
* UIInterfaceOrientationLandscapeLeft
* UIInterfaceOrientationLandscapeRight

There are three different approaches to autorotation:

=====Autosize=====
Give elements autosize properties using the size inspector (command-3).

=====Restructure=====
Create outlets for each element; then call something like <code><br /></code>
<source lang="objc">
element.frame = CGRectMake(x1, y1, width, height)
</source>
to resize/relocate each on rotation in the
<source lang="objc">
-(void)willAnimateSecondHalfOfRotationFromInterfaceOrientation
</source>
method using self.interfaceOrientation as the "to" orientation.

======Animating a rotation======
<source lang="objc">
[UIView beginAnimations:@"move buttons" context:nil];
... CGRectMake calls to move stuff around ...
[UIView commitAnimations];
</source>

=====Swap views=====
* Create portrait and landscape outlets in the .h file. Save.
* Delete the default view from the project.
* Drag two or more View elements from the library and give them names like "portrait" and "landscape".
* Use the size inspector to update the geometry (480x300 for landscape with top status bar).
* Control-drag from File's Owner to each view and choose the related outlet.
* Control-drag from File's Owner to portrait and choose the View outlet to choose it as default
* Create this method in the .m file:
<source lang="objc">
-(void)willAnimateFirstHalfOfRotationToInterfaceOrientation:(UIInterfaceOrientation)toInterfaceOrientation
duration:(NSTimeInterval)duration {
if (toOrientation == UIInterfaceOrientationPortrait){
self.view = self.portrait;
self.view.transform = CGAffineTransformIdentity;
self.view.transform = CGAffineTransformMakeRotation(0); // In radians
self.view.bounds = CGRectMake(0, 0, 300, 480);
...
</source>

* Transform angles are:
** 0 for portrait
** M_PI/2 for landscape right
** M_PI for upside down
** -M_PI/2 for landscape left
* Link in the CoreGraphics framework to support the transform:
** Click Frameworks under the Groups and Files pane
** Project -> Add to Project menu
** /Developer/Platforms/iPhoneSimulator/Developer/SDKs/iPhoneSimulator3.1.sdk/System/Library/Frameworks/CoreGraphics.framework
** uncheck "Copy items to destination..."
** Reference type should be "Relative to current SDK"

Main Page

2024-10-25T22:00:59Z

Scott: /* Packages and Commands */

__NOTOC__
== Programming ==
{|
|width="120px"|
| |
|-
|'''bash'''
|[[bash|Notes]]
|-
|'''C/C++ '''
|[[C Basics]] | [[C++ Basics]] | [[C++ I/O]] | [[CUDA C]] | [[Objective C]] | [[iPhone]]
|-
|'''Go'''
|[[Go Basics|Basics]] | [[Go Strings|Strings]]
|-
|'''HTML and CSS'''
|[[HTML and CSS|Notes]]
|-
|'''Java'''
|[[Java Basics|Basics]] | [[Java I/O|I/O]] | [[Java Objects|Objects]] | [[Java Properties Files|Properties Files]] | [[Java System Calls|System Calls]] | [[log4j]]
|-
|'''JavaScript'''
|[[JavaScript Basics|Basics]] | [[AngularJS]] | [[jQuery]] | [[JavaScript mailto Trick]] | [[Dojo Basics]] | [[Dojo Data Stores]] | [[E4X]] | [[Prototype]]
|-
|'''Matlab'''
|[[Matlab|Basics]]
|-
|'''Perl'''
|[[Perl Basics|Basics]] | [[Perl I/O|I/O]] | [[Perl Command-Line Arguments|Command-Line Arguments]] | [[Perl Subroutines|Subroutines]] | [[Perl Regular Expressions|Regular Expressions]] | [[Installing Perl Modules|Installing Modules]] | [[Example Perl Scripts|Example Scripts]]
|-
|'''PHP'''
|[[PHP|Basics]]
|-
|'''Python'''
|[[Python Basics|Basics]] | [[Python I/O|I/O]] | [[Python Modules|Modules]] | [[Python Regular Expressions|Regular Expressions]] | [[Python Date and Time|Date and Time]] | [[Python System Calls|System Calls]] | [[matplotlib]] | [[scipy]] | [[Python Curses|curses]]
|-
|'''Python3'''
|[[Python3 Basics|Basics]] | [[Python 3 I/O|I/O]] | [[Python Cryptography Tools]]
|-
|'''R'''
|[[R Basics|Basics]] | [[R Graphics|Graphics]] | [[R I/O|I/O]] | [[R Packages|Packages]] | [[R Statistics|Statistics]]
|-
|'''Ruby'''
|[[Ruby Basics|Basics]] | [[Ruby Classes and Modules|Classes and Modules]] | [[Ruby Data Structures|Data Structures]] | [[Ruby I/O|I/O]] | [[RVM]]
|-
|'''Ruby on Rails'''
|[[Rails Basics|Basics]] | [[Rails Form Examples]] | [[Rails 4 Notes]] | [[Nginx, Passenger, and Rails]]
|-
|'''Rails 3'''
|[[Rails 3 Basics|Basics]] | [[Rails 3 Model|Model]] | [[Rails 3 View|View]] | [[Rails 3 Controller|Controller]]
|}

== Packages and Commands ==
[[7zip]] |
[[apache]] |
[[autofs]] |
[[awk]] |
[[awstats]] |
[[ccrypt]] |
[[certbot]] |
[[chkconfig]] |
[[crontab]] |
[[date]] |
[[dd]] |
[[diff]] |
[[dirvish]] |
[[docker]]

[[emacs]] |
[[fastcgi++]] |
[[find]] |
[[gimp]] |
[[git]] |
[[gnuplot]] |
[[goaccess]] |
[[gpg]] |
[[iozone]] |
[[iptables]] |
[[locate]] |
[[mail]] |
[[mediawiki]]

[[mercurial]] |
[[mtr]] |
[[mysql]] |
[[netplan]] |
[[nfs4]] |
[[nginx]] |
[[openssl]] |
[[pipenv]] |
[[postgresql]] |
[[ps]] |
[[quota]] |
[[rbenv]] |
[[rsync]]

[[screen]] |
[[sed]] |
[[smartctl]] |
[[sort]] |
[[split]] |
[[ssh]] |
[[Sublime Text|subl]] |
[[subversion]] |
[[supervisor]] |
[[systemd]] |
[[tar]] |
[[thin]] |
[[tr]]

[[ufw]] |
[[update-rc.d]] |
[[usermod]] |
[[vi]] |
[[virtualbox]] |
[[xargs]] |
[[xsendfile]] |
[[youtube]] |
[[yum]] |
[[zfs]] |
[[zip]]

== Linux How-To ==
[[How to set up two-factor authentication|2FA (two-factor authentication)]] |
[[How to add a new disk drive|add a new disk drive]] |
[[How to back up and restore a partition|back up and restore a partition]] |
[[How to burn a DVD|burn a DVD]]

[[How to change a server's hostname|change a server's hostname]] |
[[Linux file compression|compress/decompress files and directories]] |
[[How to create an ISO file from a CD-ROM|create an ISO file from a CD-ROM]]

[[How to find a MAC address|find a MAC address]] |
[[How to find an executable|find an executable]] |
[[How to free kernel memory|free kernel memory]] |
[[How to interrogate a computer's hardware|interrogate a computer's hardware]]

[[How to manage quotas|manage quotas]] |
[[How to monitor performance|monitor performance]] |
[[How to mount an ISO|mount an ISO]] |
[[How to mount an LVM partition|mount an LVM partition]] |
[[How to optimize a solid state drive|optimize a solid state drive]]

[[How to repair GRUB|repair GRUB]] |
[[How to re-create /dev/null|re-create <code>/dev/null</code>]] |
[[How to set up Ubuntu Server|set up Ubuntu Server]] |
[[How to set up Ubuntu Desktop|set up Ubuntu Desktop]] |
[[How to set up a VPS|set up VPS]]

[[Ubuntu keyboard shortcuts]] |
[[How to use a tape drive|use a tape drive]] |
[[How to wipe a hard drive|wipe a hard drive]]

== Mac and Windows ==
'''Mac'''

[[Mac Orientation]]

'''Windows'''

[[Windows access control lists|access control lists]] | [[Windows administrative login|administrative login]] | [[Windows file sharing|file sharing]] | [[Windows minimum hardware requirements|minimum hardware requirements]] | [[Windows offline files|offline files]]

[[Recover files from a non-booting Windows PC|recover files]] | [[Windows remote desktop|remote desktop]] | [[Windows security|security]] | [[Windows services|services]] | [[Windows shell programming|shell programming]] | [[Windows troubleshoot network connection|troubleshoot network connection]] | [[Windows wisdom|wisdom]]

== Math ==
[[Exponential Moving Average]] | [[Statistics]]

== Biology ==
[[Brain]] | [[MRI]] | [[fMRI]] | [[Bioinformatics]]

== Books ==
[[Guide to the Good Life]] | [[How We Decide]] | [[Logic of Life]] | [[New Abs Diet]] | [[Parenting]]

[[Power of Habit]] | [[Predictably Irrational]] | [[Run]] | [[Run Faster]] | [[Sapiens]] | [[Spark]] | [[Total Heart Rate Training]]

== Other ==
[[Wiki Formatting Cheat Sheet]] | [[Recipes]] | [[Diet]] | [[Quotes]] | [[Alberto Salazar's Ten Golden Rules]]
| [[Buddhism]] | [[Favorite Booze]]

Mysql

2024-10-25T20:25:38Z

Scott:

== Ubuntu setup ==
Have a <code>mysql</code> root password ready to go.
<pre>
apt install mysql-server mysql-client libmysqlclient-dev
apt install python3-mysqldb # if using python to access mysql
mysql_secure_installation
</pre>

ERROR in UBUNTU 22.04 solved here:
https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233
<pre>
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SetRootPasswordHere';
</pre>

Log in as root to mysql database
<pre>
mysql -u root -p mysql
select * from user;
delete from user where host = 'myserver'; # not needed if secure installation completed above
create user barney@localhost identified by 'xxxxxxxx';
create database bookstore;
grant all privileges on bookstore.* to barney@localhost; # regular account
grant select on bookstore.* to barney@localhost; # read-only account
grant lock tables on bookstore.* to barney@localhost; # need lock tables to run mysqldump
grant file on *.* to barney@localhost; # write output to files
flush privileges;
</pre>

== Show Permissions ==
Logged in as root:
<pre>
show grants for barney@localhost;
</pre>

==File I/O==
You should have already granted "file" privileges to user:
<pre>
grant file on *.* to barney@localhost;
flush privileges;
</pre>

To execute SQL commands in a text file (from the command line):
<pre>
mysql -u barney -p bookstore < mycommands.sql
</pre>

To execute SQL commands in a text file (from the mysql prompt):
<pre>
mysql> use bookstore;
mysql> source /home/barney/sql/mycommands.sql;
</pre>

To read data out to a file (NOTE: The <code>mysql</code> user can only write to the <code>/var/lib/mysql-files/</code> directory):
<pre>
select ... into outfile "/var/lib/mysql-files/goodbooks.txt";
</pre>

To load a file into a table:
<pre>
load data local infile "/home/barney/sql/goodbooks.txt" into table books;
</pre>

Save into a CSV file:
<pre>
select * from users into outfile '/tmp/users.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\n';
</pre>

== Backing up and restoring a database ==
To back up the database "bookstore" to a file sq5.sql:
<pre>
export MYSQL_PWD=XXXXX
mysqldump --no-tablespaces --opt bookstore > bookstore.sql
</pre>
To restore a database from backup (overwrites any existing):
<pre>
mysql -u root -p bookstore < bookstore.sql
</pre>

== Searching on three-character words ==
* Edit <code>/etc/mysql/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
<pre>
[mysqld]
ft_min_word_len=3
</pre>
* Restart mysql.
* For each table you are doing a fulltext search on, run this command:
<pre>
repair table <table_name> quick;
</pre>
* Restart mysql and any dependent apps.

== Create database/table example ==
<pre>
drop database if exists edapt_quiz;
create database edapt_quiz;
use edapt_quiz;

drop table if exists quizzes;
create table quizzes (
id int unsigned not null auto_increment,
name varchar(64) not null,
primary key (id)
) engine=innodb;
insert into quizzes (name) values ('Prodromal Questionnaire – Brief Version');

drop table if exists questions;
create table questions (
id int unsigned not null auto_increment,
quiz_id int unsigned not null,
sort_order smallint,
text text,
primary key (id),
foreign key (quiz_id) references quizzes(id)
) engine=innodb;
</pre>

== Troubleshooting ==
When attempting to load a database from a mysqldump backup, you get
<blockquote>
'''ERROR 1227 (42000) at line 81: Access denied; you need (at least one of) the SUPER privilege(s) for this operation'''
</blockquote>
You need to remove all DEFINER lines from the mysqldump file:
<pre>
sed 's/DEFINER=[^*]*\*/\*/g' backup.sql > new_backup.sql
</pre>

How to set up two-factor authentication

2024-10-25T20:15:45Z

Scott:

https://vrealmatic.com/ubuntu-server/2fa-google-authenticator

OATH-TOTP (Open Authentication Time-Based One-Time Password) is an open protocol that generates a one-time use password, commonly a 6 digit number that is recycled every 30 seconds.

PREREQUISITE: Before setting this up, you need a smartphone or tablet with an OATH-TOTP app installed, like Google Authenticator or Authy.

== Install Google's PAM ==
<pre>
$ sudo apt install libpam-google-authenticator
</pre>
For each user that needs 2FA, run
<pre>
$ google-authenticator
</pre>
Answer "y" for yes to say that "you want authentication tokens to be time-based". A QR code will pop up in your terminal. Use the TOTP app on your phone to take a picture of this to add the account. Give reasonable answers to the rest of the questions. You should end up with a hidden <code>.google_authenticator</code> file in your home directory.

== Configure SSH ==
Edit <code>/etc/pam.d/sshd</code> to add this line at the end:
<pre>
auth required pam_google_authenticator.so nullok
</pre>
Edit <code>/etc/ssh/sshd_config</code>. Look for <code>ChallengeResponseAuthentication</code> OR <code>KbdInteractiveAuthentication</code> and set its value to <code>yes</code>:
<pre>
. . .
# Change to yes to enable challenge-response passwords (beware issues with
# some PAM modules and threads)
ChallengeResponseAuthentication yes
# OR #
KbdInteractiveAuthentication yes
. . .
</pre>

Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

WARNING: Don't close your existing terminal until you know everything is working!

== Public Key OR Password+2FA ==
Open a new terminal and attempt to log in via SSH. If you've previously created an SSH key and are using it, you'll notice you didn't have to type in your user's password or the MFA verification code. This is because an SSH key overrides all other authentication options by default. Otherwise, you should have gotten a password and verification code prompt.

== Public Key + 2FA ==
If your SSH server doesn't allow passwords (with <code>PasswordAuthentication no</code> and you want to require BOTH public key AND 2FA:

Edit <code>/etc/pam.d/sshd</code> to comment out <code>@include common-auth</code>:
<pre>
. . .
# Standard Un*x authentication.
#@include common-auth
. . .
</pre>
Edit <code>/etc/ssh/sshd_config</code> to add a <code>Match User</code> section for users that need to use 2FA:
<pre>
Match User barney
AuthenticationMethods publickey,keyboard-interactive
</pre>
Restart sshd:
<pre>
sudo systemctl restart sshd.service
</pre>

How to set up a VPS

2024-10-25T18:49:54Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap ntp postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port by editing <code>/lib/systemd/system/ssh.socket</code>, then restart ssh. Test it!
* Carefully deny root access
* set up firewall
* set up backups
* apt install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

How to set up a VPS

2024-10-25T18:34:16Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap ntp postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port by editing <code>/lib/systemd/system/ssh.socket</code>, then restart ssh. Test it!
* Carefully deny root access
* set up firewall
* set up backups
* apt-get install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

How to set up a VPS

2024-10-25T18:33:14Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap ntp postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port by editing <code>/lib/systemd/system/ssh.socket</code>, then restart ssh.
and (carefully) to deny root access
* set up firewall
* set up backups
* apt-get install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

How to set up a VPS

2024-10-25T18:31:57Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap ntp postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port by editing <code>/lib/systemd/system/ssh.socket</code>, then <code>systemctl daemon-reload</code>.
and (carefully) to deny root access
* set up firewall
* set up backups
* apt-get install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

How to set up a VPS

2024-10-25T18:17:20Z

Scott:

* Log in as root via ssh
* add line to <code>/etc/hosts</code>
* <code>dpkg-reconfigure tzdata</code>
* create user account, add to sudoers:
<pre>
useradd --create-home --shell /bin/bash myuser
usermod -aG sudo myuser
</pre>
* <code>apt install emacs-nox nmap ntp postfix mailutils logwatch unzip zip</code>
* update ssh to listen on a different port and (carefully) to deny root access
* set up firewall
* set up backups
* apt-get install nginx mysql-server supervisor
* install docker-compose: http://docs.docker.com/compose/install/
* fix [[mysql]], create mysql databases and app accounts
* schedule nightly database snapshots
* set up sites in <code>/etc/nginx/sites-available</code> and activate in <code>/etc/nginx/sites-enabled</code>
* set up apps in <code>/etc/supervisor/conf.d</code>

== after setting up DNS name ==
* update hostname in /etc/hosts, /etc/hostname, run "hostname -F /etc/hostname"
* configure postfix
* make sure you receive nightly log messages

Git

2024-06-28T22:42:39Z

Scott: /* Overwrite a single file from repository */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git reset --hard origin/master
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
# or just write out a specific version for comparison
git show 7f7a8214befd1903260e6c6ae65d9158e4249881:rails/public/faq.html > faq.html.old
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Mysql

2024-03-28T19:15:13Z

Scott: /* Searching on three-character words */

== Ubuntu setup ==
Have a <code>mysql</code> root password ready to go.
<pre>
apt install mysql-server mysql-client libmysqlclient-dev
apt install python3-mysqldb # if using python to access mysql
mysql_secure_installation
</pre>

ERROR in UBUNTU 22.04 solved here:
https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233

Log in as root to mysql database
<pre>
mysql -u root -p mysql
select * from user;
delete from user where host = 'myserver'; # not needed if secure installation completed above
create user barney@localhost identified by 'xxxxxxxx';
create database bookstore;
grant all privileges on bookstore.* to barney@localhost; # regular account
grant select on bookstore.* to barney@localhost; # read-only account
grant lock tables on bookstore.* to barney@localhost; # need lock tables to run mysqldump
grant file on *.* to barney@localhost; # write output to files
flush privileges;
</pre>

== Show Permissions ==
Logged in as root:
<pre>
show grants for barney@localhost;
</pre>

==File I/O==
You should have already granted "file" privileges to user:
<pre>
grant file on *.* to barney@localhost;
flush privileges;
</pre>

To execute SQL commands in a text file (from the command line):
<pre>
mysql -u barney -p bookstore < mycommands.sql
</pre>

To execute SQL commands in a text file (from the mysql prompt):
<pre>
mysql> use bookstore;
mysql> source /home/barney/sql/mycommands.sql;
</pre>

To read data out to a file (NOTE: The <code>mysql</code> user can only write to the <code>/var/lib/mysql-files/</code> directory):
<pre>
select ... into outfile "/var/lib/mysql-files/goodbooks.txt";
</pre>

To load a file into a table:
<pre>
load data local infile "/home/barney/sql/goodbooks.txt" into table books;
</pre>

Save into a CSV file:
<pre>
select * from users into outfile '/tmp/users.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\n';
</pre>

== Backing up and restoring a database ==
To back up the database "bookstore" to a file sq5.sql:
<pre>
export MYSQL_PWD=XXXXX
mysqldump --no-tablespaces --opt bookstore > bookstore.sql
</pre>
To restore a database from backup (overwrites any existing):
<pre>
mysql -u root -p bookstore < bookstore.sql
</pre>

== Searching on three-character words ==
* Edit <code>/etc/mysql/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
<pre>
[mysqld]
ft_min_word_len=3
</pre>
* Restart mysql.
* For each table you are doing a fulltext search on, run this command:
<pre>
repair table <table_name> quick;
</pre>
* Restart mysql and any dependent apps.

== Create database/table example ==
<pre>
drop database if exists edapt_quiz;
create database edapt_quiz;
use edapt_quiz;

drop table if exists quizzes;
create table quizzes (
id int unsigned not null auto_increment,
name varchar(64) not null,
primary key (id)
) engine=innodb;
insert into quizzes (name) values ('Prodromal Questionnaire – Brief Version');

drop table if exists questions;
create table questions (
id int unsigned not null auto_increment,
quiz_id int unsigned not null,
sort_order smallint,
text text,
primary key (id),
foreign key (quiz_id) references quizzes(id)
) engine=innodb;
</pre>

== Troubleshooting ==
When attempting to load a database from a mysqldump backup, you get
<blockquote>
'''ERROR 1227 (42000) at line 81: Access denied; you need (at least one of) the SUPER privilege(s) for this operation'''
</blockquote>
You need to remove all DEFINER lines from the mysqldump file:
<pre>
sed 's/DEFINER=[^*]*\*/\*/g' backup.sql > new_backup.sql
</pre>

Mysql

2024-03-28T19:14:29Z

Scott: /* Searching on three-character words */

== Ubuntu setup ==
Have a <code>mysql</code> root password ready to go.
<pre>
apt install mysql-server mysql-client libmysqlclient-dev
apt install python3-mysqldb # if using python to access mysql
mysql_secure_installation
</pre>

ERROR in UBUNTU 22.04 solved here:
https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233

Log in as root to mysql database
<pre>
mysql -u root -p mysql
select * from user;
delete from user where host = 'myserver'; # not needed if secure installation completed above
create user barney@localhost identified by 'xxxxxxxx';
create database bookstore;
grant all privileges on bookstore.* to barney@localhost; # regular account
grant select on bookstore.* to barney@localhost; # read-only account
grant lock tables on bookstore.* to barney@localhost; # need lock tables to run mysqldump
grant file on *.* to barney@localhost; # write output to files
flush privileges;
</pre>

== Show Permissions ==
Logged in as root:
<pre>
show grants for barney@localhost;
</pre>

==File I/O==
You should have already granted "file" privileges to user:
<pre>
grant file on *.* to barney@localhost;
flush privileges;
</pre>

To execute SQL commands in a text file (from the command line):
<pre>
mysql -u barney -p bookstore < mycommands.sql
</pre>

To execute SQL commands in a text file (from the mysql prompt):
<pre>
mysql> use bookstore;
mysql> source /home/barney/sql/mycommands.sql;
</pre>

To read data out to a file (NOTE: The <code>mysql</code> user can only write to the <code>/var/lib/mysql-files/</code> directory):
<pre>
select ... into outfile "/var/lib/mysql-files/goodbooks.txt";
</pre>

To load a file into a table:
<pre>
load data local infile "/home/barney/sql/goodbooks.txt" into table books;
</pre>

Save into a CSV file:
<pre>
select * from users into outfile '/tmp/users.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\n';
</pre>

== Backing up and restoring a database ==
To back up the database "bookstore" to a file sq5.sql:
<pre>
export MYSQL_PWD=XXXXX
mysqldump --no-tablespaces --opt bookstore > bookstore.sql
</pre>
To restore a database from backup (overwrites any existing):
<pre>
mysql -u root -p bookstore < bookstore.sql
</pre>

== Searching on three-character words ==
* Edit <code>/etc/mysql/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
<pre>
[mysqld]
ft_min_word_len=3
</pre>
* Restart mysql.
* For each table you are doing a fulltext search on, run this command:
<pre>
repair table <table_name> quick;
</pre>

== Create database/table example ==
<pre>
drop database if exists edapt_quiz;
create database edapt_quiz;
use edapt_quiz;

drop table if exists quizzes;
create table quizzes (
id int unsigned not null auto_increment,
name varchar(64) not null,
primary key (id)
) engine=innodb;
insert into quizzes (name) values ('Prodromal Questionnaire – Brief Version');

drop table if exists questions;
create table questions (
id int unsigned not null auto_increment,
quiz_id int unsigned not null,
sort_order smallint,
text text,
primary key (id),
foreign key (quiz_id) references quizzes(id)
) engine=innodb;
</pre>

== Troubleshooting ==
When attempting to load a database from a mysqldump backup, you get
<blockquote>
'''ERROR 1227 (42000) at line 81: Access denied; you need (at least one of) the SUPER privilege(s) for this operation'''
</blockquote>
You need to remove all DEFINER lines from the mysqldump file:
<pre>
sed 's/DEFINER=[^*]*\*/\*/g' backup.sql > new_backup.sql
</pre>

Mysql

2024-03-28T19:08:24Z

Scott: /* Searching on three-character words */

== Ubuntu setup ==
Have a <code>mysql</code> root password ready to go.
<pre>
apt install mysql-server mysql-client libmysqlclient-dev
apt install python3-mysqldb # if using python to access mysql
mysql_secure_installation
</pre>

ERROR in UBUNTU 22.04 solved here:
https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233

Log in as root to mysql database
<pre>
mysql -u root -p mysql
select * from user;
delete from user where host = 'myserver'; # not needed if secure installation completed above
create user barney@localhost identified by 'xxxxxxxx';
create database bookstore;
grant all privileges on bookstore.* to barney@localhost; # regular account
grant select on bookstore.* to barney@localhost; # read-only account
grant lock tables on bookstore.* to barney@localhost; # need lock tables to run mysqldump
grant file on *.* to barney@localhost; # write output to files
flush privileges;
</pre>

== Show Permissions ==
Logged in as root:
<pre>
show grants for barney@localhost;
</pre>

==File I/O==
You should have already granted "file" privileges to user:
<pre>
grant file on *.* to barney@localhost;
flush privileges;
</pre>

To execute SQL commands in a text file (from the command line):
<pre>
mysql -u barney -p bookstore < mycommands.sql
</pre>

To execute SQL commands in a text file (from the mysql prompt):
<pre>
mysql> use bookstore;
mysql> source /home/barney/sql/mycommands.sql;
</pre>

To read data out to a file (NOTE: The <code>mysql</code> user can only write to the <code>/var/lib/mysql-files/</code> directory):
<pre>
select ... into outfile "/var/lib/mysql-files/goodbooks.txt";
</pre>

To load a file into a table:
<pre>
load data local infile "/home/barney/sql/goodbooks.txt" into table books;
</pre>

Save into a CSV file:
<pre>
select * from users into outfile '/tmp/users.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\n';
</pre>

== Backing up and restoring a database ==
To back up the database "bookstore" to a file sq5.sql:
<pre>
export MYSQL_PWD=XXXXX
mysqldump --no-tablespaces --opt bookstore > bookstore.sql
</pre>
To restore a database from backup (overwrites any existing):
<pre>
mysql -u root -p bookstore < bookstore.sql
</pre>

== Searching on three-character words ==
* Edit <code>/etc/mysql/conf.d/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section:
<pre>
ft_min_word_len=3
</pre>
* Restart mysql.
* For each table you are doing a fulltext search on, run this command:
<pre>
repair table <table_name> quick;
</pre>

== Create database/table example ==
<pre>
drop database if exists edapt_quiz;
create database edapt_quiz;
use edapt_quiz;

drop table if exists quizzes;
create table quizzes (
id int unsigned not null auto_increment,
name varchar(64) not null,
primary key (id)
) engine=innodb;
insert into quizzes (name) values ('Prodromal Questionnaire – Brief Version');

drop table if exists questions;
create table questions (
id int unsigned not null auto_increment,
quiz_id int unsigned not null,
sort_order smallint,
text text,
primary key (id),
foreign key (quiz_id) references quizzes(id)
) engine=innodb;
</pre>

== Troubleshooting ==
When attempting to load a database from a mysqldump backup, you get
<blockquote>
'''ERROR 1227 (42000) at line 81: Access denied; you need (at least one of) the SUPER privilege(s) for this operation'''
</blockquote>
You need to remove all DEFINER lines from the mysqldump file:
<pre>
sed 's/DEFINER=[^*]*\*/\*/g' backup.sql > new_backup.sql
</pre>

Mediawiki

2024-03-24T15:37:30Z

Scott: /* Install on Ubuntu */

{{lowercase title}}

== Install on Ubuntu ==
* ASSUMPTION: MySQL is already installed
* install the following packages:
<pre>
apt install imagemagick php-cli php-fpm php-intl php-mbstring php-mysql php-xml
</pre>
* If the web server is running under a separate deploy user, you will need to edit <code>/etc/php/7.?/fpm/pool.d/www.conf</code> and change the user for <code>listen.owner</code> and <code>listen.group</code>

== Upgrade from tarball ==
* read all Release Notes
* download new tarball from http://www.mediawiki.org/wiki/Download
* unpack in deploy@myserver:wiki/
* copy over LocalSettings.php (which is a pointer to ~/wiki/var/LocalSettings.php)
* make images point to ../var/images
* in extensions, make links to folders in ~/wiki/var/extensions
* make a link to your ../var/my-logo-image.png file (and make sure $wgLogo matches in LocalSettings.php)
* run the database update script:
<pre>
php maintenance/update.php
</pre>

== Increase the maximum upload file size ==
* Edit <code>/etc/php5/apache2/php.ini</code> to change this line:
<pre>
; Maximum allowed size for uploaded files.
upload_max_filesize = 200M
</pre>
* restart apache

== Allow additional file types for upload ==
* Edit <code>/etc/mediawiki/LocalSettings.php</code> and add something like this:
<pre>
$wgFileExtensions = array('png', 'gif', 'jpg', 'jpeg', 'doc', 'xls', 'pdf', 'txt');
</pre>

== Add your own logo image ==
* create a 135x135-pixel logo image and save as png
* copy the png file to <code>/var/lib/mediawiki1.10/skins/common/images</code>
* edit <code>/etc/mediawiki1.10/LocalSettings.php</code> to include this line:
<pre>
$wgLogo = "/mediawiki/skins/common/images/mylogo.png";
</pre>

== Clean up the navigation sidebar ==
* log in as the admin user
* edit the wiki page http://localhost/mediawiki/index.php/MediaWiki:Sidebar

== Lowercase Page Titles ==
* This helps you fix the titles of pages like "iPhone" that mediawiki automatically converts to "IPhone".
* install and enable the ParserFunctions extension:
<pre>
apt-get install mediawiki-extensions (if not already installed)
mwenext ParserFunctions.php
</pre>
* open the page Template:Lowercase_title for editing.
* add this code:
<pre>
<span>{{DISPLAYTITLE:{{#if:{{NAMESPACE}}|{{NAMESPACE}}:|}}{{lcfirst:{{PAGENAME}}}}}}</span><noinclude>
{{documentation}}
</noinclude>
</pre>
This can be found on Wikipedia: http://en.wikipedia.org/w/index.php?title=Template:Lowercase_title&action=edit
* add this line to the top of each affected page:
<pre>
{{lowercase title}}
</pre>

== Syntax highlighting ==
Use the GeSHi extension included with <code>mediawiki-extensions</code>: http://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi

== Custom edit buttons ==
* download the icons you want to use: http://commons.wikimedia.org/wiki/Mediawiki_edit_toolbar
* download the icons in the images tree and find out where they ended up
* open the MediaWiki:Common.js page on your wiki for editing and add something like this
<source lang="javascript">
if (mwCustomEditButtons) {

mwCustomEditButtons[mwCustomEditButtons.length] = {
"imageFile": "images/2/23/Button_code.png",
"speedTip": "inline <code> tag",
"tagOpen": "<code>",
"tagClose": "</code>",
"sampleText": "Insert code here"};

mwCustomEditButtons[mwCustomEditButtons.length] = {
"imageFile": "images/3/3c/Button_pre.png",
"speedTip": "block <pre> tag",
"tagOpen": "<pre>\n",
"tagClose": "\n</pre>",
"sampleText": "Insert code here"}
}
</source>
* hold down the shift key and hit refresh on the browser to get the page to completely reload

== Delete History ==
* Make sure the <code>php5-cli</code> package is installed.
* cd to <code>/usr/share/mediawiki/maintenance</code>
* run this:
<pre>
sudo php deleteOldRevisions.php --delete
</pre>

== Back up the wiki ==
Use a command like this to dump the wiki database to a flat file:
<pre>
/usr/bin/mysqldump --opt -u barney -pXXXXXXXX wikidb > /backup/wikidb.sql
</pre>

May need this command in <code>mysql</code> to get it to work:
<pre>
grant lock tables on *.* to barney@localhost;
flush privileges;
</pre>

== OLD ==

=== Setup ===
On Ubuntu, install the <code>mediawiki</code> package. May also want <code>mediawiki-extensions</code> and <code>mediawiki-math</code>.

https://help.ubuntu.com/community/MediaWiki
* uncomment alias line of <code>/etc/apache2/conf.d/mediawiki1.10.conf</code>
* restart apache2
* open a browser window and visit http://localhost/mediawiki
* fill out installation form
* move <code>/var/lib/mediawiki1.10/config/LocalSettings.php</code> to <code>/etc/mediawiki1.10/</code>

Python Cryptography Tools

2024-02-09T00:15:08Z

Scott:

== Encoding ==
Integers can be '''encoded''' as either binary, decimal, hexadecimal, or Base64 (among others).
<pre>
>>> bin(95616)
'0b10111010110000000'
>>> hex(95616)
'0x17580'
>>> import base64
>>> base64.b64encode(95616)
TypeError: a bytes-like object is required, not 'int'
</pre>

== Converting to Bytes ==
The most straightforward way to convert number-like objects into bytes-like objects seems to involve converting to string first.
<pre>
>>> bytes(bin(95616), 'ascii')
b'0b10111010110000000'
>>> bytes(hex(95616), 'ascii')
b'0x17580'
>>> base64.b64encode(bytes(str(95616), 'ascii'))
b'OTU2MTY='
</pre>

[https://en.wikipedia.org/wiki/Base64 Base64] uses 64 characters (and a padding symbol) to represent numbers in groups of six bits. These don't line up nicely with sequences of bytes.

== XOR ==
<pre>
decoded_hex1 = bytes.fromhex("1c0111001f010100061a024b53535009181c")
decoded_hex2 = bytes.fromhex("686974207468652062756c6c277320657965")
xor_result = bytes(a ^ b for a, b in zip(decoded_hex1, decoded_hex2))
</pre>

== Hamming Distance ==
<pre>
def hammingDistance(bytes1, bytes2):
distance = 0
for a, b in zip(bytes1, bytes2):
xor_result = a ^ b
distance += bin(xor_result).count("1")
return distance
</pre>

Python Cryptography Tools

2024-02-09T00:13:05Z

Scott:

Python Cryptography Tools

2024-02-08T23:52:45Z

Scott:

Python Cryptography Tools

2024-02-08T23:51:59Z

Scott: /* Converting to Bytes */

Python Cryptography Tools

2024-02-08T23:36:40Z

Scott:

Python Cryptography Tools

2024-02-08T23:18:18Z

Scott: /* Encoding */

Python Cryptography Tools

2024-02-08T23:17:57Z

Scott: Created page with "== Encoding == Integers can be '''encoded''' as either binary, decimal, hexadecimal, or Base64 (among others). <pre> >>> bin(95616) '0b10111010110000000' >>> hex(95616) '0x17580' >>> import base64 >>> base64.b64encode(95616) ... TypeError: a bytes-like object is required, not 'int' </pre>"

Main Page

2024-02-08T23:11:11Z

Scott:

__NOTOC__
== Programming ==
{|
|width="120px"|
| |
|-
|'''bash'''
|[[bash|Notes]]
|-
|'''C/C++ '''
|[[C Basics]] | [[C++ Basics]] | [[C++ I/O]] | [[CUDA C]] | [[Objective C]] | [[iPhone]]
|-
|'''Go'''
|[[Go Basics|Basics]] | [[Go Strings|Strings]]
|-
|'''HTML and CSS'''
|[[HTML and CSS|Notes]]
|-
|'''Java'''
|[[Java Basics|Basics]] | [[Java I/O|I/O]] | [[Java Objects|Objects]] | [[Java Properties Files|Properties Files]] | [[Java System Calls|System Calls]] | [[log4j]]
|-
|'''JavaScript'''
|[[JavaScript Basics|Basics]] | [[AngularJS]] | [[jQuery]] | [[JavaScript mailto Trick]] | [[Dojo Basics]] | [[Dojo Data Stores]] | [[E4X]] | [[Prototype]]
|-
|'''Matlab'''
|[[Matlab|Basics]]
|-
|'''Perl'''
|[[Perl Basics|Basics]] | [[Perl I/O|I/O]] | [[Perl Command-Line Arguments|Command-Line Arguments]] | [[Perl Subroutines|Subroutines]] | [[Perl Regular Expressions|Regular Expressions]] | [[Installing Perl Modules|Installing Modules]] | [[Example Perl Scripts|Example Scripts]]
|-
|'''PHP'''
|[[PHP|Basics]]
|-
|'''Python'''
|[[Python Basics|Basics]] | [[Python I/O|I/O]] | [[Python Modules|Modules]] | [[Python Regular Expressions|Regular Expressions]] | [[Python Date and Time|Date and Time]] | [[Python System Calls|System Calls]] | [[matplotlib]] | [[scipy]] | [[Python Curses|curses]]
|-
|'''Python3'''
|[[Python3 Basics|Basics]] | [[Python 3 I/O|I/O]] | [[Python Cryptography Tools]]
|-
|'''R'''
|[[R Basics|Basics]] | [[R Graphics|Graphics]] | [[R I/O|I/O]] | [[R Packages|Packages]] | [[R Statistics|Statistics]]
|-
|'''Ruby'''
|[[Ruby Basics|Basics]] | [[Ruby Classes and Modules|Classes and Modules]] | [[Ruby Data Structures|Data Structures]] | [[Ruby I/O|I/O]] | [[RVM]]
|-
|'''Ruby on Rails'''
|[[Rails Basics|Basics]] | [[Rails Form Examples]] | [[Rails 4 Notes]] | [[Nginx, Passenger, and Rails]]
|-
|'''Rails 3'''
|[[Rails 3 Basics|Basics]] | [[Rails 3 Model|Model]] | [[Rails 3 View|View]] | [[Rails 3 Controller|Controller]]
|}

== Packages and Commands ==
[[7zip]] |
[[apache]] |
[[autofs]] |
[[awk]] |
[[awstats]] |
[[ccrypt]] |
[[certbot]] |
[[chkconfig]] |
[[crontab]] |
[[date]] |
[[dd]] |
[[diff]] |
[[dirvish]] |
[[docker]]

[[emacs]] |
[[fastcgi++]] |
[[find]] |
[[gimp]] |
[[git]] |
[[gnuplot]] |
[[goaccess]] |
[[gpg]] |
[[iozone]] |
[[iptables]] |
[[locate]] |
[[mail]] |
[[mediawiki]]

[[mercurial]] |
[[mtr]] |
[[mysql]] |
[[netplan]] |
[[nfs4]] |
[[nginx]] |
[[openssl]] |
[[postgresql]] |
[[ps]] |
[[quota]] |
[[rbenv]] |
[[rsync]]

[[screen]] |
[[sed]] |
[[smartctl]] |
[[sort]] |
[[split]] |
[[ssh]] |
[[Sublime Text|subl]] |
[[subversion]] |
[[supervisor]] |
[[systemd]] |
[[tar]] |
[[thin]] |
[[tr]]

[[ufw]] |
[[update-rc.d]] |
[[usermod]] |
[[vi]] |
[[virtualbox]] |
[[xargs]] |
[[xsendfile]] |
[[youtube]] |
[[yum]] |
[[zfs]] |
[[zip]]

== Linux How-To ==
[[How to set up two-factor authentication|2FA (two-factor authentication)]] |
[[How to add a new disk drive|add a new disk drive]] |
[[How to back up and restore a partition|back up and restore a partition]] |
[[How to burn a DVD|burn a DVD]]

[[How to change a server's hostname|change a server's hostname]] |
[[Linux file compression|compress/decompress files and directories]] |
[[How to create an ISO file from a CD-ROM|create an ISO file from a CD-ROM]]

[[How to find a MAC address|find a MAC address]] |
[[How to find an executable|find an executable]] |
[[How to free kernel memory|free kernel memory]] |
[[How to interrogate a computer's hardware|interrogate a computer's hardware]]

[[How to manage quotas|manage quotas]] |
[[How to monitor performance|monitor performance]] |
[[How to mount an ISO|mount an ISO]] |
[[How to mount an LVM partition|mount an LVM partition]] |
[[How to optimize a solid state drive|optimize a solid state drive]]

[[How to repair GRUB|repair GRUB]] |
[[How to re-create /dev/null|re-create <code>/dev/null</code>]] |
[[How to set up Ubuntu Server|set up Ubuntu Server]] |
[[How to set up Ubuntu Desktop|set up Ubuntu Desktop]] |
[[How to set up a VPS|set up VPS]]

[[Ubuntu keyboard shortcuts]] |
[[How to use a tape drive|use a tape drive]] |
[[How to wipe a hard drive|wipe a hard drive]]

== Mac and Windows ==
'''Mac'''

[[Mac Orientation]]

'''Windows'''

[[Windows access control lists|access control lists]] | [[Windows administrative login|administrative login]] | [[Windows file sharing|file sharing]] | [[Windows minimum hardware requirements|minimum hardware requirements]] | [[Windows offline files|offline files]]

[[Recover files from a non-booting Windows PC|recover files]] | [[Windows remote desktop|remote desktop]] | [[Windows security|security]] | [[Windows services|services]] | [[Windows shell programming|shell programming]] | [[Windows troubleshoot network connection|troubleshoot network connection]] | [[Windows wisdom|wisdom]]

== Math ==
[[Exponential Moving Average]] | [[Statistics]]

== Biology ==
[[Brain]] | [[MRI]] | [[fMRI]] | [[Bioinformatics]]

== Books ==
[[Guide to the Good Life]] | [[How We Decide]] | [[Logic of Life]] | [[New Abs Diet]] | [[Parenting]]

[[Power of Habit]] | [[Predictably Irrational]] | [[Run]] | [[Run Faster]] | [[Sapiens]] | [[Spark]] | [[Total Heart Rate Training]]

== Other ==
[[Wiki Formatting Cheat Sheet]] | [[Recipes]] | [[Diet]] | [[Quotes]] | [[Alberto Salazar's Ten Golden Rules]]
| [[Buddhism]] | [[Favorite Booze]]

Git

2024-01-24T20:02:40Z

Scott: /* Overwrite local from repository */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git reset --hard origin/master
</pre>

== Overwrite a single file from repository ==
<pre>
git checkout HEAD~ <filename>
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2024-01-05T23:42:59Z

Scott: /* Git Server */

== Initial Setup ==
<pre>
git config --global user.name "Harry Truman"
git config --global user.email "harry.truman@example.com"
git config --global --list
</pre>
May need to set up SSH-key authentication for gitlab.

== Clone Repository ==
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
</pre>

== Upload Existing Code Directory as Gitlab Repository ==
First, creat a new project on gitlab. Then, on the local dev machine:
<pre>
git clone git@gitlab.com:scottcamacmartin/my_project.git
cd my_project
# then copy code into new folder my_project
# DELETE ANY SENSITIVE PASSWORDS, ETC
# also set up .gitignore file
git status
git add .
git commit -m "initial commit"
git push -u origin master
</pre>

== Overwrite local from repository ==
<pre>
git fetch --all
git reset --hard origin/master
</pre>

== Cheat Sheets ==
https://about.gitlab.com/images/press/git-cheat-sheet.pdf

https://github.com/kenmueller/gitignore

== Git Server ==
https://git-scm.com/book/en/v2/Git-on-the-Server-Setting-Up-the-Server
<pre>
/opt/git-server/bin # refresh-auth command
/opt/git-server/keys # ssh keys
/opt/git-server/repos # home directory with repos
/opt/git-server/repos/.ssh # authorized_users file
</pre>
<pre>
root@perth:/etc# grep git /etc/passwd
git:x:222:222:Git Service User:/opt/git-server/repos:/usr/bin/git-shell
root@perth:/etc# grep git /etc/group
git:x:222:
root@perth:/etc# grep git /etc/shadow
git:*:17767:0:99999:7:::
</pre>
<pre>
root@perth:/opt/git-server/bin# cat refresh-auth
#!/bin/bash

GIT_SERVER_DIR=/opt/git-server
KEY_DIR=$GIT_SERVER_DIR/keys
SSH_KEY_FILE=$GIT_SERVER_DIR/repos/.ssh/authorized_keys
SSH_KEY_PREFIX="no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding"

find $KEY_DIR -type f -exec grep -v '#' {} \; | awk '$1' | sort -u | sed -e "s/^/${SSH_KEY_PREFIX} /" > $SSH_KEY_FILE
</pre>
<pre>
root@perth:/opt/git-server/keys# ls -l
total 16
drwxr-xr-x 2 root root 4096 Nov 28 16:28 dc
drwxr-xr-x 2 root root 4096 Nov 30 10:18 martin
drwxr-xr-x 2 root root 4096 Nov 28 16:28 root
drwxr-xr-x 2 root root 4096 Nov 28 16:28 statsuser
</pre>
<pre>
root@perth:/opt/git-server/keys/martin# cat adelaide
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIDbyBYOnAoKLyNvittK+xyEt01NPnPC2XUFKz4bHeolz martin@adelaide
</pre>

=== Initialize repository ===
As root on git server:
<pre>
cd ~git
mkdir project.git
cd project.git
git init --bare
cd ..
chown -R git.git project.git
</pre>
As developer on developer PC:
<pre>
cd project
emacs .gitignore # include a line with "**/.hg" to exclude .hg content
git init
git add .
git commit -m 'Initial commit'
git remote add origin git@irc-git-host:project.git
git push origin master
</pre>
As another user:
<pre>
git clone git@irc-git-host:project.git
</pre>

Git

2024-01-05T23:39:04Z

Scott: /* Git Server */

Git

2024-01-05T23:36:47Z

Scott: /* Cheat Sheets */

Git

2024-01-01T16:21:05Z

Scott: /* Cheat Sheets */