Topic: Can't access phpMyAdmin properly

[ddougan]

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

[Garfield]

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.

[ddougan]

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.

[wilmsoft]

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

Any other ideas?

[jimb]

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