45 private links
yeahhhh !
à vérifier.
chapeau !
hey non, toujours pas du gigabit sur l'Ethernet...
...
Mes condoléances...
...
ha ! bien !
H1 : mysqldump --all-databases --add-drop-database --skip-comments >/tmp/dumph1.sql
H1 : cat /tmp/dumph1.sql | mysql -h H2 -uroot -p
H1 : cat /tmp/dumph1.sql | md5sum
H2 : mysqldump --all-databases --add-drop-database --skip-comments | md5sum
EDIT : attention aux bases "système"
Coudé, il parait qu'elle est bien !
parce que ça claque mieux et que c'est toujours bien de savoir comment va une machine en se connectant.
This feature is very nice as it will give you a quick look at useful information. Unfortunately, Debian Server does not include the dynamic MOTD. First you will need to install some prerequisites and build the directory structure. To do so, run the following commands in terminal. If you would like to add update notification, I have written another article detailing the steps at Debian MOTD Update Notifier.
Shell
install lsb-release
sudo apt-get install lsb-release
install figlet to enable ASCII art
sudo apt-get install figlet
create directory
mkdir /etc/update-motd.d/
change to new directory
cd /etc/update-motd.d/
create dynamic files
touch 00-header ; touch 10-sysinfo; touch 90-footer
make files executable
chmod +x /etc/update-motd.d/*
remove MOTD file
rm /etc/motd
Once the above commands have been run, you can move on to populating the files you created. Below you can copy and paste.
Header (00-header)
!/bin/sh
#
00-header - create the header of the MOTD
Copyright (c) 2013 Nick Charlton
Copyright (c) 2009-2010 Canonical Ltd.
#
Authors: Nick Charlton hello@nickcharlton.net
Dustin Kirkland kirkland@canonical.com
#
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
#
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
#
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
[ -r /etc/lsb-release ] && . /etc/lsb-release
if [ -z "$DISTRIB_DESCRIPTION" ] && [ -x /usr/bin/lsb_release ]; then
Fall back to using the very slow lsb_release utility
DISTRIB_DESCRIPTION=$(lsb_release -s -d)fi
figlet $(hostname)
printf "\n"
printf "Welcome to %s (%s).\n" "$DISTRIB_DESCRIPTION" "$(uname -r)"
printf "\n"
System Information (10-sysinfo)
!/bin/bash
#
10-sysinfo - generate the system information
Copyright (c) 2013 Nick Charlton
#
Authors: Nick Charlton hello@nickcharlton.net
#
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
#
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
#
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
date=date
load=cat /proc/loadavg | awk '{print $1}'
root_usage=df -h / | awk '/\// {print $(NF-1)}'
memory_usage=free -m | awk '/Mem:/ { total=$2 } /buffers\/cache/ { used=$3 } END { printf("%3.1f%%", used/total*100)}'
swap_usage=free -m | awk '/Swap/ { printf("%3.1f%%", $3/$2*100) }'
users=users | wc -w
time=uptime | grep -ohe 'up .*' | sed 's/,/\ hours/g' | awk '{ printf $2" "$3 }'
processes=ps aux | wc -l
#ip=ifconfig $(route | grep default | awk '{ print $8 }') | grep "inet addr" | awk -F: '{print $2}' | awk '{print $1}'
#ip=hostname --all-ip-addresses || hostname -I
ip=ip a | grep 'inet ' | awk '{print $2}' | tr '\n' ' '
echo "System information as of: $date"
echo
printf "System Load:\t%s\tIP Address:\t%s\n" $load "$ip"
printf "Memory Usage:\t%s\tSystem Uptime:\t%s\n" $memory_usage "$time"
printf "Usage On /:\t%s\tSwap Usage:\t%s\n" $root_usage $swap_usage
printf "Local Users:\t%s\tProcesses:\t%s\n" $users $processes
echo
Footer (90-footer)
!/bin/sh
#
90-footer - write the admin's footer to the MOTD
Copyright (c) 2013 Nick Charlton
Copyright (c) 2009-2010 Canonical Ltd.
#
Authors: Nick Charlton hello@nickcharlton.net
Dustin Kirkland kirkland@canonical.com
#
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
#
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
#
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
[ -f /etc/motd.tail ] && cat /etc/motd.tail || true
Once these files are populated with the above, you should now be able to logout and then log back in either using putty or on the console and you will be presented with something that looks like below.
hoooo merde !
heu non, en cas d'urgence, on va aux.... Urgences ! Arrêtez avec vos "médecines douces" dans des cas comme ça, vous vous mettez en danger ou pire vous mettez en danger vos proches !
Sinon, pour la bobologie ou les petits tracas tant qu'ils sont rares et pas trop douleurs, j'ai rien à dire, faites ce que vous voulez.
ha bien !
via https://bookmarks.geekandfree.org/?meRaEQ
à tester. comment certains peuvent encore prétendre être efficace sur nano...
EDIT:
echo "set undodir=~/.vimundo" >>/etc/vim/vimrc
echo "set undofile" >>/etc/vim/vimrc
et bim !
ça semble sympa.
ça fait quoi ?
function setproxy() {
export {http,https,ftp}_proxy='http://greatfirewall.bullshit.tld:<PORT>'
}
function unsetproxy() {
unset {http,https,ftp}_proxy
}
function httpretcode {
curl -sIL $1 | grep HTTP | tail -n1 | cut -d " " -f 2
}
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
IF OBJECT_ID('t_uq') IS NOT NULL DROP FUNCTION t_uq
GO
CREATE TABLE t(c0 INT, c1 NVARCHAR(50), c2 bit)
GO
CREATE FUNCTION t_uq(@c1 NVARCHAR(50))
RETURNS bit
AS
BEGIN
DECLARE @ret bit
IF (SELECT COUNT(*) FROM t WHERE c1 = @c1 AND c2 = 1) > 1
SET @ret = 0
ELSE
SET @ret = 1
RETURN @ret
END
GO
ALTER TABLE t ADD CONSTRAINT t_c CHECK(dbo.t_uq(c1) = 1)
INSERT INTO t(c0, c1, c2) VALUES(1, 'a', 0) --OK
INSERT INTO t(c0, c1, c2) VALUES(2, 'a', 0) --OK
INSERT INTO t(c0, c1, c2) VALUES(3, 'b', 1) --OK
INSERT INTO t(c0, c1, c2) VALUES(4, 'b', 1) --Fails
--So far so good, but watch now:
UPDATE t SET c2 = 1 WHERE c0 = 2
--No error, the constraint doesn't do its job!
--We have invalid data:
SELECT * FROM t
Les gens qui vont chez le docteur : "Je vais mal, et voici en détail tous mes symptômes."
Les gens qui vont chez le garagiste : "Ma voiture ne marche plus, voici tout ce que j'ai noté"
Les gens qui ont un souci informatique : "CA MARCHE PAS. VOILA MERCI AU REVOIR."
-> tellement vrai
parfait.