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?