phpmyadmin installation problem
- Login o registrati per inviare commenti
Becoming somewhat frustrated trying to install phpmyadmin.
Web search reveals half a dozen 'recipes' for fixing the problem,
none of which work. I don't know why the apt-get installer doesn't
get it right in the first place; I expect I have somehow managed to
make my system non-standard in some way, but don't know enough about
Apache2 configuration to see what.
I'm running Trisquel Belenos, and it is kept updated.
Based on (admittedly outdated) instructions at:
https://trisquel.info/en/wiki/installing-trisquel-server
I did the following:
# aptitude install apache2
# aptitude install mysql-server phpmyadmin php5 php5-mysql
And from a suggestion here:
https://trisquel.info/en/forum/trisquel-server-0
I created the file
/var/www/html/index.php
which caused the browser to display a huge page of info about PHP, headed:
PHP Version 5.5.9-1ubuntu4.17
so PHP looks to be working OK.
Anyway, this is what I did to install
(mysql was already installed and works fine from the command line):
# apt-get install apache2
# apt-get install phpmyadmin
All appeared to work fine; only slightly odd message was this:
Processing triggers for libc-bin (2.19-0ubuntu6.9) ...
W: Operation was interrupted before it could finish
No idea if that is significant.
Went ahead and pointed my browser (IceCat) to
localhost/phpmyadmin/
after quite a while (5-10 seconds) it showed a blank white page,
with a 'PMA' logo on the tab.
Grateful for any advice on how to debug this.
Please, no magic 'fixes', I've had enough of them,
just hints on ways to find out what phpmyadmin and/or apache2 need.
Any broken package? To discover it, you can launch the "Synaptic Package Manager" (in the "System Settings"), click the "Custom Filters" button (in the bottom-left part of the window) and choose "Broken" (above).
Nope, none broken, none upgradable.
Update:
I have tried replacing /usr/share/phpmyadmin/index.php with a simple dummy PHP script, and that displays correctly, so the problem could perhaps be that there is an error in the 'real' index.php, as a blank white page seems to be PHP's way of signaling syntax errors and such.
Further update:
Ran php on the index.php from the command line.
It output the following errors.
phpmyadmin: Failed to load /var/lib/phpmyadmin/blowfish_secret.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /var/lib/phpmyadmin/config.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions.
I checked the permissions of the files mentioned; they have read access by group www-data.
I don't know what is meant by 'open_basedir restrictions'.
Captured the output HTML from running php and attempted to display it in the browser.
It showed nothing (as expected) so edited bits out until it did.
The item causing the blank page was this:
[style]html{display: none;}[/style]
[ I do not know how to display quoted code in this forum, so have replaced the angle-brackets round the HTML tags with square brackets, otherwise it fails to display properly on the forum page. ]
Removing the 'style' tag allowed a reasonable looking page to display.
I'm not an expert on HTML, so not sure why that tag is there,
possibly it is meant to be overridden by some other included text that is missing.
The page that showed had a couple of possibly significant lines:
Javascript must be enabled past this point
and
The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!
Anyone able to throw any light here?
Have you tried alternatives like Adminer from http://adminer.org ?
It hadn't even occurred to me that there were alternatives - many thanks for the pointer!
Installed it, similar results (a 404 this time) but a quick search revealed that there are still a few manual configuration steps, for some reason not included in the package:
sudo ln -s /etc/adminer/apache.conf /etc/apache2/conf-available/adminer.conf
sudo a2enconf adminer.conf
sudo service apache2 reload
After which it worked like a charm.
I won't mark this as 'solved' because it would still be good to fix phpMyAdmin - anyone have any more ideas about what might be wrong with it?
- Login o registrati per inviare commenti