Koozali.org: home of the SME Server
Obsolete Releases => SME 8.x Contribs => Topic started by: mealogav on July 04, 2013, 10:51:22 AM
-
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
-
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.
-
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
-
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
-
mealogav
Only https://yourdomain.com/phpmyadmin works.
Sorry my original reply was not correct, I meant to say the above.
-
No worries.
I still can't see why /phpMyAdmin doesn't work .... But at least I've got it working now!
Thanks, Gavin
-
You should change the Title to SOLVED:
-
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.
-
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 /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
rpm -ql smeserver-phpmyadmin
shows the location for the templates.
nano /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
to see the alias
-
If you really need the capability of using any verions of /PhPMyAdMiN
Then you may want to look into the AliasMatch Syntax
Also 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:
-
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.