apache - phpMyAdmin SSL configuration -


i have 2 mysql users, regular 'tommy' , control user 'tommy_ctl'
apache httpd 2.4.7 runs on 9090 http , 9080 https

phpmyadmin (v4.1.6) config.inc.php file has user/password 'tommy_ctl'
logging phpmyadmin home page 'tommy'

now
a) in config.inc.php

$cfg['servers'][$i]['ssl'] = false;   $cfg['forcessl'] = false; 

i can logon

http://linuxboxa:9090/phpmyadmin/index.php   https://linuxboxa:9080/phpmyadmin/index.php 

b) when set

$cfg['servers'][$i]['ssl'] = true;  

why

https://linuxboxa:9080/phpmyadmin/index.php  

on logon give error ?:

 #1043 cannot log in mysql server    connection controluser defined in configuration failed   

is ssl option not communication on apache?

c) when set

$cfg['servers'][$i]['ssl'] = true;   $cfg['forcessl'] = true;   

the https 9080 url takes many many seconds open

https://lnappd201.hphc.org:9080/phpmyadmin/index.php   

and on logon becomes

https://lnappd201.hphc.org/phpmyadmin/index.php?token=23771cb3b3851979903c6eb233465fd8   

note, there's no port# in redirected url

also,

http://lnappd201.hphc.org:9090/phpmyadmin/index.php  

becomes (without logon)

https://lnappd201.hphc.org/phpmyadmin/?sid   

when 'forcessl' set, phpmyadmin apparently doesn't know apache ssl on port 9080,
how forcessl option work?

my intention is, if apache running on both ports, want phpmyadmin use ssl , forcessl (to apache ssl)

$cfg['servers'][$i]['ssl'] communication between web server , mysql server.

$cfg['forcessl'] should force web browser connection phpmyadmin on https.

as noted in documentation forcessl, enabling in configurations (i suspect nonstandard https port may apply) require set $cfg['pmaabsoluteuri'] phpmyadmin knows port use.

hope helps!


Comments

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

SQL: Divide the sum of values in one table with the count of rows in another -