Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen.<\/strong><\/p>\n<\/a><\/p>\nVoraussetzungen:<\/strong><\/p>\nEin Debian Server mit folgenden Paketen:<\/p>\napache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo<\/p>\n <\/p>\nInstallation des Management-Servers:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nErzeugen eines RSA-Schl\u00fcssel „ssh-keygen“<\/li>\nErweitern der „\/etc\/ssh\/ssh_config“ mit dem Wert „StrictHostKeyChecking no“<\/li>\nanpassen der sudoers f\u00fcr www-data:<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n# User privilege specification\r\nroot ALL=(ALL:ALL) ALL\r\nwww-data ALL=(ALL) NOPASSWD: ALL<\/pre>\n\nanlegen eines Verzeichnis f\u00fcr das WEB-Frontend „mkdir \/var\/www\/html\/patch“<\/li>\nPostgresql erlauben Kommunikation aus dem internen Netzwerk an zu nehmen:\n\n\n\n\/etc\/postgresql\/11\/main\/postgresql.conf\u00a0 -> listen_addresses = ‚*‘<\/li>\n\/etc\/postgres\/11\/main\/pg_hba.conf:\n# IPv4 local connections:\r\n host all all 192.168.66.1\/24 password\r\n\r\n<\/pre>\n<\/li>\n\/etc\/init.d\/postgresql restart<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\nanlegen der Datenbank in Postgresql ‚psql -U postgres -c „create database apt“‚<\/li>\neinen User f\u00fcr die Datenbank anlegen psql -d apt -U postgres -c „CREATE USER apt WITH PASSWORD ‚apt123‘;“‚<\/li>\nEine Tabelle anlegen „psql -d apt -U postgres“<\/li>\n<\/ul>\n<\/li>\n<\/ol>\nCREATE TABLE IF NOT EXISTS zustand (\r\n id SERIAL PRIMARY KEY,\r\n server VARCHAR(15) NOT NULL,\r\n sys VARCHAR(255) NOT NULL,\r\n pu VARCHAR(3) NOT NULL,\r\n ul TEXT,\r\n root_free VARCHAR(10) NOT NULL,\r\n last_run TIMESTAMP NOT NULL\r\n);\r\n<\/pre>\n<\/li>\nerzeugen der Startseite (\/var\/www\/html\/patch\/index.php)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Server Information<\/title>\r\n<style>\r\nbody {\r\nbackground-color: #0e0e0e;\r\ncolor: #ffffff;\r\nfont-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\r\nmargin: 0;\r\npadding: 0;\r\nbox-sizing: border-box;\r\noverflow-x: hidden;\r\n}\r\n\r\n.container {\r\nwidth: 100%;\r\nmargin: 50px 0;\r\noverflow-x: auto;\r\n}\r\n\r\ntable {\r\nwidth: 100%;\r\nborder-collapse: collapse;\r\nmargin-top: 20px;\r\nbackground-color: #1e1e1e;\r\nbox-shadow: 0px 0px 20px rgba(0, 0, 0, 0.5);\r\nborder-radius: 12px;\r\noverflow: hidden;\r\n}\r\n\r\nth,\r\ntd {\r\nborder: 1px solid #333;\r\npadding: 16px;\r\ntext-align: left;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\nth {\r\nbackground-color: #4CAF50;\r\ncolor: white;\r\n}\r\n\r\ntextarea {\r\nwidth: 100%;\r\nheight: 6em;\r\nresize: vertical;\r\nbackground-color: #333;\r\ncolor: #ffffff;\r\nborder: 1px solid #666;\r\npadding: 12px;\r\nborder-radius: 6px;\r\n}\r\n\r\n.action-button {\r\nbackground-color: #3498db;\r\ncolor: #ffffff;\r\npadding: 12px 20px;\r\nborder: none;\r\nborder-radius: 8px;\r\ncursor: pointer;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\n.action-button:hover {\r\nbackground-color: #2980b9;\r\n}\r\n\r\n.connected {\r\ncolor: #3498db;\r\n}\r\n\r\n.highlight-row {\r\nbackground-color: #2ecc71;\r\ncolor: #ffffff;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2 style=\"text-align: center;\">Server Information<\/h2>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>Server<\/th>\r\n<th>Debian Version<\/th>\r\n<th>Updates Possible<\/th>\r\n<th style=\"width: 100%;\">Update List<\/th>\r\n<th>Root Free<\/th>\r\n<th>Last Run<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<?php\r\n\/\/ PostgreSQL Credentials\r\n$host = \"192.168.66.31\";\r\n$user = \"postgres\";\r\n$password = \"postgres\";\r\n$database = \"apt\";\r\n\r\n\/\/ Verbindung zur Datenbank herstellen\r\n$conn = new PDO(\"pgsql:host=$host;dbname=$database;user=$user;password=$password\");\r\n\r\n\/\/ SQL-Abfrage\r\n\/\/$query = \"SELECT * FROM zustand ORDER BY server\";\r\n$query = \"SELECT * FROM zustand ORDER BY (split_part(server, '.', 4)::int)\";\r\n$result = $conn->query($query);\r\n\r\nif ($result) {\r\nforeach ($result as $row) {\r\n$name = $row['server'];\r\n$version = $row['sys'];\r\n$updates = $row['pu'];\r\n$updateList = $row['ul'];\r\n$rootFree = $row['root_free'];\r\n$lastRun = $row['last_run'];\r\n$ip = $row['ip'];\r\n\r\n\/\/ Pr\u00fcfe, ob die IP in der idlist.log vorhanden ist\r\n$IPC = shell_exec(\"cat \/var\/www\/html\/patch\/idlist.log | grep $name | wc -l\");\r\n\r\n\/\/ $isIPConnected = in_array($ip, file('\/var\/www\/html\/patch\/idlist.log;\r\n\r\n\/\/ Bestimme den Inhalt der Action-Spalte basierend auf der IP-Verbindung\r\nif ($IPC != 0 AND $updates != 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span><p><button class=\"action-button\" onclick=\"openUpdatePage(\\'' . $name . '\\', \\'' . $name . '\\')\">Server Update<\/button>';\r\n}\r\nif ($IPC != 0 AND $updates == 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span>';\r\n}\r\nif ($IPC == 0) {\r\n$action = '<button class=\"action-button\" onclick=\"openSSHPage(\\'' . $name . '\\', \\'' . $name . '\\')\">connect SSH<\/button>';\r\n}\r\n\r\n\/\/ F\u00fcge eine Klasse f\u00fcr die Hervorhebung hinzu, wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist\r\n$rowClass = ($updates > 0) ? 'highlight-row' : '';\r\n\r\necho \"<tr class='$rowClass'>\";\r\necho \"<td>$name<\/td>\";\r\necho \"<td>$version<\/td>\";\r\necho \"<td>$updates<\/td>\";\r\n\r\n\/\/ Wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist, zeige die Textarea\r\nif ($updates > 0) {\r\necho \"<td><textarea rows='6' readonly>$updateList<\/textarea><\/td>\";\r\n} else {\r\necho \"<td>$updateList<\/td>\";\r\n}\r\n\r\necho \"<td>$rootFree<\/td>\";\r\necho \"<td>$lastRun<\/td>\";\r\necho \"<td>$action<\/td>\";\r\necho \"<\/tr>\";\r\n}\r\n} else {\r\necho \"<tr><td colspan='7'>Error fetching data.<\/td><\/tr>\";\r\n}\r\n\r\n$conn = null; \/\/ Verbindung schlie\u00dfen\r\n?>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n\r\n<script>\r\nfunction openUpdatePage(serverName, serverIP) {\r\nwindow.open('supdate.php?ip=' + serverIP, '_blank');\r\n}\r\nfunction openSSHPage(serverName, serverIP) {\r\nwindow.open('sid.php?ip=' + serverIP, '_blank');\r\n}\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n\r\n<\/html><\/code><\/pre>\n<\/li>\nerzeugen des Skripts f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/imp.sh)\nip=`\/bin\/cat \/var\/www\/html\/patch\/simp.tmp`\r\nsshpass -p \"ROOTPASSWORT\" ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@$ip<\/pre>\n<\/li>\nerzeugen des PHP \u00dcbergang f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/sid.php) <\n!--?php $ip=$_GET[ip]; shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo \/var\/www\/html\/patch\/imp.sh\"); shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo $ip ?-->\r\n<\/pre>\n<\/li>\nerzeugen des PHP-Skrips f\u00fcr das Updaten (\/var\/www\/html\/patch\/supdate.sh) <\n!--?php $ip=$_GET[ip]; \/\/shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo ssh root@$ip 'apt upgrade -y'\"); $xd=shell_exec(\"sudo ssh root@$ip '\/local\/patch.sh'\"); \/\/shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo \"$xd\"; echo $ip ?--><\/pre>\n\nerzeugen des Skripts f\u00fcr die Satellite-Server (\/var\/www\/html\/patch\/patch.sh)\n#!\/bin\/bash\r\n\r\n# PostgreSQL Credentials\r\nPG_HOST=\"IP-DES-POSTGRESQL-SERVER\"\r\nPG_USER=\"apt\"\r\nPG_PASSWORD=\"apt123\"\r\nPG_DATABASE=\"apt\"\r\n\r\n# Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle\r\ninsert_or_update_data() {\r\n local server_ip=\"$1\"\r\n local debian_version=\"$2\"\r\n local updates_possible=\"$3\"\r\n local update_list=\"$4\"\r\n local root_free=\"$5\"\r\n local current_datetime=\"$(date +'%Y-%m-%d %H:%M:%S')\"\r\n\r\n # SQL-Statement zum Einf\u00fcgen oder Aktualisieren von Daten in die Tabelle\r\n psql -h \"$PG_HOST\" -U \"$PG_USER\" -d \"$PG_DATABASE\" -c \"INSERT INTO zustand (server, sys, pu, ul, root_free, last_run) VALUES ('$server_ip', '$debian_version', '$updates_possible', '$update_list', '$root_free', '$current_datetime') ON CONFLICT (server) DO UPDATE SET sys='$debian_version', pu='$updates_possible', ul='$update_list', root_free='$root_free', last_run='$current_datetime';\"\r\n}\r\n\r\n# Hauptskript\r\n\r\n# Aktualisieren Sie die Paketliste\r\napt update\r\nif ! command -v psql &> \/dev\/null\r\nthen\r\n echo \"psql is not installed. Installing postgresql-client...\"\r\n apt install -y postgresql-client\r\nfi\r\n# Erfassen von Systeminformationen\r\nserver_ip=$(hostname -I | awk '{print $1}') # IP-Adresse des Servers\r\ndebian_version=$(lsb_release -ds) # Aktuelle Debian-Version\r\nupdate_output=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null) # Ausgabe der m\u00f6glichen Updates\r\nupdates_possible=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null | wc -l) # Anzahl der m\u00f6glichen Updates\r\nupdate_list=\"$update_output\" # Liste der m\u00f6glichen Updates\r\nroot_free=$(df -h \/ | awk 'NR==2 {print $4}') # Freier Speicherplatz auf der Root-Partition\r\n\r\n# F\u00fchren Sie die Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle aus\r\ninsert_or_update_data \"$server_ip\" \"$debian_version\" \"$updates_possible\" \"$update_list\" \"$root_free\"\r\n\r\necho \"Daten erfolgreich in die PostgreSQL-Tabelle eingef\u00fcgt oder aktualisiert.\"\r\n<\/pre>\n<\/li>\nEinrichtung eines Satellitenserver:\nmkdir \/local \r\nwget http:\/\/192.168.66.31\/patch\/patch.sh -O \/local\/patch.sh \r\nchmod 777 \/local\/patch.sh \r\necho \"59 * * * * \/local\/patch.sh > \/dev\/null 2>&1\" >> \/var\/spool\/cron\/crontabs\/root \r\n\/local\/patch.sh<\/pre>\n<\/li>\nNun kann die erstellte Webseite (index.php) mit einem Browser aufgerufen werden.<\/li>\nJeder neue Satellit muss mit einem Klick auf den Button \u201econnect-SSH\u201c zuerst verbunden werden.<\/li>\nDanach kann er mit dem Button Update-Server aktualisiert werden.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-409","page","type-page","status-publish","hentry"],"yoast_head":"\nDebian Patchmanagement - bmetallica.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian Patchmanagement - bmetallica.de\" \/>\n<meta property=\"og:description\" content=\"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"bmetallica.de\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"name\":\"Debian Patchmanagement - bmetallica.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage-300x155.jpg\",\"datePublished\":\"2023-12-03T00:22:46+00:00\",\"dateModified\":\"2023-12-03T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"width\":1896,\"height\":978},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bmetallica.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian Patchmanagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/\",\"name\":\"bmetallica.de\",\"description\":\"das Wissen der Welt geh\u00f6rt den Menschen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bmetallica.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\",\"name\":\"bmetallica\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"caption\":\"bmetallica\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Debian Patchmanagement - bmetallica.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_locale":"de_DE","og_type":"article","og_title":"Debian Patchmanagement - bmetallica.de","og_description":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →","og_url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_site_name":"bmetallica.de","article_modified_time":"2023-12-03T00:58:01+00:00","og_image":[{"url":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","name":"Debian Patchmanagement - bmetallica.de","isPartOf":{"@id":"https:\/\/www.bmetallica.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"image":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"thumbnailUrl":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","datePublished":"2023-12-03T00:22:46+00:00","dateModified":"2023-12-03T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage","url":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","width":1896,"height":978},{"@type":"BreadcrumbList","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bmetallica.de\/"},{"@type":"ListItem","position":2,"name":"Debian Patchmanagement"}]},{"@type":"WebSite","@id":"https:\/\/www.bmetallica.de\/#website","url":"https:\/\/www.bmetallica.de\/","name":"bmetallica.de","description":"das Wissen der Welt geh\u00f6rt den Menschen","publisher":{"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bmetallica.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97","name":"bmetallica","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","caption":"bmetallica"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g"}}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8uhVF-6B","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":33,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/media?parent=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/a><\/p>\nVoraussetzungen:<\/strong><\/p>\nEin Debian Server mit folgenden Paketen:<\/p>\napache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo<\/p>\n <\/p>\nInstallation des Management-Servers:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nErzeugen eines RSA-Schl\u00fcssel „ssh-keygen“<\/li>\nErweitern der „\/etc\/ssh\/ssh_config“ mit dem Wert „StrictHostKeyChecking no“<\/li>\nanpassen der sudoers f\u00fcr www-data:<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n# User privilege specification\r\nroot ALL=(ALL:ALL) ALL\r\nwww-data ALL=(ALL) NOPASSWD: ALL<\/pre>\n\nanlegen eines Verzeichnis f\u00fcr das WEB-Frontend „mkdir \/var\/www\/html\/patch“<\/li>\nPostgresql erlauben Kommunikation aus dem internen Netzwerk an zu nehmen:\n\n\n\n\/etc\/postgresql\/11\/main\/postgresql.conf\u00a0 -> listen_addresses = ‚*‘<\/li>\n\/etc\/postgres\/11\/main\/pg_hba.conf:\n# IPv4 local connections:\r\n host all all 192.168.66.1\/24 password\r\n\r\n<\/pre>\n<\/li>\n\/etc\/init.d\/postgresql restart<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\nanlegen der Datenbank in Postgresql ‚psql -U postgres -c „create database apt“‚<\/li>\neinen User f\u00fcr die Datenbank anlegen psql -d apt -U postgres -c „CREATE USER apt WITH PASSWORD ‚apt123‘;“‚<\/li>\nEine Tabelle anlegen „psql -d apt -U postgres“<\/li>\n<\/ul>\n<\/li>\n<\/ol>\nCREATE TABLE IF NOT EXISTS zustand (\r\n id SERIAL PRIMARY KEY,\r\n server VARCHAR(15) NOT NULL,\r\n sys VARCHAR(255) NOT NULL,\r\n pu VARCHAR(3) NOT NULL,\r\n ul TEXT,\r\n root_free VARCHAR(10) NOT NULL,\r\n last_run TIMESTAMP NOT NULL\r\n);\r\n<\/pre>\n<\/li>\nerzeugen der Startseite (\/var\/www\/html\/patch\/index.php)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Server Information<\/title>\r\n<style>\r\nbody {\r\nbackground-color: #0e0e0e;\r\ncolor: #ffffff;\r\nfont-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\r\nmargin: 0;\r\npadding: 0;\r\nbox-sizing: border-box;\r\noverflow-x: hidden;\r\n}\r\n\r\n.container {\r\nwidth: 100%;\r\nmargin: 50px 0;\r\noverflow-x: auto;\r\n}\r\n\r\ntable {\r\nwidth: 100%;\r\nborder-collapse: collapse;\r\nmargin-top: 20px;\r\nbackground-color: #1e1e1e;\r\nbox-shadow: 0px 0px 20px rgba(0, 0, 0, 0.5);\r\nborder-radius: 12px;\r\noverflow: hidden;\r\n}\r\n\r\nth,\r\ntd {\r\nborder: 1px solid #333;\r\npadding: 16px;\r\ntext-align: left;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\nth {\r\nbackground-color: #4CAF50;\r\ncolor: white;\r\n}\r\n\r\ntextarea {\r\nwidth: 100%;\r\nheight: 6em;\r\nresize: vertical;\r\nbackground-color: #333;\r\ncolor: #ffffff;\r\nborder: 1px solid #666;\r\npadding: 12px;\r\nborder-radius: 6px;\r\n}\r\n\r\n.action-button {\r\nbackground-color: #3498db;\r\ncolor: #ffffff;\r\npadding: 12px 20px;\r\nborder: none;\r\nborder-radius: 8px;\r\ncursor: pointer;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\n.action-button:hover {\r\nbackground-color: #2980b9;\r\n}\r\n\r\n.connected {\r\ncolor: #3498db;\r\n}\r\n\r\n.highlight-row {\r\nbackground-color: #2ecc71;\r\ncolor: #ffffff;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2 style=\"text-align: center;\">Server Information<\/h2>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>Server<\/th>\r\n<th>Debian Version<\/th>\r\n<th>Updates Possible<\/th>\r\n<th style=\"width: 100%;\">Update List<\/th>\r\n<th>Root Free<\/th>\r\n<th>Last Run<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<?php\r\n\/\/ PostgreSQL Credentials\r\n$host = \"192.168.66.31\";\r\n$user = \"postgres\";\r\n$password = \"postgres\";\r\n$database = \"apt\";\r\n\r\n\/\/ Verbindung zur Datenbank herstellen\r\n$conn = new PDO(\"pgsql:host=$host;dbname=$database;user=$user;password=$password\");\r\n\r\n\/\/ SQL-Abfrage\r\n\/\/$query = \"SELECT * FROM zustand ORDER BY server\";\r\n$query = \"SELECT * FROM zustand ORDER BY (split_part(server, '.', 4)::int)\";\r\n$result = $conn->query($query);\r\n\r\nif ($result) {\r\nforeach ($result as $row) {\r\n$name = $row['server'];\r\n$version = $row['sys'];\r\n$updates = $row['pu'];\r\n$updateList = $row['ul'];\r\n$rootFree = $row['root_free'];\r\n$lastRun = $row['last_run'];\r\n$ip = $row['ip'];\r\n\r\n\/\/ Pr\u00fcfe, ob die IP in der idlist.log vorhanden ist\r\n$IPC = shell_exec(\"cat \/var\/www\/html\/patch\/idlist.log | grep $name | wc -l\");\r\n\r\n\/\/ $isIPConnected = in_array($ip, file('\/var\/www\/html\/patch\/idlist.log;\r\n\r\n\/\/ Bestimme den Inhalt der Action-Spalte basierend auf der IP-Verbindung\r\nif ($IPC != 0 AND $updates != 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span><p><button class=\"action-button\" onclick=\"openUpdatePage(\\'' . $name . '\\', \\'' . $name . '\\')\">Server Update<\/button>';\r\n}\r\nif ($IPC != 0 AND $updates == 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span>';\r\n}\r\nif ($IPC == 0) {\r\n$action = '<button class=\"action-button\" onclick=\"openSSHPage(\\'' . $name . '\\', \\'' . $name . '\\')\">connect SSH<\/button>';\r\n}\r\n\r\n\/\/ F\u00fcge eine Klasse f\u00fcr die Hervorhebung hinzu, wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist\r\n$rowClass = ($updates > 0) ? 'highlight-row' : '';\r\n\r\necho \"<tr class='$rowClass'>\";\r\necho \"<td>$name<\/td>\";\r\necho \"<td>$version<\/td>\";\r\necho \"<td>$updates<\/td>\";\r\n\r\n\/\/ Wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist, zeige die Textarea\r\nif ($updates > 0) {\r\necho \"<td><textarea rows='6' readonly>$updateList<\/textarea><\/td>\";\r\n} else {\r\necho \"<td>$updateList<\/td>\";\r\n}\r\n\r\necho \"<td>$rootFree<\/td>\";\r\necho \"<td>$lastRun<\/td>\";\r\necho \"<td>$action<\/td>\";\r\necho \"<\/tr>\";\r\n}\r\n} else {\r\necho \"<tr><td colspan='7'>Error fetching data.<\/td><\/tr>\";\r\n}\r\n\r\n$conn = null; \/\/ Verbindung schlie\u00dfen\r\n?>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n\r\n<script>\r\nfunction openUpdatePage(serverName, serverIP) {\r\nwindow.open('supdate.php?ip=' + serverIP, '_blank');\r\n}\r\nfunction openSSHPage(serverName, serverIP) {\r\nwindow.open('sid.php?ip=' + serverIP, '_blank');\r\n}\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n\r\n<\/html><\/code><\/pre>\n<\/li>\nerzeugen des Skripts f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/imp.sh)\nip=`\/bin\/cat \/var\/www\/html\/patch\/simp.tmp`\r\nsshpass -p \"ROOTPASSWORT\" ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@$ip<\/pre>\n<\/li>\nerzeugen des PHP \u00dcbergang f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/sid.php) <\n!--?php $ip=$_GET[ip]; shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo \/var\/www\/html\/patch\/imp.sh\"); shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo $ip ?-->\r\n<\/pre>\n<\/li>\nerzeugen des PHP-Skrips f\u00fcr das Updaten (\/var\/www\/html\/patch\/supdate.sh) <\n!--?php $ip=$_GET[ip]; \/\/shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo ssh root@$ip 'apt upgrade -y'\"); $xd=shell_exec(\"sudo ssh root@$ip '\/local\/patch.sh'\"); \/\/shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo \"$xd\"; echo $ip ?--><\/pre>\n\nerzeugen des Skripts f\u00fcr die Satellite-Server (\/var\/www\/html\/patch\/patch.sh)\n#!\/bin\/bash\r\n\r\n# PostgreSQL Credentials\r\nPG_HOST=\"IP-DES-POSTGRESQL-SERVER\"\r\nPG_USER=\"apt\"\r\nPG_PASSWORD=\"apt123\"\r\nPG_DATABASE=\"apt\"\r\n\r\n# Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle\r\ninsert_or_update_data() {\r\n local server_ip=\"$1\"\r\n local debian_version=\"$2\"\r\n local updates_possible=\"$3\"\r\n local update_list=\"$4\"\r\n local root_free=\"$5\"\r\n local current_datetime=\"$(date +'%Y-%m-%d %H:%M:%S')\"\r\n\r\n # SQL-Statement zum Einf\u00fcgen oder Aktualisieren von Daten in die Tabelle\r\n psql -h \"$PG_HOST\" -U \"$PG_USER\" -d \"$PG_DATABASE\" -c \"INSERT INTO zustand (server, sys, pu, ul, root_free, last_run) VALUES ('$server_ip', '$debian_version', '$updates_possible', '$update_list', '$root_free', '$current_datetime') ON CONFLICT (server) DO UPDATE SET sys='$debian_version', pu='$updates_possible', ul='$update_list', root_free='$root_free', last_run='$current_datetime';\"\r\n}\r\n\r\n# Hauptskript\r\n\r\n# Aktualisieren Sie die Paketliste\r\napt update\r\nif ! command -v psql &> \/dev\/null\r\nthen\r\n echo \"psql is not installed. Installing postgresql-client...\"\r\n apt install -y postgresql-client\r\nfi\r\n# Erfassen von Systeminformationen\r\nserver_ip=$(hostname -I | awk '{print $1}') # IP-Adresse des Servers\r\ndebian_version=$(lsb_release -ds) # Aktuelle Debian-Version\r\nupdate_output=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null) # Ausgabe der m\u00f6glichen Updates\r\nupdates_possible=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null | wc -l) # Anzahl der m\u00f6glichen Updates\r\nupdate_list=\"$update_output\" # Liste der m\u00f6glichen Updates\r\nroot_free=$(df -h \/ | awk 'NR==2 {print $4}') # Freier Speicherplatz auf der Root-Partition\r\n\r\n# F\u00fchren Sie die Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle aus\r\ninsert_or_update_data \"$server_ip\" \"$debian_version\" \"$updates_possible\" \"$update_list\" \"$root_free\"\r\n\r\necho \"Daten erfolgreich in die PostgreSQL-Tabelle eingef\u00fcgt oder aktualisiert.\"\r\n<\/pre>\n<\/li>\nEinrichtung eines Satellitenserver:\nmkdir \/local \r\nwget http:\/\/192.168.66.31\/patch\/patch.sh -O \/local\/patch.sh \r\nchmod 777 \/local\/patch.sh \r\necho \"59 * * * * \/local\/patch.sh > \/dev\/null 2>&1\" >> \/var\/spool\/cron\/crontabs\/root \r\n\/local\/patch.sh<\/pre>\n<\/li>\nNun kann die erstellte Webseite (index.php) mit einem Browser aufgerufen werden.<\/li>\nJeder neue Satellit muss mit einem Klick auf den Button \u201econnect-SSH\u201c zuerst verbunden werden.<\/li>\nDanach kann er mit dem Button Update-Server aktualisiert werden.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-409","page","type-page","status-publish","hentry"],"yoast_head":"\nDebian Patchmanagement - bmetallica.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian Patchmanagement - bmetallica.de\" \/>\n<meta property=\"og:description\" content=\"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"bmetallica.de\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"name\":\"Debian Patchmanagement - bmetallica.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage-300x155.jpg\",\"datePublished\":\"2023-12-03T00:22:46+00:00\",\"dateModified\":\"2023-12-03T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"width\":1896,\"height\":978},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bmetallica.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian Patchmanagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/\",\"name\":\"bmetallica.de\",\"description\":\"das Wissen der Welt geh\u00f6rt den Menschen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bmetallica.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\",\"name\":\"bmetallica\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"caption\":\"bmetallica\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Debian Patchmanagement - bmetallica.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_locale":"de_DE","og_type":"article","og_title":"Debian Patchmanagement - bmetallica.de","og_description":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →","og_url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_site_name":"bmetallica.de","article_modified_time":"2023-12-03T00:58:01+00:00","og_image":[{"url":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","name":"Debian Patchmanagement - bmetallica.de","isPartOf":{"@id":"https:\/\/www.bmetallica.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"image":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"thumbnailUrl":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","datePublished":"2023-12-03T00:22:46+00:00","dateModified":"2023-12-03T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage","url":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","width":1896,"height":978},{"@type":"BreadcrumbList","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bmetallica.de\/"},{"@type":"ListItem","position":2,"name":"Debian Patchmanagement"}]},{"@type":"WebSite","@id":"https:\/\/www.bmetallica.de\/#website","url":"https:\/\/www.bmetallica.de\/","name":"bmetallica.de","description":"das Wissen der Welt geh\u00f6rt den Menschen","publisher":{"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bmetallica.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97","name":"bmetallica","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","caption":"bmetallica"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g"}}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8uhVF-6B","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":33,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/media?parent=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Voraussetzungen:<\/strong><\/p>\nEin Debian Server mit folgenden Paketen:<\/p>\napache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo<\/p>\n <\/p>\nInstallation des Management-Servers:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nErzeugen eines RSA-Schl\u00fcssel „ssh-keygen“<\/li>\nErweitern der „\/etc\/ssh\/ssh_config“ mit dem Wert „StrictHostKeyChecking no“<\/li>\nanpassen der sudoers f\u00fcr www-data:<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n# User privilege specification\r\nroot ALL=(ALL:ALL) ALL\r\nwww-data ALL=(ALL) NOPASSWD: ALL<\/pre>\n\nanlegen eines Verzeichnis f\u00fcr das WEB-Frontend „mkdir \/var\/www\/html\/patch“<\/li>\nPostgresql erlauben Kommunikation aus dem internen Netzwerk an zu nehmen:\n\n\n\n\/etc\/postgresql\/11\/main\/postgresql.conf\u00a0 -> listen_addresses = ‚*‘<\/li>\n\/etc\/postgres\/11\/main\/pg_hba.conf:\n# IPv4 local connections:\r\n host all all 192.168.66.1\/24 password\r\n\r\n<\/pre>\n<\/li>\n\/etc\/init.d\/postgresql restart<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\nanlegen der Datenbank in Postgresql ‚psql -U postgres -c „create database apt“‚<\/li>\neinen User f\u00fcr die Datenbank anlegen psql -d apt -U postgres -c „CREATE USER apt WITH PASSWORD ‚apt123‘;“‚<\/li>\nEine Tabelle anlegen „psql -d apt -U postgres“<\/li>\n<\/ul>\n<\/li>\n<\/ol>\nCREATE TABLE IF NOT EXISTS zustand (\r\n id SERIAL PRIMARY KEY,\r\n server VARCHAR(15) NOT NULL,\r\n sys VARCHAR(255) NOT NULL,\r\n pu VARCHAR(3) NOT NULL,\r\n ul TEXT,\r\n root_free VARCHAR(10) NOT NULL,\r\n last_run TIMESTAMP NOT NULL\r\n);\r\n<\/pre>\n<\/li>\nerzeugen der Startseite (\/var\/www\/html\/patch\/index.php)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Server Information<\/title>\r\n<style>\r\nbody {\r\nbackground-color: #0e0e0e;\r\ncolor: #ffffff;\r\nfont-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\r\nmargin: 0;\r\npadding: 0;\r\nbox-sizing: border-box;\r\noverflow-x: hidden;\r\n}\r\n\r\n.container {\r\nwidth: 100%;\r\nmargin: 50px 0;\r\noverflow-x: auto;\r\n}\r\n\r\ntable {\r\nwidth: 100%;\r\nborder-collapse: collapse;\r\nmargin-top: 20px;\r\nbackground-color: #1e1e1e;\r\nbox-shadow: 0px 0px 20px rgba(0, 0, 0, 0.5);\r\nborder-radius: 12px;\r\noverflow: hidden;\r\n}\r\n\r\nth,\r\ntd {\r\nborder: 1px solid #333;\r\npadding: 16px;\r\ntext-align: left;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\nth {\r\nbackground-color: #4CAF50;\r\ncolor: white;\r\n}\r\n\r\ntextarea {\r\nwidth: 100%;\r\nheight: 6em;\r\nresize: vertical;\r\nbackground-color: #333;\r\ncolor: #ffffff;\r\nborder: 1px solid #666;\r\npadding: 12px;\r\nborder-radius: 6px;\r\n}\r\n\r\n.action-button {\r\nbackground-color: #3498db;\r\ncolor: #ffffff;\r\npadding: 12px 20px;\r\nborder: none;\r\nborder-radius: 8px;\r\ncursor: pointer;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\n.action-button:hover {\r\nbackground-color: #2980b9;\r\n}\r\n\r\n.connected {\r\ncolor: #3498db;\r\n}\r\n\r\n.highlight-row {\r\nbackground-color: #2ecc71;\r\ncolor: #ffffff;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2 style=\"text-align: center;\">Server Information<\/h2>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>Server<\/th>\r\n<th>Debian Version<\/th>\r\n<th>Updates Possible<\/th>\r\n<th style=\"width: 100%;\">Update List<\/th>\r\n<th>Root Free<\/th>\r\n<th>Last Run<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<?php\r\n\/\/ PostgreSQL Credentials\r\n$host = \"192.168.66.31\";\r\n$user = \"postgres\";\r\n$password = \"postgres\";\r\n$database = \"apt\";\r\n\r\n\/\/ Verbindung zur Datenbank herstellen\r\n$conn = new PDO(\"pgsql:host=$host;dbname=$database;user=$user;password=$password\");\r\n\r\n\/\/ SQL-Abfrage\r\n\/\/$query = \"SELECT * FROM zustand ORDER BY server\";\r\n$query = \"SELECT * FROM zustand ORDER BY (split_part(server, '.', 4)::int)\";\r\n$result = $conn->query($query);\r\n\r\nif ($result) {\r\nforeach ($result as $row) {\r\n$name = $row['server'];\r\n$version = $row['sys'];\r\n$updates = $row['pu'];\r\n$updateList = $row['ul'];\r\n$rootFree = $row['root_free'];\r\n$lastRun = $row['last_run'];\r\n$ip = $row['ip'];\r\n\r\n\/\/ Pr\u00fcfe, ob die IP in der idlist.log vorhanden ist\r\n$IPC = shell_exec(\"cat \/var\/www\/html\/patch\/idlist.log | grep $name | wc -l\");\r\n\r\n\/\/ $isIPConnected = in_array($ip, file('\/var\/www\/html\/patch\/idlist.log;\r\n\r\n\/\/ Bestimme den Inhalt der Action-Spalte basierend auf der IP-Verbindung\r\nif ($IPC != 0 AND $updates != 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span><p><button class=\"action-button\" onclick=\"openUpdatePage(\\'' . $name . '\\', \\'' . $name . '\\')\">Server Update<\/button>';\r\n}\r\nif ($IPC != 0 AND $updates == 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span>';\r\n}\r\nif ($IPC == 0) {\r\n$action = '<button class=\"action-button\" onclick=\"openSSHPage(\\'' . $name . '\\', \\'' . $name . '\\')\">connect SSH<\/button>';\r\n}\r\n\r\n\/\/ F\u00fcge eine Klasse f\u00fcr die Hervorhebung hinzu, wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist\r\n$rowClass = ($updates > 0) ? 'highlight-row' : '';\r\n\r\necho \"<tr class='$rowClass'>\";\r\necho \"<td>$name<\/td>\";\r\necho \"<td>$version<\/td>\";\r\necho \"<td>$updates<\/td>\";\r\n\r\n\/\/ Wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist, zeige die Textarea\r\nif ($updates > 0) {\r\necho \"<td><textarea rows='6' readonly>$updateList<\/textarea><\/td>\";\r\n} else {\r\necho \"<td>$updateList<\/td>\";\r\n}\r\n\r\necho \"<td>$rootFree<\/td>\";\r\necho \"<td>$lastRun<\/td>\";\r\necho \"<td>$action<\/td>\";\r\necho \"<\/tr>\";\r\n}\r\n} else {\r\necho \"<tr><td colspan='7'>Error fetching data.<\/td><\/tr>\";\r\n}\r\n\r\n$conn = null; \/\/ Verbindung schlie\u00dfen\r\n?>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n\r\n<script>\r\nfunction openUpdatePage(serverName, serverIP) {\r\nwindow.open('supdate.php?ip=' + serverIP, '_blank');\r\n}\r\nfunction openSSHPage(serverName, serverIP) {\r\nwindow.open('sid.php?ip=' + serverIP, '_blank');\r\n}\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n\r\n<\/html><\/code><\/pre>\n<\/li>\nerzeugen des Skripts f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/imp.sh)\nip=`\/bin\/cat \/var\/www\/html\/patch\/simp.tmp`\r\nsshpass -p \"ROOTPASSWORT\" ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@$ip<\/pre>\n<\/li>\nerzeugen des PHP \u00dcbergang f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/sid.php) <\n!--?php $ip=$_GET[ip]; shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo \/var\/www\/html\/patch\/imp.sh\"); shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo $ip ?-->\r\n<\/pre>\n<\/li>\nerzeugen des PHP-Skrips f\u00fcr das Updaten (\/var\/www\/html\/patch\/supdate.sh) <\n!--?php $ip=$_GET[ip]; \/\/shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo ssh root@$ip 'apt upgrade -y'\"); $xd=shell_exec(\"sudo ssh root@$ip '\/local\/patch.sh'\"); \/\/shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo \"$xd\"; echo $ip ?--><\/pre>\n\nerzeugen des Skripts f\u00fcr die Satellite-Server (\/var\/www\/html\/patch\/patch.sh)\n#!\/bin\/bash\r\n\r\n# PostgreSQL Credentials\r\nPG_HOST=\"IP-DES-POSTGRESQL-SERVER\"\r\nPG_USER=\"apt\"\r\nPG_PASSWORD=\"apt123\"\r\nPG_DATABASE=\"apt\"\r\n\r\n# Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle\r\ninsert_or_update_data() {\r\n local server_ip=\"$1\"\r\n local debian_version=\"$2\"\r\n local updates_possible=\"$3\"\r\n local update_list=\"$4\"\r\n local root_free=\"$5\"\r\n local current_datetime=\"$(date +'%Y-%m-%d %H:%M:%S')\"\r\n\r\n # SQL-Statement zum Einf\u00fcgen oder Aktualisieren von Daten in die Tabelle\r\n psql -h \"$PG_HOST\" -U \"$PG_USER\" -d \"$PG_DATABASE\" -c \"INSERT INTO zustand (server, sys, pu, ul, root_free, last_run) VALUES ('$server_ip', '$debian_version', '$updates_possible', '$update_list', '$root_free', '$current_datetime') ON CONFLICT (server) DO UPDATE SET sys='$debian_version', pu='$updates_possible', ul='$update_list', root_free='$root_free', last_run='$current_datetime';\"\r\n}\r\n\r\n# Hauptskript\r\n\r\n# Aktualisieren Sie die Paketliste\r\napt update\r\nif ! command -v psql &> \/dev\/null\r\nthen\r\n echo \"psql is not installed. Installing postgresql-client...\"\r\n apt install -y postgresql-client\r\nfi\r\n# Erfassen von Systeminformationen\r\nserver_ip=$(hostname -I | awk '{print $1}') # IP-Adresse des Servers\r\ndebian_version=$(lsb_release -ds) # Aktuelle Debian-Version\r\nupdate_output=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null) # Ausgabe der m\u00f6glichen Updates\r\nupdates_possible=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null | wc -l) # Anzahl der m\u00f6glichen Updates\r\nupdate_list=\"$update_output\" # Liste der m\u00f6glichen Updates\r\nroot_free=$(df -h \/ | awk 'NR==2 {print $4}') # Freier Speicherplatz auf der Root-Partition\r\n\r\n# F\u00fchren Sie die Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle aus\r\ninsert_or_update_data \"$server_ip\" \"$debian_version\" \"$updates_possible\" \"$update_list\" \"$root_free\"\r\n\r\necho \"Daten erfolgreich in die PostgreSQL-Tabelle eingef\u00fcgt oder aktualisiert.\"\r\n<\/pre>\n<\/li>\nEinrichtung eines Satellitenserver:\nmkdir \/local \r\nwget http:\/\/192.168.66.31\/patch\/patch.sh -O \/local\/patch.sh \r\nchmod 777 \/local\/patch.sh \r\necho \"59 * * * * \/local\/patch.sh > \/dev\/null 2>&1\" >> \/var\/spool\/cron\/crontabs\/root \r\n\/local\/patch.sh<\/pre>\n<\/li>\nNun kann die erstellte Webseite (index.php) mit einem Browser aufgerufen werden.<\/li>\nJeder neue Satellit muss mit einem Klick auf den Button \u201econnect-SSH\u201c zuerst verbunden werden.<\/li>\nDanach kann er mit dem Button Update-Server aktualisiert werden.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-409","page","type-page","status-publish","hentry"],"yoast_head":"\nDebian Patchmanagement - bmetallica.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian Patchmanagement - bmetallica.de\" \/>\n<meta property=\"og:description\" content=\"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"bmetallica.de\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"name\":\"Debian Patchmanagement - bmetallica.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage-300x155.jpg\",\"datePublished\":\"2023-12-03T00:22:46+00:00\",\"dateModified\":\"2023-12-03T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"width\":1896,\"height\":978},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bmetallica.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian Patchmanagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/\",\"name\":\"bmetallica.de\",\"description\":\"das Wissen der Welt geh\u00f6rt den Menschen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bmetallica.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\",\"name\":\"bmetallica\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"caption\":\"bmetallica\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Debian Patchmanagement - bmetallica.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_locale":"de_DE","og_type":"article","og_title":"Debian Patchmanagement - bmetallica.de","og_description":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →","og_url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_site_name":"bmetallica.de","article_modified_time":"2023-12-03T00:58:01+00:00","og_image":[{"url":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","name":"Debian Patchmanagement - bmetallica.de","isPartOf":{"@id":"https:\/\/www.bmetallica.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"image":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"thumbnailUrl":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","datePublished":"2023-12-03T00:22:46+00:00","dateModified":"2023-12-03T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage","url":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","width":1896,"height":978},{"@type":"BreadcrumbList","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bmetallica.de\/"},{"@type":"ListItem","position":2,"name":"Debian Patchmanagement"}]},{"@type":"WebSite","@id":"https:\/\/www.bmetallica.de\/#website","url":"https:\/\/www.bmetallica.de\/","name":"bmetallica.de","description":"das Wissen der Welt geh\u00f6rt den Menschen","publisher":{"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bmetallica.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97","name":"bmetallica","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","caption":"bmetallica"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g"}}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8uhVF-6B","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":33,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/media?parent=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Ein Debian Server mit folgenden Paketen:<\/p>\n
apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo<\/p>\n
<\/p>\n
Installation des Management-Servers:<\/p>\n
# User privilege specification\r\nroot ALL=(ALL:ALL) ALL\r\nwww-data ALL=(ALL) NOPASSWD: ALL<\/pre>\n
# IPv4 local connections:\r\n host all all 192.168.66.1\/24 password\r\n\r\n<\/pre>\n<\/li>\n
CREATE TABLE IF NOT EXISTS zustand (\r\n id SERIAL PRIMARY KEY,\r\n server VARCHAR(15) NOT NULL,\r\n sys VARCHAR(255) NOT NULL,\r\n pu VARCHAR(3) NOT NULL,\r\n ul TEXT,\r\n root_free VARCHAR(10) NOT NULL,\r\n last_run TIMESTAMP NOT NULL\r\n);\r\n<\/pre>\n<\/li>\n
<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Server Information<\/title>\r\n<style>\r\nbody {\r\nbackground-color: #0e0e0e;\r\ncolor: #ffffff;\r\nfont-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\r\nmargin: 0;\r\npadding: 0;\r\nbox-sizing: border-box;\r\noverflow-x: hidden;\r\n}\r\n\r\n.container {\r\nwidth: 100%;\r\nmargin: 50px 0;\r\noverflow-x: auto;\r\n}\r\n\r\ntable {\r\nwidth: 100%;\r\nborder-collapse: collapse;\r\nmargin-top: 20px;\r\nbackground-color: #1e1e1e;\r\nbox-shadow: 0px 0px 20px rgba(0, 0, 0, 0.5);\r\nborder-radius: 12px;\r\noverflow: hidden;\r\n}\r\n\r\nth,\r\ntd {\r\nborder: 1px solid #333;\r\npadding: 16px;\r\ntext-align: left;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\nth {\r\nbackground-color: #4CAF50;\r\ncolor: white;\r\n}\r\n\r\ntextarea {\r\nwidth: 100%;\r\nheight: 6em;\r\nresize: vertical;\r\nbackground-color: #333;\r\ncolor: #ffffff;\r\nborder: 1px solid #666;\r\npadding: 12px;\r\nborder-radius: 6px;\r\n}\r\n\r\n.action-button {\r\nbackground-color: #3498db;\r\ncolor: #ffffff;\r\npadding: 12px 20px;\r\nborder: none;\r\nborder-radius: 8px;\r\ncursor: pointer;\r\ntransition: background-color 0.3s ease;\r\n}\r\n\r\n.action-button:hover {\r\nbackground-color: #2980b9;\r\n}\r\n\r\n.connected {\r\ncolor: #3498db;\r\n}\r\n\r\n.highlight-row {\r\nbackground-color: #2ecc71;\r\ncolor: #ffffff;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2 style=\"text-align: center;\">Server Information<\/h2>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>Server<\/th>\r\n<th>Debian Version<\/th>\r\n<th>Updates Possible<\/th>\r\n<th style=\"width: 100%;\">Update List<\/th>\r\n<th>Root Free<\/th>\r\n<th>Last Run<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<?php\r\n\/\/ PostgreSQL Credentials\r\n$host = \"192.168.66.31\";\r\n$user = \"postgres\";\r\n$password = \"postgres\";\r\n$database = \"apt\";\r\n\r\n\/\/ Verbindung zur Datenbank herstellen\r\n$conn = new PDO(\"pgsql:host=$host;dbname=$database;user=$user;password=$password\");\r\n\r\n\/\/ SQL-Abfrage\r\n\/\/$query = \"SELECT * FROM zustand ORDER BY server\";\r\n$query = \"SELECT * FROM zustand ORDER BY (split_part(server, '.', 4)::int)\";\r\n$result = $conn->query($query);\r\n\r\nif ($result) {\r\nforeach ($result as $row) {\r\n$name = $row['server'];\r\n$version = $row['sys'];\r\n$updates = $row['pu'];\r\n$updateList = $row['ul'];\r\n$rootFree = $row['root_free'];\r\n$lastRun = $row['last_run'];\r\n$ip = $row['ip'];\r\n\r\n\/\/ Pr\u00fcfe, ob die IP in der idlist.log vorhanden ist\r\n$IPC = shell_exec(\"cat \/var\/www\/html\/patch\/idlist.log | grep $name | wc -l\");\r\n\r\n\/\/ $isIPConnected = in_array($ip, file('\/var\/www\/html\/patch\/idlist.log;\r\n\r\n\/\/ Bestimme den Inhalt der Action-Spalte basierend auf der IP-Verbindung\r\nif ($IPC != 0 AND $updates != 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span><p><button class=\"action-button\" onclick=\"openUpdatePage(\\'' . $name . '\\', \\'' . $name . '\\')\">Server Update<\/button>';\r\n}\r\nif ($IPC != 0 AND $updates == 0) {\r\n$action = '<span class=\"connected\">✔ ssh connected<\/span>';\r\n}\r\nif ($IPC == 0) {\r\n$action = '<button class=\"action-button\" onclick=\"openSSHPage(\\'' . $name . '\\', \\'' . $name . '\\')\">connect SSH<\/button>';\r\n}\r\n\r\n\/\/ F\u00fcge eine Klasse f\u00fcr die Hervorhebung hinzu, wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist\r\n$rowClass = ($updates > 0) ? 'highlight-row' : '';\r\n\r\necho \"<tr class='$rowClass'>\";\r\necho \"<td>$name<\/td>\";\r\necho \"<td>$version<\/td>\";\r\necho \"<td>$updates<\/td>\";\r\n\r\n\/\/ Wenn \"Updates Possible\" gr\u00f6\u00dfer als 0 ist, zeige die Textarea\r\nif ($updates > 0) {\r\necho \"<td><textarea rows='6' readonly>$updateList<\/textarea><\/td>\";\r\n} else {\r\necho \"<td>$updateList<\/td>\";\r\n}\r\n\r\necho \"<td>$rootFree<\/td>\";\r\necho \"<td>$lastRun<\/td>\";\r\necho \"<td>$action<\/td>\";\r\necho \"<\/tr>\";\r\n}\r\n} else {\r\necho \"<tr><td colspan='7'>Error fetching data.<\/td><\/tr>\";\r\n}\r\n\r\n$conn = null; \/\/ Verbindung schlie\u00dfen\r\n?>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n\r\n<script>\r\nfunction openUpdatePage(serverName, serverIP) {\r\nwindow.open('supdate.php?ip=' + serverIP, '_blank');\r\n}\r\nfunction openSSHPage(serverName, serverIP) {\r\nwindow.open('sid.php?ip=' + serverIP, '_blank');\r\n}\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n\r\n<\/html><\/code><\/pre>\n<\/li>\nerzeugen des Skripts f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/imp.sh)\nip=`\/bin\/cat \/var\/www\/html\/patch\/simp.tmp`\r\nsshpass -p \"ROOTPASSWORT\" ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@$ip<\/pre>\n<\/li>\nerzeugen des PHP \u00dcbergang f\u00fcr den Import der SSH-Keys (\/var\/www\/html\/patch\/sid.php) <\n!--?php $ip=$_GET[ip]; shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo \/var\/www\/html\/patch\/imp.sh\"); shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo $ip ?-->\r\n<\/pre>\n<\/li>\nerzeugen des PHP-Skrips f\u00fcr das Updaten (\/var\/www\/html\/patch\/supdate.sh) <\n!--?php $ip=$_GET[ip]; \/\/shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo ssh root@$ip 'apt upgrade -y'\"); $xd=shell_exec(\"sudo ssh root@$ip '\/local\/patch.sh'\"); \/\/shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo \"$xd\"; echo $ip ?--><\/pre>\n\nerzeugen des Skripts f\u00fcr die Satellite-Server (\/var\/www\/html\/patch\/patch.sh)\n#!\/bin\/bash\r\n\r\n# PostgreSQL Credentials\r\nPG_HOST=\"IP-DES-POSTGRESQL-SERVER\"\r\nPG_USER=\"apt\"\r\nPG_PASSWORD=\"apt123\"\r\nPG_DATABASE=\"apt\"\r\n\r\n# Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle\r\ninsert_or_update_data() {\r\n local server_ip=\"$1\"\r\n local debian_version=\"$2\"\r\n local updates_possible=\"$3\"\r\n local update_list=\"$4\"\r\n local root_free=\"$5\"\r\n local current_datetime=\"$(date +'%Y-%m-%d %H:%M:%S')\"\r\n\r\n # SQL-Statement zum Einf\u00fcgen oder Aktualisieren von Daten in die Tabelle\r\n psql -h \"$PG_HOST\" -U \"$PG_USER\" -d \"$PG_DATABASE\" -c \"INSERT INTO zustand (server, sys, pu, ul, root_free, last_run) VALUES ('$server_ip', '$debian_version', '$updates_possible', '$update_list', '$root_free', '$current_datetime') ON CONFLICT (server) DO UPDATE SET sys='$debian_version', pu='$updates_possible', ul='$update_list', root_free='$root_free', last_run='$current_datetime';\"\r\n}\r\n\r\n# Hauptskript\r\n\r\n# Aktualisieren Sie die Paketliste\r\napt update\r\nif ! command -v psql &> \/dev\/null\r\nthen\r\n echo \"psql is not installed. Installing postgresql-client...\"\r\n apt install -y postgresql-client\r\nfi\r\n# Erfassen von Systeminformationen\r\nserver_ip=$(hostname -I | awk '{print $1}') # IP-Adresse des Servers\r\ndebian_version=$(lsb_release -ds) # Aktuelle Debian-Version\r\nupdate_output=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null) # Ausgabe der m\u00f6glichen Updates\r\nupdates_possible=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null | wc -l) # Anzahl der m\u00f6glichen Updates\r\nupdate_list=\"$update_output\" # Liste der m\u00f6glichen Updates\r\nroot_free=$(df -h \/ | awk 'NR==2 {print $4}') # Freier Speicherplatz auf der Root-Partition\r\n\r\n# F\u00fchren Sie die Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle aus\r\ninsert_or_update_data \"$server_ip\" \"$debian_version\" \"$updates_possible\" \"$update_list\" \"$root_free\"\r\n\r\necho \"Daten erfolgreich in die PostgreSQL-Tabelle eingef\u00fcgt oder aktualisiert.\"\r\n<\/pre>\n<\/li>\nEinrichtung eines Satellitenserver:\nmkdir \/local \r\nwget http:\/\/192.168.66.31\/patch\/patch.sh -O \/local\/patch.sh \r\nchmod 777 \/local\/patch.sh \r\necho \"59 * * * * \/local\/patch.sh > \/dev\/null 2>&1\" >> \/var\/spool\/cron\/crontabs\/root \r\n\/local\/patch.sh<\/pre>\n<\/li>\nNun kann die erstellte Webseite (index.php) mit einem Browser aufgerufen werden.<\/li>\nJeder neue Satellit muss mit einem Klick auf den Button \u201econnect-SSH\u201c zuerst verbunden werden.<\/li>\nDanach kann er mit dem Button Update-Server aktualisiert werden.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-409","page","type-page","status-publish","hentry"],"yoast_head":"\nDebian Patchmanagement - bmetallica.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian Patchmanagement - bmetallica.de\" \/>\n<meta property=\"og:description\" content=\"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"bmetallica.de\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"name\":\"Debian Patchmanagement - bmetallica.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage-300x155.jpg\",\"datePublished\":\"2023-12-03T00:22:46+00:00\",\"dateModified\":\"2023-12-03T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"width\":1896,\"height\":978},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bmetallica.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian Patchmanagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/\",\"name\":\"bmetallica.de\",\"description\":\"das Wissen der Welt geh\u00f6rt den Menschen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bmetallica.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\",\"name\":\"bmetallica\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"caption\":\"bmetallica\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Debian Patchmanagement - bmetallica.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_locale":"de_DE","og_type":"article","og_title":"Debian Patchmanagement - bmetallica.de","og_description":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →","og_url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_site_name":"bmetallica.de","article_modified_time":"2023-12-03T00:58:01+00:00","og_image":[{"url":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","name":"Debian Patchmanagement - bmetallica.de","isPartOf":{"@id":"https:\/\/www.bmetallica.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"image":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"thumbnailUrl":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","datePublished":"2023-12-03T00:22:46+00:00","dateModified":"2023-12-03T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage","url":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","width":1896,"height":978},{"@type":"BreadcrumbList","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bmetallica.de\/"},{"@type":"ListItem","position":2,"name":"Debian Patchmanagement"}]},{"@type":"WebSite","@id":"https:\/\/www.bmetallica.de\/#website","url":"https:\/\/www.bmetallica.de\/","name":"bmetallica.de","description":"das Wissen der Welt geh\u00f6rt den Menschen","publisher":{"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bmetallica.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97","name":"bmetallica","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","caption":"bmetallica"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g"}}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8uhVF-6B","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":33,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/media?parent=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
ip=`\/bin\/cat \/var\/www\/html\/patch\/simp.tmp`\r\nsshpass -p \"ROOTPASSWORT\" ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@$ip<\/pre>\n<\/li>\n
!--?php $ip=$_GET[ip]; shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo \/var\/www\/html\/patch\/imp.sh\"); shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo $ip ?-->\r\n<\/pre>\n<\/li>\n
!--?php $ip=$_GET[ip]; \/\/shell_exec(\"sudo echo $ip > \/var\/www\/html\/patch\/simp.tmp\"); $d=shell_exec(\"sudo ssh root@$ip 'apt upgrade -y'\"); $xd=shell_exec(\"sudo ssh root@$ip '\/local\/patch.sh'\"); \/\/shell_exec(\"sudo echo $ip >> \/var\/www\/html\/patch\/idlist.log\"); echo \"$d\"; echo \"$xd\"; echo $ip ?--><\/pre>\n
#!\/bin\/bash\r\n\r\n# PostgreSQL Credentials\r\nPG_HOST=\"IP-DES-POSTGRESQL-SERVER\"\r\nPG_USER=\"apt\"\r\nPG_PASSWORD=\"apt123\"\r\nPG_DATABASE=\"apt\"\r\n\r\n# Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle\r\ninsert_or_update_data() {\r\n local server_ip=\"$1\"\r\n local debian_version=\"$2\"\r\n local updates_possible=\"$3\"\r\n local update_list=\"$4\"\r\n local root_free=\"$5\"\r\n local current_datetime=\"$(date +'%Y-%m-%d %H:%M:%S')\"\r\n\r\n # SQL-Statement zum Einf\u00fcgen oder Aktualisieren von Daten in die Tabelle\r\n psql -h \"$PG_HOST\" -U \"$PG_USER\" -d \"$PG_DATABASE\" -c \"INSERT INTO zustand (server, sys, pu, ul, root_free, last_run) VALUES ('$server_ip', '$debian_version', '$updates_possible', '$update_list', '$root_free', '$current_datetime') ON CONFLICT (server) DO UPDATE SET sys='$debian_version', pu='$updates_possible', ul='$update_list', root_free='$root_free', last_run='$current_datetime';\"\r\n}\r\n\r\n# Hauptskript\r\n\r\n# Aktualisieren Sie die Paketliste\r\napt update\r\nif ! command -v psql &> \/dev\/null\r\nthen\r\n echo \"psql is not installed. Installing postgresql-client...\"\r\n apt install -y postgresql-client\r\nfi\r\n# Erfassen von Systeminformationen\r\nserver_ip=$(hostname -I | awk '{print $1}') # IP-Adresse des Servers\r\ndebian_version=$(lsb_release -ds) # Aktuelle Debian-Version\r\nupdate_output=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null) # Ausgabe der m\u00f6glichen Updates\r\nupdates_possible=$(apt list --upgradable 2>\/dev\/null |grep -v \"Listing\" |grep -v \"Auflistung\" 2>\/dev\/null | wc -l) # Anzahl der m\u00f6glichen Updates\r\nupdate_list=\"$update_output\" # Liste der m\u00f6glichen Updates\r\nroot_free=$(df -h \/ | awk 'NR==2 {print $4}') # Freier Speicherplatz auf der Root-Partition\r\n\r\n# F\u00fchren Sie die Funktion zum Einf\u00fcgen oder Aktualisieren von Daten in die PostgreSQL-Tabelle aus\r\ninsert_or_update_data \"$server_ip\" \"$debian_version\" \"$updates_possible\" \"$update_list\" \"$root_free\"\r\n\r\necho \"Daten erfolgreich in die PostgreSQL-Tabelle eingef\u00fcgt oder aktualisiert.\"\r\n<\/pre>\n<\/li>\n
mkdir \/local \r\nwget http:\/\/192.168.66.31\/patch\/patch.sh -O \/local\/patch.sh \r\nchmod 777 \/local\/patch.sh \r\necho \"59 * * * * \/local\/patch.sh > \/dev\/null 2>&1\" >> \/var\/spool\/cron\/crontabs\/root \r\n\/local\/patch.sh<\/pre>\n<\/li>\n
Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-409","page","type-page","status-publish","hentry"],"yoast_head":"\nDebian Patchmanagement - bmetallica.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian Patchmanagement - bmetallica.de\" \/>\n<meta property=\"og:description\" content=\"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"bmetallica.de\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\",\"name\":\"Debian Patchmanagement - bmetallica.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage-300x155.jpg\",\"datePublished\":\"2023-12-03T00:22:46+00:00\",\"dateModified\":\"2023-12-03T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.bmetallica.de\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/manage.jpg?fit=1896%2C978&ssl=1\",\"width\":1896,\"height\":978},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/index.php\\\/debian-patchmanagement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bmetallica.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian Patchmanagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bmetallica.de\\\/\",\"name\":\"bmetallica.de\",\"description\":\"das Wissen der Welt geh\u00f6rt den Menschen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bmetallica.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.bmetallica.de\\\/#\\\/schema\\\/person\\\/95f9265fa19015a54cb0537aad39bf97\",\"name\":\"bmetallica\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\",\"caption\":\"bmetallica\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Debian Patchmanagement - bmetallica.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_locale":"de_DE","og_type":"article","og_title":"Debian Patchmanagement - bmetallica.de","og_description":"Debian Patchmanagement Ziel ist es ein einfaches Patchmanagement mit Webinterface f\u00fcr eine Anzahl von Debian Servern zu schaffen. Voraussetzungen: Ein Debian Server mit folgenden Paketen: apache2, php, postgresql-server, php-pgsql, openssh-server, sshpass, sudo Installation des Management-Servers: Erzeugen eines RSA-Schl\u00fcssel „ssh-keygen“... Continue Reading →","og_url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","og_site_name":"bmetallica.de","article_modified_time":"2023-12-03T00:58:01+00:00","og_image":[{"url":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","url":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/","name":"Debian Patchmanagement - bmetallica.de","isPartOf":{"@id":"https:\/\/www.bmetallica.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"image":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage"},"thumbnailUrl":"http:\/\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage-300x155.jpg","datePublished":"2023-12-03T00:22:46+00:00","dateModified":"2023-12-03T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#primaryimage","url":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?fit=1896%2C978&ssl=1","width":1896,"height":978},{"@type":"BreadcrumbList","@id":"https:\/\/www.bmetallica.de\/index.php\/debian-patchmanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bmetallica.de\/"},{"@type":"ListItem","position":2,"name":"Debian Patchmanagement"}]},{"@type":"WebSite","@id":"https:\/\/www.bmetallica.de\/#website","url":"https:\/\/www.bmetallica.de\/","name":"bmetallica.de","description":"das Wissen der Welt geh\u00f6rt den Menschen","publisher":{"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bmetallica.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bmetallica.de\/#\/schema\/person\/95f9265fa19015a54cb0537aad39bf97","name":"bmetallica","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g","caption":"bmetallica"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/1a90b65655e93274890daff126ceebcc75e52e4da445ee5c6831e925e3c619cf?s=96&d=mm&r=g"}}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8uhVF-6B","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":33,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/pages\/409\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.bmetallica.de\/index.php\/wp-json\/wp\/v2\/media?parent=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg?resize=300%2C155\")
<\/a><\/p>\n![\"\"](\"https:\/\/i0.wp.com\/www.bmetallica.de\/wp-content\/uploads\/2023\/12\/manage.jpg\")
<\/a><\/p>\n