I ran the setup of ispconfig. I choosed for https (and not for http) I entered a domain name of one of my websites (the one I want to test ISPConfig is configured correct). So I try to connect to http://www.domainname.nl:81, but the computer replies: The connection was refused when attempting to contact www.domainname.nl:81 What did I do wrong? In another topic I read about to copy my websites to the directory trr, but I have not do it at this moment. Do I have to do that first? Where can I find the directory trr?
Please post the output of Code: netstat -tap Do you try to connect from within your local network or from the outside? Did you forward port 81 from your router to your ISPConfig server? DO you use firewalls that block accesses to port 81? Does www.domainname.nl point to the correct IP address? Does your provider block port 81? Forget about this issue for now.
Code: linux:/ # netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 4592/mysqld tcp 0 0 *:netbios-ssn *:* LISTEN 4822/smbd tcp 0 0 *:sunrpc *:* LISTEN 4245/portmap tcp 0 0 *:www-http *:* LISTEN 5831/httpd tcp 0 0 *:ftp *:* LISTEN 4821/xinetd tcp 0 0 *:ipp *:* LISTEN 4428/cupsd tcp 0 0 localhost:smtp *:* LISTEN 4373/master tcp 0 0 *:microsoft-ds *:* LISTEN 4822/smbd tcp 0 0 192.168.2.100:www-http adsl-dc-40afc.ads:31056 ESTABLISHED 5838/httpd tcp 0 0 192.168.2.1:netbios-ssn 192.168.2.:availant-mgr ESTABLISHED 6824/smbd tcp 0 0 192.168.2.100:www-http adsl-dc-40afc.ads:31055 ESTABLISHED 5834/httpd tcp 0 0 *:ssh *:* LISTEN 4819/sshd tcp 0 0 localhost:smtp *:* LISTEN 4373/master linux:/ # I am connecting from within my local network I didn't. Before I asked my server for 'netstat -tap' I corrected it. Port 80 and 81 are forwarded to 192.168.2.100, my ISPConfig. Are there other ports which should forwarded to my ISPConfig? At this moment there is no firewall installed on my Linux machine, port 81 is not blocked. The correct domainname is www.samendienen.nl, which is pointed to my IP-address. If you want, try to open this URL. If the first line shows a "L" you are on my Linux-machine... No, they didn't.
ISPConfig is missing in this list which means it isn't running at all. Please start it: Code: /etc/init.d/ispconfig_server start All ports that you want to access from the outside, e.g. 21 (FTP), 22 (SSH), 25 (SMTP), 110 (POP3), 143 (IMAP), 443 (HTTPS),...
The result of this command is: Code: linux:/ # /etc/init.d/ispconfig_server start Starting ISPConfig system... /root/ispconfig/httpd/bin/apachectl startssl: httpd started Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47 No results found!ISPConfig system is now up and running! linux:/ # When I try to connect, ISPConfig represents a login screen. My manual tells me that I have to login with user admin en password admin, but I got "ERROR 101" followed by "Bad login or username" (I see this in Dutch). Because my mail is currently handled on my Windows server, the ports 25, 110, 143 and 443 are forwarded to my Windows-server.
I guess your ISPConfig database is missing. Can you check that as described here? http://www.howtoforge.com/forums/showpost.php?p=9408&postcount=10
Ok, I have a database, it's called ispconfigdb. When I enter the MySQL-command SHOW TABLES;, the result is: ERROR 1018 (HY000): Can't read dir of './ispconfigdb/' (errno: 13). What do I have to do now?
Did you enter a mysql username in the ispconfig setup that is alowed to create tables in the mysql database?
Yes, I followed the installation described on http://www.ispconfig.org/manual_installation.htm. But I'm not familiar with MySQL, so I don't know how to fill the database. The manual tells me to enter username admin and password admin, but these combination is not correct.
I'am speaking about the mysql users, not the ISPConfig login after the installation. When you raun the ISPConfig installer, you are asked for the mysql username and password and you have to enter there a mysql user that has the priveliges to add databases and tables. You dont have to fill any mysql databases manually, this is done by the installer automatically.
Please enter your MySQL server: E.G. localhost Please enter your MySQL user: E.G. root Please enter your MySQL password: Your MySQL password I entered the advised names: MySQL server: localhost MySQL user: root and I entered a password
Run this on the command line: Code: mysql -u root -p SHOW DATABASES; quit; What's the output of the SHOW DATABASES; command?
Code: mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | ispconfigdb | | mysql | | test | +--------------------+ 4 rows in set (0.02 sec) Regards, Guido
Code: linux:/home/guido # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 5.0.18-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SHOW TABLES; ERROR 1046 (3D000): No database selected mysql> USE ispconfigdb; Database changed mysql> SHOW TABLES; ERROR 1018 (HY000): Can't read dir of './ispconfigdb/' (errno: 13) mysql> Regards, Guido
Code: linux:/home/guido # ls -la /var/lib/mysql totaal 20524 drwxr-xr-x 5 mysql mysql 312 2006-03-02 21:36 . drwxr-xr-x 47 root root 1232 2006-03-02 21:49 .. -rw-rw---- 1 mysql mysql 10485760 2006-02-27 22:08 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2006-03-02 21:36 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2006-02-17 23:44 ib_logfile1 drwx------ 2 root root 5472 2006-02-27 16:51 ispconfigdb -rw-rw---- 1 mysql root 10990 2006-03-03 15:15 linux.err -rw-rw---- 1 mysql mysql 5 2006-03-02 21:36 linux.pid drwx--x--x 2 mysql mysql 1752 2006-02-17 23:44 mysql srwxrwxrwx 1 mysql mysql 0 2006-03-02 21:36 mysql.sock drwxr-xr-x 2 mysql mysql 48 2006-02-17 23:44 test linux:/home/guido #
Code: linux:/home/guido # ls -la /var/lib/mysql/ispconfigdb totaal 1209 drwx------ 2 root root 5472 2006-02-27 16:51 . drwxr-xr-x 5 mysql mysql 312 2006-03-02 21:36 .. -rw-rw---- 1 root root 65 2006-02-27 16:51 db.opt -rw-rw---- 1 root root 8806 2006-02-27 16:51 del_status.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 del_status.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 del_status.MYI -rw-rw---- 1 root root 8678 2006-02-27 16:51 dns_a.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_a.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_a.MYI -rw-rw---- 1 root root 8666 2006-02-27 16:51 dns_cname.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_cname.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_cname.MYI -rw-rw---- 1 root root 8970 2006-02-27 16:51 dns_dep.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_dep.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_dep.MYI -rw-rw---- 1 root root 9040 2006-02-27 16:51 dns_isp_dns.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_isp_dns.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_isp_dns.MYI -rw-rw---- 1 root root 8720 2006-02-27 16:51 dns_mx.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_mx.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_mx.MYI -rw-rw---- 1 root root 8904 2006-02-27 16:51 dns_nodes.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_nodes.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_nodes.MYI -rw-rw---- 1 root root 8714 2006-02-27 16:51 dns_secondary.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_secondary.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_secondary.MYI -rw-rw---- 1 root root 8906 2006-02-27 16:51 dns_spf.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 dns_spf.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 dns_spf.MYI -rw-rw---- 1 root root 8874 2006-02-27 16:51 doctype.frm -rw-rw---- 1 root root 243800 2006-02-27 16:51 doctype.MYD -rw-rw---- 1 root root 4096 2006-02-27 22:08 doctype.MYI -rw-rw---- 1 root root 8780 2006-02-27 16:51 groups.frm -rw-rw---- 1 root root 36 2006-02-27 16:51 groups.MYD -rw-rw---- 1 root root 4096 2006-02-27 22:08 groups.MYI -rw-rw---- 1 root root 8746 2006-02-27 16:51 help_documents.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 help_documents.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 help_documents.MYI -rw-rw---- 1 root root 8904 2006-02-27 16:51 help_nodes.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 help_nodes.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 help_nodes.MYI -rw-rw---- 1 root root 8936 2006-02-27 16:51 help_tickets.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 help_tickets.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 help_tickets.MYI -rw-rw---- 1 root root 8756 2006-02-27 16:51 isp_com.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_com.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_com.MYI -rw-rw---- 1 root root 8970 2006-02-27 16:51 isp_dep.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_dep.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_dep.MYI -rw-rw---- 1 root root 8992 2006-02-27 16:51 isp_dienste.frm -rw-rw---- 1 root root 44 2006-02-27 16:51 isp_dienste.MYD -rw-rw---- 1 root root 3072 2006-02-27 22:08 isp_dienste.MYI -rw-rw---- 1 root root 9252 2006-02-27 16:51 isp_fakt_artikel.frm -rw-rw---- 1 root root 396 2006-02-27 16:51 isp_fakt_artikel.MYD -rw-rw---- 1 root root 3072 2006-02-27 22:08 isp_fakt_artikel.MYI -rw-rw---- 1 root root 8970 2006-02-27 16:51 isp_fakt_dep.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_fakt_dep.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_fakt_dep.MYI -rw-rw---- 1 root root 8904 2006-02-27 16:51 isp_fakt_nodes.frm -rw-rw---- 1 root root 556 2006-02-27 16:51 isp_fakt_nodes.MYD -rw-rw---- 1 root root 5120 2006-02-27 22:08 isp_fakt_nodes.MYI -rw-rw---- 1 root root 8820 2006-02-27 16:51 isp_fakt_rechnung.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_fakt_rechnung.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_fakt_rechnung.MYI -rw-rw---- 1 root root 8996 2006-02-27 16:51 isp_fakt_record.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_fakt_record.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_fakt_record.MYI -rw-rw---- 1 root root 8816 2006-02-27 16:51 isp_firewall.frm -rw-rw---- 1 root root 392 2006-02-27 16:51 isp_firewall.MYD -rw-rw---- 1 root root 3072 2006-02-27 22:08 isp_firewall.MYI -rw-rw---- 1 root root 8770 2006-02-27 16:51 isp_htaccess.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_htaccess.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_htaccess.MYI -rw-rw---- 1 root root 8778 2006-02-27 16:51 isp_isp_actions.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_actions.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_actions.MYI -rw-rw---- 1 root root 8606 2006-02-27 16:51 isp_isp_admin.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_admin.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_admin.MYI -rw-rw---- 1 root root 8862 2006-02-27 16:51 isp_isp_datenbank.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_datenbank.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_datenbank.MYI -rw-rw---- 1 root root 9046 2006-02-27 16:51 isp_isp_domain.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_domain.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_domain.MYI -rw-rw---- 1 root root 14020 2006-02-27 16:51 isp_isp_kunde.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_kunde.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_kunde.MYI -rw-rw---- 1 root root 20110 2006-02-27 16:51 isp_isp_reseller.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_reseller.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_reseller.MYI -rw-rw---- 1 root root 9826 2006-02-27 16:51 isp_isp_user.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_user.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_user.MYI -rw-rw---- 1 root root 15680 2006-02-27 16:51 isp_isp_web.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_web.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_web.MYI -rw-rw---- 1 root root 9722 2006-02-27 16:51 isp_isp_web_template.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_isp_web_template.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_isp_web_template.MYI -rw-rw---- 1 root root 8978 2006-02-27 16:51 isp_monitor.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_monitor.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_monitor.MYI -rw-rw---- 1 root root 8904 2006-02-27 16:51 isp_nodes.frm -rw-rw---- 1 root root 140 2006-02-27 16:51 isp_nodes.MYD -rw-rw---- 1 root root 5120 2006-02-27 22:08 isp_nodes.MYI -rw-rw---- 1 root root 31534 2006-02-27 16:51 isp_server.frm -rw-rw---- 1 root root 8644 2006-02-27 16:51 isp_server_ip.frm -rw-rw---- 1 root root 24 2006-02-27 16:51 isp_server_ip.MYD -rw-rw---- 1 root root 4096 2006-02-27 22:08 isp_server_ip.MYI -rw-rw---- 1 root root 824 2006-02-27 16:51 isp_server.MYD -rw-rw---- 1 root root 4096 2006-02-27 22:08 isp_server.MYI -rw-rw---- 1 root root 8606 2006-02-27 16:51 isp_serverstatus.frm -rw-rw---- 1 root root 17 2006-02-27 16:51 isp_serverstatus.MYD -rw-rw---- 1 root root 3072 2006-02-27 22:08 isp_serverstatus.MYI -rw-rw---- 1 root root 8814 2006-02-27 16:51 isp_traffic.frm -rw-rw---- 1 root root 8770 2006-02-27 16:51 isp_traffic_ip.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_traffic_ip.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_traffic_ip.MYI -rw-rw---- 1 root root 0 2006-02-27 16:51 isp_traffic.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 isp_traffic.MYI -rw-rw---- 1 root root 8908 2006-02-27 16:51 listtype.frm -rw-rw---- 1 root root 4528 2006-02-27 16:51 listtype.MYD -rw-rw---- 1 root root 4096 2006-02-27 22:08 listtype.MYI -rw-rw---- 1 root root 8762 2006-02-27 16:51 login.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 login.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 login.MYI -rw-rw---- 1 root root 8970 2006-02-27 16:51 multidoc_dep.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 multidoc_dep.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 multidoc_dep.MYI -rw-rw---- 1 root root 8904 2006-02-27 16:51 multidoc_nodes.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 multidoc_nodes.MYD -rw-rw---- 1 root root 1024 2006-02-27 16:51 multidoc_nodes.MYI -rw-rw---- 1 root root 9122 2006-02-27 16:51 session.frm -rw-rw---- 1 root root 0 2006-02-27 16:51 session.MYD
Please run Code: chown -R mysql:mysql /var/lib/mysql/ispconfigdb chmod 711 /var/lib/mysql/ispconfigdb and try again.
