PDA

View Full Version : [ubuntu] UBUNTU 8.04 LTS update killed mysql!!! Sites are all down!!!



breauxlg
November 26th, 2009, 03:26 PM
Hello,
I received a partial update message from the update manager, and found a thread on here that said to do:
sudo apt-get update
sudo apt-get dist-upgrade

The second one killed mysql. Now all of my sites are down.

Here's the output from the command:
root@linux:/home/administrator# sudo apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages will be REMOVED:
mysql-client-5.0 mysql-server-5.0
The following NEW packages will be installed:
libmysqlclient16 mysql-client-5.1 mysql-server-5.1
The following packages have been kept back:
php5-imap
The following packages will be upgraded:
apache2 apache2-doc apache2-mpm-prefork apache2-utils apache2.2-common
cupsys cupsys-bsd cupsys-client cupsys-common libcupsimage2 libcupsys2
libpurple0 libvorbis0a libvorbisenc2 libvorbisfile3 mysql-client
mysql-common mysql-server php-pear php5 php5-dev php5-imagick php5-mcrypt
php5-memcache pidgin pidgin-data tzdata
27 upgraded, 3 newly installed, 2 to remove and 1 not upgraded.
Need to get 33.5MB of archives.
After this operation, 54.4MB disk space will be freed.
Do you want to continue [Y/n]? y
WARNING: The following packages cannot be authenticated!
mysql-common mysql-client libmysqlclient16 mysql-server mysql-client-5.1
mysql-server-5.1 php-pear php5 php5-dev php5-imagick php5-mcrypt
php5-memcache
Install these packages without verification [y/N]? y
Get:1 http://us.archive.ubuntu.com hardy-updates/main tzdata 2009r~repack-0ubuntu0.8.04 [685kB]
Get:2 http://packages.dotdeb.org stable/all mysql-common 5.1.41-1.dotdeb.1 [94.1kB]
Get:3 http://packages.dotdeb.org stable/all mysql-client 5.1.41-1.dotdeb.1 [88.2kB]
Get:4 http://packages.dotdeb.org stable/all libmysqlclient16 5.1.41-1.dotdeb.1 [1959kB]
Get:5 http://us.archive.ubuntu.com hardy-updates/main apache2-utils 2.2.8-1ubuntu0.14 [141kB]
Get:6 http://us.archive.ubuntu.com hardy-updates/main apache2-mpm-prefork 2.2.8-1ubuntu0.14 [232kB]
Get:7 http://us.archive.ubuntu.com hardy-updates/main apache2.2-common 2.2.8-1ubuntu0.14 [756kB]
Get:8 http://us.archive.ubuntu.com hardy-updates/main apache2 2.2.8-1ubuntu0.14 [45.9kB]
Get:9 http://us.archive.ubuntu.com hardy-updates/main apache2-doc 2.2.8-1ubuntu0.14 [1929kB]
Get:10 http://us.archive.ubuntu.com hardy-updates/main cupsys-common 1.3.7-1ubuntu3.6 [1144kB]
Get:11 http://us.archive.ubuntu.com hardy-updates/main libcupsys2 1.3.7-1ubuntu3.6 [175kB]
Get:12 http://us.archive.ubuntu.com hardy-updates/main libcupsimage2 1.3.7-1ubuntu3.6 [49.9kB]
Get:13 http://us.archive.ubuntu.com hardy-updates/main cupsys 1.3.7-1ubuntu3.6 [1865kB]
Get:14 http://packages.dotdeb.org stable/all mysql-server 5.1.41-1.dotdeb.1 [88.3kB]
Get:15 http://packages.dotdeb.org stable/all mysql-client-5.1 5.1.41-1.dotdeb.1 [8252kB]
Get:16 http://packages.dotdeb.org stable/all mysql-server-5.1 5.1.41-1.dotdeb.1 [11.6MB]
Get:17 http://packages.dotdeb.org stable/all php-pear 5.2.11-0.dotdeb.1 [332kB]
Get:18 http://packages.dotdeb.org stable/all php5 5.2.11-0.dotdeb.1 [1058B]
Get:19 http://packages.dotdeb.org stable/all php5-dev 5.2.11-0.dotdeb.1 [428kB]
Get:20 http://packages.dotdeb.org stable/all php5-imagick 5.2.11-0.dotdeb.1 [99.5kB]
Get:21 http://packages.dotdeb.org stable/all php5-mcrypt 5.2.11-0.dotdeb.1 [12.9kB]
Get:22 http://packages.dotdeb.org stable/all php5-memcache 5.2.11-0.dotdeb.1 [39.9kB]
Get:23 http://us.archive.ubuntu.com hardy-updates/main cupsys-bsd 1.3.7-1ubuntu3.6 [36.9kB]
Get:24 http://us.archive.ubuntu.com hardy-updates/main cupsys-client 1.3.7-1ubuntu3.6 [88.4kB]
Get:25 http://us.archive.ubuntu.com hardy-updates/main pidgin-data 1:2.4.1-1ubuntu2.7 [1329kB]
Get:26 http://us.archive.ubuntu.com hardy-updates/main libpurple0 1:2.4.1-1ubuntu2.7 [1332kB]
Get:27 http://us.archive.ubuntu.com hardy-updates/main libvorbis0a 1.2.0.dfsg-2ubuntu0.3 [99.4kB]
Get:28 http://us.archive.ubuntu.com hardy-updates/main libvorbisenc2 1.2.0.dfsg-2ubuntu0.3 [76.7kB]
Get:29 http://us.archive.ubuntu.com hardy-updates/main libvorbisfile3 1.2.0.dfsg-2ubuntu0.3 [20.4kB]
Get:30 http://us.archive.ubuntu.com hardy-updates/main pidgin 1:2.4.1-1ubuntu2.7 [517kB]
Fetched 33.5MB in 2min2s (273kB/s)
Preconfiguring packages ...
(Reading database ... 121577 files and directories currently installed.)
Preparing to replace mysql-common 5.0.51a-3ubuntu5.4 (using .../mysql-common_5.1.41-1.dotdeb.1_all.deb) ...
Unpacking replacement mysql-common ...
Preparing to replace mysql-client 5.0.51a-3ubuntu5.4 (using .../mysql-client_5.1.41-1.dotdeb.1_all.deb) ...
Unpacking replacement mysql-client ...
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.41-1.dotdeb.1_i386.deb) ...
Preparing to replace mysql-server 5.0.51a-3ubuntu5.4 (using .../mysql-server_5.1.41-1.dotdeb.1_all.deb) ...
Unpacking replacement mysql-server ...
(Reading database ... 121585 files and directories currently installed.)
Removing mysql-server-5.0 ...
* Stopping MySQL database server mysqld [ OK ]
dpkg: mysql-client-5.0: dependency problems, but removing anyway as you request:
bacula-director-mysql depends on mysql-client; however:
Package mysql-client is not configured yet.
Package mysql-client-5.0 which provides mysql-client is to be removed.
Removing mysql-client-5.0 ...
Selecting previously deselected package mysql-client-5.1.
(Reading database ... 119606 files and directories currently installed.)
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.41-1.dotdeb.1_i386.deb) ...
Setting up mysql-common (5.1.41-1.dotdeb.1) ...

Configuration file `/etc/mysql/my.cnf'
==> Modified (by you or by a script) since installation.
==> Package distributor has shipped an updated version.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** my.cnf (Y/I/N/O/D/Z) [default=N] ? n
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 119660 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.41-1.dotdeb.1_i386.deb) ...
chgrp: cannot dereference `/var/lib/mysql/mysql.sock': No such file or directory
Preparing to replace tzdata 2009o+repack-0ubuntu0.8.04.2 (using .../tzdata_2009r~repack-0ubuntu0.8.04_all.deb) ...
Unpacking replacement tzdata ...
Setting up tzdata (2009r~repack-0ubuntu0.8.04) ...

Current default timezone: 'America/Chicago'
Local time is now: Thu Nov 26 08:16:51 CST 2009.
Universal Time is now: Thu Nov 26 14:16:51 UTC 2009.
Run 'dpkg-reconfigure tzdata' if you wish to change it.


(Reading database ... 119825 files and directories currently installed.)
Preparing to replace apache2-utils 2.2.8-1ubuntu0.11 (using .../apache2-utils_2.2.8-1ubuntu0.14_i386.deb) ...
Unpacking replacement apache2-utils ...
Preparing to replace apache2-mpm-prefork 2.2.8-1ubuntu0.11 (using .../apache2-mpm-prefork_2.2.8-1ubuntu0.14_i386.deb) ...
* Stopping web server apache2 [ OK ]
Unpacking replacement apache2-mpm-prefork ...
Preparing to replace apache2.2-common 2.2.8-1ubuntu0.11 (using .../apache2.2-common_2.2.8-1ubuntu0.14_i386.deb) ...
Unpacking replacement apache2.2-common ...
Preparing to replace apache2 2.2.8-1ubuntu0.11 (using .../apache2_2.2.8-1ubuntu0.14_all.deb) ...
Unpacking replacement apache2 ...
Preparing to replace apache2-doc 2.2.8-1ubuntu0.11 (using .../apache2-doc_2.2.8-1ubuntu0.14_all.deb) ...
Unpacking replacement apache2-doc ...
Preparing to replace cupsys-common 1.3.7-1ubuntu3.5 (using .../cupsys-common_1.3.7-1ubuntu3.6_all.deb) ...
Unpacking replacement cupsys-common ...
Preparing to replace libcupsys2 1.3.7-1ubuntu3.5 (using .../libcupsys2_1.3.7-1ubuntu3.6_i386.deb) ...
Unpacking replacement libcupsys2 ...
Preparing to replace libcupsimage2 1.3.7-1ubuntu3.5 (using .../libcupsimage2_1.3.7-1ubuntu3.6_i386.deb) ...
Unpacking replacement libcupsimage2 ...
Preparing to replace cupsys 1.3.7-1ubuntu3.5 (using .../cupsys_1.3.7-1ubuntu3.6_i386.deb) ...
Ignoring nonregistered document `cupsys'
* Stopping Common Unix Printing System: cupsd [ OK ]
Unpacking replacement cupsys ...
Preparing to replace cupsys-bsd 1.3.7-1ubuntu3.5 (using .../cupsys-bsd_1.3.7-1ubuntu3.6_i386.deb) ...
Unpacking replacement cupsys-bsd ...
Preparing to replace cupsys-client 1.3.7-1ubuntu3.5 (using .../cupsys-client_1.3.7-1ubuntu3.6_i386.deb) ...
Unpacking replacement cupsys-client ...
Preparing to replace pidgin-data 1:2.4.1-1ubuntu2.6 (using .../pidgin-data_1%3a2.4.1-1ubuntu2.7_all.deb) ...
Unpacking replacement pidgin-data ...
Preparing to replace libpurple0 1:2.4.1-1ubuntu2.6 (using .../libpurple0_1%3a2.4.1-1ubuntu2.7_i386.deb) ...
Unpacking replacement libpurple0 ...
Preparing to replace libvorbis0a 1.2.0.dfsg-2ubuntu0.2 (using .../libvorbis0a_1.2.0.dfsg-2ubuntu0.3_i386.deb) ...
Unpacking replacement libvorbis0a ...
Preparing to replace libvorbisenc2 1.2.0.dfsg-2ubuntu0.2 (using .../libvorbisenc2_1.2.0.dfsg-2ubuntu0.3_i386.deb) ...
Unpacking replacement libvorbisenc2 ...
Preparing to replace libvorbisfile3 1.2.0.dfsg-2ubuntu0.2 (using .../libvorbisfile3_1.2.0.dfsg-2ubuntu0.3_i386.deb) ...
Unpacking replacement libvorbisfile3 ...
Preparing to replace php-pear 5.2.4-2ubuntu5.7 (using .../php-pear_5.2.11-0.dotdeb.1_all.deb) ...
Unpacking replacement php-pear ...
Preparing to replace php5 5.2.4-2ubuntu5.7 (using .../php5_5.2.11-0.dotdeb.1_all.deb) ...
Unpacking replacement php5 ...
Preparing to replace php5-dev 5.2.4-2ubuntu5.7 (using .../php5-dev_5.2.11-0.dotdeb.1_i386.deb) ...
Unpacking replacement php5-dev ...
Preparing to replace php5-imagick 2.0.1-1ubuntu0.1 (using .../php5-imagick_5.2.11-0.dotdeb.1_i386.deb) ...
Unpacking replacement php5-imagick ...
Preparing to replace php5-mcrypt 5.2.3-0ubuntu1 (using .../php5-mcrypt_5.2.11-0.dotdeb.1_i386.deb) ...
Unpacking replacement php5-mcrypt ...
Preparing to replace php5-memcache 2.2.0-1 (using .../php5-memcache_5.2.11-0.dotdeb.1_i386.deb) ...
Unpacking replacement php5-memcache ...
Preparing to replace pidgin 1:2.4.1-1ubuntu2.6 (using .../pidgin_1%3a2.4.1-1ubuntu2.7_i386.deb) ...
Unpacking replacement pidgin ...
Setting up libmysqlclient16 (5.1.41-1.dotdeb.1) ...

Setting up mysql-client-5.1 (5.1.41-1.dotdeb.1) ...
Setting up mysql-client (5.1.41-1.dotdeb.1) ...
Setting up mysql-server-5.1 (5.1.41-1.dotdeb.1) ...
Installing new version of config file /etc/init.d/mysql ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up apache2-utils (2.2.8-1ubuntu0.14) ...
Setting up apache2.2-common (2.2.8-1ubuntu0.14) ...

Setting up apache2-mpm-prefork (2.2.8-1ubuntu0.14) ...
* Starting web server apache2 [ OK ]

Setting up apache2 (2.2.8-1ubuntu0.14) ...
Setting up apache2-doc (2.2.8-1ubuntu0.14) ...
* Reloading web server config apache2
Setting up cupsys-common (1.3.7-1ubuntu3.6) ...
Setting up libcupsys2 (1.3.7-1ubuntu3.6) ...

Setting up libcupsimage2 (1.3.7-1ubuntu3.6) ...

Setting up cupsys (1.3.7-1ubuntu3.6) ...
* Starting Common Unix Printing System: cupsd [ OK ]

Setting up cupsys-client (1.3.7-1ubuntu3.6) ...

Setting up cupsys-bsd (1.3.7-1ubuntu3.6) ...

Setting up pidgin-data (1:2.4.1-1ubuntu2.7) ...

Setting up libpurple0 (1:2.4.1-1ubuntu2.7) ...

Setting up libvorbis0a (1.2.0.dfsg-2ubuntu0.3) ...

Setting up libvorbisenc2 (1.2.0.dfsg-2ubuntu0.3) ...

Setting up libvorbisfile3 (1.2.0.dfsg-2ubuntu0.3) ...

Setting up php-pear (5.2.11-0.dotdeb.1) ...
Installing new version of config file /etc/pear/pear.conf ...
Setting up php5 (5.2.11-0.dotdeb.1) ...
Setting up php5-dev (5.2.11-0.dotdeb.1) ...

Setting up php5-imagick (5.2.11-0.dotdeb.1) ...

Configuration file `/etc/php5/conf.d/imagick.ini'
==> File on system created by you or by a script.
==> File also in package provided by package maintainer.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** imagick.ini (Y/I/N/O/D/Z) [default=N] ?

Setting up php5-mcrypt (5.2.11-0.dotdeb.1) ...

Setting up php5-memcache (5.2.11-0.dotdeb.1) ...

Configuration file `/etc/php5/conf.d/memcache.ini'
==> File on system created by you or by a script.
==> File also in package provided by package maintainer.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** memcache.ini (Y/I/N/O/D/Z) [default=N] ?

Setting up pidgin (1:2.4.1-1ubuntu2.7) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@linux:/home/administrator#

snowpine
November 26th, 2009, 03:36 PM
WARNING: The following packages cannot be authenticated!
mysql-common mysql-client libmysqlclient16 mysql-server mysql-client-5.1
mysql-server-5.1 php-pear php5 php5-dev php5-imagick php5-mcrypt
php5-memcache
Install these packages without verification [y/N]? y


This was your warning to stop and think about what you were about to do.

5.0 is the correct and supported version for Hardy. You seem to have added an unsigned outside repository to get 5.1 (dotdeb.org). That is fine if you trust the source and know what you're doing, but you do so at your own risk. In this case however, I think it might be best to disable that repository and roll back to the official Ubuntu version, at least until you've figure out the problem. Good luck!

breauxlg
November 26th, 2009, 03:46 PM
Thanks for the reply. I found a skip entry in the mysql.cnf that I commented out and was able to get the updgrade done. I was shaking in my boots there for a while. I have tried to keep this server as clean as possible. I'm running ispconfig, and I seem to remember them wanting an additional repository for some reason. Is this a bad thing? I am having problems with a drupal site displaying images, and the drupal people are saying it's a problem with my apache config. I have a joomla site that displays images just fine, but as a linux rookie, I'm kind of at the mercy of what anybody with more experience (meaning everybody) tells me to do. I'm just amazed that the whole thing works. I come from an AS400 and Windows background and have developed a passionate hatred for Microsoft (but I can't afford to divorce them just yet.) Things that seem easy in MS come hard for me in Ubuntu, but there are so many easy things in Ubuntu that are hard, even for an experienced MS person, that I'm really enjoying this. I know this is off subject of this original cry for help, but can you point me in a direction for troubelshooting my install (logs, etc.) to try to see if it truly is my apache that's causing my image serving problem? The website that's not working is www.praisebandexchange.com. If it's outside your expertise, thanks anyway for this reply.
Lynn