Re: [webmin-l] mysql module

[Barry <we...@i1...>]

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&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
>
>
>  
>