kevin39

SELECT Heure, ROUND(AVG(nbAppels),2) nbAppelsMoyen 
FROM 
(
SELECT DATE_PART('day',eventtime) Jour, DATE_PART('hour',eventtime) Heure, count(DISTINCT cid_name) nbAppels 
FROM cel
WHERE eventtime >= '2016-02-01 00:00:00'
AND eventtime < '2016-03-01 00:00:00'
AND eventtype = 'CHAN_START'
AND context = 'from-extern'
GROUP BY DATE_PART('day',eventtime), DATE_PART('hour',eventtime)

kevin39

$ sleep 30& sleep 60&
[1] 8007
[2] 8008

$ pkill -f 'sleep 30'
[1]  - terminated  sleep 30

$ pgrep sleep
8008

kevin39

Source : http://www.tecmint.com/rbash-a-restricted-bash-shell-explained-with-practical-examples/

# cd /bin
# ln -s bash rbash

Extra setup to improve security : 
http://blog.bodhizazen.net/linux/how-to-restrict-access-with-rbash/

kevin39

# The issue could be that Github isn't present in your ~/.ssh/known_hosts file.
# Append GitHub to the list of authorized hosts:

ssh-keyscan -H github.com >> ~/.ssh/known_hosts

kevin39

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400,000 to 500,000 requests per second (clustered), most what i saw is 50,000 to 80,000 (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

• Stable version NGINX (deb/rpm)
• Mainline version NGINX (deb/rpm)

kevin39

Source: http://serverfault.com/a/539036/217375

Did you check your error_log file for php-fpm? Location of that file should be declared in your php-fpm.conf (in Ubuntu config is /etc/php5/fpm/php-fpm.conf, log file is /var/log/php5-fpm/log), also check your log_level, if is disabled (;log_level), please enable it and change it to the debug. After that try restart php5-fpm service and check your logs.

You can also try to run php5-fpm in foreground mode:

# php5-fpm -y /etc/php5/fpm/php-fpm.conf
Maybe this show you something interesting.

kevin39

Source : http://pierrehirel.info/blog/?p=19

client:~$ ssh -Nf -R 26000:127.0.0.1:22 -p 2222 login@server.org
-N indique au client de ne pas se connecter mais de se mettre en attente ; en l’occurence il va écouter le port 22 ;
-f détache le client de la console, il continuera donc de tourner en arrière-plan ;
-R pour « reverse » indique qu’on met en place un tunnel inversé ;
26000:127.0.0.1:22 indique au serveur de rediriger son port 26000 vers le port 22 de la machine locale (localhost ou 127.0.0.1) ; le port du serveur (26000) peut être remplacé par n’importe quel port disponible ; le port du client (22) est à remplacer par le port sur lequel le serveur ssh du client écoute.
-p 2222 indique au client ssh de communiquer vers le port 2222 du serveur (au lieu du 22 par défaut) ;
la dernière partie est bien sûr à remplacer par un login et une adresse de serveur valides.

kevin39

cat /etc/mysql/debian.cnf

mysql -u root -p 
Enter password:
Puis on recrée l’utilisateur avec le mot de passe trouvé précedemment dans /etc/mysql/debian.cnf :

mysql>GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED \
BY 'Le_passwd_du_fichier';
mysql>FLUSH PRIVILEGES;
mysql>exit

kevin39

Create a new file "/etc/apparmor.d/lxc/lxc-default-with-nfsd" and paste in the following;

Code:
# Do not load this file.  Rather, load /etc/apparmor.d/lxc-containers, which
# will source all profiles under /etc/apparmor.d/lxc

profile lxc-container-default-with-nfsd flags=(attach_disconnected,mediate_deleted) {
  #include <abstractions/lxc/container-base>

  # the container may never be allowed to mount devpts.  If it does, it

kevin39

# This is an example of the Stack Exchange Tier 1 HAProxy config
# The only things that have been changed from what we are running are: 
# 1. User names have been removed
# 2. All Passwords have been remove
# 3. IPs have been changed to use the example/documentation ranges
# 4. Rate limit numbers have been changed to randome numbers, don't read into them

userlist stats-auth
        group admin users $admin_user
        user $admin_user insecure-password $some_password