Forum

bisane@bisane:~$ ls -lsah /home/bisane/.local/share/akonadi/
total 32K
4,0K drwxrwxr-x  5 bisane bisane 4,0K nov.  20 07:27 .
4,0K drwx------ 39 bisane bisane 4,0K nov.  20 07:54 ..
4,0K -rw-rw-r--  1 bisane bisane 1,2K nov.  20 07:27 Akonadi.error
4,0K -rw-rw-r--  1 bisane bisane  140 nov.  20 07:27 Akonadi.error.old
4,0K drwxrwxr-x  6 bisane bisane 4,0K nov.  20 07:27 db_data
4,0K drwxrwxr-x  2 bisane bisane 4,0K nov.  19 19:30 db_misc
4,0K drwxrwxr-x  2 bisane bisane 4,0K nov.  19 19:30 file_db_data
4,0K -rw-rw-r--  1 bisane bisane 3,6K nov.  19 19:30 mysql.conf
   0 lrwxrwxrwx  1 bisane bisane   22 nov.  20 07:27 socket-bisane-default -> /run/user/1000/akonadi

#Sauvegarde du dossier db_data en data.bak et suppression du dossier db_data
#Autrement dit, on renomme le dossier
mv /home/${USER}/.local/share/akonadi/db_data /home/${USER}/.local/share/akonadi/db_data.bak
 
#Regénération du dossier db_data avec l'option --initialize
#Attention, il s'agit bien d'une seule ligne, coupé en plusieurs lignes du à la largeur de l'écran.
/usr/sbin/mysqld-akonadi --defaults-file=/home/${USER}/.local/share/akonadi/mysql.conf --datadir=/home/${USER}/.local/share/akonadi/db_data/ --socket=/run/user/$(id -ur)/akonadi/default/mysql.socket --pid-file=/run/user/$(id -ur)/akonadi/default/mysql.pid --initialize --console
 
#Je ne sais pas si ça démarre akonadi. Comme j'ai un doute, je propose :
#Redémarrage du service
akonadictl start --verbose
 
#récupération des registres
cat /home/bisane/.local/share/akonadi/db_data/mysql.err 
 

bisane@bisane:~$ cp /home/bisane/.local/share/akonadi/db_data /home/bisane/.local/share/akonadi/db_data.bak
cp: -r non spécifié ; omission du répertoire '/home/bisane/.local/share/akonadi/db_data'

echo ${USER}
echo tra${USER}lala
echo "tra${USER}lala"
echo 'tra${USER}lala'
echo $(id -ur)
echo moins$(id -ur)degrès
echo "moins$(id -ur) degrès"
echo 'moins $(id -ur) degrès'

echo=variable
echo mot
echo echo mot
echo echo ${echo} mot
echo $(echo ${echo}) mot
echo $(echo mot $(echo ${echo}) ${echo}) $echo mot
echo=echo
$echo
$(${echo} mot)
commande=echo
${commande} ${echo}
commande=id
${commande}

usertest@usertest-virtualbox:~$ /usr/sbin/mysqld --version
/usr/sbin/mysqld  Ver 8.0.22-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))
usertest@usertest-virtualbox:~$ sudo apt install mariadb-server-10.3
[sudo] Mot de passe de usertest : 
Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances       
Lecture des informations d'état... Fait
Les paquets suivants ont été installés automatiquement et ne sont plus nécessaires :
  libevent-core-2.1-7 libevent-pthreads-2.1-7 libmecab2 libqt5opengl5
  mecab-ipadic mecab-ipadic-utf8 mecab-utils qtgstreamer-plugins-qt5
Veuillez utiliser « sudo apt autoremove » pour les supprimer.
Les paquets supplémentaires suivants seront installés : 
  galera-3 gawk libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl
  libsigsegv2 libterm-readkey-perl mariadb-client-10.3
  mariadb-client-core-10.3 mariadb-common mariadb-server-core-10.3 socat
Paquets suggérés :
  gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl
  libsql-statement-perl mailx mariadb-test tinyca
Les paquets suivants seront ENLEVÉS :
  mysql-client-8.0 mysql-client-core-8.0 mysql-server-8.0
  mysql-server-core-8.0

#!/bin/bash
echo "Téléchargement du fichier Mariadb dans ~/Téléchargements - avec wget\n"
cd ~/Téléchargements
wget https://ftp.igh.cnrs.fr/pub/mariadb//mariadb-10.5.8/bintar-linux-systemd-x86_64/mariadb-10.5.8-linux-systemd-x86_64.tar.gz
cd /opt
echo "Décompression du fichier de MariaDB dans /opt - identification  nécessaire\n"
sudo tar zxvf ~/Téléchargements/mariadb-10.5.8-linux-systemd-x86_64.tar.gz
echo "Création d\' un utilisateur Mariadb\n"
sudo adduser --system mariadb
echo "Changement de propriétaire/groupe du répertoire mariadb-10.5.8-linux-systemd-x86_64\n"
sudo chown -R mariadb:mariadb mariadb-10.5.8-linux-systemd-x86_64 
echo "Création d\' un lien symbolique vers MariaDB afin de faciliter la mise à jour de MariaDB plus tard\n"
sudo ln -s mariadb-10.5.8-linux-systemd-x86_64 mariadb
echo "Suppression du lien symbolique /usr/sbin/mysqld-akonadi. Il faut le faire pointer vers /opt/mariadb/bin/mysqld !\n"
sudo rm /usr/sbin/mysqld-akonadi
echo "Création du lien mysqld-akonadi vers /opt/mariadb/bin/mysqld \n"
sudo ln -s /opt/mariadb/bin/mysqld /usr/sbin/mysqld-akonadi
echo "On déplace le répertoire db_data de l\' utilisateur courant d\' Akonadi afin d\' en faire une sauvegarde \n après arrêt eventuel d\' Akonadi"
akonadictl stop
mv ~/.local/share/akonadi/db_data ~/.local/share/akonadi/db_data_sauvegarde_mysql
echo "On essaie de démarrer Akonadi \n"
akonadictl start

bisane@bisane:~$ /usr/sbin/mysqld-akonadi --defaults-file=/home/bisane/.local/share/akonadi/mysql.conf --datadir=/home/bisane/.local/share/akonadi/db_data/ --socket=/run/user/$(id -ur)/akonadi/default/mysql.socket --pid-file=/run/user/$(id -ur)/akonadi/default/mysql.pid --initialize --console
bisane@bisane:~$ akonadictl start --verbose
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
bisane@bisane:~$ org.kde.pim.akonadicontrol: Service ":1.78" owner changed from "" to ":1.78"
org.kde.pim.akonadicontrol: Service ":1.79" owner changed from "" to ":1.79"
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db:  ""
org.kde.pim.akonadiserver: Found mysqlcheck:  "/usr/bin/mysqlcheck"
org.kde.pim.akonadiserver: Using mysqld: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: mysqld reports version 8.0.22 (Oracle MySQL)
org.kde.pim.akonadiserver: Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/bisane/.local/share/akonadi/mysql.conf --datadir=/home/bisane/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid"
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/bisane/.local/share/akonadi/mysql.conf", "--datadir=/home/bisane/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: stopping db process
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/run/user/1000/akonadi/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Service ":1.79" owner changed from ":1.79" to ""
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

bisane@bisane:~$ cat /home/bisane/.local/share/akonadi/db_data/mysql.err 
2020-11-21T16:46:11.079649Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2020-11-21T16:46:11.079829Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld-akonadi (mysqld 8.0.22-0ubuntu0.20.04.2) starting as process 7077
2020-11-21T16:46:11.088729Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-11-21T16:46:11.088751Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-11-21T16:46:11.142465Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-21T16:46:12.145465Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-21T16:46:12.552557Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2020-11-21T16:46:12.553169Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't open lock file /var/run/mysqld/mysqlx.sock.lock'
2020-11-21T16:46:12.986629Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-11-21T16:46:13.254420Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-11-21T16:46:13.322457Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-11-21T16:46:13.323794Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-11-21T16:46:13.330346Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2020-11-21T16:46:13.333256Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2020-11-21T16:46:13.334354Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2020-11-21T16:46:13.335250Z 0 [ERROR] [MY-000067] [Server] unknown variable 'log_warnings=2'.
2020-11-21T16:46:13.336492Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-11-21T16:46:15.493934Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld-akonadi: Shutdown complete (mysqld 8.0.22-0ubuntu0.20.04.2)  (Ubuntu).