RE: [webmin-l] mysql module

[Thomas E D. <ed...@al...>]

 

> -----Original Message-----
> From: web...@li... 
> [mailto:web...@li...] On Behalf 
> Of Jamie Cameron
> Sent: Thursday, November 17, 2005 5:54 AM
> To: web...@li...
> Subject: Re: [webmin-l] mysql module
> 
> 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..
> 

I did not pay attention to this thread.  I have now found myself unable to
login the mysql module as well.  I found this out when I recently upgrade
virtualmin (free) to 2.609.  Running webmin 1.246 on a CentOS 4.2 system
with all upgrades.

What do I need to do?  :-(

TIA