#1  
Old 27th November 2010, 21:59
Youko Youko is offline
Junior Member
 
Join Date: Oct 2007
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default [Solved] Problem updating (MySQL issue)

Hello!

When I try to update ISPCOnfig 3, I ge tthe following errors:

Code:
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 78

Fatal error: Cannot use string offset as an array in /tmp/ispconfig3_install/install/lib/update.lib.php on line 98
I am running the update command as root.

Now, I most likely know what the first error is.
My ISP had made the initial ISPConfig 3 installation.

Later, I updated my MySQL root password. However, according to
the upgrade guide, the updater should ask me the root password for
MySQL which it does not which leads me to think the info is stored in some
file, but I can't find it anywhere! Help would really be appreciated!

For the second error I have no clue.

Last edited by Youko; 28th November 2010 at 21:17.
Reply With Quote
Sponsored Links
  #2  
Old 28th November 2010, 15:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

The mysql root password has to be changed in the file /usr/local/ispconfig/server/lib/mysql-clientdb.conf when you change the root password of the mysql server. Otherwise ispconfig will not work properly anymore and is e.g. unable to create new databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following 2 Users Say Thank You to till For This Useful Post:
finn (27th February 2011), Youko (28th November 2010)
  #3  
Old 28th November 2010, 21:16
Youko Youko is offline
Junior Member
 
Join Date: Oct 2007
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thank you so much! This was driving me insane.
Reply With Quote
  #4  
Old 24th December 2010, 15:09
mascoxx mascoxx is offline
Junior Member
 
Join Date: Sep 2007
Location: Austria
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to mascoxx Send a message via Skype™ to mascoxx
 
Default

Hi,

I've got the same issues, but the credentials are correct because I'm also able to login in manually!
In my environment are three machines. One of them is the master service which also provides the admin panel. The other both are web- and mailservers.
The master update was successful, but then I've tried to update the second one - with this error as described by Youko.

Till, do you have an idea what's going wrong?

Thanks and regards,
Clemens
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
mysql ssl data replication problem certificate issue? isn Server Operation 5 30th July 2010 15:38
MySQL problem satimis Server Operation 5 25th June 2008 15:41
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
ISPConfig Mysql root password issue ?? Stuck at install Randall Hoffman Installation/Configuration 1 16th January 2007 20:53
Site with MySQL problem?! edge Server Operation 2 13th August 2006 19:57


All times are GMT +2. The time now is 03:10.


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