Koozali.org: home of the SME Server

private / public access PhpMyAdmin

Offline groyk

  • *
  • 138
  • +0/-0
private / public access PhpMyAdmin
« on: October 24, 2023, 09:07:03 PM »
Hi SME users

anyone tested if private access works in PhpMyAdmin on SME 10?

Just tested today. It shows that i can connect to phpmyadmin when "config setprop phpmyadmin access" is set to private.

SME box is server only, and behind firewall forwarding port 80.

I dont know if it is because of the firewall. But I think it is a bug.

server manager and local ibays are not reachable from wan side.

Offline Jean-Philippe Pialasse

  • *
  • 2,765
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: private / public access PhpMyAdmin
« Reply #1 on: October 24, 2023, 09:44:13 PM »
any template custom?
phpmyadmin should not be used over port 80 ( and could not by default) but port 443 with SSL ….

Offline groyk

  • *
  • 138
  • +0/-0
Re: private / public access PhpMyAdmin
« Reply #2 on: October 24, 2023, 10:10:51 PM »
Sorry port 443 is offcourse also forwarded :-)

I don't think I have any custom templates related to this issue.


any template custom?
phpmyadmin should not be used over port 80 ( and could not by default) but port 443 with SSL ….

Offline Jean-Philippe Pialasse

  • *
  • 2,765
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: private / public access PhpMyAdmin
« Reply #3 on: October 24, 2023, 11:30:44 PM »
first check all rpm are up to date contribs and core.

any httpd.conf custom template could be related to this issue. 
The thing is httpd 2.4 is between two way of handling access the former  one (allow|deny) and the new way with Require/satisfy.

if you have any old way allowing access the previous way to root then this will override the other new that are used for phpmyadmin, and might create such a behaviour.  so do not just « don’t think ». check ;)


Offline Jean-Philippe Pialasse

  • *
  • 2,765
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: private / public access PhpMyAdmin
« Reply #4 on: October 25, 2023, 03:21:54 AM »
known bug referenced on the bugzilla see https://bugs.koozali.org/show_bug.cgi?id=12343

this will only affect the admin login not the multiuser.  indeed due to location precedence the directory is ignored with its reference to local ip only.  to fix we should simply add this reference again in location section.

Offline Jean-Philippe Pialasse

  • *
  • 2,765
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: private / public access PhpMyAdmin
« Reply #5 on: October 27, 2023, 02:14:11 AM »
there is a fixed rpm available in smetest

yum install smeserver-phpmyadmin --enablerepo=smetest

please report if this fixes it for you.

Offline groyk

  • *
  • 138
  • +0/-0
Re: private / public access PhpMyAdmin
« Reply #6 on: November 04, 2023, 10:02:13 AM »
Hi Jean-Philippe

Just tested with success, thank you.

Tried to view the bug with no luck.

I am getting following error when logged in.

"You are not authorized to access bug #12343"

Offline TerryF

  • grumpy old man
  • *
  • 1,826
  • +6/-0
Re: private / public access PhpMyAdmin
« Reply #7 on: November 04, 2023, 10:55:14 AM »
Tried to view the bug with no luck.

I am getting following error when logged in.

"You are not authorized to access bug #12343"

Try again you have been added to the CC list...
--
qui scribit bis legit