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: root@dns-30:/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 database.root@dns-30:/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
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).
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
