Project

General

Profile

Tâche #31166

Scénario #30841: Supprimer EoleSQL sur EOLE 2.8.1

Erreurs MySQL lors de la restauration du catalogue Bareos

Added by Joël Cuissinat 10 months ago. Updated 10 months ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
11/17/2020
Due date:
% Done:

100%

Remaining (hours):
0.0

Description

https://dev-eole.ac-dijon.fr/jenkins/job/2.8.1/job/test-sauvegarde-bareos-restaure-full-2.8.1-amd64/3/parsed_console/

            ******* RESTAURATION DU CATALOGUE ***********
            Start Systemd service mysql                                             [  OK  ]
            Stop Systemd service mysql                                              [  OK  ]
            ## Régénération du catalogue Bareos##
            Stop Systemd service bareos-director                                    [  OK  ]
            Stop Systemd service bareos-storage                                     [  OK  ]
            Dropping mysql database

            mysql: [Warning] Using a password on the command line interface can be insecure.
            ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
            Drop of bareos database failed.
            Creating mysql database

            mysql: [Warning] Using a password on the command line interface can be insecure.
            ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
            Creating of bareos database failed.
            Making mysql tables

            mysql: [Warning] Using a password on the command line interface can be insecure.
            ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
            Creation of Bareos MySQL tables failed.

            mysql: [Warning] Using a password on the command line interface can be insecure.
            ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
            Start Systemd service mysql                                             [  OK  ]
            Mise à jour de la base de donnée Bareos...
            Updating mysql tables

            mysql: [Warning] Using a password on the command line interface can be insecure.
            Finished upgrading database to version 2004
            Régénération du catalogue terminée
            Suppression des anciens rapports d'état

Dans ce genre de cas, on pourrait s'attendre à ce que /usr/share/eole/sbin/bareosrestore.py --catalog sorte en erreur ce qui ne semble pas être le cas (cf. script utilisé dans le test : eole-ci-tests/tests/sauvegarde/run-bareos-restaure-complete.sh)

Associated revisions

Revision da96d5bb (diff)
Added by Joël Cuissinat 10 months ago

logparser-eole.rules : détection MySQL injoignable

Ref: #31166

Revision f7b740a6 (diff)
Added by Matthieu Lamalle 10 months ago

update bareosregenscript to start mysql when needed

Revision 409b5b71 (diff)
Added by Joël Cuissinat 10 months ago

logparser-eole.rules : détection Access denied MySQL

Ref: #31166

Revision 66fe3e91 (diff)
Added by Matthieu Lamalle 10 months ago

set new method of mysql connexion ref #31166

Revision 7408cf91 (diff)
Added by Joël Cuissinat 10 months ago

remove old path for mysql_pwd.py

Ref: #31097
Ref: #31166

Revision 0f80b8d9 (diff)
Added by Matthieu Lamalle 10 months ago

update bareosregen.sh

History

#1 Updated by Joël Cuissinat 10 months ago

  • Description updated (diff)

#2 Updated by Matthieu Lamalle 10 months ago

  • Status changed from Nouveau to En cours

#3 Updated by Matthieu Lamalle 10 months ago

  • Status changed from En cours to Résolu

#4 Updated by Joël Cuissinat 10 months ago

  • Status changed from Résolu to En cours

D'après https://dev-eole.ac-dijon.fr/jenkins/job/2.8.1/job/test-sauvegarde-bareos-restaure-full-2.8.1-amd64/6/parsed_console/ l'erreur s'est transformée en :

            ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

#5 Updated by Matthieu Lamalle 10 months ago

  • Status changed from En cours to Résolu

#6 Updated by Matthieu Lamalle 10 months ago

  • Assigned To set to Matthieu Lamalle

#7 Updated by Joël Cuissinat 10 months ago

  • Status changed from Résolu to En cours

Malgré les corrections apportées, il y a toujours des erreurs mysql au même endroit...
https://dev-eole.ac-dijon.fr/jenkins/job/2.8.1/job/test-sauvegarde-bareos-restaure-full-2.8.1-amd64/10/parsed_console/

#8 Updated by Matthieu Lamalle 10 months ago

  • Status changed from En cours to Résolu

#9 Updated by Joël Cuissinat 10 months ago

  • Status changed from Résolu to Fermé
  • % Done changed from 0 to 100
  • Remaining (hours) set to 0.0

OK avec eole-bareos (2.8.1-18)

Also available in: Atom PDF