Intern:Benutzer:PaulRiegel/Panik - Versionsgeschichte

PaulRiegel: /* MySQL */

2018-11-01T03:12:17Z

MySQL

← Nächstältere Version		Version vom 1. November 2018, 05:12 Uhr
Zeile 81:		Zeile 81:

	* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]		* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]

			== Zugang ==

			=== gang muskul ===

			; Vorname.Nachname: SsjFSJBWtNO

	== Siehe auch ==		== Siehe auch ==

	* [[user:PaulRiegel/TrueOS]]		* [[user:PaulRiegel/TrueOS]]

PaulRiegel am 1. Dezember 2017 um 11:51 Uhr

2017-12-01T11:51:34Z

← Nächstältere Version		Version vom 1. Dezember 2017, 13:51 Uhr
Zeile 81:		Zeile 81:

	* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]		* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]

			== Siehe auch ==

			* [[user:PaulRiegel/TrueOS]]

PaulRiegel: /* rsync Allgemein */

2017-07-10T12:53:17Z

rsync Allgemein

← Nächstältere Version		Version vom 10. Juli 2017, 14:53 Uhr
Zeile 26:		Zeile 26:
	: vom Rechner auf den Server schieben		: vom Rechner auf den Server schieben
	: <code>sudo rsync -avzPe "ssh -p 2142" /home/rg/ PaulRiegel@srs2.stura.htw-dresden.de:/home/PaulRiegel/backup/kleines/rsync/rg/</code>		: <code>sudo rsync -avzPe "ssh -p 2142" /home/rg/ PaulRiegel@srs2.stura.htw-dresden.de:/home/PaulRiegel/backup/kleines/rsync/rg/</code>
			:: <code>sudo rsync -avzPe "ssh -p 22" /home/rg/ vater@nax.bsd.services:/mnt/nas/home/vater/backup/rsync/rg/</code>
	; Sicherung mit <code>rsync</code> wiederherstellen		; Sicherung mit <code>rsync</code> wiederherstellen
	: <code>sudo rsync -avzPe "ssh -p 2142" PaulRiegel@srs2.stura.htw-dresden.de:/home/PaulRiegel/backup/kleines/rsync/rg/ /home/rg/</code>		: <code>sudo rsync -avzPe "ssh -p 2142" PaulRiegel@srs2.stura.htw-dresden.de:/home/PaulRiegel/backup/kleines/rsync/rg/ /home/rg/</code>
			:: <code></code>

	=== zfs ===		=== zfs ===

PaulRiegel: /* pf */

2017-01-23T08:14:47Z

← Nächstältere Version		Version vom 23. Januar 2017, 10:14 Uhr
Zeile 79:		Zeile 79:

	* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]		* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]

	~~== pf ==~~
	~~<pre>~~
	~~ext_if="em0"~~
	~~# int_if="lo0"~~

	~~ip = "141.56.50.123"~~

	~~icmp_types = "echoreq"~~

	~~open_tcp = "{~~
	~~22,~~
	~~80,~~
	~~443~~
	}"

	~~open_udp = "{~~
	~~22,~~
	80
	}"

	~~jails = "{~~
	~~10.1.1.1~~
	}"

	~~set block-policy return~~
	~~set skip on lo0~~
	~~set timeout { interval 10, frag 30 }~~
	~~set timeout { tcp.first 120, tcp.opening 30, tcp.established 86400 }~~
	~~set timeout { tcp.closing 900, tcp.finwait 45, tcp.closed 90 }~~
	~~set timeout { udp.first 60, udp.single 30, udp.multiple 60 }~~
	~~set timeout { icmp.first 20, icmp.error 10 }~~
	~~set timeout { other.first 60, other.single 30, other.multiple 60 }~~
	~~set timeout { adaptive.start 0, adaptive.end 0 }~~
	~~set limit { states 10000, frags 5000 }~~
	~~set loginterface em0~~
	~~set optimization normal~~
	~~set require-order yes~~
	~~set fingerprints "/etc/pf.os"~~
	~~set ruleset-optimization basic~~

	~~scrub in all fragment reassemble random-id~~

	~~nat on $ext_if proto {tcp udp icmp} from $jails to any -> $ip~~

	~~block log all~~
	~~block return~~
	~~block in quick on $ext_if inet from <rfc1918> to any~~
	~~antispoof quick for $ext_if~~

	~~pass in on $ext_if proto tcp from any to any port ssh flags S/SA keep state~~
	~~pass in on $ext_if proto tcp from any to any port $open_tcp flags S/SA keep state~~
	~~pass in on $ext_if proto udp from any to any port $open_udp keep state~~
	~~pass in on $ext_if inet proto icmp all icmp-type $icmp_types keep state~~
	~~pass in on $ext_if inet proto udp from any to any port 33433 >< 33626 keep state~~
	~~pass out quick all keep state~~
	~~</pre>~~

PaulRiegel am 16. Januar 2017 um 08:33 Uhr

2017-01-16T08:33:18Z

← Nächstältere Version		Version vom 16. Januar 2017, 10:33 Uhr
Zeile 79:		Zeile 79:

	* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]		* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]

			== pf ==
			<pre>
			ext_if="em0"
			# int_if="lo0"

			ip = "141.56.50.123"

			icmp_types = "echoreq"

			open_tcp = "{
			22,
			80,
			443
			}"

			open_udp = "{
			22,
			80
			}"

			jails = "{
			10.1.1.1
			}"

			set block-policy return
			set skip on lo0
			set timeout { interval 10, frag 30 }
			set timeout { tcp.first 120, tcp.opening 30, tcp.established 86400 }
			set timeout { tcp.closing 900, tcp.finwait 45, tcp.closed 90 }
			set timeout { udp.first 60, udp.single 30, udp.multiple 60 }
			set timeout { icmp.first 20, icmp.error 10 }
			set timeout { other.first 60, other.single 30, other.multiple 60 }
			set timeout { adaptive.start 0, adaptive.end 0 }
			set limit { states 10000, frags 5000 }
			set loginterface em0
			set optimization normal
			set require-order yes
			set fingerprints "/etc/pf.os"
			set ruleset-optimization basic

			scrub in all fragment reassemble random-id

			nat on $ext_if proto {tcp udp icmp} from $jails to any -> $ip

			block log all
			block return
			block in quick on $ext_if inet from <rfc1918> to any
			antispoof quick for $ext_if

			pass in on $ext_if proto tcp from any to any port ssh flags S/SA keep state
			pass in on $ext_if proto tcp from any to any port $open_tcp flags S/SA keep state
			pass in on $ext_if proto udp from any to any port $open_udp keep state
			pass in on $ext_if inet proto icmp all icmp-type $icmp_types keep state
			pass in on $ext_if inet proto udp from any to any port 33433 >< 33626 keep state
			pass out quick all keep state
			</pre>

PaulRiegel: /* zfs */

2016-12-11T19:51:20Z

zfs

← Nächstältere Version		Version vom 11. Dezember 2016, 21:51 Uhr
Zeile 44:		Zeile 44:
	<!--		<!--
	: <code>zfs send -R pad@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>		: <code>zfs send -R pad@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>
			-->
			<!--
			: <code>zfs send -R pad@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs recv -Fdvu valume/rep/kleines-schwarzes</code>
	-->		-->

PaulRiegel: /* zfs */

2016-12-11T19:16:44Z

zfs

← Nächstältere Version		Version vom 11. Dezember 2016, 21:16 Uhr
Zeile 41:		Zeile 41:
	: <code>zfs list -t snapshot</code>		: <code>zfs list -t snapshot</code>

	: <code>zfs send -R ~~vank~~@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes</code>		: <code>zfs send -R pad@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes</code>
	<!--		<!--
	: <code>zfs send -R ~~vank~~@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>		: <code>zfs send -R pad@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>
	-->		-->

			; Dataset (zuvor) zum Entgegennehmen der Sicherung erstellen und konfigurieren

			: <code>sudo zfs create data/backup/paul</code>

			: <code>sudo chown PaulRiegel /mnt/data/backup/paul</code>

			: <code>sudo zfs allow -u PaulRiegel create,mount,receive,destroy,mountpoint,canmount,send,snapshot,atime,setuid,compression,exec data/backup/paul</code>

	== singel user mode ==		== singel user mode ==

PaulRiegel: /* zfs */

2016-05-01T03:54:57Z

zfs

← Nächstältere Version		Version vom 1. Mai 2016, 05:54 Uhr
Zeile 30:		Zeile 30:

	=== zfs ===		=== zfs ===

			; Sicherung mit zfs erstellen

	: <code>su</code>		: <code>su</code>
Zeile 39:		Zeile 41:
	: <code>zfs list -t snapshot</code>		: <code>zfs list -t snapshot</code>

			: <code>zfs send -R vank@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes</code>
			<!--
	: <code>zfs send -R vank@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>		: <code>zfs send -R vank@`date "+%Y-%m-%d"` \| ssh -i ~/.ssh/id_rsa 141.56.50.121 zfs receive -vFd valume/rep/kleines-schwarzes@`date "+%Y-%m-%d"`</code>
			-->

	== singel user mode ==		== singel user mode ==

PaulRiegel: /* rsync */

2016-05-01T03:47:38Z

rsync

@@ Zeile 28: / Zeile 28: @@
 ; Sicherung mit <code>rsync</code> wiederherstellen
 : <code>sudo rsync -avzPe "ssh -p 2142" PaulRiegel@srs2.stura.htw-dresden.de:/home/PaulRiegel/backup/kleines/rsync/rg/ /home/rg/</code>
 == singel user mode ==

PaulRiegel am 29. April 2016 um 19:05 Uhr

2016-04-29T19:05:03Z

← Nächstältere Version		Version vom 29. April 2016, 21:05 Uhr
Zeile 47:		Zeile 47:

	[[wikipedia:en:QWERTY#US-International]]:[[wikipedia:en:File:KB US-International.svg]]		[[wikipedia:en:QWERTY#US-International]]:[[wikipedia:en:File:KB US-International.svg]]

			== MySQL ==

			* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password Resetting a forgotten MySQL root password]