Slave server update issue

Discussion in 'General' started by Sharone, Aug 18, 2020.

  1. Sharone

    Sharone Member

    Hi there,
    I am running Ubuntu 18.04, trying to upgrade to ISPConfig 3.1.15p3 from 3.0.5.4p9. I hit a deadend when trying to update the secondary dns name server. I'm not sure of what to make of the logs. I'm able to login to the db, I run a db mysqlcheck/repair nothing was amiss.
    Code:
    [email protected]:/tmp/ispconfig3_install/install# php -q update.php           
    
    
    --------------------------------------------------------------------------------
     _____ ___________   _____              __ _         ____
    |_   _/  ___| ___ \ /  __ \            / _(_)       /__  \
      | | \ `--.| |_/ / | /  \/ ___  _ __ | |_ _  __ _    _/ /
      | |  `--. \  __/  | |    / _ \| '_ \|  _| |/ _` |  |_ |
     _| |_/\__/ / |     | \__/\ (_) | | | | | | | (_| | ___\ \
     \___/\____/\_|      \____/\___/|_| |_|_| |_|\__, | \____/
                                                  __/ |
                                                 |___/
    --------------------------------------------------------------------------------
    
    
    >> Update 
    
    Operating System: Ubuntu 18.04.5 LTS (Bionic Beaver)
    
    This application will update ISPConfig 3 on your server.
    
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
    
    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    mysql: [Warning] Using a password on the command line interface can be insecure.
    mysqldump: [Warning] Using a password on the command line interface can be insecure.
    MySQL master server hostname [db-20.srv.domain.tld]:
    
    MySQL master server port []:
    
    MySQL master server root username [root]:
    
    MySQL master server root password []: xxxxxxxxxxx
    
    MySQL master server database name [dbispconfig]:
    
    Checking ISPConfig database .. mysqlcheck: [Warning] Using a password on the command line interface can be insecure.
    OK
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Unable to read server configuration from [email protected]:/tmp/ispconfig3_install/install# 
    /var/log/ispconfig_install.log
    Code:
    Tue Aug 18 14:44:49 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    Tue Aug 18 16:04:31 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    Tue Aug 18 16:07:22 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    Tue Aug 18 16:10:31 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    Tue Aug 18 16:39:32 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    Tue Aug 18 16:44:27 EAT 2020 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in pre_update.sql
    
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    take a look into the dbispconfig database on the slave node, the relevant table is the 'server' table, is there a record for the server_id of this node and does the content of the config field looks normal in comparison to other servers (e.g. it may not be empty).
     
  3. Sharone

    Sharone Member

    Y
    You're right. I see 2 entries with the same hostname but different IPs. Server name column is also the same.

    Code:
    [global]
    webserver=apache
    mailserver=postfix
    dnsserver=mydns
    
    [server]
    auto_network_configuration=n
    ip_address=10.0.0.3
    netmask=255.255.255.192
    gateway=10.0.0.1
    firewall=bastille
    hostname=dns-20.srv.domain.tld
    nameservers=1.1.1.1,8.8.8.8
    loglevel=2
    admin_notify_events=1
    backup_dir=/var/backup
    backup_mode=rootgz
    monit_url=
    monit_user=
    monit_password=
    munin_url=
    munin_user=
    munin_password=
    [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
    mailbox_quota_stats=y
    realtime_blackhole_list=
    overquota_notify_admin=y
    overquota_notify_client=y
    overquota_notify_freq=7
    overquota_notify_onok=n
    [getmail]
    getmail_config_dir=/etc/getmail
    [web]
    server_type=apache
    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]/
    website_symlinks_rel=n
    vhost_conf_dir=/etc/apache2/sites-available
    vhost_conf_enabled_dir=/etc/apache2/sites-enabled
    nginx_vhost_conf_dir=/etc/nginx/sites-available
    nginx_vhost_conf_enabled_dir=/etc/nginx/sites-enabled
    security_level=20
    user=www-data
    group=www-data
    nginx_user=www-data
    nginx_group=www-data
    apps_vhost_port=8081
    apps_vhost_ip=_default_
    apps_vhost_servername=
    php_open_basedir=[website_path]/web:[website_path]/private:[website_path]/tmp:/var/www/[website_domain]/web:/srv/www/[website_domain]/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin
    htaccess_allow_override=All
    awstats_conf_dir=/etc/awstats
    awstats_data_dir=/var/lib/awstats
    awstats_pl=/usr/lib/cgi-bin/awstats.pl
    awstats_buildstaticpages_pl=/usr/share/awstats/tools/awstats_buildstaticpages.pl
    php_ini_path_apache=/etc/php5/apache2/php.ini
    php_ini_path_cgi=/etc/php5/cgi/php.ini
    check_apache_config=y
    enable_sni=y
    enable_ip_wildcard=y
    overtraffic_notify_admin=y
    overtraffic_notify_client=y
    nginx_cgi_socket=/var/run/fcgiwrap.socket
    php_fpm_init_script=php5-fpm
    php_fpm_ini_path=/etc/php5/fpm/php.ini
    php_fpm_pool_dir=/etc/php5/fpm/pool.d
    php_fpm_start_port=9010
    php_fpm_socket_dir=/var/lib/php5-fpm
    set_folder_permissions_on_update=n
    add_web_users_to_sshusers_group=y
    connect_userid_to_webid=n
    connect_userid_to_webid_start=10000
    web_folder_protection=y
    overquota_notify_admin=y
    overquota_notify_client=y
    overquota_notify_freq=7
    overquota_notify_onok=n
    
    [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
    fastcgi_config_syntax=1
    
    [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
    
    [rescue]
    try_rescue=n
    do_not_try_rescue_httpd=n
    do_not_try_rescue_mysql=n
    do_not_try_rescue_mail=n
    
    Code:
    [global]
    webserver=apache
    mailserver=postfix
    dnsserver=mydns
    
    [server]
    auto_network_configuration=n
    ip_address=10.0.0.2
    netmask=255.255.255.192
    gateway=10.0.0.1
    hostname=dns-20.srv.domain.tld
    nameservers=1.1.1.1,8.8.8.8
    firewall=bastille
    loglevel=2
    admin_notify_events=1
    backup_dir=/var/backup
    backup_dir_is_mount=n
    backup_mode=rootgz
    monit_url=
    monit_user=
    monit_password=
    munin_url=
    munin_user=
    munin_password=
    monitor_system_updates=y
    
    [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
    mailbox_quota_stats=y
    realtime_blackhole_list=
    overquota_notify_admin=y
    overquota_notify_client=y
    overquota_notify_freq=7
    overquota_notify_onok=n
    
    [getmail]
    getmail_config_dir=/etc/getmail
    
    [web]
    server_type=apache
    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]/
    website_symlinks_rel=n
    network_filesystem=n
    vhost_conf_dir=/etc/apache2/sites-available
    vhost_conf_enabled_dir=/etc/apache2/sites-enabled
    nginx_vhost_conf_dir=/etc/nginx/sites-available
    nginx_vhost_conf_enabled_dir=/etc/nginx/sites-enabled
    security_level=20
    user=www-data
    group=www-data
    nginx_user=www-data
    nginx_group=www-data
    apps_vhost_port=8081
    apps_vhost_ip=_default_
    apps_vhost_servername=
    php_open_basedir=[website_path]/web:[website_path]/private:[website_path]/tmp:/var/www/[website_domain]/web:/srv/www/[website_domain]/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin
    htaccess_allow_override=All
    awstats_conf_dir=/etc/awstats
    awstats_data_dir=/var/lib/awstats
    awstats_pl=/usr/lib/cgi-bin/awstats.pl
    awstats_buildstaticpages_pl=/usr/share/awstats/tools/awstats_buildstaticpages.pl
    php_ini_path_apache=/etc/php5/apache2/php.ini
    php_ini_path_cgi=/etc/php5/cgi/php.ini
    check_apache_config=y
    enable_sni=y
    enable_ip_wildcard=y
    overtraffic_notify_admin=y
    overtraffic_notify_client=y
    nginx_cgi_socket=/var/run/fcgiwrap.socket
    php_fpm_init_script=php5-fpm
    php_fpm_ini_path=/etc/php5/fpm/php.ini
    php_fpm_pool_dir=/etc/php5/fpm/pool.d
    php_fpm_start_port=9010
    php_fpm_socket_dir=/var/lib/php5-fpm
    set_folder_permissions_on_update=n
    add_web_users_to_sshusers_group=y
    connect_userid_to_webid=n
    connect_userid_to_webid_start=10000
    web_folder_protection=y
    overquota_notify_admin=y
    overquota_notify_client=y
    overquota_notify_freq=7
    overquota_notify_onok=n
    
    [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
    fastcgi_config_syntax=1
    
    [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
    
    [rescue]
    try_rescue=n
    do_not_try_rescue_httpd=n
    do_not_try_rescue_mysql=n
    do_not_try_rescue_mail=n
    
     
  4. Sharone

    Sharone Member

    Found the issue. Server ID, et al. was different from what was in the master server. Thank you.
     
    Th0m and till like this.

Share This Page