ERROR: The requested document type does not exist.

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?

 

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?

 

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

 

What's the output of

Code:

ls -la /home/admispconfig/ispconfig/web

?

 

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

 

Any idea please?

 

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

 

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

 

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

 

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

 

Does it work if you undo these changes?

 

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

If you tell me where is files related to database requests for page choosing I can test it a little ..

 

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

 

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

 

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

 

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.

 

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

 

Unfortunatelly I didn't fugured out this problem 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 .. I am not gentoo guru so I will try ubuntu perfect setup .. I hope I will be successful