Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have remote server pgsqldb01 where I have postgresql and mysql databases installed, and then I have websrv02, where I try to deploy phpMyAdmin and phpPgAdmin. My DB server is running openSUSE 12.2 and webserver is running CentOS 6.3

If I try to log-in using vhosted phppgadmin and phpmyadmin, both of these webapps freeze, unable to log-in to DB servers, with no error messages. I have already configured selinux to allow remote connections to DB servers

httpd_can_network_connect --> on
httpd_can_network_connect_cobbler --> off
httpd_can_network_connect_db --> on
httpd_can_network_memcache --> off
httpd_can_network_relay --> off


<VirtualHost *:80>
    ServerAdmin webmaster@stopkaconsulting.eu
    ServerName phpmyadmin.kosare.perlur.cz
    DocumentRoot /var/www/phpMyAdmin-3.5.5-all-languages/

    ErrorLog /var/log/httpd/phpmyadmin.kosare.perlur.cz-error_log
    CustomLog /var/log/httpd/phpmyadmin.kosare.perlur.cz-access_log combined

    # don't loose time with IP address lookups
    HostnameLookups Off

    # needed for named virtual hosts
    UseCanonicalName On

    # configures the footer on server-generated documents
    ServerSignature On


    <Directory "/var/www/phpMyAdmin-3.5.5-all-languages/">
        Options FollowSymLinks
        Order allow,deny
        Allow from all
    </Directory>

</VirtualHost>

I can connect from websrv02 to MySQL on pgsqldb01 using mysql command line client, as well as I can create a table in MySQL server using simple php script from both php-cli and php in Apache2 webserver, however phpmyadmin on http://phpmyadmin.kosare.perlur.cz/ still does not connect to database...

I have following configuration in config.inc.php

/* Servers configuration */
$i = 0;

/* Server: pgsqldb01 [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'pgsqldb01';
$cfg['Servers'][$i]['host'] = 'pgsqldb01.kosare.perlur.cz';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['ssl'] = false;

/* End of servers configuration */

Does anyone have a clue where could be a problem?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.