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
  #1  
Old 22nd March 2010, 18:47
zabry23 zabry23 is offline
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default ispconfig 3.0.2 oriblem with mysql - access denied

Hi,

please I need help with ISPconfig 3.0.2.
After automatic update from version 3.0.1.6. email and web server is not runing
because have problem with connection to database.

Apache 2 log >>
DBI connect('database=dbispconfig;host=localhost:3306' ,'ispconfig',...) failed: Access denied for user 'ispconfig'@'localhost' (using password: YES) at /usr/local/ispconfig/server/scripts/vlogger line 255

Postfix log >>

postfix/smtp[3645]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)


I try change password with phpmyadmin for user ispconfig and then paste MD5 hash to config.inc.php file to field db_password, but problem is still there.

Could you help me with this.

Thank you
Reply With Quote
Sponsored Links
  #2  
Old 22nd March 2010, 18:52
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

Quote:
I try change password with phpmyadmin for user ispconfig and then paste MD5 hash to config.inc.php file to field db_password, but problem is still there.
This can not work. Never try to change the password manually.

Please redo the update by using the manual update instructions that are diescribed in the release notes and select to reconfigure services when the updater asks you.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 22nd March 2010, 19:43
zabry23 zabry23 is offline
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default run manualy

I try run update manualy again but this problem is still there.
Is possible install ispconfig again with no lose data? Because I have a lot of email account in ispconfig.

Or is possible correct password for user ispconfig ?

Thank you
Reply With Quote
  #4  
Old 22nd March 2010, 20:13
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

Quote:
Is possible install ispconfig again with no lose data?
No. And this wont help you as the ispconfig install is not the problem, the problem is the mysql login.

Take a look at the config.inc.php file from ispconfig, there you find the cleartext password of the ispconfig user (looks like an md5, but thats the claertext password). Now login to your mysql database as root user with e.g. phpmyadmin and make sure that the user ispconfig is able to login to mysql with this password from localhost. Change this only in mysql and do not change the password in any ispconfig file, you have to make the mysal login work with this password and not try to set any other password.
__________________
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:
zabry23 (23rd March 2010)
  #5  
Old 23rd March 2010, 00:23
zabry23 zabry23 is offline
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
No. And this wont help you as the ispconfig install is not the problem, the problem is the mysql login.

Take a look at the config.inc.php file from ispconfig, there you find the cleartext password of the ispconfig user (looks like an md5, but thats the claertext password). Now login to your mysql database as root user with e.g. phpmyadmin and make sure that the user ispconfig is able to login to mysql with this password from localhost. Change this only in mysql and do not change the password in any ispconfig file, you have to make the mysal login work with this password and not try to set any other password.


wery well ,,, I use password from config file to mysql for user ispconfig and everything is working.

Thank you
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 setup - DNS, router and general access problems ingvar Installation/Configuration 6 31st July 2010 14:13
MySQL5 client access to ISPConfig box vs plain centos5 pakogah Installation/Configuration 1 5th August 2008 19:47
MySQL problem satimis Server Operation 5 25th June 2008 16:41
ISPconfig after installation cannot reach www.xyz.de:81 Figth4Linux Installation/Configuration 23 6th March 2008 23:38
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41


All times are GMT +2. The time now is 04:34.


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