View Single Post
  #16  
Old 15th January 2011, 22:11
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 119
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.
__________________
Jakob

SuperWeb
Reply With Quote