Menu
▾
▴
Re: [webmin-l] mysql module
|
From: Jamie C. <jca...@we...> - 2005-11-20 22:23:08
|
Hi Craig, Try installing the updated MySQL Webmin module from : http://www.webmin.com/updates/mysql-1.240-8.wbm.gz I have made a small change to display the error message from MySQL if you cannot connect or login, which should explain what is really going wrong .. - Jamie On Mon, 2005-11-21 at 03:04, Craig White wrote: > '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. > > > |
