Distribution EOLE » Commun » eole-db

Bonjour,

Sur une EOLE 2.7.1 à jour, je tente d'installer limesurvey sur un serveur BDD distant Mariadb 10.4.12.

Je fais mon apt-eole install eole-limesurvey, puis direction le gen_config pour renseigner les valeurs de mon serveur BDD distant et ensuite reconfigure.

Hors, lors du reconfigure, eole-db me donne une erreur :

run-parts: executing /usr/share/eole/posttemplate/01-eoledb reconfigure
Start Systemd service mysql                                                                                                                                                                                                          [  OK  ]
LIMESURVEY :
        >>> Passwords
Traceback (most recent call last):
  File "/usr/bin/eole_db_gen", line 415, in <module>
    main()
  File "/usr/bin/eole_db_gen", line 401, in main
    args.backup_dir)
  File "/usr/bin/eole_db_gen", line 328, in run_change_password
    if conn.change_passwords(local_conf, bdir):
  File "/usr/lib/python2.7/dist-packages/eoledb/eoledbmysql.py", line 203, in change_passwords
    hostlist, backup_dir)
  File "/usr/lib/python2.7/dist-packages/eoledb/password/_eole_mypwd.py", line 120, in update_password
    if self.run_req(req, True) is None:
  File "/usr/lib/python2.7/dist-packages/eoledb/password/_eole_mypwd.py", line 35, in run_req
    res = cursor.execute(request)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
_mysql_exceptions.OperationalError: (1348, "Column 'authentication_string' is not updatable")
Stop Systemd service mysql                                                                                                                                                                                                           [  OK  ]
run-parts: executing /usr/share/eole/posttemplate/01-eoleflask-nginx reconfigure

L'erreur Column 'authentication_string' is not updatable a l'air se produire car :

MariaDB starting with 10.4
In MariaDB 10.4 and later, the mysql.global_priv table has replaced the mysql.user table, and mysql.user is now a view.

Source : https://mariadb.com/kb/en/mysqluser-table/

All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table. The mysql.user table still exists and has exactly the same set of columns as before, but it’s now a view that references the mysql.global_priv table.

Sources : https://mariadb.com/kb/en/authentication-from-mariadb-104/ ou bien https://mariadb.org/authentication-in-mariadb-10-4/

Pourriez-vous rapidement faire quelques choses ? Car dans l'état actuel des choses, les gens ayant des serveurs BDD distants et ne souhaitant pas utiliser le mysql local en prod ne peuvent plus utiliser installer de nouvelles applis... :/

Je suis dispo si besoin d'infos supplémentaire.

Merci d'avance et bon courage !
Cordialement,

Nicolas PENOT