Menu
▾
▴
Re: [webmin-l] mysql module
|
From: Faisal M. <fa...@gm...> - 2005-11-20 23:10:02
|
I am using MYSQL ver. 4.1.12 On 21 Nov 2005 10:06:28 +1100, Jamie Cameron <jca...@we...> wrote: > > Hi Craig, > > What happens if you run the following at the command line : > > mysqladmin -u root -pROOT_MYSQL_PASSWORD status > > That is the command Webmin users to attempt a login. > BTW, which MySQL version are you using there? > > - Jamie > > On Mon, 2005-11-21 at 09:59, Craig White wrote: > > Not sure this is going to be much hope > > > > Messages presented below login screen... > > with module config administrator string set to: "" > > with module config administrator string set to: "" > > The full MySQL error message was : connect to server at 'localhost' > > failed error: 'Access denied for user 'root'@'localhost' (using > > password: NO)' > > > > Messages presented below login screen... > > with module config administrator string set to: "root" > > with module config administrator string set to: "ROOT_MYSQL_PASSWORD" > > The full MySQL error message was : connect to server at 'localhost' > > failed error: 'Access denied for user 'root'@'localhost' (using > > password: YES)' > > and after attempt to login... > > the usual "Login failed : Incorrect administration username or password= " > > > > from command line (passing everything because I have > > renamed /root/.my.cnf for the duration of this problem) > > # mysql mysql -u root -p -h localhost > > Enter password: > > Reading table information for completion of table and column names > > You can turn off this feature to get a quicker startup with -A > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 297 to server version: 4.1.12 > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > Craig > > > > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote: > > > 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 goin= g > > > 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 h= ave > 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 <http://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' =3D 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=3D7628&alloc_id=3D16845&op=3Dclick > > > > > - > > > > > 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=3D7628&alloc_id=3D16845&op=3Dclick > > > > > - > > > > > 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 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=3D7628&alloc_id=3D16845&op=3Dclick > > > - > > > 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 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=3D7628&alloc_id=3D16845&op=3Dclick > - > 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 > -- ~Dont tell me its hard to contact me~ Faisal Mehmood. fa...@gm... fa...@st... fa...@fa... |
