Re: [webmin-l] mysql module

[Jamie C. <jca...@we...>]

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..

 - Jamie