Table des matières
- 2026:
- 2025:
12 billet(s) pour novembre 2026
| Notes conversion JSON YAML | 2026/11/13 11:16 | Jean-Baptiste |
| Git commit perdu | 2026/11/12 18:16 | Jean-Baptiste |
| Notes mojo lang | 2026/11/11 20:34 | Jean-Baptiste |
| Notes rust lang compilation | 2026/11/11 18:35 | Jean-Baptiste |
| Mémoire VSIZE VMSIZE SEGV lang C | 2026/11/11 15:59 | Jean-Baptiste |
| Ansible-navigator utilisation de ansible-vault | 2026/11/06 11:33 | Jean-Baptiste |
| Err Ansible - Module result deserialization failed No start of json char found | 2026/11/06 09:09 | Jean-Baptiste |
| Script Python conversion JSON vers CSV | 2026/11/06 08:14 | Jean-Baptiste |
| Filter Incoming IPv4 Packets Containing IP Options - cve-2026-98432 mitigation - Kernel TCP Use-After-Free | 2026/11/04 21:04 | Jean-Baptiste |
| Notes ZFS | 2026/11/03 18:04 | Jean-Baptiste |
| Diff image container | 2026/11/03 16:30 | Jean-Baptiste |
| Notes processus multi-thread | 2026/11/03 10:59 | Jean-Baptiste |
Ansible-navigator utilisation de ansible-vault
Erreur "Attempting to decrypt but no vault secrets found"
ansible-navigator -m stdout --eei registry.acme.local/repository/local-docker/ansible-builder:0.0.10 run tests/ main.yml -i inventories --limit srv03-vm -u ansible -e "ansible_become_password=$PASS"
TASK [../.. : Log into registry.acme.local] ********************************
fatal: [srv03-vm]: FAILED! => {"msg": "Attempting to decrypt but no vault secrets found"}
Solution
cp -p ~/.ansible/.vault_pass .
ansible.cfg
[defaults] vault_password_file = .vault_pass
ansible-navigator.yml
ansible-navigator: ansible: config: path: ansible.cfg
Err Ansible - Module result deserialization failed No start of json char found
- Connexion SSH OK
- Ansible ping NOK
"module_stdout": " File \"/home/ansible/.ansible/tmp/ansible-tmp-1793904492.8637123-21045-75480237419326/AnsiballZ_ping.py\", line 3\r\n from __future__ import anno tations\r\n ^\r\nSyntaxError: future feature annotations is not defined\r\n", "msg": "Module result deserialization failed: No start of json char found", "rc": 1 }
Cause :
Version Ansible ou de l'Execution Environment incompatible avec la version de Python installée sur le Managed host.
Script Python conversion JSON vers CSV
Exemple 1 - 2 colonnes - clefs / valeurs
json2csv_kv.py
#! /usr/bin/env python3 import sys import json import argparse parser = argparse.ArgumentParser(epilog="""Convert JSON file to CSV.""") parser.add_argument("-i", help="Input JSON file") parser.add_argument("-o", help="Output CSV file") args = parser.parse_args() def concat(a, b): a = str(a) b = str(b) return a + "_" + b def quote_string(thing): if isinstance(thing, str): return '"{}"'.format(thing) else: return thing def recursiv_if_json_dict(k, v): if isinstance(v, dict): for k2, v2 in v.items(): recursiv_if_json_dict(concat(k, k2), v2) else: write(k, v) def recursiv_if_json_list(thing): new_list = [] if isinstance(l, list): for elm in thing: if isinstance(elm, list): recursiv_if_json_list(elm) else: new_list.append(elm) return new_list def convert_json2csv(): with open(args.i, "r") as json_file: json_load = json.load(json_file) if isinstance(json_load, dict): for k, v in json_load.items(): recursiv_if_json_dict(k, v) elif isinstance(json_load, list): for elm in json_load: recursiv_if_json_list def write(k, v): with open(args.o, "a") as csv_file: print(quote_string(k), quote_string(v), sep=";", file=csv_file, flush=True) def truncate(): with open(args.o, "a+") as csv_file: csv_file.truncate(0) def main(): if args.i and args.o: truncate() convert_json2csv() sys.exit(0) if __name__ == "__main__": main()
cat /proc/meminfo | jc --proc-meminfo > meminfo.json ./json2csv_kv.py -i meminfo.json -o meminfo.csv
Exemple 2 - liste de dictionnaires
Filtrage préliminaire du JSON
cat Takeout/Chrome/Historique.json | jq '."Browser History"' > Historique2.json
json2csv_list_of_dicts.py
#!/usr/bin/env python3 import sys import json import argparse from datetime import datetime parser = argparse.ArgumentParser(epilog="""Convert JSON file to CSV.""") parser.add_argument("-i", help="Input JSON file") parser.add_argument("-o", help="Output CSV file") args = parser.parse_args() def clean_field(field): """ Clean each fields. CSV use ';' as field separator and so all ';' characters must be removed CSV use line break as line separator and so all '\n' and '\r' characters must be replaced """ if field is None or field == "Undefined": ret = "" else: ret = str(field).strip().replace(";", "").replace("\n", ",").replace("\r", ",") return ret def quote_string(thing): if isinstance(thing, str): return '"{}"'.format(thing) else: return thing def get_date_time(utimestamp): ts = datetime.fromtimestamp(utimestamp // 1000000) return ts.date(), ts.time() def convert_json2csv(): with open(args.i, "r") as json_file: json_load = json.load(json_file) with open(args.o, "a+") as csv_file: headers = json_load[0].copy() headers["time_date"], headers["time_time"] = None, None del headers["time_usec"] print(";".join(headers), file=csv_file, flush=True) for elm in json_load: elm["time_date"], elm["time_time"] = get_date_time(elm["time_usec"]) del elm["time_usec"] for v in elm.values(): print(quote_string(clean_field(v)), end=";", file=csv_file, flush=True) print(file=csv_file, flush=True) def truncate(): with open(args.o, "a+") as csv_file: csv_file.truncate(0) def main(): if args.i and args.o: truncate() convert_json2csv() sys.exit(0) if __name__ == "__main__": main()
./json2csv_list_of_dicts.py -i Historique2.json -o Historique.csv
Exemple 2b
Bon, il y avait plus simple
# cat Historique.json | jq -r '."Browser History".[0] | keys | @csv' echo '"favicon_url","page_transition_qualifier","title","url","time_usec","client_id"' > Historique.csv jq --raw-output ' ."Browser History".[] | [.favicon_url, .page_transition_qualifier, .title, .url, .time_usec, .client_id] | @csv ' Historique.json >> Historique.csv
Autres
Conversion CSV vers JSON
man jc
...
--csv CSV file parser
--csv-ih
CSV implicit header file parser
--csv-s
CSV file streaming parser
--csv-ih-s
CSV implicit header file streaming parser
...
cat Historique.csv | jc --csv
Notes ZFS
Brouillon
Voir :
Ubuntu / Debian : Installation via le paquet zfsutils-linux (ou en passant par DKMS via zfs-dkms), ou via des méta-paquets spécifiques de modules noyau comme linux-main-modules-zfs sur les versions récentes
Commandes principales de gestion
Créer un pool (zpool)
zpool create -f nomdupool /dev/sdX
• Créer un système de fichiers ZFS : bash zfs create nomdupool/mondataset
• Vérifier l'état des pools : bash zpool status
• Lancer un contrôle d'intégrité (scrub) : bash zpool scrub nomdupool
