Posts

enable the Slow Query Log in MySQL

 ✅ IMMEDIATE ACTIONS (DO THESE NOW) 1️⃣ Enable MySQL slow query log (VERY IMPORTANT) SET GLOBAL slow_query_log = ON; SET GLOBAL long_query_time = 1; Then watch: tail -f /var/lib/mysql/*-slow.log tail -f /var/log/mysql/mysql-slow.log This will show exact queries + which site causes them. 2️⃣ See live MySQL queries SHOW FULL PROCESSLIST;

error quic protocol error bitdefender

  Toggle Bitdefender Settings:  Open Bitdefender, go to  Protection  >  Online Threat Prevention  and try turning off "Encrypted Web Scan" or "Scan SSL" to see if the issue resolves.

change ssh port in ubuntu

 vi /etc/ssh/sshd_config port 1221 sudo systemctl restart ssh sudo systemctl daemon-reload sudo systemctl restart ssh.socket root@vmproc:/home/ubuntu# netstat -plunt | grep 22 tcp        0      0 0.0.0.0:1221            0.0.0.0:*               LISTEN      1/init tcp6       0      0 :::1221                 :::*                    LISTEN      1/init

nativemind chrome extension

 PS C:\Users\bum> lms server start --cors W CORS is enabled. This means any website you visit can use the LM Studio server. Success! Server is now running on port 1234 3. Enable CORS in LM Studio (Crucial)  Chrome extensions often block requests to localhost due to security restrictions (CORS).  In LM Studio, when running the server, check if there is an option to Enable CORS. If using the CLI, start the server with: lms server start --cors.  server address http://localhost:1234/v1/chat/completions

postgres sql backup

create a simple script for Linux  that will create backup for PostgreSQL USER='postgres' PASSWORD='B!XCO@2o26' and location is /usr/src/postgresql-backup/all-databases where all user database is created and one on another location /usr/src/postgresql-backup/bacula where each data base will be created  #!/bin/bash # PostgreSQL Backup Script # This script creates backups of all PostgreSQL databases # Configuration PGUSER="postgres" PGPASSWORD="B!XCO@2o26" BACKUP_DIR_ALL="/usr/src/postgresql-backup/all-databases" BACKUP_DIR_INDIVIDUAL="/usr/src/postgresql-backup/bacula" DATE=$(date +%Y%m%d_%H%M%S) RETENTION_DAYS=7 # Export password for pg_dump and pg_dumpall export PGPASSWORD="$PGPASSWORD" # Create backup directories if they don't exist mkdir -p "$BACKUP_DIR_ALL" mkdir -p "$BACKUP_DIR_INDIVIDUAL" echo "=== PostgreSQL Backup Started at $(date) ===" # Backup all databases (global backup) echo...

How to Install ModSecurity on Windows Server with OWASP Core Rule Set?

  How to Install ModSecurity on Windows Server with OWASP Core Rule Set? Complete Guide: Install ModSecurity on Windows Server with OWASP Core Rules   Introduction ModSecurity is a powerful open-source web application firewall (WAF) that helps protect your websites from various threats and attacks. This tutorial provides step-by-step instructions for installing and configuring ModSecurity on a Windows Server running Internet Information Services (IIS). By implementing ModSecurity, you’ll add an essential security layer to your web applications, helping to prevent SQL injection, cross-site scripting (XSS), and other common vulnerabilities. Step 1: Download & Install Visual C++ 2015-2022 Redistributable ModSecurity requires Microsoft Visual C++ Redistributable to function properly.   Download the latest version from  Microsoft : 🔗  https://aka.ms/vs/17/release/vc_redist.x64.exe Run the installer ( vc_redist.x64.exe)  and follow the on-screen instructions...

hestiacp phpmyadmin 404

 phpmyadmin only works with domain name or hostname not with IP with Ip 404