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
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
Can you check in the ISPConfig database if the table doctypes is existing and if there are any records in it?
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 ..
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."
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
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.
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
