Best sources to download solana mainnet snapshots

Download the snapshots using wget.

  cd snapshots
  wget --trust-server-names <URL>

US East / NYC

naviat / Reset MySQL Root Password in Mac OS.md

Created June 7, 2024 22:50 — forked from zubaer-ahammed/Reset MySQL Root Password in Mac OS.md

Reset MySQL Root Password in Mac OS

Reset mysql root password in Mac OS:

First Stop MySQL:

Go to: 'System Preferences' >> 'MySQL' and stop MySQL

OR,

sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop

naviat / gist:5aa38daecd620d5735b7d3996b2357e6

Created April 3, 2024 00:55 — forked from egonelbre/gist:1311842

Design Patterns in GO

	///////
	// Warning, code untested
	///////

	type Thinger interface {
	SomeMethod( arg bool ) bool
	}

	type RealThing struct {
	state bool

naviat / instructions.md

Created January 15, 2024 21:07 — forked from matthewjberger/instructions.md

Install a nerd font on ubuntu

1.) Download a Nerd Font

2.) Unzip and copy to ~/.fonts

3.) Run the command fc-cache -fv to manually rebuild the font cache

naviat / gist:fbce54e6b1b68dbc9cea0e9149e36188

Created May 29, 2023 08:05 — forked from luckydev/gist:ed966a7c12fd4b1311c063b77dc81389

Reset Google authenticator token (2FA) for a specific openvpn user

	SSH Login as openvpnas user

	$ ssh openvpnas@<open-vpn-server-ip>
	$ cd /usr/local/openvpn_as/scripts/ # Go to OpenVPN AS Scripts directory
	$ sudo ./sacli --user USERNAME GoogleAuthRegen # Replace USERNAME with username to get a new Google Authenticator Secret

	Source: https://forums.openvpn.net/viewtopic.php?t=15366

naviat / post-to-slack.sh

Created April 20, 2023 05:01 — forked from stekhn/post-to-slack.sh

Post to Slack using curl on the command line. The incoming webhook for your Slack team needs to be created beforehand.

	# Read more about Slack webhooks here: https://api.slack.com/messaging/webhooks

	curl -X POST \
	-H 'Content-type: application/json; charset=utf-8' \
	--data '{ "channel": "#mychannel", "username": "superbot", "icon_emoji": ":bot:", "text": "Foo" }' \
	https://hooks.slack.com/services/T00000000/B00000000/XXXXXXXXXXXXXXXXXXXXXXXX

naviat / .gitattributes

Created February 16, 2023 06:56 — forked from webbertakken/.gitattributes

.gitattributes for Unity projects

	#
	# Git attributes for Unity projects
	#
	# Compiled by the GameCI community - https://game.ci
	#
	# Latest version at https://gist.github.com/webbertakken/ff250a0d5e59a8aae961c2e509c07fbc
	#

	# Ensure that text files that any contributor introduces to the repository have their line endings normalized
	* text=auto

naviat / slowquery_logger.sh

Created November 30, 2022 02:24 — forked from theprogrammerin/slowquery_logger.sh

Bash script to fetch the log for that hour from Amazon RDS and push it to ElasticSearch / Kibana

	#!/bin/bash
	#
	# Ashutosh Agrawal
	# http://blog.theprogrammer.in
	#
	#
	# This bash script simply fetches the log for that hour from Amazon RDS,
	# parse and genarlise it using mysql_slow_log_parser (https://gist.github.com/theprogrammerin/e3206a4ec7a7a4086ac2)
	# and then push the parsed log to elastic search using logstash (slowquery.conf)(https://gist.github.com/theprogrammerin/034a3efd849112d166ea)
	# For analysis on analytic tool like kibana.

naviat / simple-k8s-backup.sh

Created November 8, 2022 15:12 — forked from mweibel/simple-k8s-backup.sh

Simple k8s backup if you don't yet have k8up or velero in place. Use with caution. Extend extracted values as needed.

	#!/bin/bash

	set -o pipefail -o errexit -o nounset -o errtrace

	mkdir -p backup/

	for ns in $(kubectl get ns --no-headers -o jsonpath='{range .items[*]}{.metadata.name}{"\n"}{end}'); do
	kubectl --namespace="${ns}" get -o=yaml role,rolebinding,secret,configmap \| \
	yq eval '
	del(

naviat / mapping.yaml

Created October 6, 2022 08:30 — forked from mweibel/mapping.yaml

banzaicloud/logging-operator working ElasticSearch example with index lifecycle management

	apiVersion: v1
	kind: Secret
	metadata:
	name: index-template
	stringData:
	template: '{"index_patterns":["logstash-*"],"template":{"aliases":{"logstash":{}},"mappings":{"dynamic":"true","dynamic_date_formats":["strict_date_optional_time","yyyy/MM/dd HH:mm:ss Z\|\|yyyy/MM/dd Z"],"dynamic_templates":[]},"settings":{"index":{"lifecycle":{"name":"logstash_policy","rollover_alias":"logstash"},"number_of_shards":"1","number_of_replicas":"0"}}}}'

Harry Dam naviat

Best sources to download solana mainnet snapshots

US East / NYC

Reset mysql root password in Mac OS:

First Stop MySQL: