Da Kiwi

bash_tips

anonymous@undisclosed.example.com (Anonymous) — Sat, 06 Aug 2011 15:10:48 +0000

2011/08/06 17:08		current
Line 91:		Line 91:

	The first command allows completion by pressing just [Tab], the second command adds a sign for each filetype (* for executable file)		The first command allows completion by pressing just [Tab], the second command adds a sign for each filetype (* for executable file)
		+
		+	====== Misc. tweaks ======
		+
		+	Activate timestamping in 'history':
		+	<code>
		+	export HISTTIMEFORMAT='%Y-%m-%d %H:%M:%S '
		+	</code>

	====== Useful links ======		====== Useful links ======

ssh

anonymous@undisclosed.example.com (Anonymous) — Wed, 21 Jun 2023 20:30:04 +0000

2013/12/09 02:12		current
Line 46:		Line 46:
	* install some proxy software (i.e., Squid)		* install some proxy software (i.e., Squid)
	* connect to the server, and map a port to the proxy's one:		* connect to the server, and map a port to the proxy's one:
		+
		+
	<code>		<code>
	ssh -R8181:localhost:3128 server_to_connect_to		ssh -R8181:localhost:3128 server_to_connect_to
	</code>		</code>
	* once connected, enter:		* once connected, enter:
		+
	<code>		<code>
	export http_proxy=http://127.0.0.1:8181		export http_proxy=http://127.0.0.1:8181

postgresql_upgrade_on_freebsd

anonymous@undisclosed.example.com (Anonymous) — Mon, 29 Sep 2025 11:54:15 +0000

2023/09/25 16:51		current
Line 2:		Line 2:

	For minimal downtime during migration, we will use `pg_upgrade` tool, which needs both old and new PostgreSQL binaries available. To do so, we will use FreeBSD's ports system, without `make clean` at first to keep compiled binaries.		For minimal downtime during migration, we will use `pg_upgrade` tool, which needs both old and new PostgreSQL binaries available. To do so, we will use FreeBSD's ports system, without `make clean` at first to keep compiled binaries.
-
	## A note about locales		## A note about locales

-	You might encounter weird locales issue while ensuing `initdb` command, like this:	+	You might encounter weird locale issue while ensuing `initdb` command, like this:

	```bash		```bash
Line 11:		Line 10:
	```		```

-	The only workaround I found was to disable locale detection in the source code:	+	This seems to be caused by a [remaining deprecated locale](https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=274718#c12). You can delete it by using the following command, depending on if you're running PostgreSQL in a jail (I didn't find a cleaner way, sorry):

-	```diff	+	```bash
-	--- /var/ports/basejail/usr/ports/databases/postgresql15-server/work/postgresql-15.2/src/backend/utils/adt/pg_locale.c 2023-08-22 18:55:52.003715000 +0200	+	sudo rm -rf /usr/share/locale/sr_YU.ISO8859-5
-	+++ /tmp/pg_locale.c 2023-08-22 18:54:40.437733000 +0200	+	sudo rm -rf /basejail/usr/share/locale/sr_YU.ISO8859-5
-	@@ -1727,8 +1727,8 @@	+
-	freelocale(loc);	+
-	}	+
-	else	+
-	- // ereport(ERROR,	+
-	- // (errmsg("could not load locale \"%s\"", collcollate)));	+
-	+ ereport(ERROR,	+
-	+ (errmsg("could not load locale \"%s\"", collcollate)));	+
-	#elif defined(WIN32) && _WIN32_WINNT >= 0x0600	+
-	/*	+
-	* If we are targeting Windows Vista and above, we can ask for a name	+
	```		```
-
-	You can apply this patch while compiling new version's port (issue `make`, stop it with ctrl+c after download and extract, patch, then issue `make` again)

	## Compile old and new version from ports		## Compile old and new version from ports

ipsec

anonymous@undisclosed.example.com (Anonymous) — Fri, 09 Mar 2012 21:43:38 +0000

2011/01/30 14:26		current
Line 1:		Line 1:
	====== IPSec for FreeBSD's jails communication ======		====== IPSec for FreeBSD's jails communication ======

-	Abstract: Here we assume we have two FreeBSD hosts, A using public IP 1.1.1.1 and internal virtual net 192.168.3.0 for jails, and B using public IP 2.2.2.2 and internal net 192.168.6.0 for jails. We need hosts and jails to communicate together, preferably in a encrypted way.	+	Abstract: Here we assume we have two FreeBSD hosts, A using public IP 1.1.1.1 and internal virtual net 192.168.3.0 for jails, and B using public IP 2.2.2.2 and internal net 192.168.6.0 for jails. We need hosts and jails to communicate together, preferably in a crypted way.

	===== Preparation on both hosts =====		===== Preparation on both hosts =====

mysql

anonymous@undisclosed.example.com (Anonymous) — Sun, 05 Apr 2026 09:06:50 +0000

2022/08/04 15:35		current
Line 161:		Line 161:

	* stop slave		* stop slave
-	<code sql>	+
		+	```sql
	mysql> STOP SLAVE;		mysql> STOP SLAVE;
-	</code>	+	```
	* either manually delete the duplicate entry, or skip counter by issuing:		* either manually delete the duplicate entry, or skip counter by issuing:
-	<code sql>	+
		+	```sql
	mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;		mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
-	</code>	+	```
	* start slave		* start slave
-	<code sql>	+
		+	```sql
	mysql> START SLAVE;		mysql> START SLAVE;
-	</code>	+	```

	==== rebuild database indexes ====		==== rebuild database indexes ====

start

anonymous@undisclosed.example.com (Anonymous) — Mon, 25 Sep 2023 09:54:04 +0000

2023/08/25 13:49		current
Line 11:		Line 11:
	* [[public:vimbashfactory\|How to quickly create fully functional shell scripts using VIM]]		* [[public:vimbashfactory\|How to quickly create fully functional shell scripts using VIM]]
	* [[public:wipeliveserver\|Wipe/shred/nuke a living server]]		* [[public:wipeliveserver\|Wipe/shred/nuke a living server]]
		+	FreeBSD
		+	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]
		+	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]
		+	* [[public:postgresql_upgrade_on_freebsd\|Migration a PostgreSQL cluster using FreeBSD ports]]
	<newcolumn>		<newcolumn>
	Networking		Networking
Line 24:		Line 28:
	* [[public:ics4n1\|Some notes on installing Android 4.0 (ICS) on the Nexus One]]		* [[public:ics4n1\|Some notes on installing Android 4.0 (ICS) on the Nexus One]]
	* [[public:groupware_toaster\|Lightweight groupware solution using nginx+php-fpm+mysql+baïkal+roundcube+agendav]]		* [[public:groupware_toaster\|Lightweight groupware solution using nginx+php-fpm+mysql+baïkal+roundcube+agendav]]
-	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]	+
-	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]	+
	</columns>		</columns>

zsh

anonymous@undisclosed.example.com (Anonymous) — Mon, 18 Feb 2013 14:03:31 +0000

2013/02/18 10:00		current
Line 35:		Line 35:

	<code>		<code>
-	RPROMPT='%?	+	RPROMPT='%?'
	</code>		</code>

2023/08/25 13:49		current
Line 11:		Line 11:
	* [[public:vimbashfactory\|How to quickly create fully functional shell scripts using VIM]]		* [[public:vimbashfactory\|How to quickly create fully functional shell scripts using VIM]]
	* [[public:wipeliveserver\|Wipe/shred/nuke a living server]]		* [[public:wipeliveserver\|Wipe/shred/nuke a living server]]
		+	FreeBSD
		+	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]
		+	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]
		+	* [[public:postgresql_upgrade_on_freebsd\|Migration a PostgreSQL cluster using FreeBSD ports]]
	<newcolumn>		<newcolumn>
	Networking		Networking
Line 24:		Line 28:
	* [[public:ics4n1\|Some notes on installing Android 4.0 (ICS) on the Nexus One]]		* [[public:ics4n1\|Some notes on installing Android 4.0 (ICS) on the Nexus One]]
	* [[public:groupware_toaster\|Lightweight groupware solution using nginx+php-fpm+mysql+baïkal+roundcube+agendav]]		* [[public:groupware_toaster\|Lightweight groupware solution using nginx+php-fpm+mysql+baïkal+roundcube+agendav]]
-	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]	+
-	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]	+
	</columns>		</columns>