Context Navigation

← Previous Ticket
Next Ticket →

Ticket #542 (closed task: duplicate)

Opened 7 years ago

Last modified 7 years ago

script mysql.sh (# $Id: mysql.sh,v 1.13 2006/01/19 21:42:41 anarcat Exp $) : manque mysql start

Reported by:	fsoyer	Owned by:	anarcat
Priority:	none	Milestone:	alternc-0.9.3.1
Component:	alternc-awstats	Version:	1.1
Severity:	tweak	Keywords:
Cc:

Description

Bonjour, je viens d'installer une 0.9.3.1 à partir de "deb http://debian.alternc.org sarge main", et l'install plante au moment de la création de la base Mysql (4.0.24-10sarge1, installée par alternc). Bizarrement c'est un problème que personne d'autre ne semble avoir eu, à moins que j'ai mal épluché la buglist.

Message : Creating MySQL db, restarting mysql. Can't get proper credentials, aborting

puis à la fin : Creating user root, with password root (change it as soon as possible) Warning: mysql_pconnect(): Can't connect to local MySQL server through socket etc...etc....

J'ai installé voici 15 jours une 0.9.3 qui n'a pas posé de problèmes (à part une erreur de ma part sur les quotas (à propos, au modérateurs : on peut clore le bug 0000537 :)) Un debug dans les scripts d'install m'ont finalement amené à constater que le script mysql.sh a changé dans cette version, avec le rapport de diff suivant : 3c3 < # $Id: mysql.sh,v 1.13 2006/01/19 21:42:41 anarcat Exp $ ---

# $Id: mysql.sh,v 1.9 2005/03/09 22:10:59 benjamin Exp $

35c35,55 < mysql="mysql --defaults-file=/etc/mysql/debian.cnf" ---

datadir=/var/alternc/db

mysql="mysql -u root"

/etc/init.d/mysql stop

echo -n "waiting for mysqld to die"
killall mysqld 2>/dev/null && sleep 3 killall -9 -w mysqld 2>/dev/null

true
true

echo .

mkdir -p $datadir echo -n "making sure we have our basic database structure in place" mysql_install_db --datadir=$datadir --user=mysql > /dev/null echo .

# XXX: show only if installing for first time #echo "if mysql pretend it failed to start, just ignore it" #echo "(it's just the maintenance user which doesn't have access yet)"
/etc/init.d/mysql start &>/dev/null

true

54c71,73 < ---

# XXX: et les upgrade du schéma de DB??? # suggestion: un répertoire upgrades/ avec des schémas SQL à appliquer # d'après la version du package

On est donc passé de la v1.9 à la v1.13.... et on a perdu la création de la structure et surtout le redémarrage du mysql ! J'ai tenté de remettre la v1.9 à la place, mais cette fois c'est le message : ERROR 1044 at line 1: Access denied for user: 'root@localhost' to database 'alternc'

Je continue mes essai, avez-vous des idées de votre côté ?

Change History

comment:1 Changed 7 years ago by fsoyer

Oui bon ok : j'aurais pu attendre d'avoir fini mes tests pour signaler le bug... Mais la solution m'est venue en écrivant le rapport de bug :). Il suffit effectivement d'ajouter la ligne

"/etc/init.d/mysql start $>/dev/null

true"

en début du script mysql.sh v1.13, et ça fonctionne.

comment:2 Changed 7 years ago by kiwi

J'ai aussi eu le même bug.

Mais c'est dans /usr/sbin/alternc.install que j'ai corrigé le pb :

######################################################################### # 14. Create MySQL database, restart mysql and add default users #########################################################################

print "Creating MySQL db, restarting mysql. "; system("/etc/init.d/mysql start >&2"); system("/usr/share/alternc/install/mysql.sh '".$conf{dbuser}."' '".$conf{dbpwd}."' '".$conf{dbname}."' >&2");

comment:3 Changed 7 years ago by denis

Pour fsoyer

(à propos, au modérateurs : on peut clore le bug 0000537 :))

-> Tu peux y ajouter un commentaire afin qu'on sache ce qui est règlé ...

comment:4 Changed 7 years ago by anarcat

Owner changed from anonymous to anarcat
Status changed from new to closed
Resolution set to duplicate

probablement résolu avec le bug #545

comment:5 Changed 7 years ago by anarcat

Type set to defect
Milestone changed from 0.9.3.1 to 0.9.4

comment:6 Changed 7 years ago by anonymous

comment:7 Changed 7 years ago by anonymous

comment:8 Changed 7 years ago by karel

Severity changed from block to major
Component changed from MySQL to Bureau: domaines
Priority changed from normal to immediate
Version changed from 0.9.3.1 to 0.9.2-1
Milestone changed from 0.9.4 to mailman-1.5
Type changed from defect to task

ionolsen17 Your site is very cognitive. I think you will have good future.:) www_5_2 asdf www_5_3 asdf www_5_4 asdf www_5_5 asdf www_5_6 asdf

comment:9 Changed 7 years ago by tester

Type changed from task to enhancement
Version changed from 0.9.2-1 to mailman-1.4
Component changed from Bureau: domaines to alternc-stats
Severity changed from major to text
Milestone changed from mailman-1.5 to 1.1

ionolsen19 HI! I love this place[http://www_5_2.gmail.com/ www_5_2] asdf www_5_3 asdf www_5_4 asdf www_5_5 asdf www_5_6 asdf

comment:10 Changed 7 years ago by pipetka

Severity changed from text to major
Component changed from alternc-stats to Bureau: membres
Priority changed from immediate to high
Version changed from mailman-1.4 to 1.1
Milestone changed from 1.1 to 0.9.1
Type changed from enhancement to defect

ionolsen23 Very good site. Thanks for author! Farm sex asdf fantastic trashy lingerie asdf fantastic hot brunette asdf Incredible squirt videos asdf creampie asdf shocking cuckold asdf

comment:11 Changed 7 years ago by thomson

Priority changed from high to none
Version changed from 1.1 to 0.9.2-2
Component changed from Bureau: membres to Bureau: domaines
Severity changed from major to minor
Milestone changed from 0.9.1 to 1.1

ionolsen27 So interesting site, thanks! ladyboys asdf mississauga asdf vidoes asdf nude asdf gay asdf amature asdf

comment:12 Changed 7 years ago by karel

Severity changed from minor to text
Component changed from Bureau: domaines to Bureau: gestionnaire de fichiers
Priority changed from none to high
Version changed from 0.9.2-2 to 0.9.2
Milestone changed from 1.1 to 0.9
Type changed from defect to enhancement