Re: [webmin-l] mysql module

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

Hi Craig,
Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  

By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).

 - Jamie

-----Original Message-----

From:  Craig White <cra...@az...>
Subj:  Re: [webmin-l] mysql module
Date:  Sun 20 Nov 2005 2:23 pm
Size:  2K
To:  web...@li...

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.



-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
Register for a JBoss Training Course.  Free Certification Exam
for All Training Attendees Through End of 2005. For more info visit:
http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list

--- message truncated ---