升級 mysql-server-5.0 遇到的問題!

這個版面主要討論 debian 在 server 端的應用問題, server 種類繁多..舉凡 Web Server 、 File Server、 DHCP Server..等等。

版主: 阿信

升級 mysql-server-5.0 遇到的問題!

文章ericsson » 週日 10月 22, 2006 6:57 pm

系統:debian 2.4.27-2-386

各位好,目前個人的主機是使用 stable ,但是日前想要將 mysql 升級至 5.0 ,因此,將 sources.list 修改為
deb http://ftp.tw.debian.org/debian/ testing main
deb-src http://ftp.tw.debian.org/debian/ testing main
deb http://security.debian.org/ stable/updates main

更改完畢之後,執行 apt-get update 與 apt-get install mysql-server-5.0
以下為安裝的部份紀錄

#apt-get install mysql-server-5.0
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
bc ftp gcc-4.1-base gdb libc6 libc6-dev libdb4.3 libgcc1 libmysqlclient15off libncurses5 libreadline5 libssl0.9.8 libstdc++6 locales lsb-base
mysql-client-5.0 mysql-common python2.3 readline-common tzdata
Suggested packages:
gdb-doc glibc-doc tinyca python2.3-doc python2.3-profiler
Recommended packages:
python2.3-cjkcodecs python2.3-iconvcodec python2.3-japanese-codecs
The following packages will be REMOVED:
base-config initrd-tools kernel-image-2.4.27-2-386 kernel-image-2.6.8-2-386 libreadline4 mysql-client-4.1 mysql-common-4.1 mysql-server-4.1
The following NEW packages will be installed:
gcc-4.1-base libmysqlclient15off libssl0.9.8 libstdc++6 lsb-base mysql-client-5.0 mysql-common mysql-server-5.0 readline-common tzdata
The following packages will be upgraded:
bc ftp gdb libc6 libc6-dev libdb4.3 libgcc1 libncurses5 libreadline5 locales python2.3
11 upgraded, 10 newly installed, 8 to remove and 252 not upgraded.
Need to get 55.5MB of archives.
After unpacking 7983kB disk space will be freed.
Do you want to continue? [Y/n]y

....省略....

(Reading database ... 42862 files and directories currently installed.)
Removing base-config ...
Removing kernel-image-2.6.8-2-386 ...
Searching for GRUB installation directory ... found: /boot/grub .
Testing for an existing GRUB menu.list file... found: /boot/grub/menu.lst .
Searching for splash image... none found, skipping...
Found kernel: /boot/vmlinuz-2.4.27-2-386
Updating /boot/grub/menu.lst ... done

The link /vmlinuz is a dangling link
Removing symbolic link vmlinuz
Unless you used the optional flag in lilo,
you may need to re-run lilo
The link /initrd.img is a dangling link
Removing symbolic link initrd.img
Unless you used the optional flag in lilo,
you may need to re-run lilo
Removing kernel-image-2.4.27-2-386 ...

You are running a kernel (version 2.4.27-2-386) and attempting to remove
the same version. This is a potentially disastrous action. Not only
will /boot/vmlinuz-2.4.27-2-386 be removed, making it impossible to boot
it, (you will have to take action to change your boot loader to boot
a new kernel), it will also remove all modules under the directory
/lib/modules/2.4.27-2-386. Just having a copy of the kernel image is not
enough, you will have to replace the modules too.

I repeat, this is very dangerous. If at all in doubt, answer
no. If you know exactly what you are doing, and are prepared to
hose your system, then answer Yes.
Remove the running kernel image (not recommended) [No]?
dpkg: error processing kernel-image-2.4.27-2-386 (--remove):
subprocess pre-removal script returned error exit status 1
dpkg: initrd-tools: dependency problems, but removing anyway as you request:
kernel-image-2.4.27-2-386 depends on initrd-tools (>= 0.1.48).
Removing initrd-tools ...
Errors were encountered while processing:
kernel-image-2.4.27-2-386
E: Sub-process /usr/bin/dpkg returned an error code (1)

後來,執行 apt-get -f install 指令

# apt-get -f install
Reading Package Lists... Done
Building Dependency Tree... Done
Correcting dependencies... Done
The following extra packages will be installed:
initrd-tools
The following NEW packages will be installed:
initrd-tools
0 upgraded, 1 newly installed, 0 to remove and 263 not upgraded.
Need to get 32.1kB of archives.
After unpacking 184kB of additional disk space will be used.
Do you want to continue? [Y/n]y
Get:1 http://ftp.tw.debian.org testing/main initrd-tools 0.1.84.1 [32.1kB]
Fetched 32.1kB in 0s (70.7kB/s)
Selecting previously deselected package initrd-tools.
(Reading database ... 41026 files and directories currently installed.)
Unpacking initrd-tools (from .../initrd-tools_0.1.84.1_all.deb) ...
Setting up initrd-tools (0.1.84.1) ...

# apt-get install mysql-server-5.0
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
bc ftp gcc-4.1-base gdb libc6 libc6-dev libdb4.3 libgcc1 libmysqlclient15off libncurses5 libreadline5 libssl0.9.8 libstdc++6 locales lsb-base
mysql-client-5.0 mysql-common python2.3 readline-common tzdata
Suggested packages:
gdb-doc glibc-doc tinyca python2.3-doc python2.3-profiler
Recommended packages:
python2.3-cjkcodecs python2.3-iconvcodec python2.3-japanese-codecs
The following packages will be REMOVED:
libreadline4 mysql-client-4.1 mysql-common-4.1 mysql-server-4.1
The following NEW packages will be installed:
gcc-4.1-base libmysqlclient15off libssl0.9.8 libstdc++6 lsb-base mysql-client-5.0 mysql-common mysql-server-5.0 readline-common tzdata
The following packages will be upgraded:
bc ftp gdb libc6 libc6-dev libdb4.3 libgcc1 libncurses5 libreadline5 locales python2.3
11 upgraded, 10 newly installed, 4 to remove and 252 not upgraded.
Need to get 0B/55.5MB of archives.
After unpacking 65.7MB of additional disk space will be used.
Do you want to continue? [Y/n]y
Preconfiguring packages ...
Selecting previously deselected package tzdata.
(Reading database ... 41039 files and directories currently installed.)
Unpacking tzdata (from .../tzdata_2006l-1_all.deb) ...
Replacing files in old package libc6 ...
Preparing to replace libc6-dev 2.3.2.ds1-22sarge4 (using .../libc6-dev_2.3.6.ds1-4_i386.deb) ...
Unpacking replacement libc6-dev ...
Preparing to replace locales 2.3.2.ds1-22sarge4 (using .../locales_2.3.6.ds1-4_all.deb) ...
Unpacking replacement locales ...
Preparing to replace libc6 2.3.2.ds1-22sarge4 (using .../libc6_2.3.6.ds1-4_i386.deb) ...

Name Service Switch update in the C Library: pre-installation question.

Running services and programs that are using NSS need to be restarted,
otherwise they might not be able to do lookup or authentication any more.
The installation process is able to restart some services (such as ssh or
telnetd), but other programs cannot be restarted automatically. One such
program that needs manual stopping and restart after the glibc upgrade by
yourself is xdm - because automatic restart might disconnect your active
X11 sessions.

Known packages that need to be stopped before the glibc upgrade are:
xdm kdm gdm postgresql xscreensaver

This script did not detect any installed services which need to be
stopped.

If you want to interrupt the upgrade now and continue later, please
answer No to the question below.

Do you want to upgrade glibc now? [Y/n]y
Unpacking replacement libc6 ...
Setting up tzdata (2006l-1) ...
Current default timezone: 'Asia/Taipei'.
Local time is now: Sat Oct 21 23:44:25 CST 2006.
Universal Time is now: Sat Oct 21 15:44:25 UTC 2006.
Run 'tzconfig' if you wish to change it.

Setting up libc6 (2.3.6.ds1-4) ...
Checking for services that may need to be restarted...done.

Name Service Switch update in the C Library: post-installation question.

Running services and programs that are using NSS need to be restarted,
otherwise they might not be able to do lookup or authentication any more
(for services such as ssh, this can affect your ability to login).
Note: restarting sshd/telnetd should not affect any existing connections.

The services detected are:
atd inetd webmin proftpd apache snmpd lpd postfix cron ssh

If other services have begun to fail mysteriously after this upgrade, it is
probably necessary to restart them too. We recommend you to reboot your
machine after the upgrade to avoid the NSS related trouble.

Do you wish to restart services? [Y/n]y
Restarting services possibly affected by the upgrade:
atd: stopping...starting...done.
inetd: stopping...starting...done.
webmin: stopping...starting...done.
proftpd: stopping...starting...done.
apache: stopping...starting...FAILED! (1)
snmpd: stopping...starting...done.
lpd: stopping...starting...done.
postfix: stopping...starting...done.
cron: stopping...starting...done.
ssh: stopping...starting...done.

The following services failed to start: apache
(Reading database ... 41145 files and directories currently installed.)
Preparing to replace libncurses5 5.4-4 (using .../libncurses5_5.5-3_i386.deb) ...
Unpacking replacement libncurses5 ...
Setting up libncurses5 (5.5-3) ...

(Reading database ... 41146 files and directories currently installed.)
Preparing to replace ftp 0.17-12 (using .../archives/ftp_0.17-16_i386.deb) ...
Unpacking replacement ftp ...
Preparing to replace bc 1.06-15 (using .../archives/bc_1.06-20_i386.deb) ...
Unpacking replacement bc ...
Preparing to replace gdb 6.3-6 (using .../gdb_6.4.90.dfsg-1_i386.deb) ...
Unpacking replacement gdb ...
Preparing to replace python2.3 2.3.5-3sarge1 (using .../python2.3_2.3.5-15_i386.deb) ...
Unpacking replacement python2.3 ...
(Reading database ... 41238 files and directories currently installed.)
Removing mysql-server-4.1 ...
Stopping MySQL database server: mysqld
dpkg: mysql-client-4.1: dependency problems, but removing anyway as you request:
phpbb2-conf-mysql depends on mysql-client; however:
Package mysql-client is not installed.
Package mysql-client-4.1 which provides mysql-client is to be removed.
Removing mysql-client-4.1 ...
Removing libreadline4 ...
(Reading database ... 40997 files and directories currently installed.)
Preparing to replace libreadline5 5.0-10 (using .../libreadline5_5.1-9_i386.deb) ...
Unpacking replacement libreadline5 ...
Selecting previously deselected package readline-common.
Unpacking readline-common (from .../readline-common_5.1-9_all.deb) ...
Preparing to replace libdb4.3 4.3.27-2 (using .../libdb4.3_4.3.29-6_i386.deb) ...
Unpacking replacement libdb4.3 ...
Selecting previously deselected package libssl0.9.8.
Unpacking libssl0.9.8 (from .../libssl0.9.8_0.9.8c-3_i386.deb) ...
dpkg: mysql-common-4.1: dependency problems, but removing anyway as you request:
libmysqlclient12 depends on mysql-common (>= 4.0.24-10sarge2) | mysql-common-4.1; however:
Package mysql-common is not installed.
Package mysql-common-4.1 is to be removed.
libmysqlclient14 depends on mysql-common-4.1 (>= 4.1.11a-4sarge7) | mysql-common; however:
Package mysql-common-4.1 is to be removed.
Package mysql-common is not installed.
Package mysql-common-4.1 which provides mysql-common is to be removed.
libmysqlclient12 depends on mysql-common (>= 4.0.24-10sarge2) | mysql-common-4.1; however:
Package mysql-common is not installed.
Package mysql-common-4.1 is to be removed.
libmysqlclient14 depends on mysql-common-4.1 (>= 4.1.11a-4sarge7) | mysql-common; however:
Package mysql-common-4.1 is to be removed.
Package mysql-common is not installed.
Package mysql-common-4.1 which provides mysql-common is to be removed.
(Reading database ... 41025 files and directories currently installed.)
Removing mysql-common-4.1 ...
Selecting previously deselected package gcc-4.1-base.
(Reading database ... 41022 files and directories currently installed.)
Unpacking gcc-4.1-base (from .../gcc-4.1-base_4.1.1-13_i386.deb) ...
Preparing to replace libgcc1 1:3.4.3-13sarge1 (using .../libgcc1_1%3a4.1.1-13_i386.deb) ...
Unpacking replacement libgcc1 ...
Setting up gcc-4.1-base (4.1.1-13) ...

Setting up libgcc1 (4.1.1-13) ...

Selecting previously deselected package libstdc++6.
(Reading database ... 41029 files and directories currently installed.)
Unpacking libstdc++6 (from .../libstdc++6_4.1.1-13_i386.deb) ...
Selecting previously deselected package lsb-base.
Unpacking lsb-base (from .../lsb-base_3.1-15_all.deb) ...
Selecting previously deselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_5.0.24a-9_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.24a-9_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.24a-9_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.24a-9_i386.deb) ...
Setting up libc6-dev (2.3.6.ds1-4) ...
Setting up locales (2.3.6.ds1-4) ...
Generating locales (this might take a while)...
zh_TW.BIG5... done
Generation complete.

Setting up readline-common (5.1-9) ...

Setting up libreadline5 (5.1-9) ...

Setting up ftp (0.17-16) ...

Setting up bc (1.06-20) ...

Setting up gdb (6.4.90.dfsg-1) ...

Setting up libdb4.3 (4.3.29-6) ...
Setting up libssl0.9.8 (0.9.8c-3) ...
Setting up python2.3 (2.3.5-15) ...
Installing new version of config file /etc/python2.3/site.py ...
byte-compiling files for package python2.3...
Linking and byte-compiling packages for runtime python2.3...

Setting up libstdc++6 (4.1.1-13) ...

Setting up lsb-base (3.1-15) ...
Setting up mysql-common (5.0.24a-9) ...
Installing new version of config file /etc/mysql/my.cnf ...
Setting up libmysqlclient15off (5.0.24a-9) ...

Setting up mysql-client-5.0 (5.0.24a-9) ...
Setting up mysql-server-5.0 (5.0.24a-9) ...
Installing new version of config file /etc/init.d/mysql ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..

You will need to start these manually by running `/etc/init.d/<service> start'
If the service still fails to start, you may need to file a bug on
libc6 or the service involved.

Press ENTER to continue:

想要請教各位的是,在更新至 mysql-server-5.0 ,這樣子的更新讓我覺得不是很安全,雖然最後更新成功了,但是卻是有部份的錯誤訊息需要解決....我了解系統最好不要在 stable 和 testing 之間相互安裝,但是如果我的確需要 testing 中的軟體,什麼樣子的執行步驟才是正確的呢?

此外,我不是很能夠理解的是為甚麼在更新 mysql ,但是卻要移除 kernel-image,甚至包含目前正在使用的 kernel-image?
不知是否可以請各位指教,謝謝您!
ericsson
可愛的小學生
可愛的小學生
 
文章: 7
註冊時間: 週日 5月 07, 2006 6:41 pm

回到 debian server

誰在線上

正在瀏覽這個版面的使用者:沒有註冊會員 和 1 位訪客