Re: [webmin-l] mysql module

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

'Use DBI to connect if available' set to 'no' doesn't change anything

nor does explicity setting port or socket as opposed to default

Craig

On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> 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 ---
> 
> 
> 
> 
> -------------------------------------------------------
> 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
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 


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