PHPMYADMIN not found or wrong link in the ISPConfig 3

Discussion in 'Installation/Configuration' started by vaio1, Feb 18, 2011.

  1. vaio1

    vaio1 ISPConfig Developer

    Hi guys,

    maybe I have found a little error in the ispconfig layout. If I click at the connection database link button at the database management page, I am redirected at the http://dbserver.mydomain.com/phpmyadmin.

    As described in the manual the phpmyadmin has been installed in the webserver and not in the dbserver.

    So what happens?
     

    Attached Files:

  2. vaio1

    vaio1 ISPConfig Developer

    The problem is within the Interface Config.

    The default phpmyadmin link must be http://webserver.mydomain.com/phpmyadmin

    At the moment the link is http://dbserver.mydomain.com/phpmyadmin ;)

    Furthermore the phpmyadmin config file is wrong:

    Code:
    
      GNU nano 2.2.4                    File: config.inc.php                                              
    
    <?php
    /**
     * Please, do not edit this file. The configuration file for Debian
     * is located in the /etc/phpmyadmin directory.
     */
    
    // Load secret generated on postinst
    include('/var/lib/phpmyadmin/blowfish_secret.inc.php');
    
    // Load autoconf local config
    include('/var/lib/phpmyadmin/config.inc.php');
    
    // Load user's local config
    include('/etc/phpmyadmin/config.inc.php');
    
    // Set the default server if there is no defined
    if (!isset($cfg['Servers'])) {
        $cfg['Servers'][1]['host'] = 'localhost';
    }
    
    $cfg['Servers'][1]['host'] = "dbserver.mydomain.com";
    
    // Set the default values for $cfg['Servers'] entries
    for ($i=1; (!empty($cfg['Servers'][$i]['host']) || (isset($cfg['Servers'][$i]['connect_type']) && $cf$
        if (!isset($cfg['Servers'][$i]['auth_type'])) {
            $cfg['Servers'][$i]['auth_type'] = 'cookie';
        }
        if (!isset($cfg['Servers'][$i]['host'])) {
            $cfg['Servers'][$i]['host'] = 'localhost';
        }
        if (!isset($cfg['Servers'][$i]['connect_type'])) {
            $cfg['Servers'][$i]['connect_type'] = 'tcp';
        }
        if (!isset($cfg['Servers'][$i]['compress'])) {
            $cfg['Servers'][$i]['compress'] = false;
        }
        if (!isset($cfg['Servers'][$i]['extension'])) {
            $cfg['Servers'][$i]['extension'] = 'mysql';
        }
    }
    
    
    Regards

    Regards
     
  3. vaio1

    vaio1 ISPConfig Developer

    Furthermore if a database is not enabled for the remote connection the phpmyadmin doesn't accept the requests.

    If the DBServer is configured with the multiserver setup, the users permissions must be set with the host webserver.mydomain.com otherwise they cannot connect using the phpmyadmin software.

    The workaround is enable them to using a remote connection and this is not a good idea at all. So why ispConfig doesn't set the right permission?

    thanks
     
  4. falko

    falko Super Moderator

    You can configure the phpMyAdmin link in ISPConfig's system settings.
     
  5. vaio1

    vaio1 ISPConfig Developer

    Hi Falko,

    anyway the databases can be read only if I select the remote access in the control panel. Is there a way to solve this problem?

    thanks
     
  6. falko

    falko Super Moderator

    Are the databases installed on a different server than phpMyAdmin?
     
  7. falko

    falko Super Moderator

    Please open a new thread.
     
  8. dvancamp

    dvancamp New Member

    Sorry to jump in

    I'm experiencing the same issue as mturillo on the multi-server setup outlined in the manual. PhpMyAdmin ends up on the webserver and is configured to connect to the localhost while the ISPConfig interface is creating client's databases on the dedicated database server.

    I manually added my db host to /etc/phpmyadmin/config.inc.php like mturillo but you still run into the problem of clients having to allow remote access to the entire internet or knowing the IP address of your main ISPConfig server.

    My first instinct was to change the defaults in the interface form (ispconfig/interface/web/sites/form/database.tform.php) and prefill the checkbox and IP address. Obviously kind of a hack that wouldn't survive upgrades.

    I see in that same database.tform.php script it pulls the database server names out of the configuration. Would it make sense to automatically grant remote access to nodes configured as webservers? Leaving the remote access checkbox and IPs to servers outside of ISPConfig control...
     

Share This Page