[WARNING] "document_root" not set

Discussion in 'Installation/Configuration' started by MichalK, Jun 5, 2017.

  1. MichalK

    MichalK New Member

    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.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The paths udner system > server config > web in ISPConfig are ok?
     
  3. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

    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.
     
  4. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

    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)
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPconfig has not set that incompatible sql mode, you should reconfigure your mysql setup and remove that option.
     
  6. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

    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?
     
  7. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

    I guess this is calculated by the amount of posts and not date :)
     
  9. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

    :) 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.
     
  10. nhybgtvfr

    nhybgtvfr Active Member

  11. Jürgen Depicker

    Jürgen Depicker New Member HowtoForge Supporter

    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...
     

Share This Page