[WARNING] "document_root" not set

Hello,
Few months ago, I have installed ISPConfig on my server, created my site, ftp users and everything else without any problems. I have not installed any additional plugins, packages or updates. The problem is, that now, when I try to create another site, no new folders are created. Cronjob queue is empty, without errors or warnings (when I try to manually run server.sh script, there are no error messages). Site is created in the database. When I click on the site's settings, document root is empty. This is my ispconfig.log:

DEBUG - Calling function 'ssl' from plugin 'apache2_plugin' raised by event 'web_domain_insert'.
DEBUG - Calling function 'insert' from plugin 'apache2_plugin' raised by event 'web_domain_insert'.
WARNING - document_root not set
DEBUG - Processed datalog_id 98
Calling function 'restartHttpd' from module 'web_module'.
DEBUG - Restarting httpd: systemctl reload apache2.service
DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
DEBUG - Info: php.ini change checking not enabled or not in this minute:
DEBUG - Found 2 changes, starting update process.
DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'.
DEBUG - Processed datalog_id 99
DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
DEBUG - Processed datalog_id 100
DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
DEBUG - Info: php.ini change checking not enabled or not in this minute:
DEBUG - Found 2 changes, starting update process.
DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
DEBUG - Processed datalog_id 101
DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
DEBUG - Created MySQL database: xxx
DEBUG - Calling GRANT for xxx with access rw and hosts localhost
DEBUG - GRANT for user xxx at host localhost
DEBUG - GRANT ALL PRIVILEGES ON `xxx`.* TO 'xxx'@'localhost' IDENTIFIED BY PASSWORD 'pass' success? yes

What went wrong? It seems like a permission problem, but I have not touched any permissions to any folder on the server since the initial installation.

Thanks in advance for your help.

 

Hello, after enabling let's encrypt, it seems my server got messed up a little in a similar way as described in this issue.

I enabled Let's encrypt according to the IspConfig3 manual. All worked fine. I added a new website, database, shell user, database user: all went fine. I added (as root) a few python packages which that site requires. All went fine.

A week or so later, I try to add a new website. The docroot is empty, no user, no group. Suspicious. I create a few more dummy sites, same result. I check the log and find this warning:
WARNING - Falsche Anfrage / Wrong QuerySQL-Query = SELECT database_id, database_name, sys_groupid, database_quota, quota_exceeded FROM web_database WHERE server_id = 1 GROUP BY sys_groupid, database_name ASC -> 1055 (Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dbispconfig.web_database.database_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)

According to faqforge ispconfig3 how-to-enable-debugging-in-ispconfig-3 i enable debug logging, and I find no obvious extra info except for:
WARNING - document_root not set
after I created another test site.

So I do as Till recommends, and check the paths under system > server config > web in ISPConfig and to my ghorror I notice all info on that page is blanck! Detail below. Any idea why this happened? I did nothing else except what I mentioned in this posting, and surely didn't touch those fields. How to recover from this, since the default values (which I surely used) are not mentioned.

Website basedir is empty.
Invalid website basedir path, min. length 5 chars.
Website path is empty.
website_path_error_regex
Website symlinks is empty.
Invalid website symlinks.
Vhost config dir is empty.
Invalid vhost config directory.
Vhost config enabled dir is empty.
Invalid vhost conf enabled directory.
Nginx Vhost config dir is empty.
Invalid nginx config directory.
Nginx Vhost config enabled dir is empty.
Invalid nginx conf enabled directory.
Apache user is empty.
Invalid apache user.
Apache group is empty.
Invalid apache group.
Nginx user is empty.
Invalid nginx user.
Nginx group is empty.
Invalid nginx group.
Apache php.ini path is empty.
Invalid apache php.ini path.
CGI php.ini path is empty.
Invalid cgi php.ini path.
Description Default PHP-Version must not be empty
PHP-FPM init script is empty.
Invalid php-fpm init script.
PHP-FPM php.ini path is empty.
Invalid php-fpm ini path.
PHP-FPM pool directory is empty.
Invalid php-fpm pool directory.
PHP-FPM socket directory is empty.
Invalid php-fpm socket directory.
PHP open_basedir is empty.
Invalid php open_basedir.
Nginx CGI Socket is empty.
nginx_cgi_socket_error_regex
.htaccess AllowOverride is empty.
Apps-vhost port is empty.
Apps-vhost IP is empty.
awstats data directory is empty
Invalid awstats data directory.
awstats.pl setting is empty.
Invalid awstats.pl path.
awstats_buildstaticpages.pl is empty
Invalid awstats_buildstaticpages.pl path.

 

Most probably all values would be restored again if the error of the query below would be fixed, but I rather not make any changes to the DB without you telling me to:
WARNING - Falsche Anfrage / Wrong QuerySQL-Query = SELECT database_id, database_name, sys_groupid, database_quota, quota_exceeded FROM web_database WHERE server_id = 1 GROUP BY sys_groupid, database_name ASC -> 1055 (Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dbispconfig.web_database.database_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)

 

Hi Till, thanks for replying. I followed https medium.com/@kasunsiyambalapitiya/fixing-this-is-incompatible-with-sql-mode-only-full-group-by-in-mysql-de811ed35ae9 and the sql error has disappeared. Unfortunately the 'web' values of my server config are still all gone (and I have no idea why).

p272 of the ISPConfig manual does indicate some default values. Should I use these, or is there still something else I could try first?

 

(also I'm howtoforge forum member since 2008, but the forum indicates me as 'new member' which isn't correct ;-) )

 

I always found what I needed, except for today.
Anyway, I'm a little worried about why this problem appeared on my server. I've been using ISPConfig since 2008 and never had any problem with it.

 

someone had a similar issue with the web section missing in the database previously.

this thread: https://www.howtoforge.com/community/threads/ispconfig-3-1-14p2-web-serv-er-config-missing.82509/
contains a list of the default values for the web section, and suggestions for what may be the easiest way to restore them.

 

Thanks!
I've added the values, but cannot submit (as was the case in the link you gave):

Nginx Vhost config dir is empty.
Invalid nginx config directory.
Nginx Vhost config enabled dir is empty.
Invalid nginx conf enabled directory.
Nginx user is empty.
Invalid nginx user.
Nginx group is empty.
Invalid nginx group.
Nginx CGI Socket is empty.
nginx_cgi_socket_error_regex

So I gave phpMyAdmin a try (UPDATE `server` SET `config`...). All fine now. But still I have no clue why only this section disappeared. Really, only me administering, and I didn't touch any such settings...