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 14th January 2011, 13:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,409
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Then try the same update on one of the slaves with "Reconfigure Permissions in master database?" = yes.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #12  
Old 14th January 2011, 14:15
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

This is getting more and more strange.

Tried to run the same on one of the remotes and got :
Code:
Unable to connect to mysql server Lost connection to MySQL server at 'reading initial communication packet', system error: 111
If I connect to mysql from phpmyadmin - no problem, even using remote connection - got phpmyadmin on one site.

Then I tried
Code:
mysql -h db9.superweb.dk -P 3308 -u root -p
on the master (master is db9.superweb.dk / 92.62.196.69) and no problems conneting. Router is set to external port 3308 - internal port 3306
Tried the same from one of the other servers and got :
Code:
ERROR 2003 (HY000): Can't connect to MySQL server on '92.62.196.69' (111)
In my my.inf :
Code:
[client]
port            = 3308
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3308
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
tried with 3306 and a restart but still the same, exept that ispconfig works, but then phpmyadmin doesnt.

Finally did a ps :
Code:
web:/var/log/mysql# ps -efH | grep mysql
root     21985 14541  0 14:13 pts/1    00:00:00         grep mysql
root     21494     1  0 13:56 pts/1    00:00:00   /bin/sh /usr/bin/mysqld_safe
mysql    21531 21494  0 13:56 pts/1    00:00:00     /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3308 --socket=/var/run/mysqld/mysqld.sock
root     21532 21494  0 13:56 pts/1    00:00:00     logger -p daemon.err -t mysqld_safe -i -t mysqld
web:/var/log/mysql#
I am still lost and have lost ftp connection to the domains also.
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe

Last edited by DKLeader; 14th January 2011 at 15:20. Reason: more info
Reply With Quote
  #13  
Old 14th January 2011, 15:35
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,409
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Maybe mysql on the master blocks connections because there were too many false logins. Try to issue this command on the master and then chack the jobqueue a few minutes later:

mysqladmin -u root -p flush-hosts
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #14  
Old 15th January 2011, 02:07
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

This is a stab in the dark but may be part of the problem here. On a fresh install of ISPConfig I get the following errors:

PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78

Line 78:
$this->linkId = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);


PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Line 63: $this->errorNumber = mysql_errno($this->linkId);

PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Line 64: $this->errorMessage = mysql_error($this->linkId);


..
..
..

sh: mailq: command not found
sh: mailq: command not found
sh: mailq: command not found (NOTE: don't have mail server installed on this which is the host)

...
...
...

/usr/local/ispconfig/server/server.sh: line 7: 8182 Segmentation fault /usr/bin/php -q /usr/local/ispconfig/server/server.php

Line 7 /usr/bin/php -q /usr/local/ispconfig/server/server.php

/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory

...
...
...

/bin/sh: /usr/local/ispconfig/server/cron_daily.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory
/bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory

...
...
...

Hope this helps.
Reply With Quote
  #15  
Old 15th January 2011, 19:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
Default

Which tutorial (URL) did you use to set up the server?
Are the MySQL details in /usr/local/ispconfig/interface/lib/config.inc.php correct?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #16  
Old 15th January 2011, 21:11
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
 
Default

I have partly slved my problem. It seems to be a port configuration problem.

I have used this tutorial : http://www.howtoforge.com/installing...th-ispconfig-3

As I have 3 of the servers behind a router and all of them are running mysql (got 9 servers running mysql) and I wanted a shared phpmyadmin. Due to this I used different external ports and 3306 as internal for the ones behind the router.

If I set my.cnf to the external port I can use the shared phpmyadmin but then ISPConfig fails. I then changed my.cnf to internal port (3306) and then ISPConfig fails, and then I get from phpmyadmin :
Code:
#2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111
In config.inc.php used for phpmyadmin I have set up for each server as this :
Code:
/*
 * Ninth server - 92.62.196.69 - 192.168.1.90
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'db9.superweb.dk:3308';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';
On the router 3308 is forwarded to 192.168.1.90 as 3306.

And in my zone it should be ok :
Code:
$TTL        3600
@       IN      SOA     ns1.superweb.dk. admin.superweb.dk. (
                        2011011401       ; serial, todays date + todays serial #
                        3600              ; refresh, seconds
                        3600              ; retry, seconds
                        1209600              ; expire, seconds
                        3600 )            ; minimum, seconds
;

cp.superweb.dk.      A        92.62.196.69
db1.superweb.dk.      A        92.62.196.66
db2.superweb.dk.      A        92.62.196.67
db3.superweb.dk.      A        92.62.196.69
db4.superweb.dk.      A        92.62.196.69
db5.superweb.dk.      A        92.62.196.70
db6.superweb.dk.      A        92.62.196.71
db7.superweb.dk.      A        92.62.196.72
db8.superweb.dk.      A        92.62.196.69
db9.superweb.dk.      A        92.62.196.69
ftp.superweb.dk.      CNAME        superweb.dk.
mail.superweb.dk.      A        92.62.196.69
ns1.superweb.dk.      A        92.62.196.66
ns2.superweb.dk.      A        92.62.196.67
ns3.superweb.dk.      A        92.62.196.77
superweb.dk.      A        92.62.196.69
superweb.dk.      MX    10   mail.superweb.dk.
superweb.dk.      MX    15   superweb.dk.
superweb.dk.      NS        ns1.superweb.dk.
superweb.dk.      NS        ns2.superweb.dk.
superweb.dk.      NS        ns3.superweb.dk.
www.superweb.dk.      CNAME        superweb.dk.
But anyway the ISPConfig is working and at the moment I can live without shared phpmyadmin.
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
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
AWStats Installer jnsc Tips/Tricks/Mods 242 22nd June 2010 11:15
Postfix - Relay access denied gotting Server Operation 3 23rd April 2008 14:06
php eating cpu shajazzi Server Operation 15 15th August 2007 01:19
DNS Configuration Problems VMartins Installation/Configuration 10 24th July 2007 14:40
No SPF record. beryl Installation/Configuration 6 17th May 2007 19:52


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


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