View Single Post
  #4  
Old 1st May 2010, 10:54
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default Checking server records in ISPConfig3 multiserver setups

As you can see it is possible to modify the installation to suit your needs.

In your case you can check if the second server record is present in the dbispconfig database like this: (please note that my database is called dbispconfig1 - yours will be called whatever you have called it!!)

root@server1:~# mysql -u root -p
Enter password: XXXXX

mysql> USE dbispconfig1;

mysql> SELECT server_name FROM server;
+------------------------+
| server_name |
+------------------------+
| server1.example.com |
| server2.example.com |
+------------------------+
2 rows in set (0.00 sec)

You can see if the second server is properly installed the record is there on the database of the first server. You can obtain more detailed information about the configuration of each of your servers by querying the "config" field of dbispconfig like this:

mysql> SELECT server_name, config FROM server;

What you are doing here is asking the ISPConfig3 database about the configuration of each server and the output should look like something along these lines:

mysql> SELECT server_name, config FROM server;
+------------------------+-------------------------------------------------------------------------------------------------------------------------------
| server_name | config |
+------------------------+-------------------------------------------------------------------------------------------------------------------------------
| server1.example.com | [global]
webserver=apache
mailserver=postfix
dnsserver=mydns

[server]
auto_network_configuration=n
ip_address=192.168.XXX.XXX
netmask=255.255.255.0
gateway=192.168.XXX.XXX
hostname=server1.example.com
nameservers=192.168.XXX.XXX,192.168.XXX.XXX
loglevel=2

[mail]
module=postfix_mysql
maildir_path=/var/vmail/[domain]/[localpart]
homedir_path=/var/vmail
pop3_imap_daemon=courier
mail_filter_syntax=maildrop
mailuser_uid=5000
mailuser_gid=5000
mailuser_name=vmail
mailuser_group=vmail
relayhost=
relayhost_user=
relayhost_password=
mailbox_size_limit=0
message_size_limit=0

[getmail]
getmail_config_dir=/etc/getmail

[web]
website_basedir=/var/www
website_path=/var/www/clients/client[client_id]/web[website_id]
website_symlinks=/var/www/[website_domain]/:/var/www/clients/client[client_id]/[website_domain]/
vhost_conf_dir=/etc/apache2/sites-available
vhost_conf_enabled_dir=/etc/apache2/sites-enabled
security_level=20
user=www-data
group=www-data
apps_vhost_port=8081
apps_vhost_ip=_default_
apps_vhost_servername=
php_open_basedir=[website_path]/web:[website_path]/tmp:/var/www/[website_domain]/web:/srv/www/[website_domain]/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin
htaccess_allow_override=All

[dns]
bind_user=root
bind_group=bind
bind_zonefiles_dir=/etc/bind
named_conf_path=/etc/bind/named.conf
named_conf_local_path=/etc/bind/named.conf.local

[fastcgi]
fastcgi_starter_path=/var/www/php-fcgi-scripts/[system_user]/
fastcgi_starter_script=.php-fcgi-starter
fastcgi_alias=/php/
fastcgi_phpini_path=/etc/php5/cgi/
fastcgi_children=8
fastcgi_max_requests=5000
fastcgi_bin=/usr/bin/php-cgi

[jailkit]
jailkit_chroot_home=/home/[username]
jailkit_chroot_app_sections=basicshell editors extendedshell netutils ssh sftp scp groups jk_lsh
jailkit_chroot_app_programs=/usr/bin/groups /usr/bin/id /usr/bin/dircolors /usr/bin/lesspipe /usr/bin/basename /usr/bin/dirname /usr/bin/nano /usr/bin/pico
jailkit_chroot_cron_programs=/usr/bin/php /usr/bin/perl /usr/share/perl /usr/share/php

[vlogger]
config_dir=/etc

[cron]
init_script=cron
crontab_dir=/etc/cron.d
wget=/usr/bin/wget

|
| server2.example.com | [global]
webserver=apache
mailserver=postfix
dnsserver=mydns

[server]
auto_network_configuration=n
ip_address=192.168.XXX.XXX
netmask=255.255.255.0
gateway=192.168.XXX.XXX
hostname=server2.example.com
nameservers=192.168.XXX.XXX,192.168.XXX.XXX
loglevel=2

[mail]
module=postfix_mysql
maildir_path=/var/vmail/[domain]/[localpart]
homedir_path=/var/vmail
pop3_imap_daemon=courier
mail_filter_syntax=maildrop
mailuser_uid=5000
mailuser_gid=5000
mailuser_name=vmail
mailuser_group=vmail
relayhost=
relayhost_user=
relayhost_password=
mailbox_size_limit=0
message_size_limit=0

[getmail]
getmail_config_dir=/etc/getmail

[web]
website_basedir=/var/www
website_path=/var/www/clients/client[client_id]/web[website_id]
website_symlinks=/var/www/[website_domain]/:/var/www/clients/client[client_id]/[website_domain]/
vhost_conf_dir=/etc/apache2/sites-available
vhost_conf_enabled_dir=/etc/apache2/sites-enabled
security_level=20
user=www-data
group=www-data
apps_vhost_port=8081
apps_vhost_ip=_default_
apps_vhost_servername=
php_open_basedir=[website_path]/web:[website_path]/tmp:/var/www/[website_domain]/web:/srv/www/[website_domain]/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin
htaccess_allow_override=All

[dns]
bind_user=root
bind_group=bind
bind_zonefiles_dir=/etc/bind
named_conf_path=/etc/bind/named.conf
named_conf_local_path=/etc/bind/named.conf.local

[fastcgi]
fastcgi_starter_path=/var/www/php-fcgi-scripts/[system_user]/
fastcgi_starter_script=.php-fcgi-starter
fastcgi_alias=/php/
fastcgi_phpini_path=/etc/php5/cgi/
fastcgi_children=8
fastcgi_max_requests=5000
fastcgi_bin=/usr/bin/php-cgi

[jailkit]
jailkit_chroot_home=/home/[username]
jailkit_chroot_app_sections=basicshell editors extendedshell netutils ssh sftp scp groups jk_lsh
jailkit_chroot_app_programs=/usr/bin/groups /usr/bin/id /usr/bin/dircolors /usr/bin/lesspipe /usr/bin/basename /usr/bin/dirname /usr/bin/nano /usr/bin/pico
jailkit_chroot_cron_programs=/usr/bin/php /usr/bin/perl /usr/share/perl /usr/share/php

[vlogger]
config_dir=/etc

[cron]
init_script=cron
crontab_dir=/etc/cron.d
wget=/usr/bin/wget

|
+
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 rows in set (0.00 sec)

As you can see - if the second and subsequent servers of a multiserver setup are installed properly they are present in the web UI for ISPConfig. When you select the server you wish to monitor, detailed information about the hardware and logging of either server is shown.

Good luck.

Last edited by CSsab; 1st May 2010 at 11:00. Reason: Tidy
Reply With Quote