Discover gists

This post is part of my Your own Virtual Private Server hosting solution project.
Get the latest version of this article here: https://gist.github.com/ddce334cd8ab21a40941.

Introduction

Let’s Encrypt is a free, automated, and open certificate authority (CA), run for the public’s benefit. So far it works well and makes it easy to obtain a free certificate. Now the created certificates will expire withing 90 days. This post will show you how you can auto renew these certificates before they expire.

Requirements

Ubuntu server

Reset MySQL 8.0 root Password in Windows

Stop the MySQL 8.0service from services
Go to path C:\Program Files\MySQL\MySQL Server 8.0\bin and open cmd
Run mysqld --console --skip-grant-tables --shared-memory
Open new cmd in the same path
Run following commands
mysql -u root
select authentication_string,host from mysql.user where user='root';
UPDATE mysql.user SET authentication_string='' WHERE user='root';

Titulo ou Arte do Projeto

Example Queries

1h active keys by location:

sum(max(increase(shadowsocks_data_bytes{access_key!=""} [1h])) by (access_key, location) > bool 0) by (location)

1h usage by location:

sum(increase(shadowsocks_data_bytes{dir=~"c<p|p>t"} [1h])) by (location)

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

Example

Complete Recent Discord Quest

Note

This no longer works in browser!

Note

This no longer works if you're alone in vc! Somebody else has to join you!

How to use this script:

Accept the quest under User Settings -> Gift Inventory

Instalaciones - Curso de React Native

Esta es la lista de instalaciones recomendadas para el curso de React Native, si encuentran enlaces adicionales o cambios en esta hoja, pueden hacerlos.

	alias: Ashley’s Light Fader
	description: >
	Fades a lamp over time. If you have any questions or comments about this
	script, feel free to tweet Ashley Bischoff at @FriendlyAshley. Released under
	the Apache 2.0 license. (v2.0)
	fields:
	light:
	name: 💡 Light
	description: entity_id of the lamp.
	selector:

	// Consumer usage
	class MyFragment : Fragment(R.layout.my_fragment) {
	private val viewModel: MyViewModel by viewModels()

	override fun onViewCreated(view: View, savedInstanceState: Bundle?) {
	super.onViewCreated(view, savedInstanceState)
	val consumer = consumeState(viewModel)
	}
	}