Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> On 17/Nov/2005 19:02 Barry wrote ..
> > 
> > >--
> > >I was hoping to get Jamie or someone to pipe in on this.
> > >
> > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > to
> > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > >
> > >I did manage to get it to work...as long as there is no password for
> > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > >to insert the password for root and then see if webmin can access it but
> > >I can't think of a reason why I can't set the password with mysqldadmin
> > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > >
> > >Craig
> > >
> > >
> > >  
> > >
> > Craig -
> > 
> > This last bit lit a light bulb for me. There is something to do with
> > long and short passwords in mysql v4.0. The default mysql setting broke
> > whatever webmin was doing for a while, but then it was fixed by Jamie
> > (not sure when). Is it possible you have some settings out of whack there?
> > 
> > the mysql docs on their web site describe the issue fairly well... this
> > drove me nuts for a while too...
> 
> That could be another cause actually.. for MySQL 4.0, they changed the format
> uses for encrypted passwords, which means that old clients can no longer connect.
> To resolve this, you need to upgrade all your mysql packages (client and server), and
> possibly the DBD::mysql Perl module as well..
----
my rpm module is # rpm -qa|grep DBD
perl-DBD-MySQL-2.9004-3.1

cpan.org shows 3.0002

do you think I need to get that one?

# rpm -q --whatprovides /usr/bin/mysql
mysql-4.1.12-3.RHEL4.1

The client is as up to date as RHEL 4 gets

I understood that they changed and that's why in the config - you offer
password hashing mode choice of old/default

I have a similar setup and the same problem now here at my home server
so this is definitely the place to work this issue through.

The last thing I tried was Frank's recommendation...

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
('newpassword');
 
That normally allows me to access the MySQL module on Webmin just fine
afterwards.

I'm still locked out unless I remove root's password altogether - not
that big of an issue at home...probably something I don't really don't
want to do at clients

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.