Da Kiwi

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

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

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>

syntax

anonymous@undisclosed.example.com (Anonymous) — Wed, 22 Jul 2026 19:16:28 +0000

2025/05/26 15:34		current
Line 9:		Line 9:
	DokuWiki supports bold, //italic//, __underlined__ and ''monospaced'' texts.		DokuWiki supports bold, //italic//, __underlined__ and ''monospaced'' texts.
	Of course you can __//''combine''//__ all these.		Of course you can __//''combine''//__ all these.
		+
		+	Note that the formatting markers have to directly enclose the text, so ''%% bold %%'' with spaces inside the markers will not be formatted.

	You can use <sub>subscript</sub> and <sup>superscript</sup>, too.		You can use <sub>subscript</sub> and <sup>superscript</sup>, too.
Line 156:		Line 158:
	{{wiki:dokuwiki-128.png }}		{{wiki:dokuwiki-128.png }}
	{{ wiki:dokuwiki-128.png }}		{{ wiki:dokuwiki-128.png }}
		+
		+	You can also set the alignment explicitly with a ''?left'', ''?right'' or ''?center'' parameter. This takes precedence over the whitespace alignment above and can be combined with a size.
		+
		+	{{wiki:dokuwiki-128.png?100&right}}
		+
		+	{{wiki:dokuwiki-128.png?100&right}}

	Of course, you can add a title (displayed as a tooltip by most browsers), too.		Of course, you can add a title (displayed as a tooltip by most browsers), too.

deinstall_removed_port

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

2026/07/27 04:46	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.

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>

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>

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

dokuwiki

anonymous@undisclosed.example.com (Anonymous) — Mon, 26 May 2025 13:34:07 +0000

2026/07/27 04:46	current
Line 1:	Line 1:
	+	====== DokuWiki ======
	+
	+	[[doku>wiki:dokuwiki\|{{wiki:dokuwiki-128.png }}]] DokuWiki is a simple to use and highly versatile Open Source [[wp>wiki]] software that doesn't require a database. It is loved by users for its clean and readable [[wiki:syntax]]. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in [[doku>acl\|access controls]] and [[doku>auth\|authentication connectors]] make DokuWiki especially useful in the enterprise context and the large number of [[doku>plugins]] contributed by its vibrant community allow for a broad range of use cases beyond a traditional wiki.
	+
	+	Read the [[doku>manual\|DokuWiki Manual]] to unleash the full power of DokuWiki.
	+
	+	===== Download =====
	+
	+	DokuWiki is available at https://download.dokuwiki.org/
	+
	+
	+	===== Read More =====
	+
	+	All documentation and additional information besides the [[syntax\|syntax description]] is maintained in the DokuWiki at [[doku>\|www.dokuwiki.org]].
	+
	+	About DokuWiki
	+
	+	* [[doku>features\|A feature list]] :!:
	+	* [[doku>users\|Happy Users]]
	+	* [[doku>press\|Who wrote about it]]
	+	* [[doku>blogroll\|What Bloggers think]]
	+	* [[https://www.wikimatrix.org/show/DokuWiki\|Compare it with other wiki software]]
	+
	+	Installing DokuWiki
	+
	+	* [[doku>requirements\|System Requirements]]
	+	* [[https://download.dokuwiki.org/\|Download DokuWiki]] :!:
	+	* [[doku>changes\|Change Log]]
	+	* [[doku>Install\|How to install or upgrade]] :!:
	+	* [[doku>config\|Configuration]]
	+
	+	Using DokuWiki
	+
	+	* [[doku>syntax\|Wiki Syntax]]
	+	* [[doku>manual\|The manual]] :!:
	+	* [[doku>FAQ\|Frequently Asked Questions (FAQ)]]
	+	* [[doku>glossary\|Glossary]]
	+
	+	Customizing DokuWiki
	+
	+	* [[doku>tips\|Tips and Tricks]]
	+	* [[doku>Template\|How to create and use templates]]
	+	* [[doku>plugins\|Installing plugins]]
	+	* [[doku>development\|Development Resources]]
	+
	+	DokuWiki Feedback and Community
	+
	+	* [[doku>newsletter\|Subscribe to the newsletter]] :!:
	+	* [[doku>mailinglist\|Join the mailing list]]
	+	* [[https://forum.dokuwiki.org\|Check out the user forum]]
	+	* [[doku>irc\|Talk to other users in the IRC channel]]
	+	* [[https://github.com/splitbrain/dokuwiki/issues\|Submit bugs and feature wishes]]
	+	* [[doku>thanks\|Some humble thanks]]
	+
	+
	+	===== Copyright =====
	+
	+	2004-2020 (c) Andreas Gohr <andi@splitbrain.org>((Please do not contact me for help and support -- use the [[doku>mailinglist]] or [[https://forum.dokuwiki.org\|forum]] instead)) and the DokuWiki Community
	+
	+	The DokuWiki engine is licensed under [[https://www.gnu.org/licenses/gpl.html\|GNU General Public License]] Version 2. If you use DokuWiki in your company, consider [[doku>donate\|donating]] a few bucks ;-).
	+
	+	Not sure what this means? See the [[doku>faq:license\|FAQ on the Licenses]].

fofox

anonymous@undisclosed.example.com (Anonymous) — Sat, 25 Jul 2026 14:43:59 +0000

2026/07/25 16:43		current
Line 17:		Line 17:
	* [[https://addons.mozilla.org/firefox/addon/darkreader/\|Dark Reader]] : "Darth" mode everywhere!		* [[https://addons.mozilla.org/firefox/addon/darkreader/\|Dark Reader]] : "Darth" mode everywhere!
	* [[https://addons.mozilla.org/firefox/addon/twitter-to-nitter/\|Twitter to Nitter]] : Redirects Twitter (X) links to Nitter		* [[https://addons.mozilla.org/firefox/addon/twitter-to-nitter/\|Twitter to Nitter]] : Redirects Twitter (X) links to Nitter
-	*
	====== Some Userscripts ======		====== Some Userscripts ======

2026/07/27 04:46	current
Line 1:	Line 1:
	+	====== DokuWiki ======
	+
	+	[[doku>wiki:dokuwiki\|{{wiki:dokuwiki-128.png }}]] DokuWiki is a simple to use and highly versatile Open Source [[wp>wiki]] software that doesn't require a database. It is loved by users for its clean and readable [[wiki:syntax]]. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in [[doku>acl\|access controls]] and [[doku>auth\|authentication connectors]] make DokuWiki especially useful in the enterprise context and the large number of [[doku>plugins]] contributed by its vibrant community allow for a broad range of use cases beyond a traditional wiki.
	+
	+	Read the [[doku>manual\|DokuWiki Manual]] to unleash the full power of DokuWiki.
	+
	+	===== Download =====
	+
	+	DokuWiki is available at https://download.dokuwiki.org/
	+
	+
	+	===== Read More =====
	+
	+	All documentation and additional information besides the [[syntax\|syntax description]] is maintained in the DokuWiki at [[doku>\|www.dokuwiki.org]].
	+
	+	About DokuWiki
	+
	+	* [[doku>features\|A feature list]] :!:
	+	* [[doku>users\|Happy Users]]
	+	* [[doku>press\|Who wrote about it]]
	+	* [[doku>blogroll\|What Bloggers think]]
	+	* [[https://www.wikimatrix.org/show/DokuWiki\|Compare it with other wiki software]]
	+
	+	Installing DokuWiki
	+
	+	* [[doku>requirements\|System Requirements]]
	+	* [[https://download.dokuwiki.org/\|Download DokuWiki]] :!:
	+	* [[doku>changes\|Change Log]]
	+	* [[doku>Install\|How to install or upgrade]] :!:
	+	* [[doku>config\|Configuration]]
	+
	+	Using DokuWiki
	+
	+	* [[doku>syntax\|Wiki Syntax]]
	+	* [[doku>manual\|The manual]] :!:
	+	* [[doku>FAQ\|Frequently Asked Questions (FAQ)]]
	+	* [[doku>glossary\|Glossary]]
	+
	+	Customizing DokuWiki
	+
	+	* [[doku>tips\|Tips and Tricks]]
	+	* [[doku>Template\|How to create and use templates]]
	+	* [[doku>plugins\|Installing plugins]]
	+	* [[doku>development\|Development Resources]]
	+
	+	DokuWiki Feedback and Community
	+
	+	* [[doku>newsletter\|Subscribe to the newsletter]] :!:
	+	* [[doku>mailinglist\|Join the mailing list]]
	+	* [[https://forum.dokuwiki.org\|Check out the user forum]]
	+	* [[doku>irc\|Talk to other users in the IRC channel]]
	+	* [[https://github.com/splitbrain/dokuwiki/issues\|Submit bugs and feature wishes]]
	+	* [[doku>thanks\|Some humble thanks]]
	+
	+
	+	===== Copyright =====
	+
	+	2004-2020 (c) Andreas Gohr <andi@splitbrain.org>((Please do not contact me for help and support -- use the [[doku>mailinglist]] or [[https://forum.dokuwiki.org\|forum]] instead)) and the DokuWiki Community
	+
	+	The DokuWiki engine is licensed under [[https://www.gnu.org/licenses/gpl.html\|GNU General Public License]] Version 2. If you use DokuWiki in your company, consider [[doku>donate\|donating]] a few bucks ;-).
	+
	+	Not sure what this means? See the [[doku>faq:license\|FAQ on the Licenses]].