Mariadb
Troumad Membre non connecté
-
- Voir le profil du membre Troumad
- Inscrit le : 16/10/2010
- Site internet
- Groupes :
En cemoment, j'essaie d'installer nginx + mariadb + phpmyadmin sur ma cauldron. J'y suis arrivé il y a moins d'un mois sur debian.
Je viens d'avoir un problème que j'ai résulu. J'ai envoyé un couriel sur la liste dev, je ne le vois pas. Je le transmets ici. (c'est comme s'il venait d'arriver maintenant !)
Citation :Hello
I have resolv a problem with mariadb in Cauldron.
The problem :
mysqld: Deprecated program name. It will be removed in a future release, use '/usr/sbin/mariadbd' instead
2026-01-19 11:02:34 0 [Warning] --table-cache is deprecated and will be removed in a future release. Please use --ta
ble-open-cache instead.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so' (errno: 2,
cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'auth_socket.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/cracklib_password_check.so'
(errno: 2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'cracklib_password_check.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/ha_archive.so' (errno: 2, c
annot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'ha_archive.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/ha_blackhole.so' (errno: 2,
cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'ha_blackhole.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/ha_federatedx.so' (errno: 2
, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'ha_federatedx.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/locales.so' (errno: 2, cann
ot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'locales.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/metadata_lock_info.so' (err
no: 2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'metadata_lock_info.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/provider_bzip2.so' (errno:
2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'provider_bzip2.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/provider_lz4.so' (errno: 2,
cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'provider_lz4.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/provider_lzma.so' (errno: 2
, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'provider_lzma.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/provider_lzo.so' (errno: 2,
cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'provider_lzo.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/provider_snappy.so' (errno:
2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'provider_snappy.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/query_cache_info.so' (errno
: 2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'query_cache_info.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/query_response_time.so' (er
rno: 2, cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'query_response_time.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/server_audit.so' (errno: 2,
cannot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'server_audit.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/sql_errlog.so' (errno: 2, c
annot open shared object file: No such file or directory)
2026-01-19 11:02:34 0 [ERROR] Couldn't load plugins from 'sql_errlog.so'.
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown option '--federated'
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown variable 'provider_bzip2=force_plus_permanent'
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown variable 'provider_lz4=force_plus_permanent'
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown variable 'provider_lzma=force_plus_permanent'
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown variable 'provider_lzo=force_plus_permanent'
2026-01-19 11:02:34 0 [ERROR] mysqld: unknown variable 'provider_snappy=force_plus_permanent'
log-error
The solve :
[root@localhost plugin]# pwd
/usr/lib64/mysql/plugin
[root@localhost plugin]# ln -s ../../mariadb/plugin/* .
[root@localhost plugin]# systemctl restart mysqld.service
[root@localhost plugin]# systemctl status mysqld.service
●mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; preset: disabled)
Active: active (running)since Mon 2026-01-19 11:03:39 CET; 10s ago
Invocation: f8043819e351492e8b99ae12dd9029b7
Process: 10002 ExecStartPre=/usr/sbin/mariadb-prepare-db-dir (code=exited, status=0/SUCCESS)
Main PID: 10016 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 11(limit: 18935)
Memory: 73.1M (peak: 74M)
CPU: 646ms
CGroup: /system.slice/mysqld.service
└� /usr/sbin/mariadbd
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:38 0 [Note] InnoDB: File './ibtmp1' size >
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:38 0 [Note] InnoDB: log sequence number 4>
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:38 0 [Note] InnoDB: Loading buffer pool(s>
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 260119 11:03:38 server_audit: MariaDB Audit Plugin version>
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 260119 11:03:38 server_audit: Query cache is enabled with >
janv. 19 11:03:38 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:38 0 [Note] InnoDB: Buffer pool(s) load c>
janv. 19 11:03:39 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:39 0 [Note] mariadbd: Event Scheduler: Lo>
janv. 19 11:03:39 localhost.localdomain mariadbd[10016]: 2026-01-19 11:03:39 0 [Note] /usr/sbin/mariadbd: ready for>
janv. 19 11:03:39 localhost.localdomain mariadbd[10016]: Version: '12.1.2-MariaDB' socket: '/var/lib/mysql/mysql.s>
janv. 19 11:03:39 localhost.localdomain systemd[1]: Started MariaDB database server.
[root@localhost plugin]# mysql -p
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 12.1.2-MariaDB Mageia MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
Édité par Troumad Le 19/01/2026 à 14h50
Amicalement Votre
Bernard SIAUD Alias Troumad
Bernard SIAUD Alias Troumad
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie