[求助］安装mysql的问题

cbkid

portage里没有mysql-5.1版本，添加了个mysql-testing的overlay有了mysql-community-5.2alpha版，emerge 之出现mysql-5.06和mysql-commnity的循环依赖。

1. These are the packages that would be merged, in order:
3. Calculating dependencies   ... done!
4. [ebuild  N    ] dev-db/mysql-5.0.60-r1  USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 0 kB [0]
5. [ebuild  N    ] virtual/mysql-5.0  0 kB [0]
6. [ebuild  N    ] dev-perl/DBD-mysql-4.00.8  0 kB [0]
7. [ebuild  N    ] dev-db/mysql-community-5.2.0_alpha20070104-r61  USE="perl ssl -big-tables -cluster -debug -embedded -extraengine -innodb -latin1 -max-idx-128 -minimal -pbxt (-selinux) -static" 12,213 kB [1]
8. [blocks B     ] dev-db/mysql-community ("dev-db/mysql-community" is blocking dev-db/mysql-5.0.60-r1)
9. [blocks B     ] dev-db/mysql ("dev-db/mysql" is blocking dev-db/mysql-community-5.2.0_alpha20070104-r61)
11. Total: 4 packages (4 new), Size of downloads: 12,213 kB
12. Conflict: 2 blocks (2 unsatisfied)
13. Portage tree and overlays:
14. [0] /usr/portage
15. [1] /usr/local/portage/layman/mysql-testing
17. For more information about Blocked Packages, please refer to the following
18. section of the Gentoo Linux x86 Handbook (architecture is irrelevant):
20. http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?full=1#blocked
23. * GNU info directory index is up-to-date.

复制代码

考虑到可能是一些按装文件的依赖问题，所以先安装了ev-perl/DBD-mysql-4.00.8，但是出现mysql-5.0.6的安装问题

2. [32;01m*[0m Adding group 'mysql' to your system ...
3. [32;01m*[0m - Groupid: 60
4. [32;01m*[0m Adding user 'mysql' to your system ...
5. [32;01m*[0m - Userid: 60
6. [32;01m*[0m - Shell: /sbin/nologin
7. [32;01m*[0m - Home: /dev/null
8. [32;01m*[0m - Groups: mysql
9. [32;01m*[0m Berkeley DB support is deprecated and will be removed in future versions!
10. >>> Unpacking source...
11. [32;01m*[0m Using default DATADIR
12. [32;01m*[0m MySQL DATADIR is /var/lib/mysql
13. >>> Unpacking mysql-5.0.60.tar.gz to /var/tmp/portage/dev-db/mysql-5.0.60-r1/work
14. >>> Unpacking mysql-extras-20080601.tar.bz2 to /var/tmp/portage/dev-db/mysql-5.0.60-r1/work
15. /var/tmp/portage/dev-db/mysql-5.0.60-r1/temp/environment: line 2988: /var/tmp/portage/dev-db/mysql-5.0.60-r1/work/mysql-extras/000_index.txt: 没有那个文件或目录
16. [31;01m*[0m
17. [31;01m*[0m ERROR: dev-db/mysql-5.0.60-r1 failed.
18. [31;01m*[0m Call stack:
19. [31;01m*[0m ebuild.sh, line   49:  Called src_unpack
20. [31;01m*[0m environment, line 3636:  Called mysql_src_unpack
21. [31;01m*[0m environment, line 3274:  Called mysql_mv_patches
22. [31;01m*[0m environment, line 3027:  Called _mysql_test_patch_ver_pn '0' ''
23. [31;01m*[0m environment, line  367:  Called die
24. [31;01m*[0m The specific snippet of code:
25. [31;01m*[0m [[ -d "${filesdir}" ]] || die "Source dir must be a directory";
26. [31;01m*[0m The die message:
27. [31;01m*[0m Source dir must be a directory
28. [31;01m*[0m
29. [31;01m*[0m If you need support, post the topmost build error, and the call stack if relevant.
30. [31;01m*[0m A complete build log is located at '/var/tmp/portage/dev-db/mysql-5.0.60-r1/temp/build.log'.
31. [31;01m*[0m The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.0.60-r1/temp/environment'.
32. [31;01m*[0m

复制代码

1. emerge --info
3. ortage 2.2_rc11 (default/linux/amd64/2008.0/desktop, gcc-4.3.1, glibc-2.8_p20080602-r0, 2.6.26-gentoo x86_64)
4. =================================================================
5. System uname: Linux-2.6.26-gentoo-x86_64-Intel-R-_Pentium-R-_Dual_CPU_T2310_@_1.46GHz-with-glibc2.2.5
6. Timestamp of tree: Wed, 01 Oct 2008 21:45:04 +0000
7. ccache version 2.4 [enabled]
8. app-shells/bash:     3.2_p39
9. dev-java/java-config: 1.3.7, 2.1.6-r1
10. dev-lang/python:     2.5.2-r8
11. dev-python/pycrypto: 2.0.1-r6
12. dev-util/ccache:     2.4-r8
13. sys-apps/baselayout: 2.0.0
14. sys-apps/openrc:     0.2.5
15. sys-apps/sandbox:    1.2.18.1-r3
16. sys-devel/autoconf:  2.63
17. sys-devel/automake:  1.4_p6, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
18. sys-devel/binutils:  2.18-r3
19. sys-devel/gcc-config: 1.4.0-r4
20. sys-devel/libtool:   2.2.6a
21. virtual/os-headers:  2.6.26
22. ABI="amd64"
23. ACCEPT_KEYWORDS="amd64 ~amd64"
24. ALSA_CARDS="ICH8 ICH7"
25. ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol"
26. 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"
27. ARCH="amd64"
28. ASFLAGS_x86="--32"
29. AUTOCLEAN="yes"
30. CBUILD="x86_64-pc-linux-gnu"
31. CCACHE_DIR="/var/tmp/ccache"
32. CCACHE_SIZE="2G"
33. CDEFINE_amd64="__x86_64__"
34. CDEFINE_x86="__i386__"
35. CFLAGS="-O2 -pipe"
36. CFLAGS_x86="-m32"
37. CHOST="x86_64-pc-linux-gnu"
38. CHOST_amd64="x86_64-pc-linux-gnu"
39. CHOST_x86="i686-pc-linux-gnu"
40. CLASSPATH="."
41. CLEAN_DELAY="5"
42. COLLISION_IGNORE="/lib/modules"
43. COLORTERM="rxvt"
44. CONFIG_PROTECT="/etc /usr/env /usr/share/config /usr/shutdown"
45. CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/udev/rules.d"
46. CVS_RSH="ssh"
47. CXXFLAGS="-O2 -pipe"
48. DEFAULT_ABI="amd64"
49. DISPLAY=":0.0"
50. DISTDIR="/home/.portage/distfiles"
51. ELIBC="glibc"
52. EMERGE_DEFAULT_OPTS="--verbose "
53. EMERGE_WARNING_DELAY="10"
54. FEATURES="ccache distlocks parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-orphans userfetch"
55. FETCHCOMMAND="/usr/bin/wget -t 5 -T 60 --passive-ftp -O "${DISTDIR}/${FILE}" "${URI}""
56. GCC_SPECS=""
57. GDK_USE_XFT="1"
58. GENTOO_MIRRORS="http://61.135.158.199"
59. HOME="/home/cbkid"
60. INFOPATH="/usr/share/info:/usr/share/binutils-data/x86_64-pc-linux-gnu/2.18/info:/usr/share/gcc-data/x86_64-pc-linux-gnu/4.3.1/info:/usr/share/info/emacs-23"
61. INPUT_DEVICES="keyboard mouse"
62. KDEDIRS="/usr:/usr/local"
63. KERNEL="linux"
64. LANG="zh_CN"
65. LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text"
66. LC_ALL="zh_CN.UTF-8"
67. LC_CTYPE="zh_CN.utf8"
68. LDFLAGS="-Wl,-O1"
69. LDFLAGS_x86="-m elf_i386"
70. LESS="-R -M --shift 5"
71. LESSOPEN="|lesspipe.sh %s"
72. LIBDIR_amd64="lib64"
73. LIBDIR_ppc="lib32"
74. LIBDIR_ppc64="lib64"
75. LIBDIR_x86="lib32"
76. LINGUAS="zh_CN zh_TW zh"
77. LOGNAME="root"
78. LS_COLORS="rs=0:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.pdf=00;32:*.ps=00;32:*.txt=00;32:*.patch=00;32:*.diff=00;32:*.log=00;32:*.tex=00;32:*.doc=00;32:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:"
79. MAKEOPTS="-j3"
80. MANPATH="/usr/local/share/man:/usr/share/man:/usr/share/binutils-data/x86_64-pc-linux-gnu/2.18/man:/usr/share/gcc-data/x86_64-pc-linux-gnu/4.3.1/man:/etc/java-config/system-vm/man/:/usr/qt/3/doc/man:/usr/lib64/erlang/man"
81. MULTILIB_ABIS="amd64 x86"
82. MULTILIB_STRICT_DENY="64-bit.*shared object"
83. MULTILIB_STRICT_DIRS="/lib32 /lib /usr/lib32 /usr/lib /usr/kde/*/lib32 /usr/kde/*/lib /usr/qt/*/lib32 /usr/qt/*/lib /usr/X11R6/lib32 /usr/X11R6/lib"
84. MULTILIB_STRICT_EXEMPT="(perl5|gcc|gcc-lib|binutils|eclipse-3|debug|portage)"
85. NOcolor="true"
86. OPENGL_PROFILE="xorg-x11"
87. PATH="/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/opt/bin"
88. PKGDIR="/usr/portage/packages"
89. PKG_CONFIG_PATH="/usr/qt/3/lib64/pkgconfig"
90. PORTAGE_ARCHLIST="ppc s390 amd64 x86 ppc64 x86-fbsd m68k arm sparc sh mips ia64 alpha hppa sparc-fbsd"
91. PORTAGE_BINHOST_CHUNKSIZE="3000"
92. PORTAGE_BIN_PATH="/usr/lib64/portage/bin"
93. PORTAGE_COMPRESS_EXCLUDE_SUFFIXES="css gif htm[l]? jp[e]?g js pdf png"
94. PORTAGE_CONFIGROOT="/"
95. PORTAGE_DEBUG="0"
96. PORTAGE_DEPCACHEDIR="/var/cache/edb/dep"
97. PORTAGE_ECLASS_WARNING_ENABLE="0"
98. PORTAGE_ELOG_CLASS="log"
99. PORTAGE_ELOG_CLASSES="log warn error"
100. PORTAGE_ELOG_MAILFROM="portage@localhost"
101. PORTAGE_ELOG_MAILSUBJECT="[portage] ebuild log for ${PACKAGE} on ${HOST}"
102. PORTAGE_ELOG_MAILURI="root"
103. PORTAGE_ELOG_SYSTEM="save"
104. PORTAGE_FETCH_CHECKSUM_TRY_MIRRORS="5"
105. PORTAGE_FETCH_RESUME_MIN_SIZE="350K"
106. PORTAGE_GID="250"
107. PORTAGE_INST_GID="0"
108. PORTAGE_INST_UID="0"
109. PORTAGE_NICENESS="10"
110. PORTAGE_PYM_PATH="/usr/lib64/portage/pym"
111. PORTAGE_RSYNC_EXTRA_OPTS="--quiet --progress"
112. PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
113. PORTAGE_RSYNC_RETRIES="3"
114. PORTAGE_TMPDIR="/var/tmp"
115. PORTAGE_WORKDIR_MODE="0700"
116. PORTDIR="/usr/portage"
117. PORTDIR_OVERLAY="/usr/local/portage/layman/gentoo-china /usr/local/portage/layman/emacs /usr/local/portage/layman/kde-testing /usr/local/portage/layman/mysql-testing /usr/local/portage/layman/gnome /usr/local/portage"
118. PRELINK_PATH_MASK="/usr/lib64/klibc"
119. PROFILE_ONLY_VARIABLES="ARCH ELIBC KERNEL USERLAND"
120. QMAKESPEC="linux-g++"
121. QTDIR="/usr/qt/3"
122. RESUMECOMMAND="/usr/bin/wget -c -t 5 -T 60 --passive-ftp -O "${DISTDIR}/${FILE}" "${URI}""
123. ROOT="/"
124. ROOTPATH="/opt/bin:/usr/x86_64-pc-linux-gnu/gcc-bin/4.3.1:/usr/sbin:/usr/bin:/usr/qt/3/bin"
125. RPMDIR="/usr/portage/rpm"
126. RUBYOPT="-rauto_gem"
127. SANE_CONFIG_DIR="/etc/sane.d"
128. SHELL="/bin/bash"
129. STAGE1_USE="multilib nptl nptlonly unicode"
130. SUDO_COMMAND="/usr/bin/emerge --info"
131. SUDO_GID="1007"
132. SUDO_UID="1000"
133. SUDO_USER="cbkid"
134. SYMLINK_LIB="yes"
135. SYNC="rsync://61.135.158.199/gentoo-portage"
136. TERM="rxvt-unicode"
137. USB_DEVFS_PATH="/dev/bus/usb"
138. USE="X acl acpi alsa amd64 apm aria2 berkdb bluetooth branding bzip2 cairo cdr cli cracklib crypt cups dbus dri dvd dvdr dvdread eds emboss encode esd evo fam firefox font-server fortran ftp gdbm gif gpm gstreamer gtk hal iconv ipv6 isdnlog jpeg kde kde4 kerberos ldap libnotify mad mdnsresponder-compat midi mikmod mmx mp3 mpeg msn mudflap multilib ncurses nls nptl nptlonly ogg opengl openmp pam pcre pdf perl png ppds pppd python qq qt qt3 qt3support qt4 quicktime readline reflection sdl session spell spl sse sse2 ssl startup-notification svg sysfs tcpd tiff truetype unicode usb vorbis wma xcomposite xml xorg xv zlib" ALSA_CARDS="ICH8 ICH7" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul 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 zh_TW zh" USERLAND="GNU" VIDEO_CARDS="i810"
139. USER="root"
140. USERLAND="GNU"
141. USERNAME="root"
142. USE_EXPAND="ALSA_CARDS ALSA_PCM_PLUGINS APACHE2_MODULES APACHE2_MPMS CAMERAS CROSSCOMPILE_OPTS DVB_CARDS ELIBC FCDSL_CARDS FOO2ZJS_DEVICES FRITZCAPI_CARDS INPUT_DEVICES KERNEL LCD_DEVICES LINGUAS LIRC_DEVICES MISDN_CARDS USERLAND VIDEO_CARDS"
143. USE_EXPAND_HIDDEN="CROSSCOMPILE_OPTS ELIBC KERNEL USERLAND"
144. USE_ORDER="env:pkg:conf:defaults:pkginternal:env.d"
145. VIDEO_CARDS="i810"
146. XDG_DATA_DIRS="/usr/share:/usr/local/share"

复制代码

没有 /var/tmp/portage/dev-db/mysql-5.0.60-r1/work/mysql-extras/000_index.txt文件，但是在mysql-extras-20080601/目录里有000_index.txt

flyinflash

对于普通用户来说，dev-db/mysql与dev-db/mysql-community有什么区别？

如果您不知道，那么您应该使用前者。

2. [i] dev-db/mysql
3.      Available versions:  [M]3.23.58-r1 4.0.27-r1 4.1.22-r1 [M](~)4.1.23_alpha20070101-r61 5.0.26-r2 (~)5.0.32 (~)5.0.34 5.0.38 5.0.40 5.0.42 5.0.44 5.0.44-r1 5.0.44-r2 5.0.54 (~)5.0.56 (~)5.0.60 5.0.60-r1 {berkdb big-tables cluster debug embedded extraengine innodb latin1 max-idx-128 minimal perl raid readline selinux ssl static tcpd}
4.      Installed versions:  5.0.60-r1(09:24:47 PM 08/08/2008)(perl ssl -berkdb -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -selinux -static)
5.      Homepage:            http://www.mysql.com/
6.      Description:         A fast, multi-threaded, multi-user SQL database server.

复制代码

cbkid

一直认为community为社区版不知道理解的对不对，我因为手册里说mysql-5.0和5.1差别很大，所以才决定一定要用5.1版的，如果真的叫社区版的话，就没理由不用了。

flyinflash

请问您看过《MySQL5权威指南》吗？里面有一节是说mysql繁杂的版权问题，也提到了各个版本的区别，如果您空，应该看一下--我建议所有学MySQL的人都应该看一下，它应该是目前能买到、找到的是好的、最权威的、最全（开源程序不是参照物）MySQL中文参考。

我因为手册里说mysql-5.0和5.1差别很大

微软说Vista相对于Windows XP来说是一个质的飞越，是一个全新的系统，是……但是我还在用Windows XP。

“大大相同小小有变”而已。没有加入“面向对象”和xml支持，它的本质始终是orale,DB/2的之后的弟弟，始终是兼容于SQL标准。

如果真的叫社区版的话，就没理由不用了。

据说有不少gentoo社区版，请问您会去用吗？

另外，套用乐哥的前几天回复的一句话，“当您应该/需要知道x是什么时，您就会知道了，就不会上来这里问了”：
当您学好SQL基础时，您把《MySQL权威指南》看完了，开发了若干个小项目后，您就会……

嘻嘻，大家是同学，纯粹交流经验，不是说教

抽烟斗的狗

长远来说，用 PostgreSQL 吧，我已全面转向 PostgreSQL 了，为了她，wordpress 也不用了。

zhllg

这不叫循环依赖
这叫相互阻挡
两个只能用一个
根据我的理解，以后就应该用mysql-community了，mysql到头了

cbkid

fly,你说的那本书我没看过，我是个新手，对于有新版本我看了看他和5.0的对比，我觉得从新学习的话我没有理由学一个旧版本再更新。特别是差别特别大的时候。我只是想学习sql所以要装个DBM用用的，我不可能光看书就会sql了。用mysql-community是为了版权问题，你也说过版权是很麻烦的。但是community是gpl的版权这个就没什么说的，为什么我没有都有社区版是因为我的技术不够，不想给别人和自己找麻烦，但是我一直在努力。

烟，谢谢烟哥给的提示，我搜了一下发现pgsql真的不错，但是我真的不是很了解搜到的对比全是06年以前的，而且我最顾虑的就是BSD的版权，希望烟哥说说自己为什么选择PGsql我也只是为了学习sql语言的，老是让用WIN的SQL server这显然对我们来说是不可能的。

zhllg,恩应该叫相互阻挡，我叫循环依赖的原因是因为我发现安装mysql-community需要安装dbi安装dbi需要安装mysql，怪我口误，问题是现在安装mysql却不成功了。

zhllg

先去掉perl这个USE标记
USE='-perl' emerge mysql-community

flyinflash

Post by zhllg;1889789
这不叫循环依赖
这叫相互阻挡
两个只能用一个
根据我的理解，以后就应该用mysql-community了，mysql到头了

嗯，小牛，还是听老大的吧 ^_^

抽烟斗的狗

希望烟哥说说自己为什么选择PGsql。。。。。

我也是刚接触 PostgreSQL 原因有二：

1.在安装开源 erp 时，都不支持 MySQL，间接说明很多高级特许 MySQL 稍差，在商业级应用比较少用 MySQL
2. SUN 收购 MySQL 后，MySQL 好像声明不发布源码版了，我也是编译安装有问题后，考虑一下，下决心转向 PostgreSQL（维护MySQL 的大牛们会会已经放弃了，哈哈~~~）。

MySQL 大多数用在 Web 网站上，原因是 PHP 对 MySQL 支持好，提供接口，网站为效率高、简单，直接使用。
现在一些 PHP 的 CMS 如 Drupal 使用一个数据库层来连接数据库，可以支持较多类型的数据库（ PostgreSQL），这种趋势应该开始出现了

版权这问题，我很少考虑，哈~~~~

PostgreSQL 的中文书很少，大多数是几年前，唉~~~

数据库拿来用，研究不精，见谅~~~