Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[mysql] Problème de config
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index French
View previous topic :: View next topic  
Author Message
smu
n00b
n00b


Joined: 13 May 2006
Posts: 28

PostPosted: Sun Apr 27, 2008 4:47 pm    Post subject: [mysql] Problème de config Reply with quote

Bonsoir,

En essayant d'installer mysql, je me heurte au message ci-dessous.
Quel erreur ai-je pu commettre ?

Quote:
emerge --config =dev-db/mysql-5.0.54

Configuring pkg...

* Creating the mysql database and setting proper
* permissions on it ...
* Insert a password for the mysql 'root' user
* Avoid ["'\_%] characters in the password
>
* Retype the password
>
*
* ERROR: dev-db/mysql-5.0.54 failed.
* Call stack:
* ebuild.sh, line 49: Called pkg_config
* environment, line 3308: Called mysql_pkg_config
* environment, line 3015: Called die
* The specific snippet of code:
* die "Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND ${TMPDIR}/mysql_install_db.log";
* The die message:
* Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.0.54/temp/mysql_install_db.log
*
* If you need support, post the topmost build error, and the call stack if relevant.
* A complete build log is located at '/var/tmp/portage/dev-db/mysql-5.0.54/temp/build.log'.
* The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.0.54/temp/environment'.
* This ebuild is from an overlay: '/var/db/pkg/'
*

D'avance merci

smu
Back to top
View user's profile Send private message
loopx
Advocate
Advocate


Joined: 01 Apr 2005
Posts: 2787
Location: Belgium / Liège

PostPosted: Sun Apr 27, 2008 4:50 pm    Post subject: Reply with quote

Tiens, je connaissais pas ce genre de chose avec emerge :o


T'es sur de pas avoir mis un caractère foireux ?


Sinon, jsais vraiment pas ... J'ai jamais fais ainsi pour configurer mysql ...


Tu as essayé de le démarré ? (faut le lancer avant de le configurer ...)

/etc/init.d/mysql start
_________________
Mon MediaWiki perso : http://pix-mania.dyndns.org
Back to top
View user's profile Send private message
geekounet
Bodhisattva
Bodhisattva


Joined: 11 Oct 2004
Posts: 3772
Location: Wellington, Aotearoa

PostPosted: Sun Apr 27, 2008 4:50 pm    Post subject: Re: [mysql] Problème de config Reply with quote

smu wrote:
Quel erreur ai-je pu commettre ?

De ne pas avoir lu /var/log/mysql/mysqld.err et /var/tmp/portage/dev-db/mysql-5.0.54/temp/mysql_install_db.log ?
Back to top
View user's profile Send private message
loopx
Advocate
Advocate


Joined: 01 Apr 2005
Posts: 2787
Location: Belgium / Liège

PostPosted: Sun Apr 27, 2008 4:52 pm    Post subject: Re: [mysql] Problème de config Reply with quote

geekounet wrote:
smu wrote:
Quel erreur ai-je pu commettre ?

De ne pas avoir lu /var/log/mysql/mysqld.err et /var/tmp/portage/dev-db/mysql-5.0.54/temp/mysql_install_db.log ?


+1

Toujours lire les logs quand on tombe sur un problème :lol:
_________________
Mon MediaWiki perso : http://pix-mania.dyndns.org
Back to top
View user's profile Send private message
smu
n00b
n00b


Joined: 13 May 2006
Posts: 28

PostPosted: Sun Apr 27, 2008 6:06 pm    Post subject: Reply with quote

Bonsoir,

Quote:
cat /var/log/mysql/mysqld.err

080427 18:45:12 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
ERROR: 1062 Duplicate entry 'localhost-' for key 1
080427 18:45:12 [ERROR] Aborting

080427 18:45:12 [Note] /usr/sbin/mysqld: Shutdown complete

Quote:
cat /var/tmp/portage/dev-db/mysql-5.0.54/temp/mysql_install_db.log

Installing MySQL system tables...
080427 18:45:12 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
080427 18:45:12 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!

Donc je fais:
Quote:
host ~ # /usr/bin/mysql -u root mysql
mysql> show tables;
mysql> select * from user;
Empty set (0.00 sec)

La plupart des tables sont vides.
Je m'attendais à voir les informations de connexions dans cette table.

D'avance merci

smu
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index French All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum