Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentesRévision précédenteProchaine révision | Révision précédente | ||
| tech:sql-01 [23/10/2025 17:36] – [Routage et filtrage avec iptables] LibertAdmin | tech:sql-01 [18/01/2026 16:23] (Version actuelle) – [Paquets installés] LibertAdmin | ||
|---|---|---|---|
| Ligne 20: | Ligne 20: | ||
| Ce serveur héberge donc les services : | Ce serveur héberge donc les services : | ||
| - | * MySQL/MariaDB | + | * MariaDB |
| * PostgreSQL | * PostgreSQL | ||
| - | * Redis | + | * Valkey |
| ===== Configuration ===== | ===== Configuration ===== | ||
| Ligne 109: | Ligne 109: | ||
| ==== Paquets installés ==== | ==== Paquets installés ==== | ||
| - | Nous utilisons le dépôts '' | + | Nous utilisons le dépôts '' |
| < | < | ||
| - | deb http:// | + | deb http:// |
| </ | </ | ||
| Ligne 133: | Ligne 133: | ||
| bind9-libs: | bind9-libs: | ||
| bsdextrautils | bsdextrautils | ||
| + | bsd-mailx | ||
| bsdutils | bsdutils | ||
| busybox | busybox | ||
| Ligne 166: | Ligne 167: | ||
| doc-debian | doc-debian | ||
| dpkg | dpkg | ||
| + | dracut-install | ||
| e2fsprogs | e2fsprogs | ||
| eject | eject | ||
| emacsen-common | emacsen-common | ||
| ethtool | ethtool | ||
| + | exim4-base | ||
| + | exim4-config | ||
| + | exim4-daemon-light | ||
| exuberant-ctags | exuberant-ctags | ||
| fail2ban | fail2ban | ||
| Ligne 175: | Ligne 180: | ||
| file | file | ||
| findutils | findutils | ||
| + | firmware-ath9k-htc | ||
| + | firmware-carl9170 | ||
| firmware-linux-free | firmware-linux-free | ||
| fontconfig-config | fontconfig-config | ||
| fonts-dejavu-core | fonts-dejavu-core | ||
| + | fonts-dejavu-mono | ||
| galera-4 | galera-4 | ||
| gawk | gawk | ||
| gcc-10-base: | gcc-10-base: | ||
| - | gcc-12-base:amd64 | + | gcc-14-base:amd64 |
| gcc-8-base: | gcc-8-base: | ||
| gdal-data | gdal-data | ||
| - | gdal-plugins | + | gdal-plugins:amd64 |
| gdbm-l10n | gdbm-l10n | ||
| gettext-base | gettext-base | ||
| Ligne 214: | Ligne 222: | ||
| init | init | ||
| initramfs-tools | initramfs-tools | ||
| + | initramfs-tools-bin | ||
| initramfs-tools-core | initramfs-tools-core | ||
| init-system-helpers | init-system-helpers | ||
| Ligne 234: | Ligne 243: | ||
| laptop-detect | laptop-detect | ||
| less | less | ||
| + | libabsl20240722: | ||
| libacl1: | libacl1: | ||
| libaec0: | libaec0: | ||
| Ligne 240: | Ligne 250: | ||
| libapt-inst2.0: | libapt-inst2.0: | ||
| libapt-pkg5.0: | libapt-pkg5.0: | ||
| - | libapt-pkg6.0:amd64 | + | libapt-pkg7.0:amd64 |
| libargon2-1: | libargon2-1: | ||
| - | libarmadillo11 | + | libarmadillo14 |
| - | libarpack2:amd64 | + | libarpack2t64:amd64 |
| libaspell15: | libaspell15: | ||
| - | libassuan0:amd64 | + | libassuan9:amd64 |
| libatomic1: | libatomic1: | ||
| libattr1: | libattr1: | ||
| libaudit1: | libaudit1: | ||
| libaudit-common | libaudit-common | ||
| + | libavif16: | ||
| libblas3: | libblas3: | ||
| libblkid1: | libblkid1: | ||
| Ligne 262: | Ligne 273: | ||
| libcap-ng0: | libcap-ng0: | ||
| libc-bin | libc-bin | ||
| - | libcbor0.8:amd64 | + | libcbor0.10:amd64 |
| - | libcfitsio10:amd64 | + | libcfitsio10t64:amd64 |
| libcgi-fast-perl | libcgi-fast-perl | ||
| libcgi-pm-perl | libcgi-pm-perl | ||
| Ligne 273: | Ligne 284: | ||
| libcrypt1: | libcrypt1: | ||
| libcryptsetup12: | libcryptsetup12: | ||
| - | libcurl3-gnutls: | + | libcurl3t64-gnutls: |
| - | libcurl4:amd64 | + | libcurl4t64:amd64 |
| - | libdav1d6: | + | libdav1d7:amd64 |
| - | libdaxctl1:amd64 | + | libdb5.3t64:amd64 |
| - | libdb5.3:amd64 | + | |
| libdbd-mysql-perl: | libdbd-mysql-perl: | ||
| libdbd-pg-perl | libdbd-pg-perl | ||
| Ligne 289: | Ligne 299: | ||
| libdns-export1104 | libdns-export1104 | ||
| libedit2: | libedit2: | ||
| - | libefiboot1:amd64 | + | libefiboot1t64:amd64 |
| - | libefivar1:amd64 | + | libefivar1t64:amd64 |
| - | libelf1:amd64 | + | libelf1t64:amd64 |
| libencode-locale-perl | libencode-locale-perl | ||
| libestr0: | libestr0: | ||
| - | libevent-core-2.1-7:amd64 | + | libevent-2.1-7t64: |
| + | libevent-core-2.1-7t64:amd64 | ||
| libexpat1: | libexpat1: | ||
| - | libext2fs2:amd64 | + | libext2fs2t64:amd64 |
| libfastjson4: | libfastjson4: | ||
| - | libfcgi0ldbl:amd64 | + | libfcgi0t64:amd64 |
| libfcgi-bin | libfcgi-bin | ||
| libfcgi-perl | libfcgi-perl | ||
| Ligne 305: | Ligne 316: | ||
| libffi8: | libffi8: | ||
| libfido2-1: | libfido2-1: | ||
| - | libfile-find-rule-perl | + | libfile-fcntllock-perl |
| libfontconfig1: | libfontconfig1: | ||
| libfreetype6: | libfreetype6: | ||
| libfreexl1: | libfreexl1: | ||
| libfstrm0: | libfstrm0: | ||
| - | libfuse2:amd64 | + | libfuse3-4:amd64 |
| - | libfyba0:amd64 | + | libfyba0t64: |
| + | libgav1-1:amd64 | ||
| libgc1: | libgc1: | ||
| libgcc1: | libgcc1: | ||
| libgcc-s1: | libgcc-s1: | ||
| libgcrypt20: | libgcrypt20: | ||
| - | libgdal32 | + | libgdal36: |
| - | libgdbm6:amd64 | + | libgdbm6t64:amd64 |
| - | libgdbm-compat4:amd64 | + | libgdbm-compat4t64:amd64 |
| - | libgeos3.11.1:amd64 | + | libgeos3.13.1:amd64 |
| - | libgeos-c1v5:amd64 | + | libgeos-c1t64:amd64 |
| libgeotiff5: | libgeotiff5: | ||
| libgfortran5: | libgfortran5: | ||
| libgif7: | libgif7: | ||
| - | libglib2.0-0:amd64 | + | libglib2.0-0t64:amd64 |
| libglib2.0-data | libglib2.0-data | ||
| libgmp10: | libgmp10: | ||
| - | libgnutls30:amd64 | + | libgnutls30t64: |
| + | libgnutls-dane0t64:amd64 | ||
| libgpg-error0: | libgpg-error0: | ||
| + | libgpgme11t64: | ||
| + | libgpgmepp6t64: | ||
| libgpm2: | libgpm2: | ||
| libgssapi-krb5-2: | libgssapi-krb5-2: | ||
| - | libhdf4-0-alt | + | libhdf4-0-alt:amd64 |
| - | libhdf5-103-1:amd64 | + | libhdf5-310:amd64 |
| - | libhdf5-hl-100:amd64 | + | libhdf5-hl-310:amd64 |
| libheif1: | libheif1: | ||
| + | libheif-plugin-aomenc: | ||
| + | libheif-plugin-dav1d: | ||
| + | libheif-plugin-libde265: | ||
| + | libheif-plugin-x265: | ||
| libhogweed4: | libhogweed4: | ||
| - | libhogweed6:amd64 | + | libhogweed6t64:amd64 |
| libhtml-parser-perl: | libhtml-parser-perl: | ||
| libhtml-tagset-perl | libhtml-tagset-perl | ||
| Ligne 342: | Ligne 361: | ||
| libhttp-date-perl | libhttp-date-perl | ||
| libhttp-message-perl | libhttp-message-perl | ||
| - | libicu72:amd64 | + | libicu76:amd64 |
| libidn11: | libidn11: | ||
| + | libidn12: | ||
| libidn2-0: | libidn2-0: | ||
| + | libio-compress-brotli-perl | ||
| libio-html-perl | libio-html-perl | ||
| - | libio-pty-perl | ||
| libip4tc0: | libip4tc0: | ||
| libip4tc2: | libip4tc2: | ||
| libip6tc0: | libip6tc0: | ||
| libip6tc2: | libip6tc2: | ||
| - | libipc-run-perl | ||
| - | libiptc0: | ||
| libisc-export1100: | libisc-export1100: | ||
| libjbig0: | libjbig0: | ||
| Ligne 364: | Ligne 382: | ||
| libkeyutils1: | libkeyutils1: | ||
| libklibc: | libklibc: | ||
| - | libkmlbase1:amd64 | + | libkmlbase1t64:amd64 |
| - | libkmldom1:amd64 | + | libkmldom1t64:amd64 |
| - | libkmlengine1:amd64 | + | libkmlengine1t64:amd64 |
| libkmod2: | libkmod2: | ||
| libkrb5-3: | libkrb5-3: | ||
| Ligne 372: | Ligne 390: | ||
| libksba8: | libksba8: | ||
| liblapack3: | liblapack3: | ||
| + | liblastlog2-2: | ||
| liblcms2-2: | liblcms2-2: | ||
| - | libldap-2.5-0:amd64 | + | libldap2:amd64 |
| libldap-common | libldap-common | ||
| liblerc4: | liblerc4: | ||
| - | libllvm16: | ||
| libllvm19: | libllvm19: | ||
| liblmdb0: | liblmdb0: | ||
| liblocale-gettext-perl | liblocale-gettext-perl | ||
| + | liblockfile1: | ||
| liblockfile-bin | liblockfile-bin | ||
| liblognorm5: | liblognorm5: | ||
| + | liblsof0 | ||
| libltdl7: | libltdl7: | ||
| liblwp-mediatypes-perl | liblwp-mediatypes-perl | ||
| Ligne 388: | Ligne 408: | ||
| liblzma5: | liblzma5: | ||
| liblzo2-2: | liblzo2-2: | ||
| - | libmagic1:amd64 | + | libmagic1t64:amd64 |
| libmagic-mgc | libmagic-mgc | ||
| libmariadb3: | libmariadb3: | ||
| libmaxminddb0: | libmaxminddb0: | ||
| libmd0: | libmd0: | ||
| - | libminizip1:amd64 | + | libminizip1t64:amd64 |
| libmnl0: | libmnl0: | ||
| libmount1: | libmount1: | ||
| Ligne 399: | Ligne 419: | ||
| libncurses6: | libncurses6: | ||
| libncursesw6: | libncursesw6: | ||
| - | libndctl6: | + | libnetcdf22:amd64 |
| - | libnetcdf19:amd64 | + | |
| libnetfilter-conntrack3: | libnetfilter-conntrack3: | ||
| libnettle6: | libnettle6: | ||
| - | libnettle8:amd64 | + | libnettle8t64:amd64 |
| libnewt0.52: | libnewt0.52: | ||
| libnfnetlink0: | libnfnetlink0: | ||
| Ligne 409: | Ligne 428: | ||
| libnftnl11: | libnftnl11: | ||
| libnghttp2-14: | libnghttp2-14: | ||
| - | libnl-3-200:amd64 | + | libnghttp3-9:amd64 |
| - | libnl-genl-3-200:amd64 | + | libngtcp2-16:amd64 |
| - | libnpth0:amd64 | + | libngtcp2-crypto-gnutls8:amd64 |
| + | libnpth0t64:amd64 | ||
| libnsl2: | libnsl2: | ||
| libnspr4: | libnspr4: | ||
| Ligne 419: | Ligne 439: | ||
| libnss-systemd: | libnss-systemd: | ||
| libnuma1: | libnuma1: | ||
| - | libnumber-compare-perl | ||
| libodbc2: | libodbc2: | ||
| + | libodbccr2: | ||
| libodbcinst2: | libodbcinst2: | ||
| - | libogdi4.1 | + | libogdi4.1:amd64 |
| libopenjp2-7: | libopenjp2-7: | ||
| libp11-kit0: | libp11-kit0: | ||
| Ligne 430: | Ligne 450: | ||
| libpam-runtime | libpam-runtime | ||
| libpam-systemd: | libpam-systemd: | ||
| - | libpcap0.8:amd64 | + | libpcap0.8t64:amd64 |
| libpci3: | libpci3: | ||
| libpcre2-8-0: | libpcre2-8-0: | ||
| + | libpcre2-posix3: | ||
| libpcre3: | libpcre3: | ||
| - | libperl5.36:amd64 | + | libperl5.40:amd64 |
| libpipeline1: | libpipeline1: | ||
| - | libpmem1: | + | libpng16-16t64:amd64 |
| - | libpng16-16:amd64 | + | libpoppler147:amd64 |
| - | libpoppler126:amd64 | + | |
| libpopt0: | libpopt0: | ||
| libpq5: | libpq5: | ||
| Ligne 445: | Ligne 465: | ||
| libproj25: | libproj25: | ||
| libprotobuf-c1: | libprotobuf-c1: | ||
| - | libpsl5:amd64 | + | libpsl5t64:amd64 |
| - | libpython3.11-minimal: | + | libpython3.13-minimal: |
| - | libpython3.11-stdlib: | + | libpython3.13-stdlib: |
| libpython3-stdlib: | libpython3-stdlib: | ||
| libqhull-r8.0: | libqhull-r8.0: | ||
| - | libquadmath0:amd64 | + | librav1e0.7:amd64 |
| - | libreadline8:amd64 | + | libreadline8t64:amd64 |
| libregexp-ipv6-perl | libregexp-ipv6-perl | ||
| librtmp1: | librtmp1: | ||
| Ligne 466: | Ligne 486: | ||
| libsepol1: | libsepol1: | ||
| libsepol2: | libsepol2: | ||
| + | libsharpyuv0: | ||
| libsigsegv2: | libsigsegv2: | ||
| libslang2: | libslang2: | ||
| Ligne 471: | Ligne 492: | ||
| libsnappy1v5: | libsnappy1v5: | ||
| libsodium23: | libsodium23: | ||
| - | libspatialite7:amd64 | + | libspatialite8t64:amd64 |
| libsqlite3-0: | libsqlite3-0: | ||
| libss2: | libss2: | ||
| - | libssh2-1:amd64 | + | libssh2-1t64:amd64 |
| libssl1.1: | libssl1.1: | ||
| - | libssl3:amd64 | + | libssl3t64:amd64 |
| libstdc++6: | libstdc++6: | ||
| - | libsuperlu5:amd64 | + | libsvtav1enc2:amd64 |
| libsystemd0: | libsystemd0: | ||
| libsystemd-shared: | libsystemd-shared: | ||
| Ligne 485: | Ligne 506: | ||
| libterm-readkey-perl | libterm-readkey-perl | ||
| libtext-charwidth-perl: | libtext-charwidth-perl: | ||
| - | libtext-glob-perl | ||
| libtext-iconv-perl: | libtext-iconv-perl: | ||
| - | libtext-template-perl | ||
| libtext-wrapi18n-perl | libtext-wrapi18n-perl | ||
| libtiff6: | libtiff6: | ||
| libtimedate-perl | libtimedate-perl | ||
| libtinfo6: | libtinfo6: | ||
| - | libtirpc3:amd64 | + | libtirpc3t64:amd64 |
| libtirpc-common | libtirpc-common | ||
| libtypes-serialiser-perl | libtypes-serialiser-perl | ||
| libuchardet0: | libuchardet0: | ||
| libudev1: | libudev1: | ||
| + | libunbound8: | ||
| libunistring2: | libunistring2: | ||
| + | libunistring5: | ||
| + | liburcu8t64: | ||
| liburing2: | liburing2: | ||
| liburiparser1: | liburiparser1: | ||
| Ligne 503: | Ligne 525: | ||
| libusb-1.0-0: | libusb-1.0-0: | ||
| libuuid1: | libuuid1: | ||
| - | libuv1:amd64 | + | libuv1t64:amd64 |
| libwebp7: | libwebp7: | ||
| libwrap0: | libwrap0: | ||
| + | libwtmpdb0: | ||
| libx11-6: | libx11-6: | ||
| libx11-data | libx11-data | ||
| - | libx265-199:amd64 | + | libx265-215:amd64 |
| libxau6: | libxau6: | ||
| libxcb1: | libxcb1: | ||
| libxdmcp6: | libxdmcp6: | ||
| - | libxerces-c3.2:amd64 | + | libxerces-c3.2t64:amd64 |
| libxext6: | libxext6: | ||
| libxml2: | libxml2: | ||
| Ligne 519: | Ligne 542: | ||
| libxtables12: | libxtables12: | ||
| libxxhash0: | libxxhash0: | ||
| + | libyuv0: | ||
| libz3-4: | libz3-4: | ||
| libzstd1: | libzstd1: | ||
| linux-base | linux-base | ||
| - | linux-image-6.1.0-39-amd64 | + | linux-image-6.1.0-42-amd64 |
| - | linux-image-6.1.0-40-amd64 | + | linux-image-6.12.63+deb13-amd64 |
| linux-image-amd64 | linux-image-amd64 | ||
| + | linux-sysctl-defaults | ||
| locales | locales | ||
| login | login | ||
| + | login.defs | ||
| logrotate | logrotate | ||
| logsave | logsave | ||
| Ligne 567: | Ligne 593: | ||
| openssh-sftp-server | openssh-sftp-server | ||
| openssl | openssl | ||
| + | openssl-provider-legacy | ||
| os-prober | os-prober | ||
| passwd | passwd | ||
| Ligne 574: | Ligne 601: | ||
| perl-base | perl-base | ||
| perl-modules-5.36 | perl-modules-5.36 | ||
| + | perl-modules-5.40 | ||
| pg-activity | pg-activity | ||
| pinentry-curses | pinentry-curses | ||
| poppler-data | poppler-data | ||
| postgis | postgis | ||
| - | postgis-doc | ||
| postgresql | postgresql | ||
| - | postgresql-17 | ||
| - | postgresql-17-rum | ||
| postgresql-18 | postgresql-18 | ||
| postgresql-18-jit | postgresql-18-jit | ||
| - | postgresql-client-17 | ||
| postgresql-client-18 | postgresql-client-18 | ||
| postgresql-client-common | postgresql-client-common | ||
| postgresql-common | postgresql-common | ||
| - | postgresql-common-dev | ||
| - | postgresql-contrib | ||
| powermgmt-base | powermgmt-base | ||
| procps | procps | ||
| Ligne 598: | Ligne 620: | ||
| pv | pv | ||
| python3 | python3 | ||
| - | python3.11 | + | python3.13 |
| - | python3.11-minimal | + | python3.13-minimal |
| python3-apt | python3-apt | ||
| python3-attr | python3-attr | ||
| + | python3-autocommand | ||
| + | python3-bcrypt | ||
| python3-blessed | python3-blessed | ||
| python3-certifi | python3-certifi | ||
| Ligne 611: | Ligne 635: | ||
| python3-debian | python3-debian | ||
| python3-debianbts | python3-debianbts | ||
| - | python3-httplib2 | ||
| python3-humanize | python3-humanize | ||
| python3-idna | python3-idna | ||
| + | python3-inflect | ||
| + | python3-jaraco.context | ||
| + | python3-jaraco.functools | ||
| + | python3-jaraco.text | ||
| python3-minimal | python3-minimal | ||
| + | python3-more-itertools | ||
| python3-pkg-resources | python3-pkg-resources | ||
| python3-psutil | python3-psutil | ||
| - | python3-psycopg2 | + | python3-psycopg |
| - | python3-pycurl | + | python3-psycopg-c |
| + | python3-pyasyncore | ||
| python3-pyinotify | python3-pyinotify | ||
| python3-pymysql | python3-pymysql | ||
| - | python3-pyparsing | ||
| - | python3-pysimplesoap | ||
| python3-reportbug | python3-reportbug | ||
| python3-requests | python3-requests | ||
| - | python3-six | + | python3-setuptools |
| python3-systemd | python3-systemd | ||
| + | python3-typeguard | ||
| + | python3-typing-extensions | ||
| python3-urllib3 | python3-urllib3 | ||
| python3-wcwidth | python3-wcwidth | ||
| + | python3-zipp | ||
| python-apt-common | python-apt-common | ||
| python-is-python3 | python-is-python3 | ||
| qemu-guest-agent | qemu-guest-agent | ||
| readline-common | readline-common | ||
| - | redis | ||
| - | redis-server | ||
| - | redis-tools | ||
| reportbug | reportbug | ||
| rpcbind | rpcbind | ||
| Ligne 641: | Ligne 668: | ||
| rsyslog | rsyslog | ||
| runit-helper | runit-helper | ||
| + | screen | ||
| sed | sed | ||
| sensible-utils | sensible-utils | ||
| shared-mime-info | shared-mime-info | ||
| socat | socat | ||
| + | sqv | ||
| ssl-cert | ssl-cert | ||
| sysstat | sysstat | ||
| systemd | systemd | ||
| + | systemd-cryptsetup | ||
| systemd-sysv | systemd-sysv | ||
| systemd-timesyncd | systemd-timesyncd | ||
| Ligne 663: | Ligne 693: | ||
| unixodbc-common | unixodbc-common | ||
| usbutils | usbutils | ||
| - | usrmerge | ||
| util-linux | util-linux | ||
| util-linux-extra | util-linux-extra | ||
| util-linux-locales | util-linux-locales | ||
| + | valkey-server | ||
| + | valkey-tools | ||
| vim | vim | ||
| vim-common | vim-common | ||