Da Kiwi

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

fofox

anonymous@undisclosed.example.com (Anonymous) — Wed, 06 May 2026 09:49:36 +0000

2026/04/10 22:11		current
Line 22:		Line 22:
	* [[http://userscripts-mirror.org/scripts/show/1052\|Check Range]] : allows to check multiple check-boxes at a time, using shift+left click		* [[http://userscripts-mirror.org/scripts/show/1052\|Check Range]] : allows to check multiple check-boxes at a time, using shift+left click
	* [[http://userscripts-mirror.org/scripts/show/100858\|Disable Youtube Autoplay]]: because I don't want a fucking jukebox		* [[http://userscripts-mirror.org/scripts/show/100858\|Disable Youtube Autoplay]]: because I don't want a fucking jukebox
-	* [[https://greasyfork.org/en/scripts/34651-disable-youtube-next-video-autoplay\|Disable Youtube next video autoplay]]: same as above, but for next video (unfortunatly the first one does not seem to work for that)	+	* [[https://greasyfork.org/fr/scripts/35769-auto-disable-youtube-autoplay-next-video-setting\|Auto Disable YouTube AutoPlay Next Video Setting]]: same as above, but for next video (unfortunately the first one does not seem to work for that)
	* [[https://cable.ayra.ch/tampermonkey/view.php?script=youtube_overlay_remover.user.js\|YT - Overlay remover]]: <del>hide cards/overlays on youtube videos</del> not working (anymore), use "www.youtube.com##.ytp-ce-element" in uBlock instead		* [[https://cable.ayra.ch/tampermonkey/view.php?script=youtube_overlay_remover.user.js\|YT - Overlay remover]]: <del>hide cards/overlays on youtube videos</del> not working (anymore), use "www.youtube.com##.ytp-ce-element" in uBlock instead
	* [[https://greasyfork.org/fr/scripts/375525-youtube-age-verification-bypass\|YouTube: Age Verification Bypass]]: yeah, I'm old enough and I do not want to login		* [[https://greasyfork.org/fr/scripts/375525-youtube-age-verification-bypass\|YouTube: Age Verification Bypass]]: yeah, I'm old enough and I do not want to login

openvpn

anonymous@undisclosed.example.com (Anonymous) — Sat, 06 Mar 2010 00:00:03 +0000

2010/03/06 00:56		current
Line 312:		Line 312:
	</code>		</code>

-	A zip file name <user>_vpn.zip will the be created in /tmp/ with all necessary files, send it to the user via encrypted channel; if you really do want to send it over e-mail, you can use [[http://caspian.dotconf.net/menu/Software/SendEmail/\|SendEmail]]:	+	A zip file name j.doe_vpn.zip will the be created in /tmp/ with all necessary files, send it to the user via encrypted channel; if you really do want to send it over e-mail, you can use [[http://caspian.dotconf.net/menu/Software/SendEmail/\|SendEmail]]:

	<code>		<code>
-	# sendEmail -f <sender> -t <recipient> -u "VPN certificate" -m "here it is." -a /tmp/<user>_vpn.zip	+	# sendEmail -f vpn@example.com -t j.doe@example.com -u "VPN certificate" -m "here it is." -a /tmp/j.doe_vpn.zip
	</code>		</code>

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>

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

exchange

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

2026/06/09 12:57	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/]]

vimbashfactory

anonymous@undisclosed.example.com (Anonymous) — Thu, 04 Aug 2022 13:31:20 +0000

2012/10/25 15:46		current
Line 4:		Line 4:
	* Install it (:source path_to_vim_script)		* Install it (:source path_to_vim_script)
	* Create the following script in .vim/templates/sh:		* Create the following script in .vim/templates/sh:
-	<code>	+
		+	<code bash>
	#!/bin/sh		#!/bin/sh

Line 58:		Line 59:
	exit 0		exit 0
	</code>		</code>
		+
	* Add the following line in .vimrc:		* Add the following line in .vimrc:
-	<code>	+
		+	<code vim>
	au BufWritePost * if getline(1) =~ "^#!" \| if getline(1) =~ "/bin/" \| silent !chmod a+x <afile> \| endif \| endif		au BufWritePost * if getline(1) =~ "^#!" \| if getline(1) =~ "/bin/" \| silent !chmod a+x <afile> \| endif \| endif
	</code>		</code>

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

my_own_ipv6_tips_for_servers

anonymous@undisclosed.example.com (Anonymous) — Sat, 30 Mar 2024 21:22:28 +0000

2023/06/21 22:25		current
Line 24:		Line 24:
	</code>		</code>
	* /etc/vsftpd_ipv6.conf:		* /etc/vsftpd_ipv6.conf:
		+
	<code>		<code>
	listen=NO		listen=NO
Line 50:		Line 51:
	remember that ipv6 needs icmp to work, so you have to enable it:		remember that ipv6 needs icmp to work, so you have to enable it:
	<code>		<code>
-	# ip6tables -A INPUT -p icmpv6 -j ACCEPT	+	# ip6tables -A INPUT -p icmpv6 -j ACCEPT
	</code>		</code>

deinstall_removed_port

anonymous@undisclosed.example.com (Anonymous) — Thu, 30 Jan 2020 10:00:07 +0000

2026/06/09 12:57	current
Line 1:	Line 1:
	+	====== Deinstall an already removed port on FreeBSD ======

	+	Sometimes we use alternate ports (in my case, openssl111, to get TLS 1.3 under nginx), and the port get replaced by another version (openssl111 got deleted and openssl was upgraded to 1.1.1)
	+
	+	pkg will process dependencies and uninstall all software built against openssl111. And we cannot "make deinstall" openssl111 as the port has been removed.
	+
	+	So assuming we are replacing a port with another one with the same version, we can create a temporary port. I use jails so I have to do this in basejail:
	+
	+	<code>
	+	cd /path/to/basejail/usr/ports
	+	cp -vrp openssl openssl111
	+	sed -i bak s/openssl/openssl111/ openssl111/Makefile
	+	cd openssl111
	+	make deinstall
	+	</code>
	+
	+	Voila! You just have to install openssl now.

groupware_toaster

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

2023/06/11 01:27		current
Line 147:		Line 147:

	* If using classic skin, replace the strange "interrogation mark" button by a prettier one:		* If using classic skin, replace the strange "interrogation mark" button by a prettier one:
		+
	<code bash>		<code bash>
	mv plugins/agendav/skins/classic/agendav.gif plugins/agendav/skins/classic/agendav.old.gif		mv plugins/agendav/skins/classic/agendav.gif plugins/agendav/skins/classic/agendav.old.gif

nagios_toaster

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

2013/08/18 22:27		current
Line 42:		Line 42:
	==== NConf integration ====		==== NConf integration ====
	* Add a link in the Nuvola menu. Edit /www/monitor/nagios/side/dtree_data.js, and add the following line at the end, just before the //document.write(configuration);// statemement:		* Add a link in the Nuvola menu. Edit /www/monitor/nagios/side/dtree_data.js, and add the following line at the end, just before the //document.write(configuration);// statemement:
		+
	<code js>		<code js>
	configuration.add(5,0,'Administration','/nconf/','','','side/icons/configuration.gif');		configuration.add(5,0,'Administration','/nconf/','','','side/icons/configuration.gif');

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

twi2fedi

anonymous@undisclosed.example.com (Anonymous) — Mon, 28 Aug 2023 09:58:57 +0000

2023/08/25 13:48		current
Line 1:		Line 1:
	====== Twitter to Fediverse Bots ======		====== Twitter to Fediverse Bots ======

-	Hi, as <del>Twitter</del>X have closed its public API a few months ago, this service no longer works. All bots accounts have been closed.	+	Hi, as <del>Twitter</del> 𝕏 have closed its public API a few months ago, this service no longer works. All bots accounts have been closed.

-	You can still find other <del>blue-bird</del> black-X bots at [@tootbot](https://amicale.net/@tootbot)!	+	You can still find other <del>blue-bird</del> black-𝕏 bots at [@tootbot](https://amicale.net/@tootbot)!

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>

2026/04/10 22:11		current
Line 22:		Line 22:
	* [[http://userscripts-mirror.org/scripts/show/1052\|Check Range]] : allows to check multiple check-boxes at a time, using shift+left click		* [[http://userscripts-mirror.org/scripts/show/1052\|Check Range]] : allows to check multiple check-boxes at a time, using shift+left click
	* [[http://userscripts-mirror.org/scripts/show/100858\|Disable Youtube Autoplay]]: because I don't want a fucking jukebox		* [[http://userscripts-mirror.org/scripts/show/100858\|Disable Youtube Autoplay]]: because I don't want a fucking jukebox
-	* [[https://greasyfork.org/en/scripts/34651-disable-youtube-next-video-autoplay\|Disable Youtube next video autoplay]]: same as above, but for next video (unfortunatly the first one does not seem to work for that)	+	* [[https://greasyfork.org/fr/scripts/35769-auto-disable-youtube-autoplay-next-video-setting\|Auto Disable YouTube AutoPlay Next Video Setting]]: same as above, but for next video (unfortunately the first one does not seem to work for that)
	* [[https://cable.ayra.ch/tampermonkey/view.php?script=youtube_overlay_remover.user.js\|YT - Overlay remover]]: <del>hide cards/overlays on youtube videos</del> not working (anymore), use "www.youtube.com##.ytp-ce-element" in uBlock instead		* [[https://cable.ayra.ch/tampermonkey/view.php?script=youtube_overlay_remover.user.js\|YT - Overlay remover]]: <del>hide cards/overlays on youtube videos</del> not working (anymore), use "www.youtube.com##.ytp-ce-element" in uBlock instead
	* [[https://greasyfork.org/fr/scripts/375525-youtube-age-verification-bypass\|YouTube: Age Verification Bypass]]: yeah, I'm old enough and I do not want to login		* [[https://greasyfork.org/fr/scripts/375525-youtube-age-verification-bypass\|YouTube: Age Verification Bypass]]: yeah, I'm old enough and I do not want to login