Menu
▾
▴
Re: [webmin-l] mysql module
|
From: Faisal M. <fa...@gm...> - 2005-11-20 23:32:45
|
Hi. Jamie, there is something wrong with this module. I just deleted a server i.e. abc.com <http://abc.com>, (as i mentioned in my earlier mail) and now when i go to the user permissions of the MYSQL module logged in as the Master Admin, and i click on a server xyz.com <http://xyz.com> ... i see th= e username of abc.com <http://abc.com> in the username field ??!???!? how is that possible ? Thanks. Faisal. On 11/20/05, Faisal Mehmood <fa...@gm...> wrote: > > Hi Jamie. > > I get a > > mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: YES)' > > Faisal. > > On 21 Nov 2005 10:18:46 +1100, Jamie Cameron <jca...@we...> wrote: > > > > Ok .. how about if you run : > > > > mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status > > > > - Jamie > > > > On Mon, 2005-11-21 at 10:14, Craig White wrote: > > > On Mon, 2005-11-21 at 10:06 +1100, Jamie Cameron wrote: > > > > Hi Craig, > > > > > > > > What happens if you run the following at the command line : > > > > > > > > mysqladmin -u root -pROOT_MYSQL_PASSWORD status > > > ---- > > > Uptime: 547079 Threads: 1 Questions: 9959 Slow queries: 0 Opens: 40 > > > Flush tables: 3 Open tables: 15 Queries per second avg: 0.018 > > > ---- > > > > > > > > That is the command Webmin users to attempt a login. > > > > BTW, which MySQL version are you using there? > > > ---- > > > ]# rpm -q mysql-server > > > mysql-server-4.1.12-3.RHEL4.1 > > > > > > Craig > > > ---- > > > > > > > > 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 name= s > > > > > 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 reall= y > > 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 n= o > > 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 tha= t > > 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, the= y > > changed the format > > > > > > > > > uses for encrypted passwords, which means that old client= s > > 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 Webmi= n > > 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=3Dcli= ck > > > > > > > > - > > > > > > > > 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=3Dcli= ck > > > > > > > > - > > > > > > > > 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 Toda= y > > > > 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... > -- ~Dont tell me its hard to contact me~ Faisal Mehmood. fa...@gm... fa...@st... fa...@fa... |
