control of domain(s) associated with nextcloud snap

associate domain names with your nextcloud snap

$ nextcloud.occ config:system:set trusted_domains 1 \
--value=nextcloud.foo.bar
$ nextcloud.occ config:system:set trusted_domains 2 \
--value=192.168.1.11

and then get new certs from letsencrypt

$ nextcloud.enable-https lets-encrypt

from:
https://medium.com/@dbclin/administrating-nextcloud-as-a-snap-4eb43ca6d095

android games without ads or in-app-purchases

solitaire

https://play.google.com/store/apps/details?id=com.IskoGames.SolitaireCardGames&hl=en&gl=us $0

https://play.google.com/store/apps/details?id=com.brasskeysoftware.yukongold&hl=en&gl=us $1.99

tetris

https://play.google.com/store/apps/details?id=com.voriacorporation.tetris&hl=en&gl=us $0

https://play.google.com/store/apps/details?id=woodblock.puzzle.brick.tetris&hl=en&gl=us $0

Also some games on f-droid like 2048

copy of https://arkienet.com/2018/01/google-fi-dialer-codes/ for posterity

Google Fi Dialer Codes

Here are a list of dialer codes that can be used with Google Fi.  These codes shouldn’t be used unless you are aware that they may impact the way your Fi phone switches between carriers.

 

Carrier Selection

The following options are only available for “Designed for Fi” phones. They will not work on the iPhone or “Compatible with Fi” phones because they are T-Mobile only.  See which class of phone you have here.

ALPHA CODE DIALER CODE DESCRIPTION
FI AUTO *#*#342886#*#* Set carrier selection to automatic.
FI NEXT *#*#346398#*#* Select Next Carrier
FI SPR *#*#34777#*#* Select Sprint for 2 hours
FI TMO *#*#34866#*#* Select T-Mobile 2 hours
FI USC *#*#34872#*#* Select US Cellular 2 hours
FI SIMON *#*#3474666#*#* Select Three (UK only)

Service Codes

ALPHA CODE DIALER CODE DESCRIPTION
FIXME *#*#34963#*#* Force reactivation
FI INFO *#*#344636#*#* Get information about the current network.
INFO *#*#4636#*#* Get general phone information.
DEBUG *#*#33284#*#* Phone Debug Options
PRL *#*#775#*#* Force download of Preferred Roaming List (Sprint)
PRL *228 Force download of Preferred Roaming List (US Cellular)
FI ROAM *#*#347626#*#* Turn on International Roaming
SWITCH
SIM
*#*#794824746#*#* Switch to / from eSim.

install lineageOS on blueline (pixel 3)

copy of https://lineageosroms.com/blueline/ for posterity

Install LineageOS on blueline

Basic requirements

  1. Make sure your computer has adb and fastboot. Setup instructions can be found here.
  2. Enable USB debugging on your device.

Unlocking the bootloader

  1. Enable OEM unlock in the Developer options under device Settings, if present.
  2. Connect the device to your PC via USB.
  3. On the computer, open a command prompt (on Windows) or terminal (on Linux or macOS) window, and type:
    adb reboot bootloader
    

    You can also boot into fastboot mode via a key combination:

    • With the device powered off, hold Volume Down + Power.
  4. Once the device is in fastboot mode, verify your PC finds it by typing:
    fastboot devices
    
  5. Now type the following command to unlock the bootloader:
    fastboot flashing unlock
    
  6. If the device doesn’t automatically reboot, reboot it. It should now be unlocked.
  7. Since the device resets completely, you will need to re-enable USB debugging to continue.

Temporarily booting a custom recovery using fastboot

  1. Download a custom recovery – you can download Lineage Recovery. Simply download the latest recovery file, named something like lineage-17.1-20201116-recovery-blueline.img.
  2. Connect your device to your PC via USB.
  3. On the computer, open a command prompt (on Windows) or terminal (on Linux or macOS) window, and type:
    adb reboot bootloader
    

    You can also boot into fastboot mode via a key combination:

    • With the device powered off, hold Volume Down + Power.
  4. Once the device is in fastboot mode, verify your PC finds it by typing:
    fastboot devices
    
  5. Temporarily flash a recovery on your device by typing:
    fastboot flash boot <recovery_filename>.img
    
  6. With the device powered off, hold Volume Down + Power.

Installing LineageOS from recovery

  1. Download the LineageOS installation package that you would like to install or build the package yourself.
    • Optionally, download additional application packages such as Google Apps (use the arm64 architecture).
  2. If you are not in recovery, reboot into recovery:
    • With the device powered off, hold Volume Down + Power.
  3. Now tap Factory Reset, then Format data / factory reset and continue with the formatting process. This will remove encryption and delete all files stored in the internal storage, as well as format your cache partition (if you have one).
  4. Return to the main menu.
  5. Sideload the LineageOS .zip package:
    • On the device, select “Apply Update”, then “Apply from ADB” to begin sideload.
    • On the host machine, sideload the package using: adb sideload filename.zip
  6. (Optionally): If you want to install any additional add-ons, click Advanced, then Reboot to Recovery, then when your device reboots, click Apply Update, then Apply from ADB, then adb sideload filename.zip those packages in sequence.
  7. Once you have installed everything successfully, click the back arrow in the top left of the screen, then “Reboot system now”.

Update to a newer build of the same LineageOS version on blueline

Updating your device

Using the LineageOS Updater app

  1. Open Settings, navigate to “System”, then “Updater”.
  2. Click the Refresh Icon in the top right corner.
  3. Choose which update you’d like and press “Download”.
  4. When the download completes, click “Install”. Once the update process has finished, the device will display a “Reboot” button, you may need to go into the Updater menu in Settings, “System” to see it. This will reboot you into the updated system.

From your PC via the push_update script (Linux/macOS only)

  1. Make sure your computer has working adb. Setup instructions can be found here.
  2. Enable USB debugging on your device. Additionally, open Settings, then “System”, then “Developer Options”, and then either check “Rooted Debugging” (LineageOS 17.1 or above) or select “Root Access Options”, then “ADB Only”.
  3. Run adb root
  4. Run wget
    https://raw.githubusercontent.com/LineageOS/android_packages_apps_Updater/lineage-16.0/push-update.sh
    && chmod +x push-update.sh
  5. Run: ./push-update.sh /path/to/zip
  6. Open Settings, navigate to “System”, then “Updater”. click “Install”. Once the update process has finished, the device will display a “Reboot” button, you may need to go into the Updater menu in Settings, “System” to see it. This will reboot you into the updated system.

backup/install android app from adb

search elsewhere for how to enable developer mode, and how to enable usb debugging.

#then find the fullname of the app

$adb shell 'pm list packages' |grep i foo
package:com.bar.android.foo

#Then find the path to the app

$ adb shell pm path com.bar.android.foo
package:/data/app/com.bar.android.foo-asdfasdfasdfasdfasdfas==/base.apk

# then download the app

$ adb pull /data/app/com.bar.android.foo-asdfasdfasdfasdfasdfas==/base.apk

#then later or on another device restore the app

$ adb install -r base.apk

 

psql restore from pg_dump file – invalid command \N

when searching for this error ‘invalid command \N’ when trying to restore my database from a backup I made with the following:

$ pg_dump -d foo -t bar > bar.psql

I got lots of suggestions but what I needed was to drop the darn table before restoring it …

$psql
foo=> drop table bar;

$psql < bar.psql

julia postgres libpq update example

The Julia community seems shy about posting examples of database things…

use LibPQ, Tables

db="db" 
server="localhost" 
usr="psql"
passwd="nope"

conn = LibPQ.Connection("host=$server dbname=$db user=$usr password=$passwd")
sql = """select char from foo""" 

conn2 = LibPQ.Connection("host=$server dbname=$db user=$usr password=$passwd") 
sql2 = prepare(conn2, """update bar set agility = \$1 , bravery = \$2 where char = \$3""" ) 

response = execute(conn, sql) 

for row in rowtable(response)
  ag = agility(row[:char])
  br = bravery(row[:char])
  execute(sql2, (ag, br, row[:char]))
end