Project

General

Profile

Tâche #8744

Distribution EOLE - Scénario #8774: Creole

Après Upgrade-Auto, l'instance du Scribe-2.4 (re)bloque sur le démarrage de sympa

Added by Joël Cuissinat over 6 years ago. Updated over 6 years ago.

Status:
Fermé
Priority:
Haut
Assigned To:
Start date:
Due date:
09/12/2014
% Done:

100%

Estimated time:
2.00 h
Spent time:
Remaining (hours):

Description

Après Upgrade-Auto + reboot + gen_config + instance, la console reste bloquée sur la ligne :

Start System V service sympa               [  OK  ]

à l'étape "Démarrage des services".

01-mysql (322 Bytes) Joël Cuissinat, 09/02/2014 04:59 PM

Associated revisions

Revision cba27b5d (diff)
Added by Joël Cuissinat over 6 years ago

Correction des droits Mysql avant Upgrade

Fixes #8744 @1h

History

#1 Updated by Joël Cuissinat over 6 years ago

Erreurs dans syslog :

Sep  1 17:06:49 scribepedago sympa[14026]: info Configuration file read, default log level 0
Sep  1 17:06:50 scribepedago sympa[14026]: err SQLSource::connect() Can't connect to Database DBI:mysql:sympa:localhost as sympa
Sep  1 17:06:50 scribepedago sympa[14026]: err List::check_db_connect() Failed to connect to database
Sep  1 17:06:50 scribepedago sympa[14026]: notice SQLSource::create_db() Trying to create sympa database...
Sep  1 17:06:50 scribepedago sympa[14026]: err SQLSource::create_db() Cannot connect as root to database
Sep  1 17:06:50 scribepedago sympa[14026]: Database sympa defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf
Sep  1 17:06:50 scribepedago sympa[14026]: Exiting.
Sep  1 17:06:50 scribepedago sympa[14026]: info List::get_user_db() Sympa not setup to use DBI

#2 Updated by Joël Cuissinat over 6 years ago

=> retour du problème sur les hôtes MySQL (127.0.0.1 vs localhost) !

mysql> select Host, User from user ;
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| 127.0.0.1 | piwik            |
| 127.0.0.1 | posh             |
| 127.0.0.1 | poshprofiluser   |
| 127.0.0.1 | root             |
| 127.0.0.1 | squirreluser     |
| 127.0.0.1 | sympa            |
| localhost | debian-sys-maint |
| localhost | root             |
| localhost | roundcube        |
| scribe    | root             |
+-----------+------------------+

#3 Updated by Joël Cuissinat over 6 years ago

Après avoir ajouté le script joint en pre_download de l'Upgrade, les erreurs sont désormais :

Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Could not create table conf_table in database sympa : CREATE command denied to user Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Could not create table exclusion_table in database sympa : CREATE command denied to user 'sympa'@'localhost' for table 'exclusion_table'
Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Could not create table bulkspool_table in database sympa : CREATE command denied to user 'sympa'@'localhost' for table 'bulkspool_table'
Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Could not create table one_time_ticket_table in database sympa : CREATE command denied to user 'sympa'@'localhost' for table 'one_time_ticket_table'
Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Could not create table bulkmailer_table in database sympa : CREATE command denied to user 'sympa'@'localhost' for table 'bulkmailer_table'
Sep  2 16:47:21 scribepedago sympa[8432]: err Upgrade::probe_db() Table 'conf_table' not found in database 'sympa' ; you should create it with create_db.mysql script
Sep  2 16:47:21 scribepedago sympa[8432]: Database sympa defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf
'sympa'@'localhost' for table 'conf_table'

#4 Updated by Joël Cuissinat over 6 years ago

#5 Updated by Joël Cuissinat over 6 years ago

Je propose d'étendre la modif à toutes les applis (Roundcube n'est pas fonctionnel non plus après migration) avec :

update user set Host='localhost' where Host='127.0.0.1' and User!='root';
update db set Host='localhost' where Host='127.0.0.1' and User!='root';

Il faut également ajouter le droit "create" à l'utilisateur sympa car il lui manque pour ajouter les nouvelles tables !

#6 Updated by Joël Cuissinat over 6 years ago

  • Due date set to 09/12/2014
  • Assigned To set to Joël Cuissinat
  • Target version set to sprint 2014 36-37
  • % Done changed from 0 to 50
  • Distribution changed from Toutes to EOLE 2.4

#7 Updated by Joël Cuissinat over 6 years ago

  • Distribution changed from EOLE 2.4 to EOLE 2.3

#8 Updated by Joël Cuissinat over 6 years ago

  • Status changed from Nouveau to Résolu
  • % Done changed from 50 to 100

#9 Updated by Luc Bourdot over 6 years ago

  • Parent task set to #8774

#10 Updated by Luc Bourdot over 6 years ago

  • Tracker changed from Tâche to Anomalie

#11 Updated by Lionel Morin over 6 years ago

  • Status changed from Résolu to Fermé

Also available in: Atom PDF