Différences

Ci-dessous, les différences entre deux révisions de la page.

--- scripts [2025/05/28 14:00] – [MYSQL DATABASE BACKUP] huracan
+++ scripts [2025/12/04 14:31] (Version actuelle) – [PYTHON] huracan
@@ Ligne 1: / Ligne 1: @@
 ====== SCRIPTS ======
@@ Ligne 8: / Ligne 11: @@
 ----
+===== PYTHON =====
+Script pour commandes multithread sur plusieurs switchs
+	#!/usr/bin/env python3
+	from concurrent.futures import ThreadPoolExecutor, as_completed
+	from datetime import datetime
+	from getpass import getpass
+	import threading
+	from pathlib import Path
+	import os
+	import socket
+	from netmiko import ConnectHandler
+	SWITCH_FILE = "switches.txt"
+	MAX_WORKERS = 20
+	print_lock = threading.Lock()
+	def safe_print(*a, **kw):
+		with print_lock:
+			print(*a, **kw, flush=True)
+	def load_hosts(path):
+		p = Path(path)
+		if not p.exists():
+			return []
+		return [x.strip() for x in p.read_text().splitlines() if x.strip()]
+	# --------- AJOUT : TEST SSH AVANT CONNEXION -----------
+	def test_ssh_port(host, port=22, timeout=2):
+		try:
+			with socket.create_connection((host, port), timeout=timeout):
+				return True
+		except:
+			return False
+	# -------------------------------------------------------
+	def run_on_switch(host, username, password, commands):
+		result = {
+			"host": host,
+			"success": False,
+			"error": None,
+			"lines": [],
+			"start": datetime.now(),
+			"end": None,
+		}
+		# --- Test SSH avant toute connexion ---
+		if not test_ssh_port(host):
+			result["error"] = "SSH inaccessible (port 22 fermé / host down)"
+			result["end"] = datetime.now()
+			return result
+		try:
+			device = {
+				"device_type": "cisco_ios",
+				"host": host,
+				"username": username,
+				"password": password,
+			}
+			conn = ConnectHandler(**device)
+		except Exception as e:
+			result["error"] = f"SSH ERROR : {e}"
+			result["end"] = datetime.now()
+			return result
+		try:
+			conn.send_command("terminal length 0")
+			for cmd in commands:
+				out = conn.send_command(cmd, read_timeout=20)
+				for line in out.splitlines():
+					safe_print(f"[{host}] {line}")
+					result["lines"].append(line)
+			result["success"] = True
+		except Exception as e:
+			result["error"] = f"COMMAND ERROR : {e}"
+		finally:
+			conn.disconnect()
+			result["end"] = datetime.now()
+		return result
+	def choose_switches(hosts):
+		while True:
+			safe_print("\n====== SÉLECTION DES SWITCHES ======")
+			for i, h in enumerate(hosts, 1):
+				safe_print(f"{i}) {h}")
+			safe_print("\nOptions :")
+			safe_print("  X    -> numéro d’un switch")
+			safe_print("  1,3  -> plusieurs switchs")
+			safe_print("  all  -> tous les switches")
+			safe_print("  back -> revenir")
+			safe_print("====================================")
+			choice = input("Votre sélection : ").strip().lower()
+			if choice == "back":
+				return None
+			if choice == "all":
+				return hosts
+			try:
+				indices = [int(x.strip()) for x in choice.split(",")]
+				selected = [hosts[i - 1] for i in indices if 1 <= i <= len(hosts)]
+				if selected:
+					return selected
+			except:
+				pass
+			safe_print("Sélection invalide.")
+	def main():
+		hosts = load_hosts(SWITCH_FILE)
+		if not hosts:
+			safe_print(f"Erreur : fichier {SWITCH_FILE} introuvable ou vide.")
+			return
+		safe_print(f"{len(hosts)} switches chargés.")
+		username = input("Identifiant SSH : ").strip()
+		password = getpass("Mot de passe SSH : ")
+		current_selection = hosts  # par défaut : tous
+		while True:
+			safe_print("\n====== MENU PRINCIPAL ======")
+			safe_print("Switches sélectionnés :")
+			for h in current_selection:
+				safe_print(f"  - {h}")
+			safe_print("\nOptions :")
+			safe_print("  cmd   -> taper des commandes")
+			safe_print("  sel   -> changer la sélection")
+			safe_print("  clear -> effacer l'écran")
+			safe_print("  exit  -> quitter")
+			safe_print("============================")
+			choice = input("> ").strip().lower()
+			if choice == "exit":
+				return
+			if choice == "clear":
+				os.system("cls" if os.name == "nt" else "clear")
+				continue
+			if choice == "sel":
+				new_sel = choose_switches(hosts)
+				if new_sel:
+					current_selection = new_sel
+				continue
+			if choice == "cmd":
+				safe_print("Entrez vos commandes (ligne vide pour lancer l'exécution).")
+				commands = []
+				while True:
+					cmd = input("> ").strip()
+					if cmd == "":
+						if commands:
+							break
+						else:
+							continue
+					commands.append(cmd)
+				safe_print("\n====== EXÉCUTION ======\n")
+				start_all = datetime.now()
+				results = []
+				with ThreadPoolExecutor(max_workers=min(MAX_WORKERS, len(current_selection))) as pool:
+					future_map = {
+						pool.submit(run_on_switch, h, username, password, commands): h
+						for h in current_selection
+					}
+					for f in as_completed(future_map):
+						results.append(f.result())
+				# --- Résumé synthétique ---
+				safe_print("\n======= RÉSUMÉ =======")
+				for r in results:
+					host = r["host"]
+					status = "OK" if r["success"] else "ERREUR"
+					lines = len(r["lines"])
+					dur = (r["end"] - r["start"]).total_seconds()
+					safe_print(f"- {host}: {status} | lignes: {lines} | durée: {dur:.1f}s")
+					if r["error"]:
+						safe_print(f"    -> {r['error']}")
+				total = (datetime.now() - start_all).total_seconds()
+				safe_print(f"Durée totale : {total:.1f}s")
+				safe_print("=======================\n")
+	if __name__ == "__main__":
+		main()
+----
 ===== WINDOWS =====
@@ Ligne 14: / Ligne 239: @@
 ----
+==== CONVERSION M4A EN FLAC AVEC FFMPEG ====
+🪟 Sur Windows (PowerShell ou CMD) :
+Dans le dossier contenant les .m4a exécuter :
+  #for %a in (*.m4a) do ffmpeg -i "%a" -c:a flac -map_metadata 0 "%~na.flac"
+----
@@ Ligne 1113: / Ligne 1348: @@
   #echo `test $machin = 'truct'`
+----
+==== CONVERSION M4A EN FLAC AVEC FFMPEG ====
+Dans le dossier contenant les .m4a, exécuter :
+🐧 Sur Linux (terminal bash) :
+  #for f in *.m4a; do ffmpeg -i "$f" -c:a flac -map_metadata 0 "${f%.m4a}.flac"; done
 ----
@@ Ligne 1337: / Ligne 1582: @@
 What Does This Script Do?
-    MySQL Credentials: You need to provide your MySQL username, password, and host (usually localhost).
+  * MySQL Credentials: You need to provide your MySQL username, password, and host (usually localhost).
-    Backup Directory: This is where your backups will be stored. Make sure this directory exists on your system.
+  * Backup Directory: This is where your backups will be stored. Make sure this directory exists on your system.
-    Timestamped Backup: The script creates backups with a timestamp (e.g., 2025-04-28_12-30-00.sql) to avoid overwriting old backups.
+  * Timestamped Backup: The script creates backups with a timestamp (e.g., 2025-04-28_12-30-00.sql) to avoid overwriting old backups.
-    Databases to Back Up: In the DATABASES array, list the names of the databases you want to back up. You can add or remove databases as needed.
+  * Databases to Back Up: In the DATABASES array, list the names of the databases you want to back up. You can add or remove databases as needed.
-    Backup Command: The script uses mysqldump to create backups of your databases.
+  * Backup Command: The script uses mysqldump to create backups of your databases.
-    Old Backup Cleanup: The script also deletes backups older than 30 days (you can adjust this time as needed).
+  * Old Backup Cleanup: The script also deletes backups older than 30 days (you can adjust this time as needed).
-    Email Alerts: After running the backup, the script sends an email with the results – whether each database backup succeeded or failed.
+  * Email Alerts: After running the backup, the script sends an email with the results – whether each database backup succeeded or failed.
-Sync Backup to Remote Server (Optional but Recommended)
+**//Sync Backup to Remote Server (Optional but Recommended)//**
 After your local backup is created, it’s a smart move to sync it to a remote server for extra safety, which ensures your backups survive even if your main server crashes.
@@ Ligne 1351: / Ligne 1596: @@
 Here’s the rsync command you can add to the end of your backup script:
-# Sync backup to remote server (optional but recommended)
+  # Sync backup to remote server (optional but recommended)
-SSH_KEY="/path/to/your/private/key.pem"           # Path to your SSH private key
+  SSH_KEY="/path/to/your/private/key.pem"           # Path to your SSH private key
-REMOTE_USER="your_remote_user"                    # Remote server username
+  REMOTE_USER="your_remote_user"                    # Remote server username
-REMOTE_HOST="your.remote.server.com"              # Remote server address
+  REMOTE_HOST="your.remote.server.com"              # Remote server address
-REMOTE_DIR="/path/on/remote/server"               # Target directory on remote server
+  REMOTE_DIR="/path/on/remote/server"               # Target directory on remote server
-rsync -avz \
+  rsync -avz \
-  -e "ssh -i $SSH_KEY -o StrictHostKeyChecking=no" \
+    -e "ssh -i $SSH_KEY -o StrictHostKeyChecking=no" \
-  --delete-after \
+    --delete-after \
-  "$BACKUP_DIR/" \
+    "$BACKUP_DIR/" \
-  "$REMOTE_USER@$REMOTE_HOST:$REMOTE_DIR/"
+    "$REMOTE_USER@$REMOTE_HOST:$REMOTE_DIR/"
 Make sure the remote server is reachable, and the destination directory exists with proper write permissions.
@@ Ligne 1368: / Ligne 1613: @@
 Once you’ve saved your script, make it executable by running chmod command:
-chmod +x backup_mysql.sh
+  chmod +x backup_mysql.sh
-Step 2: Testing MySQL Backup Script
+=== Step 2: Testing MySQL Backup Script ===
 Before setting up the Cron job, it’s a good idea to test the script manually to make sure everything is working as expected.
-./backup_mysql.sh
+  ./backup_mysql.sh
 Check your backup directory to ensure the backups are created successfully. If everything looks good, proceed to the next step.
-Step 3: Automating MySQL Backups with Cron Jobs
+=== Step 3: Automating MySQL Backups with Cron Jobs ===
 Now that we have the backup script, the next step is to automate it by using Cron, a tool that runs commands at scheduled times.
-crontab -e
+  crontab -e
 Add a Cron job to run the backup script automatically. For example, to run the script every day at 2 AM, add the following line:
 2 * * * /bin/bash /path/to/your/backup_mysql.sh
 Here’s how the Cron schedule works:
-: The minute (0th minute).
+  * 0: The minute (0th minute).
-: The hour (2 AM).
+  * 2: The hour (2 AM).
-    *: Every day of the month.
+  * *: Every day of the month.
-    *: Every month.
+  * *: Every month.
-    *: Every day of the week.
+  * *: Every day of the week.
 To verify that your Cron job is running, you can check the system logs or temporarily set the script to run at a closer time to see if it works.
-grep CRON /var/log/syslog
+  grep CRON /var/log/syslog
-Additional Considerations
+**//Additional Considerations//**
-    Security: Storing your MySQL password in the script is convenient but not secure. For better security, you can store your credentials in a .my.cnf file in your home directory and configure the script to read from there.
+  * Security: Storing your MySQL password in the script is convenient but not secure. For better security, you can store your credentials in a .my.cnf file in your home directory and configure the script to read from there.
-    Backup Location: Make sure that the backup directory has enough space for your backups. If you’re running multiple backups, it’s a good idea to set up a separate storage location (like an external hard drive or cloud storage).
+  * Backup Location: Make sure that the backup directory has enough space for your backups. If you’re running multiple backups, it’s a good idea to set up a separate storage location (like an external hard drive or cloud storage).
-    Backup Frequency: Depending on how often your data changes, you might want to adjust the Cron job schedule. For example, you could run the backup every hour, every week, or only on certain days.
+  * Backup Frequency: Depending on how often your data changes, you might want to adjust the Cron job schedule. For example, you could run the backup every hour, every week, or only on certain days.

Wiki Kenny

Outils pour utilisateurs

Outils du site

Différences

Outils de la page