Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: ddougan on August 25, 2004, 05:01:38 AM

Title: Can't access phpMyAdmin properly
Post by: ddougan on August 25, 2004, 05:01:38 AM

As part of trying to debug a problem I have with accessing Webmail (on a fresh 6.0 installation), I've installed NightSpirit's phpMyAdmin contrib. However, when I get the login dialog box, and type admin and the system admin password, it does not take. In the httpd error log, I see the following:

[error] access to /opt/administration/phpmyadmin failed for 192.168.1.1, reason: AuthExtern pwauth [/usr/lib/apache/pwauth]: Failed (255) for user admin

I'm definitely using the correct password, so I'm at a loss - I've used phpMyAdmin on my own boxes for a long time, and haven't had this error.

Can anyone shed any light on what's happening? I've compared the phpmyadmin section in my own server's http.conf with the one on the server with this problem and they're identical.

Thanks,

Des

Title: Can't access phpMyAdmin properly
Post by: Garfield on August 25, 2004, 10:16:17 AM

Hi,

This has been discussed at least twice in the past few weeks. use the search function on this site and you'll find the answer. As of SME 6 per default no remote access to MySQL is allowed. On these forums and in the release notes the commands needed to enable this can be found.

Title: Can't access phpMyAdmin properly
Post by: ddougan on August 25, 2004, 03:41:10 PM

I have searched here, and did find the references you noted. I don't believe this is the cause - I've tried via an SSH tunnel, and also from the server command line using lynx and still get the problem.

Title: still no work....
Post by: wilmsoft on August 25, 2004, 03:53:26 PM

I've tried connecting using mysql control panel and did Items 1 and 2 but, it still won't connect!

Any other ideas? :oops:

Title: Can't access phpMyAdmin properly
Post by: jimb on August 27, 2004, 10:11:38 AM

I had the same problem ... finally solved it with a hack using an old howto from Darrell May
"Howto implement website access for internal/external users"

http://mirror.contribs.org/smeserver/contribs/dmay/mitel/howto/website-access-security-howto.html
It involves making a separate htpasswd file for /opt/administration/phpmyadmin and changing /etc/httpd.conf to suit

Nothing I did made AuthExternal pwauth [/usr/lib/apache/pwauth]
work. (it uses /etc/shadow for authentication)

I will file a bug report next week if you don't beat me to it.
Its getting late...
Cheers
JimB