| View previous topic :: View next topic |
| Author |
Message |
smu
n00b
Joined: 13 May 2006
Posts: 28
|
 Posted: Sun Apr 27, 2008 4:47 pm Post subject: [mysql] Problème de config |
 |
|
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 |
|
 |
loopx
Advocate
Joined: 01 Apr 2005
Posts: 2787
Location: Belgium / Liège
|
| Posted: Sun Apr 27, 2008 4:50 pm Post subject: |
|
|
Tiens, je connaissais pas ce genre de chose avec emerge 
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 |
|
|
geekounet
Bodhisattva
Joined: 11 Oct 2004
Posts: 3772
Location: Wellington, Aotearoa
|
| Posted: Sun Apr 27, 2008 4:50 pm Post subject: Re: [mysql] Problème de config |
|
|
| 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 |
|
|
loopx
Advocate
Joined: 01 Apr 2005
Posts: 2787
Location: Belgium / Liège
|
| Posted: Sun Apr 27, 2008 4:52 pm Post subject: Re: [mysql] Problème de config |
|
|
| 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 
_________________
Mon MediaWiki perso : http://pix-mania.dyndns.org |
|
| Back to top |
|
|
smu
n00b
Joined: 13 May 2006
Posts: 28
|
| Posted: Sun Apr 27, 2008 6:06 pm Post subject: |
|
|
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 |
|
|
|
French
