cannot connect to ispconfig

Discussion in 'Installation/Configuration' started by guidovanh, Feb 27, 2006.

  1. guidovanh

    guidovanh New Member

    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?
     
  2. falko

    falko Super Moderator ISPConfig Developer

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

    guidovanh New Member

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

    falko Super Moderator ISPConfig Developer

    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),...
     
  5. guidovanh

    guidovanh New Member

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

    guidovanh New Member

    So, who can tell me what is the login name and password to login to my ISPConfig?
     
  7. falko

    falko Super Moderator ISPConfig Developer

  8. guidovanh

    guidovanh New Member

    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?
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you enter a mysql username in the ispconfig setup that is alowed to create tables in the mysql database?
     
  10. guidovanh

    guidovanh New Member

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

    till Super Moderator Staff Member ISPConfig Developer

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

    guidovanh New Member

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

    falko Super Moderator ISPConfig Developer

    Run this on the command line:
    Code:
    mysql -u root -p
    SHOW DATABASES;
    quit;
    What's the output of the SHOW DATABASES; command?
     
  14. guidovanh

    guidovanh New Member

    Code:
    mysql> SHOW DATABASES;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | ispconfigdb        |
    | mysql              |
    | test               |
    +--------------------+
    4 rows in set (0.02 sec)
    
    Regards,
    Guido
     
  15. falko

    falko Super Moderator ISPConfig Developer

    Ok, then do this:

    Code:
    mysql -u root -p
    USE ispconfigdb;
    SHOW TABLES;
    quit;
    What's the output?
     
  16. guidovanh

    guidovanh New Member

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

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/lib/mysql
    and
    Code:
    ls -la /var/lib/mysql/ispconfigdb
    ?
     
  18. guidovanh

    guidovanh New Member

    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 #
    
     
  19. guidovanh

    guidovanh New Member

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

    falko Super Moderator ISPConfig Developer

    Please run
    Code:
    chown -R mysql:mysql /var/lib/mysql/ispconfigdb
    chmod 711 /var/lib/mysql/ispconfigdb
    and try again.
     

Share This Page