And now it keeps returning a problem with mysql

Help! (Home for newbies)
1

even though I can log into mysql through ssh and it appears to be functioning.

When I check the configuration I get the following response:

Checking Configuration

<…snip…>

  MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin's MySQL Database module. If your system does not use MySQL, it should be disabled in Virtualmin's module configuration page.

… your system is not ready for use by Virtualmin.

I’ve attempted to configure Webmin’s module, from fixing some file locations in the module config to entering my root password. I know it’s my root password: I can log into what appears to be a completely functional mysql server via ssh. I even changed my password and double checked. No luck.

What I get when I enter this 100% grade A mysql root password is:

Login failed : Incorrect administration username or password.

When I look at the mysql logs in /var/log, I find they are empty.

So I went about trying to see if there was anything about mysql that needed fixing. The installation seemed a bit, umm, funky, so I figured I’d reinstall.

apt-get --reinstall said it could not log in. I initially found I – really-- could not stop mysqld using /etc/init.d/mysql stop. I used mysql_zap to kill it off, and I know it’s gone.

However no amount of apt-get or dpkg will reinstall the packages (which I suspect were only partially installed, and that the files laying around are from two different versions of mysql). They return an error stating that mysql is still running and they can’t stop it (it’s not… it’s really not… it is running only in the twisted mind of the debian package system).

I am beginning to get that up-a-creek-without-a-paddle sensation (i.e. that the virtualmin install over the d*** system I found on this server has become an ugly mess and that I’m not going to be able to dig out of it by my deadline).

If anyone has a clue where to proceed from here, I’m in desperate need for clues (and a functioning mysql server that can serve up a prominent blog starting in a couple of days)

2

I’ve acquired an (obvious unless you’ve been staring at a screen too long) clue: stop mysql from starting on boot, then reboot, then purge mysql from the system, then reinstall.

3

Hey Laura,

If things continue to give you grief, drop me an email. I’ll be happy to drop in and kick it into shape.

4

Joe, if you have the time, I’m stuck trying to get php working after needing to depleskify it. Check your e-mail. Thanks.

5

oops - posted twice…<br><br>Post edited by: merlynx, at: 2007/11/17 10:37

6

Is there another way? I really don’t want to have to reinstall the database as there are over a dozen active sites using the database server. I’ve got this same issue “Login failed : Incorrect administration username or password” when I try to connect the mysql database server to webmin. I’ve done the “SET PASSWORD” thing and I can even remotely access the database with my database management tools…and access as root from ssh…with the same password, of course.

I’m stuck and concerned a reinstall may mess up the 20+ databases we have on our server…

Ideas?

Thanks,
-Jeremy

7

Hey Jeremy,

I don’t see me suggesting a re-install of MySQL anywhere! That’s just not the kind of advice I’d give. In fact, “re-install” is not even in my vocabulary…it’s some sort of foreign word to me, completely incomprehensible. :wink:

Of course…I’m not sure what the solution to your problem is, off-hand. This is not a problem I’ve seen personally. If you’re absolutely certain you have given the Webmin MySQL module the correct root password for MySQL, then it’s a bug in Webmin, and we’ll need to get it fixed. It seems like we’d be hearing a lot of screaming about such a problem (the MySQL module is one of the most popular in Webmin–it has hundreds of thousands of users)…but maybe there’s something special about the Debian MySQL that we need to deal with.

8

Well - here is what I did…

Reset the root password to one I know. Then made for sure that it works from the ssh console and then made sure it works from my mysql program sqlYog.

Stopped / started webmin and killall mysqld.

Tried again. Same results.

Rinse…wash…repeat.

Suse 10.2, AMD 64, mysql 5.0.26
Webmin 1.38 / Virtualmin 3.482 pro.

Don’t know what else to do. Enter it as a bug?
tail -f /var/log/miniser.error shows:
Error: Incorrect administration username or password

9

Yep, now is the time for all good men to come to the aid of their administration tools…if it looks like a bug, and quakes like a bug, you should file a bug. :wink:

It’s probably something specific to this particular environment, so be sure to mention the versions you’ve given here in your bug report.