LES;
</code>
* Here is a backup script you can use (on a daily use, remember to use it on the "slave" only, especially if you use MyISAM engine: tables locking will cause your dat... MASTER_HOST='master_host_name',
-> MASTER_USER='master_user_name',
-> MASTER_PASSWORD='slavepass',
... c' to clear the buffer.
mysql> DELETE FROM mysql.user WHERE User='root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'r
ously needs an already running full mail stack (I use qmail/postfix/dovecot), which will not be covered... # good ol' favicon (adjust path if you use Larry skin)
rewrite ^/favicon.ico... ed roundcubemail, hosted on “dbhost” and owned by user roundcubemail.
* Install roundecube:
<code bas... se named agendav, hosted on "dbhost" and owned by user agendav.
* Install AgenDAV plugin:
<code bash>
#
# This configuration can be used by multiple #
# clients, however each client sho... nfig file directives
# from the server.
client
# Use the same setting as you are using on
# the server... t
# Are we connecting to a TCP or
# UDP server? Use the same setting as
# on the server.
;proto tcp
p... olve the
# host name of the OpenVPN server. Very useful
# on machines which are not permanently connec
sbin/nologin
Locked : no
OK? (yes/no): yes
adduser: INFO: Successfully added (gemini) to the user database.
Add another user? (yes/no): no
Goodbye... apsule responding"
return 0
fi
</code>
Here we use "trust on first use authentication" (--tofu), so don't forget to manu... if security is not your primary concern, you can use the more permissive --no-ca-verification flag ins
le
* [[https://addons.mozilla.org/firefox/addon/user-agent-string-switcher/|User-Agent Switcher]] : adds a menu and a toolbar but... es 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
* [[https://grea... permonkey/view.php?script=youtube_overlay_remover.user.js|YT - Overlay remover]]: <del>hide cards/overl... ys on youtube videos</del> not working (anymore), use "www.youtube.com##.ytp-ce-element" in uBlock inst
ame.domain.tld
Port 22
User username
</code>
typing "ssh shortname" will be the ... omain.tld nc distant_private_ip_adress 22
User username
</code>
"ssh hostname" connects to the dist... ds in /etc/ssh/sshrc are executed by ssh when the user logs in, just before the user's shell (or command) is started. It's commonly used to send alerts using mail:
<code>
#!/bin/sh
# so
t last command argument, just like $!
N.B. xterm users, you must activate "meta send escape".
====== Emacs/VI mode ======
Bash can use Emacs or VI shortcuts, using the "set" command.
... STTIMEFORMAT='%Y-%m-%d %H:%M:%S '
</code>
====== Useful links ======
* http://wiki.gcu.info/doku.php
ds - obviously - mod_status)
Note: Not to be confused with [[http://freshmeat.net/projects/apachetop/|apachetop]], which use apache's log files instead.
====== iftop ======
... e monitoring]]. access MySQL using the "mysqltop" user with no password by default, so create on the My
D
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 f... locale "sr_YU.ISO8859-5"
```
This seems to be caused by a [remaining deprecated locale](https://bugs.... QLNEWVERSION}/pg_hba.conf
```
## Go back to root user and finish migration
```bash
exit
service postg
an 7.x</note>
<code bash>
#!/bin/bash
# script used to chroot/pivot a live system on tmpfs in order ... w connect with ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -p ${CHROOTPORT} root@$(... ), launch screen/tmux and shred"
echo "and finaly use reboot or halt commands (warning: they are not th
iaDB]] (NConf needs it)
The main idea here is to use Nagios' frames to integrate the other tools. This can also be used with Nagios-style UIs (i.e. [[https://www.icinga
<columns>
**Monitoring**
* [[public:top|Useful *top utilities, for real-time monitoring]]
* [[publi... basic usage]]
* [[public:vpn_vs_proxies|How to use a VPN to bypass stupid proxies]]
* [[public:my_