Topic: [SOLVED] phpMyAdmin installation

[mealogav]

I've installed phpMyAdmin on a newly installed and updated sme8 server, but I can't get the login page to appear.

I've read all the forum entries that seem to offer pointers - but still have the same problem.

yum reports that it's installed :

[root@databox2 phpMyAdmin]# yum list installed smeserver-phpmyadmin
Loaded plugins: fastestmirror, protect-packages, smeserver
Loading mirror speeds from cached hostfile
 * base: mirror.ox.ac.uk
 * smeaddons: mirror.chiropratique.org
 * smeextras: mirror.chiropratique.org
 * smeos: mirror.chiropratique.org
 * smeupdates: mirror.chiropratique.org
 * updates: mirror.sov.uk.goscomb.net
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Installed Packages
smeserver-phpmyadmin.noarch                             3.5.2.2-6.el5.sme                                                            installed

There are many php files in the /usr/share/phpMyAdmin  folder.

The access configuration shows as private with admin access enabled :

[root@databox2 phpMyAdmin]# config show phpmyadmin
phpmyadmin=configuration
    access=private
    adminaccess=enabled
    multiaccess=disabled

/etc/httpd/conf.d/  contains a  phpMyAdmin.conf   file.
Near the top of this file are the alias entries

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

All this looks correct to me, but when I browse to  https://databox2/phpMyAdmin   (databox2 being my hostname) from the local network all I get is a "404 Not found" error.

At the top of the  /etc/httpd/conf.d/phpMyAdmin.conf  file are the comments :

# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Surely this can't mean that by default only a browser running on the sme server can access phpMyAdmin - can it?
I'm on WinXP PC connected to the local network of the sme server.  I should be able to access phpMyAdmin from that shouldn't I?

Thanks for any help ...  Gavin

[janet]

mealogav

Try using
https://yourdomain.com/phpMyAdmin
https://yourdomain.com/phpmyadmin
I just installed that contrib & the login & pw screen opens OK in a browser from a workstation on the LAN when using the above styled URL.
The admin user login works OK too, by default.

[mealogav]

Thanks for your reply Janet,

but when I browse to  https://databox2/phpMyAdmin

It would appear that only /phpmyadmin works  (all lower case)  /phpMyAdmin  doesn't work.  Even though there is an apache alias for this and everywhere else on the internet it is refered to as phpMyAdmin!!

I can't believe that I haven't tried that before - but provided I use all lower case it just works now.

Thanks for prompting me in the right direction ...  Just got to get a procedure for installation of updates and contribs without internet access now on the production server - but that's a different thread!!

Thanks Gavin

[mealogav]

Although I notice you said you used

https://yourdomain.com/phpMyAdmin

That doesn't work for me.  Only  https://yourdomain.com/phpmyadmin  works.

If I use http://   it will redirect to https://  on port 443

but only lower case works - did /phpMyAdmin really work for you or did you actually use /phpmyadmin  ??

Thanks Gavin

[janet]

mealogav

Only  https://yourdomain.com/phpmyadmin  works.

Sorry my original reply was not correct, I meant to say the above.

[mealogav]

No worries.

I still can't see why  /phpMyAdmin   doesn't work ....  But at least I've got it working now!

Thanks,  Gavin

[newburns]

You should change the Title to SOLVED:

[mealogav]

Hmmm ... well ok - I have, but I'm not sure that it is totally solved!  It works with lower case /phpmyadmin but no one confirmed that it is not supposed to work with /phpMyAdmin and the reason why.

Anyhow as it's working maybe life's too short to worry much about it.

[newburns]

Via the Apache website
http://httpd.apache.org/docs/current/mod/mod_alias.html#page-header

The Alias directive allows documents to be stored in the local filesystem other than under the DocumentRoot. URLs with a (%-decoded) path beginning with URL-path will be mapped to local files beginning with directory-path. The URL-path is case-sensitive, even on case-insensitive file system

The alias is set in

Code: [Select]

/etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias

Code: [Select]

rpm -ql smeserver-phpmyadmin shows the location for the templates.

Code: [Select]

nano /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias to see the alias

[newburns]

If you really need the capability of using any verions of /PhPMyAdMiN

Then you may want to look into the

Code: [Select]

AliasMatch SyntaxAlso referenced in the same Apache webpage

The full range of regular expression power is available. For example, it is possible to construct an alias with case-insensitive matching of the URL-path:

[Jean-Philippe Pialasse]

please refer to the contrib wiki page  when installing a contrib everything is explained there


plus do not modify any template file, as they will be erased on update. copy them in the approriate place in templates-cutom before attempting any modification.

Please consider also that these will overule any new updates done to the original template.