PHPMyAdmin not working on IPv6
- Thread starter k1l0b1t
- Start date
Seems like a problem on your side. How do you check the way you are connecting to the server?
Code:
2a02:1810:1e20:6d00:88bf:2364:ae23:41a7 - - [30/Aug/2022:13:21:01 +0200] "POST /phpMyAdmin/index.php?route=/config/get HTTP/2.0" 200 2021 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0"
2a02:1810:1e20:6d00:88bf:2364:ae23:41a7 - - [30/Aug/2022:13:21:01 +0200] "POST /phpMyAdmin/index.php?route=/navigation&ajax_request=1 HTTP/2.0" 200 4393 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0"
2a02:1810:1e20:6d00:88bf:2364:ae23:41a7 - - [30/Aug/2022:13:21:01 +0200] "POST /phpMyAdmin/index.php?route=/config/get HTTP/2.0" 200 2114 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0"
2a02:1810:1e20:6d00:88bf:2364:ae23:41a7 - - [30/Aug/2022:13:21:01 +0200] "POST /phpMyAdmin/index.php?route=/version-check HTTP/2.0" 200 642 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0"
2a02:1810:1e20:6d00:88bf:2364:ae23:41a7 - - [30/Aug/2022:13:21:01 +0200] "POST /phpMyAdmin/index.php?route=/config/set HTTP/2.0" 200 2013 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0"I noticed since I finaly got IPv6 working at home, and I could not connect to phpmyadmin, when I remove the ipv6 record for my hostname it works again.
I think this happens:
- When I connect over ipv4, it works because that's the main IP and uses the default vhost (/var/www/html)
- When I connect over ipv6, it uses the shared-ip vhost instead of the default one that points to /var/www/html? There was a similar issue with roundcube ages ago.
I think this happens:
- When I connect over ipv4, it works because that's the main IP and uses the default vhost (/var/www/html)
- When I connect over ipv6, it uses the shared-ip vhost instead of the default one that points to /var/www/html? There was a similar issue with roundcube ages ago.
Yeah it sounds like it.
When i try:
- [IPv6]/phpmyadmin => works
- hostname/phpmyadmin: 404
- hostname_with_no_aaaa/phpmyadmin: works
Its a pretty bizarre situation.
some more testing:
seems that /phpmyadmin works, but the default /phpMyAdmin (to wich DA sends you, note the capitalization) does not. @fln seems like a bug of some kind?
When i try:
- [IPv6]/phpmyadmin => works
- hostname/phpmyadmin: 404
- hostname_with_no_aaaa/phpmyadmin: works
Its a pretty bizarre situation.
some more testing:
seems that /phpmyadmin works, but the default /phpMyAdmin (to wich DA sends you, note the capitalization) does not. @fln seems like a bug of some kind?
ok so I did some digging
and turns out it sure is because it's using the shared ip vhost for the IPv6
I have it linked up to the IPv4 though.
I added a few redirects in the sharedip folder and it works now.
Roundcube had the same issue.
and turns out it sure is because it's using the shared ip vhost for the IPv6
I have it linked up to the IPv4 though.
I added a few redirects in the sharedip folder and it works now.
Roundcube had the same issue.
Richard G
Verified User
Oh interesting. How did you manage to do that?
I bet i accidentaly changed that setting once. its my hobby server so i mess with it haha.
It still should redirect to the hostname though, which it didn't do.
Richard G
Verified User
Yes but I'm curious as to where that setting was. In some phpadmin config file? You customized that or something?
Its a custombuild thing.Yes but I'm curious as to where that setting was. In some phpadmin config file? You customized that or something?
toktokcity
Verified User
Old topic, but the same problem occured. The fix in CustomBuild:
Afterwards:
da build update
da build rewrite_confs
Thanks to Richard G mentioning that.
When selected 'Yes' ipv6 won't work.
Afterwards:
da build update
da build rewrite_confs
Thanks to Richard G mentioning that.
When selected 'Yes' ipv6 won't work.
Last edited:
Richard G
Verified User
Did you also update things afterwards?
da build update
da build rewrite_confs
Edit: and set the redirect_host=https://your.hostname.here before doing the above commands?
Or ssl_redirect_host= I'm not sure if this one is needed or both or what. There are topics about this on the forum.
toktokcity
Verified User
You're completely right, I did add this to the fix. I did not change the redirect_host because this was already set by the hostname without 'https://' Redirect_host_https was also set by "Yes".
Richard G
Verified User
That is correct, but still the ssl_redirect_host pointing to the hostname is required.
I've found some info here too https://forum.directadmin.com/threads/redirect_host_https.54496/#post-279367 ofcourse with rewrite_confs afterwards again (for people also reading this).
Or did you have it fixed now?
toktokcity
Verified User
For me and the customers it is working!