As easy as:
[root@web ~]# sqlite3 /var/www/wordpress/.svn/wc.db SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT "changed_revision" FROM "NODES" ORDER BY changed_revision DESC LIMIT 1; 586 sqlite> [root@web ~]#
To solve this problem:
Can't locate File/Which.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) BEGIN failed--compilation aborted
you just need to install perl-File-Which package:
yum install perl-File-Which
By default PHP exposes information about the script which sent an email:
X-PHP-Originating-Script: 2000:send-email.php
To fix this change the following settings:
mail.add_x_header = Off expose_php = Off
The header should be gone now. Have a nice day!
If you get
# svn update svn: Error converting entry in directory '.' to UTF-8
run the following to get it working:
# export LC_CTYPE=en_US.UTF-8
# svn update
To check how much bandwidth a server uses it would make sense to use vnstat. Let’s install it:
# yum install vnstat
Enable auto start after reboot:
# systemctl enable vnstat.service
After some time you can check data:
# vnstat
cp /etc/localtime /etc/localtime.default ln -s /usr/share/zoneinfo/GMT-0 /etc/localtime
Here’s an example:
[root@d1 ~]# date Sun Feb 12 10:24:25 CST 2017 [root@d ~]# [root@d1 ~]# date Sun Feb 12 16:24:51 GMT 2017 [root@d1 ~]#
Bash can handle getting integer from float very easily:
[root@i ~]# cat ./f_to_i.sh
#!/bin/bash
f=20.3
i=${f%.*}
echo "float: " $f
echo "integer: " $i
[root@i ~]#
[root@i ~]# bash ./f_to_i.sh float: 20.3 integer: 20 [root@i ~]#
Install certbot:
wget https://dl.eff.org/certbot-auto ; chmod a+x certbot-auto ; ./certbot-auto
Add the required location to nginx:
vim /etc/nginx/sites-enabled/443-pydelion.com:
location ~ /.well-known { allow all; }
sudo service nginx restart
Run and follow the instruction:
root@host:~# ./certbot-auto certonly -d pydelion.com Saving debug log to /var/log/letsencrypt/letsencrypt.log Failed to find apache2ctl in PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin How would you like to authenticate with the ACME CA? ------------------------------------------------------------------------------- 1: Place files in webroot directory (webroot) 2: Spin up a temporary webserver (standalone) ------------------------------------------------------------------------------- Select the appropriate number [1-2] then [enter] (press 'c' to cancel):1 Obtaining a new certificate Performing the following challenges: http-01 challenge for pydelion.com Select the webroot for for pydelion.com: ------------------------------------------------------------------------------- 1: Enter a new webroot ------------------------------------------------------------------------------- Press 1 [enter] to confirm the selection (press 'c' to cancel): Input the webroot for pydelion.com: (Enter 'c' to cancel):/usr/share/nginx/html Waiting for verification... Cleaning up challenges Generating key (2048 bits): /etc/letsencrypt/keys/0000_key-certbot.pem Creating CSR: /etc/letsencrypt/csr/0000_csr-certbot.pem IMPORTANT NOTES: - Congratulations! Your certificate and chain have been saved at /etc/letsencrypt/live/pydelion.com/fullchain.pem. Your cert will expire on 2017-04-20. To obtain a new or tweaked version of this certificate in the future, simply run certbot-auto again. To non-interactively renew *all* of your certificates, run "certbot-auto renew" - If you like Certbot, please consider supporting our work by: Donating to ISRG / Let's Encrypt: https://letsencrypt.org/donate Donating to EFF: https://eff.org/donate-le
Add SSL config to nginx:
ssl_certificate /etc/letsencrypt/live/pydelion.com/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/keys/0000_key-certbot.pem;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!3DES:!MD5:!PSK';
This is how you can use traceroute for a specific port:
traceroute -T -p 3306 10.20.41.1
or the same:
traceroute --tcp -p 3306 10.20.41.1
As simple as:
yum install perl-DBD-mysql