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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 16th September 2009, 11:36
garidan garidan is offline
Junior Member
 
Join Date: Sep 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

All small caps, no special char. I tried chrome as well as firefox 3.5. International settings: italian.
It doesn't work for a new admin account as well. Something to do with php ? Do you use the md5 function of mysql to encode passwords ?
Reply With Quote
Sponsored Links
  #12  
Old 16th September 2009, 11:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

The passwords in ispconfig are encrypted with "crypt". MD5 is only a fallback solution. I will have to check the code, maybe I find something that can get wrong there. Please post it to the bugtracker so we can review it again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #13  
Old 6th November 2009, 03:12
kronprom kronprom is offline
Junior Member
 
Join Date: Nov 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i have same problem when i changed admin password in User Settings.
Mysql DB sys_user passwordt was not encrypted with MD5.
i have to manually change to MD5 in Mysql with

UPDATE dbispconfig.sys_user SET passwort = MD5('yourpassword') WHERE sys_user.username='admin';
Reply With Quote
  #14  
Old 6th November 2009, 11:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

Quote:
Mysql DB sys_user passwordt was not encrypted with MD5.
Thats correct as ISPConfig uses crypt and not md5 for passwords. md5 is just a fallback solution to allow you to reset a password manually if nescessary.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 29th September 2010, 21:35
Festinalente Festinalente is offline
Junior Member
 
Join Date: Sep 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default locked out and can't get in

Can anyone please help.

I've stalled ISPconfig 3 latest version and it worked fine for about 4/5 days.
Then just one day I tried to log in again and then the password didn't work anymore. Same for Mysql. It might have something to do that I've installed tomcat and moved ISP config to port 8090.

Anyway, I've resetted the root password of Mysql and tried to reset the ISP password via mysql with
UPDATE sys_user SET passwort = md5('admin') WHERE username = 'admin';

But this doesn't work for me. When I try to log in I still get the message
"error 1. Error username of password worng.1"

Anybody any idee how I can get back in?

Thxs,
Tony
Reply With Quote
  #16  
Old 29th September 2010, 22:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

Most likely the password that ispconfig uses to login to mysql is wrong. Please check if you are able to login to mysql with the username and password that you find in the file /usr/local/ispconfig/interface/lib/config.inc.php. If the login does not work, change the password in mysql so that it matches the password in that file (dont change it in the file as the password is used in several other files as well, so changing in mysql is easier).
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Festinalente (1st October 2010)
  #17  
Old 1st October 2010, 09:06
Festinalente Festinalente is offline
Junior Member
 
Join Date: Sep 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default Can loggin again

Thxs, Indeed the mysql user was locked out. After resetting the password in mysql I could enter again ISP. I guess the lock out was caused because I restored an mysql dump of all tables from an other database.
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
ISPConfig 3. Email password change and autoresponders aperion General 6 8th May 2009 18:04
Change Password Page Polk Feature Requests 1 23rd March 2009 15:56
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 14:31
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47
Ubuntu 6.06 LTS during ISPConfig MySQL root password error...stuck?? Randall Hoffman General 5 13th March 2007 15:01


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


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