emerge mysql 成功，但是emerge --config mysql时失败

BzFly

按照wiki上的安装wordpress，在configure mysql这一步失败

这是出错信息：·

2. hunk@localhost ~ $ sudo emerge --config =mysql-5.0.5*

复制代码

4. Configuring pkg...
6. * Creating the mysql database and setting proper
7. * permissions on it ...
8. * Insert a password for the mysql 'root' user
9. * Avoid ["'\_%] characters in the password
10.     >
11. * Retype the password
12.     >
13. *
14. * ERROR: dev-db/mysql-5.0.56 failed.
15. * Call stack:
16. *               ebuild.sh, line   49:  Called pkg_config
17. *             environment, line 3307:  Called mysql_pkg_config
18. *             environment, line 3014:  Called die
19. * The specific snippet of code:
20. *           die "Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND ${TMPDIR}/mysql_install_db.log";
21. *  The die message:
22. *   Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.0.56/temp/mysql_install_db.log
23. *
24. * If you need support, post the topmost build error, and the call stack if relevant.
25. * A complete build log is located at '/var/tmp/portage/dev-db/mysql-5.0.56/temp/build.log'.
26. * The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.0.56/temp/environment'.
27. * This ebuild is from an overlay: '/var/db/pkg/'
28. *

复制代码

但是可以运行mysql,就是不能登录·

2. hunk@localhost ~ $ mysql -u root -p
3. Enter password:
4. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

复制代码

1. hunk@localhost ~ $ emerge --info
2. Portage 2.1.4.4 (default-linux/x86/2007.0/desktop, gcc-4.2.3, glibc-2.6.1-r0, 2.6.24-gentoo-r2 i686)
3. =================================================================
4. System uname: 2.6.24-gentoo-r2 i686 Intel(R) Pentium(R) 4 CPU 3.00GHz
5. Timestamp of tree: Wed, 19 Mar 2008 21:30:01 +0000
6. ccache version 2.4 [disabled]
7. app-shells/bash:     3.2_p17-r1
8. dev-lang/python:     2.4.4-r9
9. dev-python/pycrypto: 2.0.1-r6
10. dev-util/ccache:     2.4-r7
11. sys-apps/baselayout: 1.12.11.1
12. sys-apps/sandbox:    1.2.18.1-r2
13. sys-devel/autoconf:  2.13, 2.61-r1
14. sys-devel/automake:  1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
15. sys-devel/binutils:  2.18-r1
16. sys-devel/gcc-config: 1.4.0-r4
17. sys-devel/libtool:   1.5.26
18. virtual/os-headers:  2.6.23-r3
19. ACCEPT_KEYWORDS="x86"
20. CBUILD="i686-pc-linux-gnu"
21. CFLAGS="-O2 -march=i686 -pipe"
22. CHOST="i686-pc-linux-gnu"
23. CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config"
24. CONFIG_PROTECT_MASK="/etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/udev/rules.d"
25. CXXFLAGS="-O2 -march=i686 -pipe"
26. DISTDIR="/usr/portage/distfiles"
27. FEATURES="distlocks metadata-transfer parallel-fetch sandbox sfperms strict unmerge-orphans userfetch"
28. GENTOO_MIRRORS="http://61.135.158.199"
29. LANG="en_US.UTF-8"
30. LINGUAS="zh_CN"
31. MAKEOPTS="-j3"
32. PKGDIR="/usr/portage/packages"
33. PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
34. PORTAGE_TMPDIR="/var/tmp"
35. PORTDIR="/usr/portage"
36. PORTDIR_OVERLAY="/usr/portage/local/layman/gentoo-china"
37. SYNC="rsync://61.135.158.199/gentoo-portage"
38. USE="X acl acpi alsa apache arts berkdb cairo cdr cli cracklib crypt cups dbus dri dvd dvdr dvdread eds emboss encode esd evo fam firefox fortran gdbm gif gnome gpm gstreamer gtk hal iconv ipv6 isdnlog jpeg kde kerberos ldap libwww mad midi mikmod mp3 mpeg mudflap mysql ncurses nls nptl nptlonly ogg opengl openmp oss pam pcre pdf perl php png pppd python qt3 qt3support qt4 quicktime readline reflection sdl session spell spl ssl svg tcpd tiff truetype unicode vorbis win32codecs x86 xml xorg xv zlib" ALSA_CARDS="intel8x0" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="zh_CN" USERLAND="GNU" VIDEO_CARDS="nvidia nv"
39. Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

复制代码

druggo

Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.0.56/temp/mysql_install_db.log

里面都有什么？

kpld

手动安装mysql

BzFly

Post by druggo;1828755
Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.0.56/temp/mysql_install_db.log

里面都有什么？

/var/log/mysql/mysqld.err

1. cat: /var/log/mysql/mysqld.err: Permission denied
   
2. hunk@localhost ~ $ sudo cat /var/log/mysql/mysqld.err
   
3. Password:
   
4. 080320  9:07: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.
   
5. ERROR: 1062  Duplicate entry 'localhost-' for key 1
   
6. 080320  9:07:12 [ERROR] Aborting
   
7. 
   
8. 080320  9:07:12 [Note] /usr/sbin/mysqld: Shutdown complete
   
9. 
   
10. 080320  9:19:01 [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.
    
11. InnoDB: The first specified data file ./ibdata1 did not exist:
    
12. InnoDB: a new database to be created!
    
13. 080320  9:19:01  InnoDB: Setting file ./ibdata1 size to 10 MB
    
14. InnoDB: Database physically writes the file full: wait...
    
15. 080320  9:19:01  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    
16. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    
17. InnoDB: Database physically writes the file full: wait...
    
18. 080320  9:19:01  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    
19. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    
20. InnoDB: Database physically writes the file full: wait...
    
21. InnoDB: Doublewrite buffer not found: creating new
    
22. InnoDB: Doublewrite buffer created
    
23. InnoDB: Creating foreign key constraint system tables
    
24. InnoDB: Foreign key constraint system tables created
    
25. 080320  9:19:02  InnoDB: Started; log sequence number 0 0
    
26. 080320  9:19:02 [Note] /usr/sbin/mysqld: ready for connections.
    
27. Version: '5.0.54-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.54
    
28. 080320  9:20:36 [Note] /usr/sbin/mysqld: Normal shutdown
    
29. 
    
30. 080320  9:20:36  InnoDB: Starting shutdown...
    
31. 080320  9:20:36  InnoDB: Shutdown completed; log sequence number 0 43655
    
32. 080320  9:20:36 [Note] /usr/sbin/mysqld: Shutdown complete
    
33. 
    
34. 080320  9:22:39 [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.
    
35. ERROR: 1062  Duplicate entry 'localhost-' for key 1
    
36. 080320  9:22:39 [ERROR] Aborting
    
37. 
    
38. 080320  9:22:39 [Note] /usr/sbin/mysqld: Shutdown complete
    
39. 
    
40. 080320  9:45:29 [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.
    
41. ERROR: 1062  Duplicate entry 'localhost-' for key 1
    
42. 080320  9:45:29 [ERROR] Aborting
    
43. 
    
44. 080320  9:45:29 [Note] /usr/sbin/mysqld: Shutdown complete
    
45. 
    
46. 080320 11:29:43 [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.
    
47. ERROR: 1062  Duplicate entry 'localhost-' for key 1
    
48. 080320 11:29:43 [ERROR] Aborting
    
49. 
    
50. 080320 11:29:43 [Note] /usr/sbin/mysqld: Shutdown complete
    
51. 
    
52. 080320 11:30:15 [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.
    
53. InnoDB: The first specified data file ./ibdata1 did not exist:
    
54. InnoDB: a new database to be created!
    
55. 080320 11:30:15  InnoDB: Setting file ./ibdata1 size to 10 MB
    
56. InnoDB: Database physically writes the file full: wait...
    
57. 080320 11:30:15  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    
58. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    
59. InnoDB: Database physically writes the file full: wait...
    
60. 080320 11:30:15  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    
61. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    
62. InnoDB: Database physically writes the file full: wait...
    
63. InnoDB: Doublewrite buffer not found: creating new
    
64. InnoDB: Doublewrite buffer created
    
65. InnoDB: Creating foreign key constraint system tables
    
66. InnoDB: Foreign key constraint system tables created
    
67. 080320 11:30:16  InnoDB: Started; log sequence number 0 0
    
68. 080320 11:30:16 [Note] /usr/sbin/mysqld: ready for connections.
    
69. Version: '5.0.56-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.56
    
70. 080320 11:34:19 [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.
    
71. ERROR: 1062  Duplicate entry 'localhost-' for key 1
    
72. 080320 11:34:19 [ERROR] Aborting
    
73. 
    
74. 080320 11:34:19 [Note] /usr/sbin/mysqld: Shutdown complete
    
75. 
    
76. 080320 14:09:27 [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.
    
77. ERROR: 1062  Duplicate entry 'localhost-' for key 1
    
78. 080320 14:09:27 [ERROR] Aborting
    
79. 
    
80. 080320 14:09:27 [Note] /usr/sbin/mysqld: Shutdown complete
    
81. 
    
82. 080320 14:12:04 [Note] /usr/sbin/mysqld: Normal shutdown
    
83. 
    
84. 080320 14:12:04 [ERROR] bdb:  log_archive: DB_ARCH_ABS: No such file or directory
    
85. 080320 14:12:04  InnoDB: Starting shutdown...
    
86. 080320 14:12:05  InnoDB: Shutdown completed; log sequence number 0 43655
    
87. 080320 14:12:05 [Note] /usr/sbin/mysqld: Shutdown complete
    
88. 
    
89. 080320 14:12:05 [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.
    
90. InnoDB: The first specified data file ./ibdata1 did not exist:
    
91. InnoDB: a new database to be created!
    
92. 080320 14:12:05  InnoDB: Setting file ./ibdata1 size to 10 MB
    
93. InnoDB: Database physically writes the file full: wait...
    
94. 080320 14:12:05  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    
95. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    
96. InnoDB: Database physically writes the file full: wait...
    
97. 080320 14:12:06  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    
98. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    
99. InnoDB: Database physically writes the file full: wait...
    
100. InnoDB: Doublewrite buffer not found: creating new
     
101. InnoDB: Doublewrite buffer created
     
102. InnoDB: Creating foreign key constraint system tables
     
103. InnoDB: Foreign key constraint system tables created
     
104. 080320 14:12:06  InnoDB: Started; log sequence number 0 0
     
105. 080320 14:12:06 [Note] /usr/sbin/mysqld: ready for connections.
     
106. Version: '5.0.56-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.56
     
107. 080320 14:12:18 [Note] /usr/sbin/mysqld: Normal shutdown
     
108. 
     
109. 080320 14:12:18  InnoDB: Starting shutdown...
     
110. 080320 14:12:19  InnoDB: Shutdown completed; log sequence number 0 43655
     
111. 080320 14:12:19 [Note] /usr/sbin/mysqld: Shutdown complete
     
112. 
     
113. 080320 14:12:38 [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.
     
114. ERROR: 1062  Duplicate entry 'localhost-' for key 1
     
115. 080320 14:12:38 [ERROR] Aborting
     
116. 
     
117. 080320 14:12:38 [Note] /usr/sbin/mysqld: Shutdown complete
     
118. 
     
119. 080320 14:12:49 [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.
     
120. InnoDB: The first specified data file ./ibdata1 did not exist:
     
121. InnoDB: a new database to be created!
     
122. 080320 14:12:49  InnoDB: Setting file ./ibdata1 size to 10 MB
     
123. InnoDB: Database physically writes the file full: wait...
     
124. 080320 14:12:49  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
     
125. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
     
126. InnoDB: Database physically writes the file full: wait...
     
127. 080320 14:12:49  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
     
128. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
     
129. InnoDB: Database physically writes the file full: wait...
     
130. InnoDB: Doublewrite buffer not found: creating new
     
131. InnoDB: Doublewrite buffer created
     
132. InnoDB: Creating foreign key constraint system tables
     
133. InnoDB: Foreign key constraint system tables created
     
134. 080320 14:12:50  InnoDB: Started; log sequence number 0 0
     
135. 080320 14:12:50 [Note] /usr/sbin/mysqld: ready for connections.
     
136. Version: '5.0.56-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.56
     
137. 080320 14:46:46 [Note] /usr/sbin/mysqld: Normal shutdown
     
138. 
     
139. 080320 14:46:46  InnoDB: Starting shutdown...
     
140. 080320 14:46:47  InnoDB: Shutdown completed; log sequence number 0 43655
     
141. 080320 14:46:47 [Note] /usr/sbin/mysqld: Shutdown complete
     
142. 
     
143. 080320 14:47:51 [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.
     
144. ERROR: 1062  Duplicate entry 'localhost-' for key 1
     
145. 080320 14:47:51 [ERROR] Aborting
     
146. 
     
147. 080320 14:47:51 [Note] /usr/sbin/mysqld: Shutdown complete
     
148. 
     
149. 080320 14:49:04 [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.
     
150. ERROR: 1062  Duplicate entry 'localhost-' for key 1
     
151. 080320 14:49:04 [ERROR] Aborting
     
152. 
     
153. 080320 14:49:04 [Note] /usr/sbin/mysqld: Shutdown complete
     
154. 
     
155. 
     

复制代码

/var/tmp/portage/dev-db/mysql-5.0.56/temp/mysql_install_db.log

1. hunk@localhost ~ $ sudo cat /var/tmp/portage/dev-db/mysql-5.0.56/temp/mysql_install_db.log
   
2. Installing MySQL system tables...
   
3. 080320 14:49:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
   
4. 080320 14:49:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
   
5. Installation of system tables failed!
   
6. 
   
7. Examine the logs in /var/lib/mysql for more information.
   
8. You can try to start the mysqld daemon with:
   
9. /usr/sbin/mysqld --skip-grant &
   
10. and use the command line tool
    
11. /usr/bin/mysql to connect to the mysql
    
12. database and look at the grant tables:
    
13. 
    
14. shell> /usr/bin/mysql -u root mysql
    
15. mysql> show tables
    
16. 
    
17. Try 'mysqld --help' if you have problems with paths. Using --log
    
18. gives you a log in /var/lib/mysql that may be helpful.
    
19. 
    
20. The latest information about MySQL is available on the web at
    
21. http://www.mysql.com
    
22. Please consult the MySQL manual section: 'Problems running mysql_install_db',
    
23. and the manual section that describes problems on your OS.
    
24. Another information source is the MySQL email archive.
    
25. Please check all of the above before mailing us!
    
26. And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
    

复制代码

BzFly

Post by kpld;1828760
手动安装mysql

谢谢兄弟，如果问题得不到解决就只有这样了。。

druggo

有些ERROR啊，搜搜吧
ERROR: 1062  Duplicate entry 'localhost-' for key 1
080320 14:49:04 [ERROR] Aborting

jjj311

看上去像密码问题……
重新emerge一下，然后搞个简单的密码config试试？

hihihihi

try to remove all the files inside /var/lib/mysql ,restart the service and run the emerge --config =mysql-5.0.5 command again

BzFly

Post by druggo;1828836
有些ERROR啊，搜搜吧
ERROR: 1062  Duplicate entry 'localhost-' for key 1
080320 14:49:04 [ERROR] Aborting

找到的这些error没有与我的是一样的，在bugs.gentoo.org里找到了相同的问题，但是可惜没有解决方案

BzFly

Post by jjj311;1828838
看上去像密码问题……
重新emerge一下，然后搞个简单的密码config试试？

两个字符的密码也不行，好像也不是密码的问题，谢谢你的建议