Problem with phpmyadmin after

Discussion in 'Installation/Configuration' started by esezako, May 18, 2012.

  1. esezako

    esezako New Member

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    And which server hostname or IP did you use to access phpmyadmin?
     
  3. esezako

    esezako New Member

    Last edited: May 18, 2012
  4. esezako

    esezako New Member

    Another problem, can't connect with "myslq -u root -h db_server -p" from web_server to db_server.
     
  5. falko

    falko Super Moderator ISPConfig Developer

    You might have to adjust the URL in the ISPConfig interface settings under System.

    I guess this is just a typo, but the command is mysql, not myslq.

    Do you get any error messages?
     
  6. esezako

    esezako New Member

    What is the correct link?


    ERROR 2003 (HY000): Can't connect to MySQL server on 'db1.nombresweb.net' (110)
     
  7. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    and
    Code:
    iptables -L
    on db1.nombresweb.net
     
  8. esezako

    esezako New Member

    Code:
    [email protected]:/# netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 127.0.0.2:smtp          *:*                     LISTEN      6401/master     
    tcp        0      0 localhost.localdom:smtp *:*                     LISTEN      6401/master     
    tcp        0      0 localhost.localdom:6010 *:*                     LISTEN      6030/0          
    tcp        0      0 *:mysql                 *:*                     LISTEN      8075/mysqld     
    tcp        0      0 *:sunrpc                *:*                     LISTEN      197/portmap     
    tcp        0      0 *:ssh                   *:*                     LISTEN      6158/sshd       
    tcp        0      0 db1.mydomain.net:47141 web1.mydomain.net:mysql TIME_WAIT   -               
    tcp        0     48 db1.mydomain.net:ssh  122.Red-**-**-**.:41745 ESTABLISHED 6030/0          
    tcp6       0      0 localhost.localdom:6010 [::]:*                  LISTEN      6030/0          
    tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      6158/sshd       
    [email protected]:/# iptables -L
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination         
    fail2ban-ssh  tcp  --  anywhere             anywhere            multiport dports ssh 
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain fail2ban-ssh (1 references)
    target     prot opt source               destination         
    RETURN     all  --  anywhere             anywhere            
    
     
  9. falko

    falko Super Moderator ISPConfig Developer

    That looks ok, MySQL is listening on all interfaces and not blocked by the server's firewall (it is however possible that there's another firewall somewhere on the way between both servers which blocks requests).

    Does the DNS record for db1.nombresweb.net point to the correct server?
     
  10. esezako

    esezako New Member

    Now work, but I marked "remote access" in database config.

    It's necessary mark "remote access"?
    For safety I have to add the ip of web server right?

    As a cluster expected this to be automatic.
     
  11. esezako

    esezako New Member

    Any idea for the phpmyadmin problem?
     
  12. falko

    falko Super Moderator ISPConfig Developer

    Where/how exactly did you install phpMyAdmin?
     
  13. esezako

    esezako New Member

    As the manual says, in the web server:


    "
    Now install Apache2, PHP5, phpMyAdmin, FCGI, suExec, Pear, and mcrypt as follows:

    apt-get -y install apache2 apache2.2-common apache2-doc apache2-mpm-prefork apache2-utils libexpat1 ssl-cert libapache2-mod-php5 php5 php5-common php5-gd php5-mysql php5-imap phpmyadmin php5-cli php5-cgi libapache2-mod-fcgid apache2-suexec php-pear php-auth php5-mcrypt mcrypt php5-imagick imagemagick libapache2-mod-suphp libopenssl-ruby libapache2-mod-ruby sudo zip wget

    "
     
  14. falko

    falko Super Moderator ISPConfig Developer

    Do you have a phpMyAdmin configuration file in /etc/apache2/conf.d/?
     
  15. esezako

    esezako New Member

    No file configuration in /etc/apache2/conf.d/
     
  16. falko

    falko Super Moderator ISPConfig Developer

    Please try this:

    Code:
    ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
    /etc/init.d/apache2 reload
     
  17. esezako

    esezako New Member

    Now works, but the open the phpmyadmin in the web1 server instead on db1 server.
     
  18. esezako

    esezako New Member

    How can i configure the phpmyadmin to manage the myslq of db1 server?

    Need I install phpmyadmin in db1 server?

    Thank's for the help.
     
  19. esezako

    esezako New Member

    If i have more than one db server, how can i configure the phpmyadmin link to open the corresponding db server?
     
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    Add all db servers in config.inc.php Or config.php) file of phpmyadmin.

    No. phpmyadmin shall only be installed on the web server.
     

Share This Page