Skip to content

Instantly share code, notes, and snippets.

Installing dev environment on openvario

opkg install make git gcc-symlinks binutils libgcc-s-dev libc6-dev

Openvario SD Card Backup and Restore

Backup

On Openvario:

tar c /home/root /var/lib/connman /etc/opkg/ /etc/dropbear /opt/conf | gzip > /var/backups/openvario-backup.tar.gz
# See https://wiki.archlinux.org/index.php/ConnMan
$ connmanctl
connmanctl> technologies
connmanctl> enable wifi
connmanctl> scan wifi
connmanctl> services
connmanctl> agent on
connmanctl> connect wifi_1cbfcebf32fe_6b65646e65742d322e3467_managed_psk
@kedder
kedder / migrate_psql_to_mysql.py
Created October 12, 2019 20:55
Simple script to copy data from postgresql database to mysql with the same schema
"""Convert postgres database to mysql on live running servers
Schemas in both databases should match.
"""
from pprint import pprint
import pymysql.cursors
import psycopg2
import psycopg2.extras
ID CALL CN TYPE HANDICAP NAME
FLRDDA96D IK LS 4 104 Andrius Tamulėnas
OGN54773E FL ASW 20a 108 Darius Gudžiūnas
FLRDDD93F M7 ASG 29/15m 114 Joris Vainius
FLRDDE2EA VM Discus 2a 110 Vladas Motūza
FLRDDDD7C MZ HPH 304 CZ17 111 Mindaugas Žaliukas
FLRDDEFDE LR2 LAK 17a/15m 112 Gvidas Sabeckis
FLRDDE9CF LR JS 1 119 Gintaras Drevinskas
FLRDDEFEB H8 LS 8 110 Ringaudas Kikalas
FLRD00426 PL Pegase 101A 102 Darius Liaugaudas
<Task fai_finish="0" finish_min_height_ref="AGL" finish_min_height="0" start_max_height_ref="AGL" start_max_height="0" start_max_speed="0" start_requires_arm="0" aat_min_time="10800" type="RT">
<Point type="Start">
<Waypoint altitude="50" comment="Turn Point" id="28" name="Birstonas">
<Location latitude="54.6028" longitude="24.0347"/>
</Waypoint>
<ObservationZone length="10000" type="Line"/>
</Point>
<Point type="Turn">
<Waypoint altitude="160" comment="Turn Point" id="318" name="Sventezeris">
<Location latitude="54.2411" longitude="23.6442"/>

Keybase proof

I hereby claim:

  • I am kedder on github.
  • I am kedder (https://keybase.io/kedder) on keybase.
  • I have a public key whose fingerprint is B173 1DDA E8ED FBC8 90D9 E831 D9EC 3170 23D5 B880

To claim this, I am signing this object:

@kedder
kedder / colorize
Created June 1, 2015 07:33
Colorize stream to one color (with bash)
#!/bin/bash
declare -A colours
colours["black"]=$'\e[0;30m'
colours["red"]=$'\e[0;31m'
colours["green"]=$'\e[0;32m'
colours["yellow"]=$'\e[0;33m'
colours["blue"]=$'\e[0;34m'
colours["purple"]=$'\e[0;35m'
colours["cyan"]=$'\e[0;36m'
colours["white"]=$'\e[0;37m'