Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 31st August 2006, 14:57
kanour kanour is offline
Member
 
Join Date: Jun 2006
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default Password is not accepted from phpmyadmin.

Hi all I have debian system where I updated mysql from 4.0 to 4.1. The problem is password hash which has changed as well.
Is there any solution how to use long hash and phpmysqladmin or do I have to use short hash.

I tried to use "old-passwords" option under "[mysql]" in /etc/mysql/my.cnf. When I restart mysql service and type "mysql -u root -p" I recieved:
mysql: unknown option '--old-passwords'

Can someone help
Reply With Quote
Sponsored Links
  #2  
Old 1st September 2006, 05:25
kanour kanour is offline
Member
 
Join Date: Jun 2006
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there any way how to change in the ISPConfig code to create password for databases with OLD_PASSWORD option.
Reference:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

http://www.mysql.org/doc/refman/5.0/en/old-client.html
Reply With Quote
  #3  
Old 1st September 2006, 17:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

What's in /etc/mysql/my.cnf?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 1st September 2006, 18:11
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,044
Thanks: 269
Thanked 154 Times in 133 Posts
Default

It would be a nice option to have this as an extra!

This week I needed to convert 7 MySQL DB's to work with the OLD_PASSWORD option :/

Code:
mysql -u root -p
Enter password: ....

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2380 to server version: 4.1.11-Debian_4sarge5-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

SET PASSWORD FOR
'web38_u1'@'localhost' = OLD_PASSWORD('this_sucks');
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
Reply With Quote
  #5  
Old 1st September 2006, 18:21
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Have you tried to set the old password option in my.cnf? I've used this on several installations successfully. There is no need to change the password encryption in ISPConfig when it is available as mysql config option.

If you want to change it in ISPConfig, edit the file:

/home/admispconfig/ispconfig/lib/classes/ispconfig_isp_datenbank.lib.php line 174 and 279.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 2nd September 2006, 00:51
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,044
Thanks: 269
Thanked 154 Times in 133 Posts
Default

thank you till,

I have now added this, and I think it should do the trick.

Code:
[MYSQLD]
old-passwords
Reply With Quote
  #7  
Old 4th October 2006, 21:50
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,263
Thanks: 216
Thanked 649 Times in 295 Posts
Default

@Edge

I think you have to add this under [MYSQLD], but not as you suggested:

#Default to using old password format for compatibility with old and
#shorter password hash.
#Reference: http://dev.mysql.com/doc/mysql/en/password_hashing.html
old_passwords=1
__________________
Hans

MrHostman | Managed Hosting

Last edited by Hans; 4th October 2006 at 23:09.
Reply With Quote
  #8  
Old 4th October 2006, 22:09
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,044
Thanks: 269
Thanked 154 Times in 133 Posts
Default

Hans,

I was getting error's with my option (after restarting the MySQL some days later), so I removed it again..

I'll give your option a try later this week.
Reply With Quote
  #9  
Old 4th October 2006, 22:18
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,263
Thanks: 216
Thanked 649 Times in 295 Posts
 
Default

Hi Edge,

I've testes both options as i have upgraded mysql form 4.0.24 to 4.1.11.
It works ok on my Debian server.

If you have questions, we share our experiences. (As always)
__________________
Hans

MrHostman | Managed Hosting
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phpmyadmin - password in clear text Qrup Installation/Configuration 6 21st June 2006 21:37
perfect setup suse 10 - phpmyadmin & mysql question reddog Server Operation 7 17th June 2006 13:59
phpmyadmin password hash montezuma Installation/Configuration 5 14th June 2006 14:57
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 23:40
/stats doesn't work (password not accepted) Hellbound General 6 15th September 2005 16:34


All times are GMT +2. The time now is 16:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.