On Monday 16 February 2009, Craig White wrote:
On Mon, 2009-02-16 at 15:51 -0500, Gene Heskett wrote:
> On Monday 16 February 2009, Anne Wilson wrote:
> >On Monday 16 February 2009 20:27:04 Gene Heskett wrote:
> >> No package webmin available.
> >> Nothing to do
> >
> >I don't think I've ever had webmin from a distro package, but it
installs
> > so easily from the website.
> >
> >Anne
>
> I found it, installed it, let it do its updates, but a scan for servers
> doesn't find mysql cuz it is not running and now won't run.
>
> I had NDI this was going to such a PIMA, but a friend has mythtv running
> at his place and it does everything but fix breakfast.
>
> If anyone has any idea how to reset this SOB to absolutely square one,
> never having been run, please advise. Deleting /var/lib/mysql didn't do
> it.
----
you don't delete /var/lib/mysql
you delete /var/lib/mysql/*
mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql
service mysqld start
I got to here ^^^ and selinux stuck up its hand & waved at me.
SELinux is preventing mysqld (mysqld_t) "create" to mysql.sock (var_lib_t).
And recommended I run restorecon -v 'mysql.sock', but:
[root@coyote rpms]# restorecon -v 'mysql.sock'
restorecon: stat error on mysql.sock: No such file or directory
So I go back to the top of the list above and repeat, apparently forever cuz I
get the same thing when I restart mysqld.
Now, since mysql.sock doesn't exist, because it can't create it, therefore
restorecon can't do anything about it, WTH do I do next?
So I located the old one in the database, touched a new one, then
'chown mysql:mysql mysql.sock;restorecon -v mysql.sock' No errors reported.
But, a 'service mysqld start' eventually fails. And now the selinux count is
plus 2 cuz I tried it twice.
So how do we fix YAMYSQLFSCKUP?
Thanks Craig
mysqladmin -u root password 'new-password'
^don't change ^change
done
Craig
--
Cheers, Gene
"There are four boxes to be used in defense of liberty:
soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
"In the face of entropy and nothingness, you kind of have to pretend it's not
there if you want to keep writing good code." -- Karl Lehenbauer