FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Ubuntu > Ubuntu User

 
 
LinkBack Thread Tools
 
Old 01-10-2009, 06:41 PM
stan
 
Default How to purge completly a broken MySQL

For reasons that gave to do with me making stupid decisions, I have a
completely broken MySQL 5 server install on one of my Intrepid machines.
Eben apt-get remove fails.

I think the best way to address this is probably just to completely remove
all traces of this package, and re-install it.

How can I force a complete purge of this package?

--
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 06:46 PM
Hal Burgiss
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
>
> How can I force a complete purge of this package?

apt-get purge ....

AFAIK, that will remove all remnants of the original installation.

--
Hal


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 07:40 PM
stan
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 02:46:53PM -0500, Hal Burgiss wrote:
> On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
> >
> > How can I force a complete purge of this package?
>
> apt-get purge ....
>
> AFAIK, that will remove all remnants of the original installation.
>

root@boo-boo:/etc/mysql# apt-get purge mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server-5.0 is not installed, so not removed

Yet,

root@boo-boo:/etc/mysql# apt-get install mysql-server-5.0

Fails with.
Processing triggers for man-db ...
Setting up mysql-server-5.0 (5.0.67-0ubuntu6) ...
* Stopping MySQL database server mysqld [
OK ]
/var/lib/dpkg/info/mysql-server-5.0.postinst: line 143:
/etc/mysql/conf.d/old_passwords.cnf: No such file or directory
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)

So, that did not, somehow get me back to where no traces of the original
install exits.

--
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 08:07 PM
steve
 
Default How to purge completly a broken MySQL

Hal Burgiss wrote:
> On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
>> How can I force a complete purge of this package?
>
> apt-get purge ....
>
> AFAIK, that will remove all remnants of the original installation.
>

sudo apt-get remove --purge packagename





--
Steve Reilly

http://reillyblog.com





--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 10:40 PM
stan
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 04:07:25PM -0500, steve wrote:
> Hal Burgiss wrote:
> > On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
> >> How can I force a complete purge of this package?
> >
> > apt-get purge ....
> >
> > AFAIK, that will remove all remnants of the original installation.
> >
>
> sudo apt-get remove --purge packagename
>
That results in:

Package mysql-server-5.0 is not installed, so not removed
--
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 10:49 PM
steve
 
Default How to purge completly a broken MySQL

stan wrote:
> On Sat, Jan 10, 2009 at 04:07:25PM -0500, steve wrote:
>> Hal Burgiss wrote:
>>> On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
>>>> How can I force a complete purge of this package?
>>> apt-get purge ....
>>>
>>> AFAIK, that will remove all remnants of the original installation.
>>>
>> sudo apt-get remove --purge packagename
>>
> That results in:
>
> Package mysql-server-5.0 is not installed, so not removed


thats what you wanted, so now re install mysql



--
Steve Reilly

http://reillyblog.com





--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 10:52 PM
Hal Burgiss
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 06:40:05PM -0500, stan wrote:
> That results in:
>
> Package mysql-server-5.0 is not installed, so not removed

Stan, have you looked at the apt-get man page? Not being flip, but I
don't have a way to test your predicament to see what the best combo
of apt-get options are. I have not had this particular pleasure with
Debian based systems ;-)

There are various options there for forcing, re-installing, etc.
Somewhere in there is the answer. I would try a re-install then
uninstall (with purge), and then a clean install. On rpm based
systems, I have had the same situation, and IIRC, you do do a forced
re-install, then uninstall/purge, and then a clean install. Thats the
basis of my suggestion. r

--
Hal


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 11:06 PM
NoOp
 
Default How to purge completly a broken MySQL

On 01/10/2009 03:40 PM, stan wrote:
> On Sat, Jan 10, 2009 at 04:07:25PM -0500, steve wrote:
>> Hal Burgiss wrote:
>> > On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
>> >> How can I force a complete purge of this package?
>> >
>> > apt-get purge ....
>> >
>> > AFAIK, that will remove all remnants of the original installation.
>> >
>>
>> sudo apt-get remove --purge packagename
>>
> That results in:
>
> Package mysql-server-5.0 is not installed, so not removed

Reinstall it and then purge it. Here is what it installs (note the '-s'
which means that I've "simulated" the install" so nothing actually got
installed on my system):

$ sudo apt-get install -s mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
mysql-client-5.0
Suggested packages:
dbishell mysql-doc-5.0 tinyca
Recommended packages:
libterm-readkey-perl apparmor libhtml-template-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
mysql-client-5.0 mysql-server-5.0
0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Inst libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
Inst libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
Inst libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
Inst libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
Inst mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
Inst mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
Conf libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
Conf libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
Conf libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
Conf libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
Conf mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
Conf mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)

So, reinstall:

sudo apt-get install --reinstall mysql-server-5.0

and then purge it:

sudo apt-get remove --purge mysql-server-5.0

and you should be ok.



--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-10-2009, 11:49 PM
stan
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 04:06:42PM -0800, NoOp wrote:
> On 01/10/2009 03:40 PM, stan wrote:
> > On Sat, Jan 10, 2009 at 04:07:25PM -0500, steve wrote:
> >> Hal Burgiss wrote:
> >> > On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
> >> >> How can I force a complete purge of this package?
> >> >
> >> > apt-get purge ....
> >> >
> >> > AFAIK, that will remove all remnants of the original installation.
> >> >
> >>
> >> sudo apt-get remove --purge packagename
> >>
> > That results in:
> >
> > Package mysql-server-5.0 is not installed, so not removed
>
> Reinstall it and then purge it. Here is what it installs (note the '-s'
> which means that I've "simulated" the install" so nothing actually got
> installed on my system):
>
> $ sudo apt-get install -s mysql-server-5.0
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following extra packages will be installed:
> libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
> mysql-client-5.0
> Suggested packages:
> dbishell mysql-doc-5.0 tinyca
> Recommended packages:
> libterm-readkey-perl apparmor libhtml-template-perl
> The following NEW packages will be installed:
> libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
> mysql-client-5.0 mysql-server-5.0
> 0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
> Inst libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
> Inst libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
> Inst libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
> Inst libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
> Inst mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Inst mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Conf libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
> Conf libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
> Conf libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
> Conf libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
> Conf mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Conf mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
>
> So, reinstall:
>
> sudo apt-get install --reinstall mysql-server-5.0
>
> and then purge it:
>
> sudo apt-get remove --purge mysql-server-5.0
>
> and you should be ok.

I seem to have created quite the extrodinary mess here :-(

I went through those steps, but the install after that still fails
I don't beleive that I am getting all the remnants of this package removed.
What procedure would do that?

Here is teh failure, if it helps:

Setting up mysql-server-5.0 (5.0.67-0ubuntu6) ...
* Stopping MySQL database server mysqld [
OK ]
090110 19:46:13 [ERROR] /usr/sbin/mysqld: Can't find file:
'./mysql/user.frm' (errno: 13)
090110 19:46:13 [ERROR] /usr/sbin/mysqld: Can't find file:
'./mysql/user.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
090110 19:46:13 [ERROR] Aborting

090110 19:46:13 [Note] /usr/sbin/mysqld: Shutdown complete


Reloading AppArmor profiles : done.
* /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See
README.Debi
an.gz
* Starting MySQL database server mysqld
[fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)

--
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 01-11-2009, 01:13 AM
stan
 
Default How to purge completly a broken MySQL

On Sat, Jan 10, 2009 at 04:06:42PM -0800, NoOp wrote:
> On 01/10/2009 03:40 PM, stan wrote:
> > On Sat, Jan 10, 2009 at 04:07:25PM -0500, steve wrote:
> >> Hal Burgiss wrote:
> >> > On Sat, Jan 10, 2009 at 02:41:20PM -0500, stan wrote:
> >> >> How can I force a complete purge of this package?
> >> >
> >> > apt-get purge ....
> >> >
> >> > AFAIK, that will remove all remnants of the original installation.
> >> >
> >>
> >> sudo apt-get remove --purge packagename
> >>
> > That results in:
> >
> > Package mysql-server-5.0 is not installed, so not removed
>
> Reinstall it and then purge it. Here is what it installs (note the '-s'
> which means that I've "simulated" the install" so nothing actually got
> installed on my system):
>
> $ sudo apt-get install -s mysql-server-5.0
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following extra packages will be installed:
> libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
> mysql-client-5.0
> Suggested packages:
> dbishell mysql-doc-5.0 tinyca
> Recommended packages:
> libterm-readkey-perl apparmor libhtml-template-perl
> The following NEW packages will be installed:
> libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
> mysql-client-5.0 mysql-server-5.0
> 0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
> Inst libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
> Inst libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
> Inst libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
> Inst libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
> Inst mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Inst mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Conf libnet-daemon-perl (0.38-1.1 Ubuntu:8.04/hardy)
> Conf libplrpc-perl (0.2017-1.1 Ubuntu:8.04/hardy)
> Conf libdbi-perl (1.601-1 Ubuntu:8.04/hardy)
> Conf libdbd-mysql-perl (4.005-1 Ubuntu:8.04/hardy)
> Conf mysql-client-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
> Conf mysql-server-5.0 (5.0.51a-3ubuntu5.4 Ubuntu:8.04/hardy-updates)
>
> So, reinstall:
>
> sudo apt-get install --reinstall mysql-server-5.0
>
> and then purge it:
>
> sudo apt-get remove --purge mysql-server-5.0
>
> and you should be ok.

Well, people can quit worrying about this. Running

apt-get remove --purge apt-get remove --purge mysql-server-5.0
mysql-common mysql-client-5.0

Pretty much completly destoryed my system.
--
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 

Thread Tools




All times are GMT. The time now is 10:17 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org