Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #31  
Old 5th December 2012, 13:04
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

I can find /usr/local/ispconfig/server/lib/mysql_clientdb.conf
it contains
Code:
$clientdb_host                  = 'localhost';
$clientdb_user                  = 'root';
$clientdb_password              = 'PASSWORD1';
and I can login to mysql as user root with password PASSWORD1, but that was not the root password I setup initially. I can still login with both password for user root.

I did follow your instructions
Code:
cd /tmp
wget http://www.ispconfig.org/downloads/ISPConfig-3-stable.tar.gz
tar xvfz ISPConfig-3-stable.tar.gz
cd ispconfig3_install/install
php -q update.php
did not work
Reply With Quote
Sponsored Links
  #32  
Old 5th December 2012, 13:14
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

Code:
mysql> SELECT user,host,password FROM mysql.user WHERE user = 'root' ORDER BY host ASC;
+------+-------------------------------+-------------------------------------------+
| user | host                          | password                                  |
+------+-------------------------------+-------------------------------------------+
| root | %                                    | *E6-------------------------------------- |
| root | 127.0.0.1                         |  blank password                                 |
| root | remote.host1                    | *E6-------------------------------------- |
| root | remote.host2                    | *E6-------------------------------------- |
| root | localhost                           | *E6-------------------------------------- |
| root | localhost.localdomain         |  blank password                                |
+------+-------------------------------+-------------------------------------------+
Reply With Quote
  #33  
Old 5th December 2012, 16:22
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

There should never be a balnk password in mysql as it would allow to connect to your server without password e.g. trough phpmyadmin. Please set the same root password for all root users in mysql and set the same password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf and restart mysql and redor the ispconfig update afterwards.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #34  
Old 5th December 2012, 16:26
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

Quote:
Originally Posted by till View Post
There should never be a balnk password in mysql as it would allow to connect to your server without password e.g. trough phpmyadmin. Please set the same root password for all root users in mysql and set the same password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf and restart mysql and redor the ispconfig update afterwards.
ok, will do that, FYI I did not set a blank password nor did I add something manually to mysql_clientdb.conf, this might be something related to all those ispconfig upgrades I do....

Last edited by grungy; 5th December 2012 at 16:35.
Reply With Quote
  #35  
Old 5th December 2012, 16:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

Quote:
ok, will do that, FYI I did not set a blank password nor did I add something manually to mysql_clientdb.conf, this might be something related to all those ispconfig upgrades I do....
No, its not related to a ispconfig update.

The emüpty root password means that you have not set this password for all root users at the time you installed the mysql binary of the linux distribution and the password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf is set once when you install ispconfig the first time, it is not altered by a ispconfig update. This file contains the password that you entered into the ispconfig installer when the installer asked for the mysql root password, if you alter the mysql root password in mysql at any later time, you have to update it in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf as well or ispconfig will not be able to install updates anymore or create client databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #36  
Old 6th December 2012, 09:32
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

- /usr/local/ispconfig/server/lib/mysql_clientdb.conf has the correct password
- no more empty root passwords
- run the ispconfig update

the problem is still there
Reply With Quote
  #37  
Old 6th December 2012, 09:38
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

Then there must be a error logged to the global apache error.log.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #38  
Old 6th December 2012, 09:41
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

Quote:
Originally Posted by till View Post
Then there must be a error logged to the global apache error.log.
yes you are right

Code:
PHP Warning:  exec() has been disabled for security reasons in /usr/local/ispconfig/interface/web/client/client_edit.php
in

/var/log/apache2/error.log
Reply With Quote
  #39  
Old 6th December 2012, 09:52
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 9 Times in 6 Posts
Default

solved this error by adding

Code:
        php_admin_value suhosin.executor.func.blacklist "shell_exec"
to

/etc/apache2/sites-available/ispconfig.vhost

so when I do an upgrade this entry will be gone I now remember this happened once before
Reply With Quote
  #40  
Old 22nd July 2013, 14:05
tuxfan tuxfan is offline
Junior Member
 
Join Date: Nov 2011
Posts: 18
Thanks: 0
Thanked 4 Times in 2 Posts
 
Default

Does ISPConfig 3.0.4.6 work with the new Debian 7 (Wheezy)?
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
Control Panel - E-mail Tab is empty domi-nik General 15 14th April 2011 18:17
ISPConfig forward to VirtualBox ISPConfig Rescue9 General 3 11th March 2011 14:25
chroot SSH IspConfig2 kextra1 General 4 20th January 2011 18:41
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 01:22.


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