RE: [webmin-l] mysql module

[Frank H. <fr...@we...>]

Hi all,

Not sure this is the problem Craig is having but here is something which
might help.
=20
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 .
=20
The fix I use is to login to a shell and do the following :
=20
=20
mysql -uroot -p
=20
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
=20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
=20
mysql> SET PASSWORD FOR 'root'@'localhost' <mailto:'root'@'localhost'>
=3D OLD_PASSWORD('newpassword');
=20
That normally allows me to access the MySQL module on Webmin just fine
afterwards.
=20
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.
=20
=20
Hope this helps.
=20
=20
Cheers,

Frank

________________________________

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:=20

	=20
=09
	 =20

		-----Original Message-----
		From: web...@li...=20
		[mailto:web...@li...] On
Behalf=20
		Of Jamie Cameron
		Sent: Thursday, November 17, 2005 5:54 AM
		To: web...@li...
		Subject: Re: [webmin-l] mysql module
	=09
		On 17/Nov/2005 19:02 Barry wrote ..
		   =20

				--
				I was hoping to get Jamie or someone to
pipe in on this.
			=09
				I 'downgraded' to 1.240 and still had
the same problem so=20
				       =20

		I went back
		   =20

			to
			     =20

				1.246 for the benefit of the stuff in
LDAP Users and Groups.
			=09
				I did manage to get it to work...as long
as there is no=20
				       =20

		password for=20
		   =20

				root...I'm functional. Perhaps I will
try to back it all up, use=20
				webmin to insert the password for root
and then see if webmin can=20
				access it but I can't think of a reason
why I can't set=20
				       =20

		the password=20
		   =20

				with mysqldadmin and then login via
webmin...I used to=20
				       =20

		always do it=20
		   =20

				that way (mysql-3.x)
			=09
				Craig
			=09
			=09
				=20
			=09
				       =20

			Craig -
		=09
			This last bit lit a light bulb for me. There is
something=20
			     =20

		to do with=20
		   =20

			long and short passwords in mysql v4.0. The
default mysql setting=20
			broke whatever webmin was doing for a while, but
then it=20
			     =20

		was fixed by=20
		   =20

			Jamie (not sure when). Is it possible you have
some=20
			     =20

		settings out of whack there?
		   =20

			the mysql docs on their web site describe the
issue fairly well...=20
			this drove me nuts for a while too...
			     =20

		That could be another cause actually.. for MySQL 4.0,
they=20
		changed the format uses for encrypted passwords, which
means=20
		that old clients can no longer connect.
		To resolve this, you need to upgrade all your mysql
packages=20
		(client and server), and possibly the DBD::mysql Perl
module as well..
	=09
		   =20

=09
	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.
=09
	What do I need to do?  :-(
=09
	TIA
=09
=09
=09
=09
	-------------------------------------------------------
	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
=09
=09
	 =20