rti

## mysqlToJson.py
import re
import csv
import json
import sys
import requests
from requests.auth import HTTPBasicAuth
import hashlib
'''
	Usage: 'python3 mysqlToJson.py <targetFile.sql>


## arch_sec_install.sh
#!/bin/bash

# 0 - SSH
# This isn't necessary but if you ssh into the computer all the other steps are copy and paste
# Set a password for root
passwd
# Get network access
iwctl

"""

## root-podman-wayland.sh
# Install docker or podman package on your distro (podman doesn't need a daemon like dockerd to work). All args are exactly same, just replace ``podman`` with ``docker`` in command if you want to.
sudo pacman -S podman

# Run an archlinux container with dbus and wayland sockets.
sudo podman run                                                    \
  --volume "$XDG_RUNTIME_DIR/$WAYLAND_DISPLAY":/tmp/wayland-0 \
  --device /dev/dri                                           \
  --volume /run/user/1000/bus:/tmp/bus              \
  --rm -it archlinux /bin/bash

## keychron_linux.md

      
              1 file
            
          
              161 forks
            
          
              157 comments
            
          
              1051 stars
            
          
                andrebrait
                / keychron_linux.md
            
            
              Last active
              May 19, 2024 16:00
            
              
                Keychron keyboards on Linux + Bluetooth fixes
              
          
    Here is the best setup (I think so :D) for K-series Keychron keyboards on Linux.
Note: many newer Keychron keyboards use QMK as firmware and most tips here do not apply to them. Maybe the ones related to Bluetooth can be useful, but everything related to Apple's keyboard module (hid_apple) on Linux, won't work. As far as I know, all QMK-based boards use the hid_generic module instead. Examples of QMK-based boards are: Q, Q-Pro, V, K-Pro, etc.
Most of these commands have been tested on Ubuntu 20.04 and should also work on most Debian-based distributions.
If a command happens not to work for you, take a look in the comment section.
Make Fn + F-keys work (NOT FOR QMK-BASED BOARDS)

Older Keychron keyboards (those not based on QMK) use the hid_apple driver on Linux, even in the Windows/Android mode, both in Bluetooth and Wired modes.

  
## proxy.md

      
              1 file
            
          
              77 forks
            
          
              3 comments
            
          
              243 stars
            
          
                yougg
                / proxy.md
            
            
              Last active
              May 23, 2024 11:36
            
              
                complete ways to set http/socks/ssh proxy environment variables 
              
          
    set http or socks proxy environment variables

# set http proxy
export http_proxy=http://PROXYHOST:PROXYPORT

# set http proxy with user and password
export http_proxy=http://USERNAME:PASSWORD@PROXYHOST:PROXYPORT

# set http proxy with user and password (with special characters)

  
## gtk.css
/* ~/.config/gtk-3.0/gtk.css */

@import url("file:///usr/share/themes/Emacs/gtk-3.0/gtk-keys.css");

@binding-set gtk-alt-clipboard {
  bind "<alt>x" { "cut-clipboard" () };
  bind "<alt>c" { "copy-clipboard" () };
  bind "<alt>v" { "paste-clipboard" () };
}

## index.html
<html>
  <head>
    <title>CSS Transform Scale element to fit its parent</title>
    <script src="scale2fit.js"></script>
    <link rel="stylesheet" href="style.css"/>
    <script>
      (function(window) {
        function main() {
          const margin = 10;
          requestAnimationFrame(function fitToParentOnResize() {

## fix-infinality.md

      
              1 file
            
          
              50 forks
            
          
              157 comments
            
          
              723 stars
            
          
                cryzed
                / fix-infinality.md
            
            
              Last active
              May 8, 2024 17:00
            
              
                A set of instructions on how to fix the harfbuzz + Infinality issue and restoring good-looking, Infinality-like font rendering.
              
          
    Disclaimer: Please follow this guide being aware of the fact that I'm not an expert regarding the things outlined below, however I made my best attempt. A few people in IRC confirmed it worked for them and the results looked acceptable.
Attention: After following all the steps run gdk-pixbuf-query-loaders --update-cache as root, this prevents various gdk-related bugs that have been reported in the last few hours. Symptoms are varied, and for Cinnamon the DE fails to start entirely while for XFCE the icon theme seemingly can't be changed anymore etc.
Check the gist's comments for any further tips and instructions, especially if you are running into problems!
Screenshots

Results after following the guide as of 11.01.2017 13:08:

  
## nginx.conf
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
	import re
	import csv
	import json
	import sys
	import requests
	from requests.auth import HTTPBasicAuth
	import hashlib
	'''
	Usage: 'python3 mysqlToJson.py <targetFile.sql>
	#!/bin/bash

	# 0 - SSH
	# This isn't necessary but if you ssh into the computer all the other steps are copy and paste
	# Set a password for root
	passwd
	# Get network access
	iwctl

	"""
	# Install docker or podman package on your distro (podman doesn't need a daemon like dockerd to work). All args are exactly same, just replace ``podman`` with ``docker`` in command if you want to.
	sudo pacman -S podman

	# Run an archlinux container with dbus and wayland sockets.
	sudo podman run \
	--volume "$XDG_RUNTIME_DIR/$WAYLAND_DISPLAY":/tmp/wayland-0 \
	--device /dev/dri \
	--volume /run/user/1000/bus:/tmp/bus \
	--rm -it archlinux /bin/bash
	/* ~/.config/gtk-3.0/gtk.css */

	@import url("file:///usr/share/themes/Emacs/gtk-3.0/gtk-keys.css");

	@binding-set gtk-alt-clipboard {
	bind "<alt>x" { "cut-clipboard" () };
	bind "<alt>c" { "copy-clipboard" () };
	bind "<alt>v" { "paste-clipboard" () };
	}
	<html>
	<head>
	<title>CSS Transform Scale element to fit its parent</title>
	<script src="scale2fit.js"></script>
	<link rel="stylesheet" href="style.css"/>
	<script>
	(function(window) {
	function main() {
	const margin = 10;
	requestAnimationFrame(function fitToParentOnResize() {
	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'