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

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 ====

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

exchange

anonymous@undisclosed.example.com (Anonymous) — Fri, 10 Aug 2012 12:55:16 +0000

2026/04/08 01:35	current
Line 1:	Line 1:
	+	====== Guide de survie sous Exchange ======

	+	===== LYNC =====
	+
	+	==== Utilisation avec Pidgin ====
	+
	+	* installer le plugin [[http://sipe.sourceforge.net\|Sipe]] (paquet pidgin-sipe sous Ubuntu)
	+	* aller à Comptes->Gérer les comptes->Ajouter un compte
	+
	+	le nom d'utilisateur est première lettre du prénom - nom de famille en entier ("jdoe" pour John Doe par exemple)
	+
	+	Entrer les informations comme suis
	+
	+	{{:public:pidlync1.png\|}}
	+
	+	{{:public:pidlync2.png\|}}
	+
	+	* sous Linux, un [[http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=649456#27\|bug]] dans nss peut empêcher pidgin de se connecter, vous allez avoir un message du type "Read Error". Dans ce cas il faut lancer la commande suivante avant de lancer Pidgin:
	+
	+	$ export NSS_SSL_CBC_RANDOM_IV=0
	+	$ nohup pidgin &
	+
	+	ou
	+
	+	$ NSS_SSL_CBC_RANDOM_IV=0 nohup pidgin &
	+
	+	* pour ajouter un contact, le format est le même que pour le nom d'utilisateur (première lettre du prénom - nom de famille en entier) suivi du domaine @global-fianet.fia
	+
	+	===== Calendriers =====
	+
	+	==== Utilisation avec Thunderbird ====
	+
	+	* installer le plugin [[https://addons.mozilla.org/fr/thunderbird/addon/lightning/\|Lightning]]
	+	* installer le plugin [[https://addons.mozilla.org/en-US/thunderbird/addon/exchange-20072010-calendar-/\|Exchange 2007/2010 Calendar and Tasks Provider]]
	+	* Aller dans Lightning, ajouter un nouveau calendrier
	+
	+	Entrer les informations comme suis
	+
	+	{{:public:thundexchange.png}}
	+
	+	Le nom de serveur devra être de la forme:
	+
	+	https://global-fianet\jdoe@exch-cas-1/EWS/Exchange.asmx
	+
	+	Plus d'information sur la page suivante: [[http://www.csc.fi/blogs/itsupport/using-exchange-2007-calendar-with-thunderbird-plugin/]]

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 =====

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>

vpn_vs_proxies

anonymous@undisclosed.example.com (Anonymous) — Tue, 21 Feb 2012 17:42:57 +0000

2012/02/21 18:41		current
Line 23:		Line 23:

	<code>		<code>
-	port-share //remoteserver// 443	+	port-share remoteserver 443
	</code>		</code>

wipeliveserver

anonymous@undisclosed.example.com (Anonymous) — Sun, 19 Nov 2023 21:00:26 +0000

2019/03/14 11:01		current
Line 3:		Line 3:
	<note important>WIP. Only tested on Debian 7.x</note>		<note important>WIP. Only tested on Debian 7.x</note>

-	<code>	+	<code bash>
-	mkdir /tmp/tmproot	+	#!/bin/bash
-	mount -t tmpfs none /tmp/tmproot	+
-	mkdir /tmp/tmproot/{bin,sbin,proc,sys,dev,run,usr,var,tmp,etc,root,oldroot}	+
-	mkdir -p /tmp/tmproot/usr/bin	+
-	mkdir -p /tmp/tmproot/dev/pts	+
-	mkdir -p /tmp/tmproot/lib/x86_64-linux-gnu /tmp/tmproot/lib64 /tmp/tmproot/usr/share /tmp/tmproot/usr/lib/x86_64-linux-gnu /tmp/tmproot/var/run/screen	+

-	#tmux	+	# script used to chroot/pivot a live system on tmpfs in order to wipe it
-	cp -vrp /usr/share/terminfo /tmp/tmproot/usr/share/	+	# only tested with Debian 7.11
-	*cp -vrp /usr/lib/x86_64-linux-gnu/libevent /tmp/tmproot/usr/lib/x86_64-linux-gnu/**	+	#
-	*cp -vrp /lib/x86_64-linux-gnu/ /tmp/tmproot/lib/x86_64-linux-gnu/**	+	# first copy and execute it:
-	cp -vrp /lib64/ld-linux-x86-64.so.2 /tmp/tmproot/lib64/	+	# scp pivotroot.sh root@<remote_host>:/tmp/
-	cp -vrp /sbin/* /tmp/tmproot/sbin/	+	# ssh root@<remote_host> bash /tmp/pivotroot.sh
-	*cp -vrp /bin/ /tmp/tmproot/bin/**	+	#
-	cp -vrp /usr/bin/shred /usr/bin/ldd /usr/bin/screen /usr/bin/tmux /tmp/tmproot/usr/bin/	+	# you will then be able to connect again to it on port 666 (change it if you like) and do what you want
		+	#
		+	# note: bash is the default shell under debian so there will be bashisms (don't run it with Bourne shell)
		+	#

-	#cp -a /dev/zero /dev/random /dev/sda /tmp/tmproot/dev/	+	apt-get install -y dropbear screen tmux
-	cp -*a /dev/ /tmp/tmproot/dev/**	+

-	mount -t proc proc /tmp/tmproot/proc	+	CHROOTDIR='/tmp/tmproot'
-	mount --bind /dev/pts /tmp/tmproot/dev/pts	+	CHROOTPORT=666
-	chmod g+w /tmp/tmproot/run	+
-	chmod a+x /tmp/tmproot/tmp	+

-	apt-get install -y dropbear	+	mkdir ${CHROOTDIR}
-	cp /usr/sbin/dropbear /tmp/tmproot/sbin/	+	mount -t tmpfs none ${CHROOTDIR}
-	#cp -vrp /etc/dropbear /tmp/tmproot/etc/	+
-	#cp -vrp /etc/passwd* /etc/shadow* /etc/group* /etc/shells /tmp/tmproot/etc/	+	mkdir ${CHROOTDIR}/{bin,sbin,proc,sys,dev,run,usr,var,tmp,etc,root,oldroot}
-	cp -*vrp /etc/ /tmp/tmproot/etc**/	+	mkdir -p ${CHROOTDIR}/usr/bin
-	echo "" > /tmp/tmproot/root/.bash_history	+	mkdir -p ${CHROOTDIR}/lib/x86_64-linux-gnu ${CHROOTDIR}/lib64 ${CHROOTDIR}/usr/share ${CHROOTDIR}/usr/lib/x86_64-linux-gnu ${CHROOTDIR}/var/run/screen
-	echo "TERM=xterm-16color" >>/tmp/tmproot/root/.profile	+
		+	mount -t proc proc ${CHROOTDIR}/proc
		+	mount --bind /dev ${CHROOTDIR}/dev
		+	mount --bind /dev/pts ${CHROOTDIR}/dev/pts
	mount --make-rprivate / # necessary for pivot_root to work		mount --make-rprivate / # necessary for pivot_root to work
-	pivot_root /tmp/tmproot /tmp/tmproot/oldroot
-	/sbin/dropbear -p 666

-	ssh -p 666 root@host	+	cp -vrp /usr/share/terminfo ${CHROOTDIR}/usr/share/
		+	*cp -vrp /usr/lib/x86_64-linux-gnu/libevent ${CHROOTDIR}/usr/lib/x86_64-linux-gnu/**
		+	*cp -vrp /lib/x86_64-linux-gnu/ ${CHROOTDIR}/lib/x86_64-linux-gnu/**
		+	cp -vrp /lib64/ld-linux-x86-64.so.2 ${CHROOTDIR}/lib64/
		+	*cp -vrp /sbin/ ${CHROOTDIR}/sbin/**
		+	*cp -vrp /bin/ ${CHROOTDIR}/bin/**
		+	cp -vrp /usr/bin/id /usr/bin/shred /usr/bin/ldd /usr/bin/screen /usr/bin/tmux ${CHROOTDIR}/usr/bin/
		+	cp -vrp /usr/sbin/dropbear ${CHROOTDIR}/sbin/
		+
		+	*#cp -vrp /etc/passwd /etc/shadow* /etc/group* /etc/shells ${CHROOTDIR}/etc/**
		+	#cp -vrp /etc/dropbear ${CHROOTDIR}/etc/
		+	*cp -vrp /etc/ ${CHROOTDIR}/etc/**
		+
		+	chmod g+w ${CHROOTDIR}/run
		+
		+	echo "" > ${CHROOTDIR}/root/.bash_history
		+	{
		+	echo "TERM=xterm-16color" #necessary for tmux/screen to work
		+	echo "alias halt=\"echo 'o' > /proc/sysrq-trigger\""
		+	echo "alias reboot=\"echo 'b' > /proc/sysrq-trigger\""
		+	} >> ${CHROOTDIR}/root/.profile
		+
		+	pivot_root ${CHROOTDIR} ${CHROOTDIR}/oldroot
		+	/sbin/dropbear -p ${CHROOTPORT}

-	tmux -s shred	+	echo
-	#shred -z -v /dev/sda	+	echo "system pivot-rooted."
		+	echo "you can now connect with ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -p ${CHROOTPORT} root@$(hostname), launch screen/tmux and shred"
		+	echo "and finaly use reboot or halt commands (warning: they are not the real thing...)"
		+	echo
		+	echo "happy wiping!"
		+	echo

-	ssh -p 666 root@host
-	#tmux a -t shred
-	#echo "o" > /proc/sysrq-trigger
	</code>		</code>

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>