[Resolved] Field server are empty

Discussion in 'Installation/Configuration' started by slh69, Jun 19, 2018.

  1. slh69

    slh69 New Member

    Hello, I just reconnected to my site ISPconfig after a few weeks and can not create a new site, the SERVER field is empty !!!
    There are 4 sites that work on it without problem.
    How can I put the name of the server?
    I have not made any changes on the linux server (centos) with ispconfig 3.1

    Any help would be awesome! Thanks
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Is there a server (even without server name) listed under system > server services or system > server config in ISPConfig?
     
  3. slh69

    slh69 New Member

    No it's empty !
    upload_2018-6-19_10-48-50.png
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Is this a server with apache or nginx web server?
     
  5. slh69

    slh69 New Member

    It's with Apache
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Run this SQL query in the dbispconfig database with e.g. phpmyadmin to add a server record again:

    Code:
    INSERT INTO `server` (`server_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_name`, `mail_server`, `web_server`, `dns_server`, `file_server`, `db_server`, `vserver_server`, `proxy_server`, `firewall_server`, `xmpp_server`, `config`, `updated`, `mirror_server_id`, `dbversion`, `active`) VALUES
    (1, 1, 1, 'riud', 'riud', 'r', 'server1.example.com', 1, 1, 1, 1, 1, 0, 0, 0, 0, '[global]\nwebserver=apache\nmailserver=postfix\ndnsserver=mydns\n\n[server]\nauto_network_configuration=n\nip_address=192.168.1.100\nnetmask=255.255.255.0\nv6_prefix=\ngateway=0.0.0.0\nhostname=server1.example.com\nnameservers=8.8.8.8,8.8.4.4\nfirewall=bastille\nloglevel=2\nadmin_notify_events=1\nbackup_dir=/var/backup\nbackup_dir_is_mount=n\nbackup_mode=rootgz\nbackup_time=0:00\nbackup_delete=n\nmonit_url=\nmonit_user=\nmonit_password=\nmunin_url=\nmunin_user=\nmunin_password=\nmonitor_system_updates=y\nmigration_mode=n\n\n[mail]\nmodule=postfix_mysql\nmaildir_path=/var/vmail/[domain]/[localpart]\nhomedir_path=/var/vmail\nmaildir_format=maildir\ndkim_path=/var/lib/amavis/dkim\ndkim_strength=1024\npop3_imap_daemon=dovecot\nmail_filter_syntax=sieve\nmailuser_uid=5000\nmailuser_gid=5000\nmailuser_name=vmail\nmailuser_group=vmail\nmailbox_virtual_uidgid_maps=n\nrelayhost=\nrelayhost_user=\nrelayhost_password=\nmailbox_size_limit=0\nmessage_size_limit=0\nmailbox_quota_stats=y\nrealtime_blackhole_list=zen.spamhaus.org\noverquota_notify_admin=y\noverquota_notify_client=y\noverquota_notify_freq=7\noverquota_notify_onok=n\nsendmail_path=/usr/sbin/sendmail\n\n[getmail]\ngetmail_config_dir=/etc/getmail\n\n[web]\nserver_type=apache\nwebsite_basedir=/var/www\nwebsite_path=/var/www/clients/client[client_id]/web[website_id]\nwebsite_symlinks=/var/www/[website_domain]/:/var/www/clients/client[client_id]/[website_domain]/\nwebsite_symlinks_rel=n\nnetwork_filesystem=n\nvhost_conf_dir=/etc/httpd/conf/sites-available\nvhost_conf_enabled_dir=/etc/httpd/conf/sites-enabled\nnginx_vhost_conf_dir=/etc/nginx/sites-available\nnginx_vhost_conf_enabled_dir=/etc/nginx/sites-enabled\nsecurity_level=20\nuser=apache\ngroup=apache\nnginx_user=nginx\nnginx_group=nginx\napps_vhost_enabled=y\napps_vhost_port=8081\napps_vhost_ip=_default_\napps_vhost_servername=\nphp_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:/dev/random:/dev/urandom\nhtaccess_allow_override=All\nawstats_conf_dir=/etc/awstats\nawstats_data_dir=/var/lib/awstats\nawstats_pl=/usr/lib/cgi-bin/awstats.pl\nawstats_buildstaticpages_pl=/usr/share/awstats/tools/awstats_buildstaticpages.pl\nphp_ini_path_apache=/etc/php.ini\nphp_ini_path_cgi=/etc/php.ini\ncheck_apache_config=y\nenable_sni=y\nenable_spdy=n\nskip_le_check=n\nenable_ip_wildcard=y\novertraffic_notify_admin=y\novertraffic_notify_client=y\nnginx_cgi_socket=/var/run/fcgiwrap.socket\nphp_fpm_init_script=php-fpm\nphp_fpm_ini_path=/etc/php.ini\nphp_fpm_pool_dir=/etc/php-fpm.d\nphp_fpm_start_port=9010\nphp_fpm_socket_dir=/var/lib/php5-fpm\nset_folder_permissions_on_update=n\nadd_web_users_to_sshusers_group=y\nconnect_userid_to_webid=n\nconnect_userid_to_webid_start=10000\nweb_folder_protection=y\nphp_ini_check_minutes=1\noverquota_notify_admin=y\noverquota_notify_client=y\noverquota_notify_freq=7\noverquota_db_notify_admin=y\noverquota_db_notify_client=y\noverquota_notify_onok=n\n\n[dns]\nbind_user=named\nbind_group=named\nbind_zonefiles_dir=/var/named\nnamed_conf_path=/etc/named.conf\nnamed_conf_local_path=/etc/named.conf.local\ndisable_bind_log=n\n\n[fastcgi]\nfastcgi_starter_path=/var/www/php-fcgi-scripts/[system_user]/\nfastcgi_starter_script=.php-fcgi-starter\nfastcgi_alias=/php/\nfastcgi_phpini_path=/etc/\nfastcgi_children=8\nfastcgi_max_requests=5000\nfastcgi_bin=/usr/bin/php-cgi\nfastcgi_config_syntax=2\n\n[jailkit]\njailkit_chroot_home=/home/[username]\njailkit_chroot_app_sections=basicshell editors extendedshell netutils ssh sftp scp groups jk_lsh\njailkit_chroot_app_programs=/usr/bin/groups /usr/bin/id /usr/bin/dircolors /bin/basename /usr/bin/dirname /usr/bin/nano\njailkit_chroot_cron_programs=/usr/bin/php /usr/bin/perl /usr/share/perl /usr/share/php\n\n[vlogger]\nconfig_dir=/etc\n\n[cron]\ninit_script=cron\ncrontab_dir=/etc/cron.d\nwget=/usr/bin/wget\n\n[rescue]\ntry_rescue=n\ndo_not_try_rescue_httpd=n\ndo_not_try_rescue_mysql=n\ndo_not_try_rescue_mail=n\n\n[xmpp]\nxmpp_use_ispv6=n\nxmpp_bosh_max_inactivity=30\[email protected], [email protected]\nxmpp_modules_enabled=saslauth, tls, dialback, disco, discoitems, version, uptime, time, ping, admin_adhoc, admin_telnet, bosh, posix, announce, offline, webpresence, mam, stream_management, message_carbons\nxmpp_port_http=5290\nxmpp_port_https=5291\nxmpp_port_pastebin=5292\nxmpp_port_bosh=5280\n\n', 3, 0, 84, 1);
    
    This is a generic record from a CentOS 7 apache server. You'll have to edit the IP address and server hostname in ISPConfig under system > server config afterwards.
     
  7. slh69

    slh69 New Member

    It worked, thanks for the solution :):)
     

Share This Page