ERROR: The requested document type does not exist.

Discussion in 'Installation/Configuration' started by SupuS, May 5, 2006.

  1. SupuS

    SupuS Member HowtoForge Supporter

    Hi

    I succesfully installed ISPConfig to my server but if I log in admin I am not able create new reseller, client, dns ... atc .. I get

    Code:
    The following error occurred:
    The requested document type does not exist.
    I searched forum about this error but only one sollution I found .. about skip-networking setting. I have no skip-networking option in my /etc/mysql/my.cnf file .. so I mean this is same as commented one :)

    Here is some information which may be helpfull

    Code:
    # ps aux|grep -i mysql
    mysql    12720  0.0  5.4  90788 27900 ?        Ss   00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12726  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12727  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12728  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12729  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12730  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12731  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12732  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12733  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12734  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    mysql    12735  0.0  5.4  90788 27900 ?        S    00:47   0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    root     13412  0.0  0.0   1512   512 pts/0    S+   01:05   0:00 grep -i mysql
    Code:
    # netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 localhost:mysql         *:*                     LISTEN      12720/mysqld
    tcp        0      0 *:22                 *:*                     LISTEN      6166/sshd
    tcp        0      0 *:http                  *:*                     LISTEN      1656/apache2
    tcp        0      0 *:hosts2-ns             *:*                     LISTEN      1578/ispconfig_http
    tcp        0      0 localhost:domain        *:*                     LISTEN      1812/named
    tcp        0      0 localhost:postgresql    *:*                     LISTEN      6112/postmaster
    tcp        0      0 localhost:rndc          *:*                     LISTEN      1812/named
    I have gentoo, mysql 5 and ISPConfig Version: 2.2.2

    Any idea please?
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    First, Gentoo is not supported by ISPConfig.
    Did you get any errors during ISPConfig installation?
    What's in the error log in /root/ispconfig/httpd/logs?
     
  3. SupuS

    SupuS Member HowtoForge Supporter

    I modified setup1, dist.txt and mod/* files for gentoo and installation was succesfull. I did not found any error during installation proces.

    After install I put to /root/ispconfig/scripts/lib/classes/ispconfig_db_mysql.lib.php
    and /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php

    Code:
    mysql_query("SET character_set_client = 'latin1'");
    mysql_query("SET character_set_results = latin1");
    mysql_query("SET character_set_connection = utf8");
    due to include error.

    Here is my /root/ispconfig/httpd/logs/error_log:

    Code:
    cat /root/ispconfig/httpd/logs/error_log
    [Fri May  5 16:31:59 2006] [alert] ispconfig_httpd: Could not determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
    [Fri May  5 16:31:59 2006] [notice] Apache/1.3.34 (Unix) PHP/5.1.3 mod_ssl/2.8.25 OpenSSL/0.9.8a configured -- resuming normal operations
    [Fri May  5 16:31:59 2006] [notice] Accept mutex: sysvsem (Default: sysvsem)
    [Sat May  6 00:52:58 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/isp_dns/inhalt.php
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/globus-0.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/globus.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/vzauf-1.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/vzzu-0.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/vzzu-1.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/ini.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/vzauf-0.gif
    [Sat May  6 01:09:53 2006] [error] [client *.*.*.*] File does not exist: /home/admispconfig/ispconfig/web/help/bilder/adresse.gif
    here is end of my /root/ispconfig/httpd/logs/access_log

    Code:
    *.*.*.* - - [06/May/2006:13:17:14 +0200] "GET /isp_manager/new/reseller.php? HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:14 +0200] "GET /multidoc/edit/edit.php?doctype_id=1022& HTTP/1.1" 200 1851
    *.*.*.* - - [06/May/2006:13:17:36 +0200] "GET /isp_manager/new/kunde.php? HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:36 +0200] "GET /multidoc/edit/edit.php?doctype_id=1012& HTTP/1.1" 200 1851
    *.*.*.* - - [06/May/2006:13:17:39 +0200] "GET /isp_manager/new/web.php? HTTP/1.1" 200 2933
    *.*.*.* - - [06/May/2006:13:17:42 +0200] "GET /isp_manager/new/webtemplate.php? HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:42 +0200] "GET /multidoc/edit/edit.php?doctype_id=1030& HTTP/1.1" 200 1851
    *.*.*.* - - [06/May/2006:13:17:44 +0200] "GET /multidoc/edit/node.php? HTTP/1.1" 200 3847
    *.*.*.* - - [06/May/2006:13:17:46 +0200] "GET /isp_manager/search/index.php? HTTP/1.1" 200 2422
    *.*.*.* - - [06/May/2006:13:17:48 +0200] "GET /capp.php?app=sys HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:48 +0200] "GET /index.php? HTTP/1.1" 200 1541
    *.*.*.* - - [06/May/2006:13:17:50 +0200] "GET /admin/navigation.php? HTTP/1.1" 200 4955
    *.*.*.* - - [06/May/2006:13:17:51 +0200] "GET /admin/inhalt_tree.php? HTTP/1.1" 200 22323
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /admin/vorladen.php? HTTP/1.1" 200 569
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /admin/legende.php? HTTP/1.1" 200 373
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /admin/frame_start.php? HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /admin/placeholder.php? HTTP/1.1" 200 309
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /isp_manager/frame_start.php? HTTP/1.1" 302 5
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /design/default/icons/stamm-0.gif HTTP/1.1" 200 64
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /design/default/icons/zw0.gif HTTP/1.1" 200 66
    *.*.*.* - - [06/May/2006:13:17:52 +0200] "GET /design/default/icons/vzauf-0.gif HTTP/1.1" 200 633
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /multidoc/edit/edit.php?doc_id=3&doctype_id=1021& HTTP/1.1" 200 11659
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/zwzu-0.gif HTTP/1.1" 200 76
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/data_copy.gif HTTP/1.1" 200 628
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/data_find.gif HTTP/1.1" 200 641
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/data_ok.gif HTTP/1.1" 200 627
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/data_replace.gif HTTP/1.1" 200 625
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/lightbulb_on.gif HTTP/1.1" 200 597
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/form.gif HTTP/1.1" 200 98
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/shield_green.gif HTTP/1.1" 200 626
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/window_sidebar.gif HTTP/1.1" 200 368
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/preferences.gif HTTP/1.1" 200 640
    *.*.*.* - - [06/May/2006:13:17:53 +0200] "GET /design/default/icons/server_to_client.gif HTTP/1.1" 200 635
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    What's the output of
    Code:
    ls -la /home/admispconfig/ispconfig/web
    ?
     
  5. SupuS

    SupuS Member HowtoForge Supporter

    Code:
    # ls -la /home/admispconfig/ispconfig/web
    total 112
    drwxr-xr-x 15 admispconfig admispconfig 4096 May  6 19:45 .
    drwxr-xr-x  8 admispconfig admispconfig 4096 May  6 19:45 ..
    drwxr-xr-x  5 admispconfig admispconfig 4096 May  6 19:45 admin
    -rwxr-xr-x  1 admispconfig admispconfig 2777 May  6 19:45 capp.php
    drwxr-xr-x  5 admispconfig admispconfig 4096 May  6 19:45 design
    -rwxr-xr-x  1 admispconfig admispconfig 3638 May  6 19:45 favicon.ico
    drwxr-xr-x  7 admispconfig admispconfig 4096 May  6 19:45 help
    -rwxr-xr-x  1 admispconfig admispconfig  232 May  6 19:45 index.html
    -rwxr-xr-x  1 admispconfig admispconfig 3878 May  6 19:45 index.php
    drwxr-xr-x  6 admispconfig admispconfig 4096 May  6 19:45 isp_dns
    drwxr-xr-x  9 admispconfig admispconfig 4096 May  6 19:45 isp_fakt
    drwxr-xr-x  6 admispconfig admispconfig 4096 May  6 19:45 isp_file
    drwxr-xr-x  6 admispconfig admispconfig 4096 May  6 19:45 isp_kunde
    drwxr-xr-x  6 admispconfig admispconfig 4096 May  6 19:45 isp_manager
    drwxr-xr-x  3 admispconfig admispconfig 4096 May  6 19:45 login
    -rwxr-xr-x  1 admispconfig admispconfig 4964 May  6 19:45 login.php
    -rwxr-xr-x  1 admispconfig admispconfig 1974 May  6 19:45 logoff.php
    -rwxr-xr-x  1 admispconfig admispconfig  210 May  6 19:45 logout_fehler.htm
    drwxr-xr-x  7 admispconfig admispconfig 4096 May  6 19:45 mailuser
    drwxr-xr-x 12 admispconfig admispconfig 4096 May  6 19:45 multidoc
    -rwxr-xr-x  1 admispconfig admispconfig   72 May  6 19:45 mybookmark.css
    -rwxr-xr-x  1 admispconfig admispconfig  197 May  6 19:45 placeholder.htm
    -rwxr-xr-x  1 admispconfig admispconfig 1858 May  6 19:45 placeholder.php
    -rwxr-xr-x  1 admispconfig admispconfig 1626 May  6 19:45 start.php
    -rwxr-xr-x  1 admispconfig admispconfig   72 May  6 19:45 style.css
    drwxr-xr-x  2 admispconfig admispconfig 4096 May  6 19:45 templates
    drwxr-xr-x  5 admispconfig admispconfig 4096 May  6 19:45 tools
    
     
  6. SupuS

    SupuS Member HowtoForge Supporter

    Any idea please?
     
  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Can you check in the ISPConfig database if the table doctypes is existing and if there are any records in it?
     
  8. SupuS

    SupuS Member HowtoForge Supporter

    I found doctype table only .. is this what you mean? In this table are 26 rows of records.
     
  9. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    That's ok. So what exactly did you do before you saw this error?
     
  10. SupuS

    SupuS Member HowtoForge Supporter

    I installed ISPConfig for the first time .. and this error shows all the time .. (I reinstall several times) .. so this is my install process

    1. extract archive
    2. edit setup1, dist.txt and mod/* files
    3. run setup
    4. insert information about certificates
    5. insert database user and password
    6. installation end
    7. modify vim /root/ispconfig/scripts/lib/classes/ispconfig_db_mysql.lib.php and vim /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php
    as I described above
    8. go to the website of ISPConfig and login
    9. check if error persist .. and .. error is here again ..

    All sucessfuly installed and database is created with utf encoding.

    Is possible to miss some important software without install error?
    What about charset encoding?

    I have no idea what is wrong .. :mad:
     
    Last edited: May 7, 2006
  11. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Does it work if you undo these changes?
     
  12. SupuS

    SupuS Member HowtoForge Supporter

    No .. I get same error and even I am not able go to another page due to php include error .. :confused:

    If you tell me where is files related to database requests for page choosing I can test it a little ..
     
    Last edited: May 8, 2006
  13. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    The files are in /home/admispconfig/ispconfig/web. The important PHP classes are in /home/admispconfig/ispconfig/lib/classes.
     
  14. Reepicheep

    Reepicheep New Member

    SupuS, did you get this figured out. I am getting the same errors. I also am using gentoo. I had ISPconfig working perfectly on a gentoo ppc system with ISPconfig 2.2.1. Now I installed ISPconfig 2.2.2 on a x86 machine and get the same errors you had. I also had to modify ispconfig_db_mysql.lib.php to get mysql to use the correct character set.

    It also seems to me that it has something to do with:
    /multidoc/edit/edit.php

    as I watch the access.log every time that page is called I get the error:
    "The requested document type does not exist."
     
    Last edited: May 16, 2006
  15. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    I think it has something to do with MySQL's charset on Gentoo...
     
  16. Reepicheep

    Reepicheep New Member

    Yeah.. there is an issue with mysql charset but that keeps you from going to any page, and is fixed by adding some charset definitions to the ispconfig_db_mysql.lib.php file.

    With this problem, most pages work with the exeption of, from what I can tell, any page that calls multidoc/edit/edit.php. When I try to go to a page that calls multidoc/edit/edit.php I get a "The requested document type does not exist." error.
     
  17. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Please check if the "doctype" table is not empty in the database.
     
  18. Reepicheep

    Reepicheep New Member

    the doctype table is not empty it has 26 rows.

    I don't know what they are supposed to look like but when I select all the data from doctype the last 50 or so lines displayed are just dashes repeated line after line.

    do you think that still could be a "charset" issue if so do you know where or what I could look for?

    Thanks
     
  19. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    It might be an charset issue. The doctypes are serialaized PHP objects, if PHP is unable to unserialaize it, you might get this error. For example, the content of the field doctype_def in the doctype table with the doctype_id = 1 shall look like in the attached file.
     

    Attached Files:

  20. SupuS

    SupuS Member HowtoForge Supporter

    Unfortunatelly I didn't fugured out this problem :mad: so I will switch to ubuntu server because of this problem however I like gentoo .. I need some virtual hosting software and I am not able to succesfully install DTC, VHCS or ISPConfig on gentoo. All howtos are out of date and all software which I tested has some issue on gentoo .. there are some gentoo users which get some software works but not me :confused: .. I am not gentoo guru so I will try ubuntu perfect setup .. I hope I will be successful :cool:
     

Share This Page