Announcement

**jankushka** · Jul 25, 2007, 07:10 AM

Re: Problems installing MySQL 5.0 server

hi there...

Originally posted by alles_klar

What does that all mean?

most probably that there's some left-overs from the 4.1 installation.
since 4.1 and 5.0 appear to be 2 distinct set of packages.
i'm not sure, though, i haven't tried.

best thing (probably) is to remove everything that has to do with mysql servers.
i.e., both versions.
then install 5.0 again.
as might have come to appreciate un/install of software in linux is a piece of cake...

so...

pls, issue:

Code:

dpkg-query -l '*mysql*'

to check what's actually installed.

remove:

Code:

sudo apt-get remove <list of mysql server packages goes here> --purge

install:

Code:

sudo apt-get install <mysql server 5.0 package goes here>

of course you can do the same with adept/synaptic.

if you're unsure, ask again no problems.
hth

**alles_klar** · Jul 25, 2007, 10:59 AM

Re: Problems installing MySQL 5.0 server

Hello Jan,

Originally posted by jankushka

most probably that there's some left-overs from the 4.1 installation.
since 4.1 and 5.0 appear to be 2 distinct set of packages.
i'm not sure, though, i haven't tried.

Code:

dpkg-query -l '*mysql*'

To this query i got the following message:

Code:

No packages found matching *mysql*

Any other ideas?

**jankushka** · Jul 25, 2007, 12:09 PM

Re: Problems installing MySQL 5.0 server

Originally posted by alles_klar

Any other ideas?

well...actually...
i would have expected something to come out of the dpkg-query...
no output here means nothing is installed.

if you have rebooted since your previous post,
pls, try installing mysql server again

Code:

sudo apt-get install mysql-server --fix-broken

try with the --fix-broken.

'll try to reproduce your problem in the meanwhile...

EDIT:
try this, before the re-installation attempt and post the result (pls):

Code:

find /etc/rc?.d/ -name \*sql\* -print

**alles_klar** · Jul 25, 2007, 12:40 PM

Re: Problems installing MySQL 5.0 server

Ok, that's weird.

I rebooted my compu and reran the dpkg-query -l '*mysql*' command and now I got that:

Code:

esired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name           Version         Description
+++-========================-========================-================================================================
un kexi-mysql-driver    <none>          (no description available)
iU libdbd-mysql-perl    3.0008-1build1      A Perl5 database interface to the MySQL database
un libmysql-ruby1.8     <none>          (no description available)
un libmysqlclient15     <none>          (no description available)
iU libmysqlclient15off   5.0.38-0ubuntu1     mysql database client library
un libqt3-mt-mysql     <none>          (no description available)
un mysql-client       <none>          (no description available)
un mysql-client-4.1     <none>          (no description available)
iU mysql-client-5.0     5.0.38-0ubuntu1     mysql database client binaries
ii mysql-common       5.0.38-0ubuntu1     mysql database common files (e.g. /etc/mysql/my.cnf)
un mysql-common-4.1     <none>          (no description available)
ic mysql-server       4.1.11-1         MySQL: a very fast and reliable SQL database server
un mysql-server-4.1     <none>          (no description available)
in mysql-server-5.0     <none>          (no description available)
un virtual-mysql-client   <none>          (no description available)
un virtual-mysql-server   <none>          (no description available)

Now for good measure I'm trying the command: find /etc/rc?.d/ -name \*sql\* -print
and I got ... nothing in return - nil

So now I'm taking your advice from previous post and am attempting to remove all mysql packages i see by doing: sudo apt-get remove kexi-mysql-driver libdbd-mysql-perl libmysqlclient15 libmysqlclient15off libqt3-mt-mysql mysql-client mysql-client-4.1 mysql-client-5.0 mysql-common mysql-common-4.1 mysql-server mysql-server-4.1 mysql-server-5.0 --purge

I got this so it seems to have worked:

Code:

Password:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package kexi-mysql-driver is not installed, so not removed
Package libmysqlclient15 is not installed, so not removed
Package libqt3-mt-mysql is not installed, so not removed
Package mysql-client is not installed, so not removed
Note, selecting mysql-client-5.0 instead of mysql-client-4.1
Note, selecting mysql-common instead of mysql-common-4.1
Package mysql-server is not installed, so not removed
Package mysql-server-4.1 is not installed, so not removed
Package mysql-server-5.0 is not installed, so not removed
The following packages were automatically installed and are no longer required:
 libnet-daemon-perl libdbi-perl libplrpc-perl
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
 libdbd-mysql-perl* libmysqlclient15off* mysql-client-5.0* mysql-common*
0 upgraded, 0 newly installed, 4 to remove and 8 not upgraded.
3 not fully installed or removed.
Need to get 0B of archives.
After unpacking 21.9MB disk space will be freed.
Do you want to continue [Y/n]? y
(Reading database ... 96689 files and directories currently installed.)
Removing mysql-client-5.0 ...
Removing libdbd-mysql-perl ...
Removing libmysqlclient15off ...
Purging configuration files for libmysqlclient15off ...
Removing mysql-common ...
Purging configuration files for mysql-common ...

Now I'm feeling emboldened so I'm attempting to install the mysql-server-5.0 package by doing: 'sudo apt-get update' followed by' sudo apt-get install mysql-server-5.0 --fix-broken' using fix broken for good measure. and alas, i got the following message:

Code:

Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
 libdbd-mysql-perl libmysqlclient15off mysql-client-5.0 mysql-common
Suggested packages:
 tinyca
Recommended packages:
 mailx
The following NEW packages will be installed:
 libdbd-mysql-perl libmysqlclient15off mysql-client-5.0 mysql-common mysql-server-5.0
0 upgraded, 5 newly installed, 0 to remove and 8 not upgraded.
Need to get 0B/35.1MB of archives.
After unpacking 91.5MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 96591 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.0.38-0ubuntu1_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.38-0ubuntu1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_3.0008-1build1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.38-0ubuntu1_i386.deb) ...
Setting up mysql-common (5.0.38-0ubuntu1) ...
(Reading database ... 96690 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.38-0ubuntu1_i386.deb) ...
/etc/init.d/mysql: 66: source: not found
/etc/init.d/mysql: 166: my_print_defaults: not found
/etc/init.d/mysql: 249: log_failure_msg: not found
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 127
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.38-0ubuntu1_i386.deb (--unpack):
 subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.0.38-0ubuntu1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

And I still feel as helpless

**jankushka** · Jul 25, 2007, 02:10 PM

Re: Problems installing MySQL 5.0 server

managed to screw mine as well

installed. removed. installed again.
but now i don't have the startup/initialization script in /etc/init.d (no good!).
and the links in /etc/rc?.d for automatic startup and shutdown are also missing (no good!).
mysql cannot start.
so i:

Code:

sudo apt-get autoremove mysql-server --purge

(for you, though i lost track a bit, it will have to be mysql-server-5.0)

this asks if i also wanted to remove /var/lib/mysql.
said yes.
then i install the bloody thing again and...voilà...back up alright.

what about yours?

**alles_klar** · Jul 25, 2007, 11:19 PM

It's working

Kudos to jankushka :-)

I first followed your instructions and I got the same error message - 3 lines coming out of the init.d/mysql

Your e-mail gave me the idea of removing that file. Then I ran the install and opted to use the new init.d/mysql file that comes with the package, and it worked fine.

Thanks a lot Jan for helping me AND teaching me at the same time.

**jankushka** · Jul 26, 2007, 03:47 AM

Re: Problems installing MySQL 5.0 server

success, then!
well done.
take care.
8)

Announcement

Problems installing MySQL 5.0 server

Problems installing MySQL 5.0 server

Comment

Comment

Comment

Comment

Comment

Comment

Comment