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
  #41  
Old 22nd September 2009, 10:55
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

I get this:

Quote:
ERROR 1045 (28000): Access denied for user 'ispconfig'@'localhost' (using password: YES)
Reply With Quote
Sponsored Links
  #42  
Old 23rd September 2009, 07:27
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Any ideas to get user ispconfig back in?
Reply With Quote
  #43  
Old 23rd September 2009, 09:05
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

You can always add the user through phpmyadmin, don't forget to reload privileges after user is added.
Reply With Quote
  #44  
Old 23rd September 2009, 10:02
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

(I was using the skip grant option)
I added the user ispconfig via phpmyadmin, used the password found in /usr/local/ispconfig/interface/lib/config.inc.php

Flushed privileges. Restarted mysql. But now the password for ispconfig is changed? And my sites are extremely slow. Also for example site/phpmyadmin is not available or takes very long.
I changed back to the skip grant t option. I think I will reinstall my server from scratch.

Last edited by skoena; 23rd September 2009 at 10:26.
Reply With Quote
  #45  
Old 24th September 2009, 10:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,260 Times in 4,124 Posts
Default

Quote:
But now the password for ispconfig is changed?
Why shall it has been changed? The ispconfig password is in /usr/local/ispconfig/interface/lib/config.inc.php and the password is in cleartext. So if you add it in phpmyadmin, you have to choose "PASSWORD" to encrypt it.

Regarding the slow server, you should test if the login for the ispconfig user works now and if thats the case, then reboot your server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #46  
Old 24th September 2009, 10:37
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Quote:
Originally Posted by till View Post
Why shall it has been changed? The ispconfig password is in /usr/local/ispconfig/interface/lib/config.inc.php and the password is in cleartext. So if you add it in phpmyadmin, you have to choose "PASSWORD" to encrypt it.

Regarding the slow server, you should test if the login for the ispconfig user works now and if thats the case, then reboot your server.
Sorry Till I was unclear.

I added the user ispconfig via phpadmin and used the password like mentioned in the config.inc.php file.

After that when I want to login to ispconfig control panel it sais access denied for admin with the same password I always used before.

Rudolf.
Reply With Quote
  #47  
Old 24th September 2009, 10:38
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,260 Times in 4,124 Posts
Default

Have you tested that you are able to login to the mysql database and switch to the ispconfig database with the username "ispconfig" and the password from the file? You can test this with the mysql command or phpmyadmin.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #48  
Old 24th September 2009, 10:50
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

I get access denied.
How can I grant access to dbispconfig for user ispconfig?

I was looking in phpmyadmin (under dbispconfig, permissions) but there I can't add user ispconfig for db dbispconfig.

Cheers,
Rudolf.

Os should I set "ALL PRIVILEGES" for user ispconfig?
Reply With Quote
  #49  
Old 24th September 2009, 10:54
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 416
Thanks: 76
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Under the user settings of user ispconfig I "GRANT" the user ispconfig to use the db dbispconfig. Is this enough?

I flushed privileges and I restarted mysql. But I still get this error at the login of the ispconfig controlpanel:

Quote:
ERROR
Error
Username or Password wrong.1

Password lost?
I checked and now I can use DB in mysql with user ispconfig, I don't get access denied message.

Last edited by skoena; 24th September 2009 at 10:58.
Reply With Quote
  #50  
Old 24th September 2009, 10:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,260 Times in 4,124 Posts
 
Default

Should be ok but please test it, you will see if you can enter to the ispconfig database with phpmyadmin.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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


All times are GMT +2. The time now is 06:14.


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