Friday, March 25, 2016

ubuntu utopic 14.04 sourses.list

deb http://mirror.mirohost.net/ubuntu/ trusty main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty main restricted

deb http://mirror.mirohost.net/ubuntu/ trusty-updates main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates main restricted

deb http://mirror.mirohost.net/ubuntu/ trusty universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty universe
deb http://mirror.mirohost.net/ubuntu/ trusty-updates universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates universe

deb http://mirror.mirohost.net/ubuntu/ trusty multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty multiverse
deb http://mirror.mirohost.net/ubuntu/ trusty-updates multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates multiverse

deb http://mirror.mirohost.net/ubuntu/ trusty-backports main restricted universe multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-backports main restricted universe multiverse

deb http://mirror.mirohost.net/ubuntu/ trusty-security main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security main restricted
deb http://mirror.mirohost.net/ubuntu/ trusty-security universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security universe
deb http://mirror.mirohost.net/ubuntu/ trusty-security multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security multiverse

deb http://archive.canonical.com/ubuntu trusty partner

deb http://extras.ubuntu.com/ubuntu trusty main
deb-src http://extras.ubuntu.com/ubuntu trusty main
deb http://archive.getdeb.net/ubuntu trusty-getdeb apps

Monday, March 21, 2016

check processlist from swap

for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{ print ""}' $file; done | sort -k 2 -n -r | less

Tuesday, March 15, 2016

MariaDB enable slow logs


MariaDB [(none)]> SET GLOBAL slow_query_log = 'ON';
MariaDB [(none)]> set global slow_query_log_file = '/var/log/mariadb/slow.log';

Friday, February 26, 2016

mysql create user and db with privileges



> create database newdb;

 > GRANT ALL PRIVILEGES ON newdb . * TO 'newusername'@'localhost'  IDENTIFIED BY 'PASS';

> flush privileges;

// Change user password 

> SET PASSWORD FOR 'newusername'@'hostname' = PASSWORD('new-password');

> flush privileges;

Thursday, December 24, 2015

/var/cache/nginx/fastcgi_temp permission denied

check which user nginx is running

ps aux | grep "nginx: worker process"

in my case it "apache"

chown apache:apache /var/cache/nginx/ -R

Thursday, November 26, 2015

ssllabs A+ nginx

    ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
    ssl_ciphers !RC4:HIGH:!aNULL:!MD5:!kEDH;
    ssl_session_cache shared:SSL:10m;
    ssl_prefer_server_ciphers on;
    add_header Strict-Transport-Security "max-age=63072000; includeSubdomains; preload";
    add_header X-Frame-Options DENY;
    add_header X-Content-Type-Options nosniff;
    ssl_session_tickets off; # Requires nginx >= 1.5.9
    ssl_stapling on; # Requires nginx >= 1.3.7
    ssl_stapling_verify on; # Requires nginx => 1.3.7
    resolver_timeout 5s;

Wednesday, November 25, 2015

monit check process by name without pid

check process httpd
    matching "/usr/sbin/httpd"
    start program = "/etc/init.d/httpd start"
    stop program  = "/etc/init.d/httpd stop"


monit will check process by process name "/usr/sbin/httpd"

grub2-install: error: disk `mduuid/e54081d398c6d57b4d67436f6d032162' not found

After raid 1 disk replacement faced with this issue # grub2-install /dev/sdb Installing for i386-pc platform. grub2-install: error: disk `md...