Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x Contribs => Topic started by: groyk on October 24, 2023, 09:07:03 PM

Title: private / public access PhpMyAdmin
Post by: groyk 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.

Title: Re: private / public access PhpMyAdmin
Post by: Jean-Philippe Pialasse 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 ….

Title: Re: private / public access PhpMyAdmin
Post by: groyk 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.

Quote from: Jean-Philippe Pialasse 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 ….

Title: Re: private / public access PhpMyAdmin
Post by: Jean-Philippe Pialasse 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 ;)

Title: Re: private / public access PhpMyAdmin
Post by: Jean-Philippe Pialasse 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.

Title: Re: private / public access PhpMyAdmin
Post by: Jean-Philippe Pialasse 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.

Title: Re: private / public access PhpMyAdmin
Post by: groyk 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"

Title: Re: private / public access PhpMyAdmin
Post by: TerryF on November 04, 2023, 10:55:14 AM

Quote from: groyk on November 04, 2023, 10:02:13 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...