Menu
▾
▴
RE: [webmin-l] mysql module
|
From: Thomas E D. <ed...@al...> - 2005-11-19 00:17:39
|
_____
From: web...@li...
[mailto:web...@li...] On Behalf Of Frank
Hutcheon
Sent: Friday, November 18, 2005 6:27 AM
To: web...@li...
Subject: RE: [webmin-l] mysql module
Hi all,
Not sure this is the problem Craig is having but here is something which
might help.
I've had this problem in the past - mainly after I've updated MySQL from
3.23 on Centos 3 builds to version 4.x.x .
The fix I use is to login to a shell and do the following :
mysql -uroot -p
Enter password or not if you have one set.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 853886 to server version: 4.1.11-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SET PASSWORD FOR <mailto:'root'@'localhost'> 'root'@'localhost' =
OLD_PASSWORD('newpassword');
That normally allows me to access the MySQL module on Webmin just fine
afterwards.
Also - I thought the Webmin module fix for this was to change the password
hashing option in the MySQL module config. I never actually did that myself
but remember a posting about it from a while back.
Hope this helps.
Cheers,
Frank
Hello Frank,
I tried what you suggested but still can't login to the mysql module.
Thanks anyway!
_____
From: web...@li...
[mailto:web...@li...] On Behalf Of Barry
Sent: 18 November 2005 10:09
To: web...@li...
Subject: Re: [webmin-l] mysql module
I think all the advice that was given is below. I say review the Mysql
documentation - it will give you some guidance that aligns with Jamie's
suggestions.
Best,
Barry
Thomas E Dukes wrote:
-----Original Message-----
From: web...@li...
[mailto:web...@li...] On Behalf
Of Jamie Cameron
Sent: Thursday, November 17, 2005 5:54 AM
To: web...@li...
Subject: Re: [webmin-l] mysql module
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..
I did not pay attention to this thread. I have now found myself unable to
login the mysql module as well. I found this out when I recently upgrade
virtualmin (free) to 2.609. Running webmin 1.246 on a CentOS 4.2 system
with all upgrades.
What do I need to do? :-(
TIA
-------------------------------------------------------
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
<http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click>
&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
|
