View Single Post
  #1  
Old 4th June 2010, 18:40
DreamK DreamK is offline
Member
 
Join Date: Aug 2008
Posts: 33
Thanks: 1
Thanked 0 Times in 0 Posts
Default Multiservers Not Updated + Remove Lock

Hi,

Sorry to mind you, I have not sleeped since 48 h for trying a solution to my problem.

My network :

2 adsl
2 router for roundrobin
2 servers
3 nic on each server (192.168.10.xxx, 192.168.20.yyy, 10.0.0.zzz)

The Master :

hostname -f = master.domain.com

Works perfectly whit ISP3 when it is alone :

When I install the slave :

hostname -F = slave.domain.com


I obtain the following message :


- master :

Quote:
04-06-2010 17:07 master.domain.com Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
04-06-2010 17:07 master.domain.com. Debug No Updated records found, starting only the core.
- on slave : nothing updated and this message :

Quote:
Warning: include_once(sites/lib/module.conf.php) [function.include-once]: failed to open stream: Too many open files in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once() [function.include]: Failed opening 'sites/lib/module.conf.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once(dns/lib/module.conf.php) [function.include-once]: failed to open stream: Too many open files in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once() [function.include]: Failed opening 'dns/lib/module.conf.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once(tools/lib/module.conf.php) [function.include-once]: failed to open stream: Too many open files in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once() [function.include]: Failed opening 'tools/lib/module.conf.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once(help/lib/module.conf.php) [function.include-once]: failed to open stream: Too many open files in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: include_once() [function.include]: Failed opening 'help/lib/module.conf.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/nav.php on line 49

Warning: fopen(/usr/local/ispconfig/interface/web/themes/default/templates/topnav.tpl.htm) [function.fopen]: failed to open stream: Too many open files in /usr/local/ispconfig/interface/lib/classes/tpl.inc.php on line 816

Warning: fread(): supplied argument is not a valid stream resource in /usr/local/ispconfig/interface/lib/classes/tpl.inc.php on line 816

Warning: fclose(): supplied argument is not a valid stream resource in /usr/local/ispconfig/interface/lib/classes/tpl.inc.php on line 817

My configuration from : nano /usr/local/ispconfig/server/lib/config.inc.php


-------------- slave ---------------------
Quote:
//** Application
define('ISPC_APP_TITLE', 'ISPConfig');
define('ISPC_APP_VERSION', '3.0.2.1');


//** Database
$conf["db_type"] = 'mysql';
$conf["db_host"] = 'localhost';
$conf["db_database"] = 'dbispconfig_slave';
$conf["db_user"] = 'ispconfig';
$conf["db_password"] = 'passwd_slave';
$conf["db_charset"] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")

define("DB_TYPE",$conf["db_type"]);
define("DB_HOST",$conf["db_host"]);
define("DB_DATABASE",$conf["db_database"]);
define("DB_USER",$conf["db_user"]);
define("DB_PASSWORD",$conf["db_password"]);
define("DB_CHARSET",$conf["db_charset"]);


//** Database settings for the master DB. This setting is only used in multiserver setups
$conf["dbmaster_type"] = 'mysql';
$conf["dbmaster_host"] = 'master.domain.com';
$conf["dbmaster_database"] = 'dbispconfig';
$conf["dbmaster_user"] = 'ispcsrv2';
$conf["dbmaster_password"] = 'passwd_master';


--------- master ----------------------------
Quote:
//** Database
$conf["db_type"] = 'mysql';
$conf["db_host"] = 'localhost';
$conf["db_database"] = 'dbispconfig';
$conf["db_user"] = 'ispconfig';
$conf["db_password"] = 'psswd_xx';
$conf["db_charset"] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")

define("DB_TYPE",$conf["db_type"]);
define("DB_HOST",$conf["db_host"]);
define("DB_DATABASE",$conf["db_database"]);
define("DB_USER",$conf["db_user"]);
define("DB_PASSWORD",$conf["db_password"]);
define("DB_CHARSET",$conf["db_charset"]);


//** Database settings for the master DB. This setting is only used in multiserver setups
$conf["dbmaster_type"] = 'mysql';
$conf["dbmaster_host"] = '';
$conf["dbmaster_database"] = 'dbispconfig';
$conf["dbmaster_user"] = '';
$conf["dbmaster_password"] = 'psswd_yy';

mySQL Grant
Quote:

User Hosts Encrypted password Permissions
debian-sys-maint localhost aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa Select | Insert | Update | Delete | Create | Drop | Reload | Shutdown | Process | File | Grant | References | Index | Alter | Show DB | Super | Create temp | Lock | Execute | Slave | Client
ispconfig localhost bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb None
ispcsrv2 slave.domain.com ccccccccccccccccccccccccccccccccccccccccc None
ispcsrv2 Any ccccccccccccccccccccccccccccccccccccccccc
root localhost ddddddddddddddddddddddddddddddddddddddddd All
root master.domain.com ddddddddddddddddddddddddddddddddddddddddd All

I really thank you in advance for sharing your experience.

Last edited by DreamK; 4th June 2010 at 19:32.
Reply With Quote
Sponsored Links