Thứ Tư, 25 tháng 12, 2019

Docker Commands

docker attach - Attaches your local input/output/error stream to a running container. docker commit  - Creates a new image from the current changed state of the container. docker exec- Runs a command in a container that is active or running. docker history- Displays the history of an image. docker info- Shows system-wide information. docker inspect- Finds system-level information about docker containers and images. docker...
Read More

Thứ Tư, 18 tháng 12, 2019

GlusterFS Cheat Sheet

Brick –> is basic storage (directory) on a server in the trusted storage pool. Volume –> is a logical collection of bricks. Cluster –> is a group of linked computers, working together as a single computer. Distributed File System –> A filesystem in which the data is spread across the multiple storage nodes and allows the clients to access it over a network. Client –> is a machine which mounts the volume. Server...
Read More

Thứ Sáu, 29 tháng 11, 2019

Install PowerDNS with recursor and MySQL backend

PowerDNS is not designed to provide recursive results. It is intended to act only as an authoritative server for the domains it serves. This implies it will be serving domain data to other hosts. Install pdns and pdns-recursor sudo apt-get install pdns-server pdns-recursor edit recursor settings in /etc/powerdns/recursor.conf local-port=53 forward-zones=mydomain.local=127.0.0.1:54 # change ‘mydomain.local’ to your...
Read More

Thứ Ba, 5 tháng 11, 2019

Large MSDB Database From sysmaintplan_logdetail Table

I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing SQL to shut down. He cleaned up some other old files so that SQL would work again but did...
Read More

Thứ Ba, 29 tháng 10, 2019

How to configure the passive ports range for ProFTPd on a server behind a firewall

Note: When configuring the passive port range, a selected port range must be in the non-privileged range (e.g., greater than or equal to 1024). It is strongly recommended that the chosen range should be large enough to handle many simultaneous passive connections. The default passive port range is 49152-65535 (the IANA registered ephemeral port range). Connect to a server via SSH. Run the command below...
Read More

Thứ Ba, 22 tháng 10, 2019

Watch mysql processlist in (almost) real time

watch -n 1 “mysql -h 10.0.0.1 -u username -pPASSWORD -e ‘SHOW PROCESSLIST;...
Read More

Thứ Hai, 21 tháng 10, 2019

.my.cnf – mysql user & password

.my.cnf – mysql user & password This one is for lazy ones! If you are paranoid about security, do not use this. Create file ~/.my.cnf and add following lines in it and replace mysqluser & mysqlpass values. [client] user=mysqluser password=mysqlpass For safety, make this file readable to you only by running chmod 0600 ~/.my.cnf ...
Read More

Thứ Tư, 11 tháng 9, 2019

Lỗi exim directadmin unrouteable address

- unrouteable address exim + Lỗi do vượt ngưỡng gửi server quy định xem log tail -f /var/log/exim/paniclog        2019-09-11 16:12:11 1i7yfb-0005yS-AI failed to expand condition "${perl{check_limits}}" for lookuphost router: You (sotico) have reached your daily email limit of 1000 emails + Xem cấu hình trong server vi /etc/virtual/limit -> cho các domain echo 2000 > /etc/virtual/limit_sotico...
Read More

Thứ Tư, 28 tháng 8, 2019

Compiling and Installing ModSecurity for NGINX Open Source

 – Install NGINX from Our Official Repository If you haven’t already, the first step is to install NGINX. There are multiple ways to install NGINX, as is the case with most open source software. We generally recommend you install NGINX from the mainline branch in our official repository. For more details on how to properly install NGINX from our official repository, see our on‑demand webinar NGINX: Basics and...
Read More