Menu
▾
▴
Re: [webmin-l] mysql module
|
From: Faisal M. <fa...@gm...> - 2005-11-20 23:06:52
|
Hi. Ok Jamie. Here is the message generated. The full MySQL error message was : connect to server at 'localhost' failed error: 'Access denied for user 'interlinkage'@'localhost' (using password: YES)' Another Problem i noticed in this NEW module is: When i click on a user Under the USer Permissions of the MYSQL module, (logged in as Master Admin) The window that opens up, changes the username to another user on the system. It shows up fine when the page loads for a second then it automatically changes. For example: I have two servers on the virtualmin. xyz.com <http://xyz.com> (user: xyz) and abc.com <http://abc.com> (user: abc) I added xyz.com <http://xyz.com> before abc.com <http://abc.com> So when i click on xyz username, the window opens for the user permissions to change the password and all, for a second it shows xyz under the usernam= e field, and this automatically changes to abc I thought this was kind of a wierd behaviour, this is a new behaviour in th= e current module. I am using Firefox as my browser. Thanks. Faisal. On 21 Nov 2005 09:22:52 +1100, Jamie Cameron <jca...@we...> 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 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 acces= s > 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 (clien= t > 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 serve= r > > > 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 fin= e > > > 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 > -- ~Dont tell me its hard to contact me~ Faisal Mehmood. fa...@gm... fa...@st... fa...@fa... |
