phpmyadmin on Mint 18 is no-go

[dumbbunny]

Hi,

Installed Mint 18 then lamp-server and phpmyadmin on a new machine. The server works but phpmyadmin does not - just a blank page or perhaps error 500. Then tried a clean install of Mint 17 erasing Mint 18 and installed lamp-server and phpmyadmin - all works fine. How do I make phpmyadmin work on Mint 18?

Thanks for any help,
Paul

[weyland]

I have a similar problem with Mint 18 Mate.

The whole LAMP installation seemed to work fine. The server works, MySQL works, and this php script in /var/www/html/ works . . .

<?php
phpinfo();

But when I try to start http://xxx.xxx.x.xx/phpmyadmin I get a 404, The requested URL /phpmyadmin was not found on this server.

Any ideas?

[bbobbo]

is the following symlink in /etc/apache2/conf-available: phpmyadmin.conf -> ../../phpmyadmin/apache2.conf

if not, create it:

Code: Select all

cd /etc/apache2/conf-available
sudo ln -s ../../phpmyadmin/apache2.conf phpmyadmin.conf

is the following symlink in /etc/apache2/conf-enabled: phpmyadmin.conf -> ../conf-available/phpmyadmin.conf

if not, create it and restart apache:

Code: Select all

sudo a2enconf phpmyadmin
sudo /etc/init.d/apache2 restart

[weyland]

Thanks, bbobbo. Those links weren't there, but when I added them I got this . . .

Code: Select all

[Mon 2016-07-18 09:28:40]/etc/apache2/conf-enabled>> sudo ln -s ../conf-available/phpmyadmin.conf phpmyadmin.conf
[Mon 2016-07-18 09:40:04]/etc/apache2/conf-enabled>> ls -al
total 8
drwxr-xr-x 2 root root 4096 Jul 18 09:40 .
drwxr-xr-x 8 root root 4096 Jul 17 16:29 ..
lrwxrwxrwx 1 root root   30 Jul 16 11:54 charset.conf -> ../conf-available/charset.conf
lrwxrwxrwx 1 root root   44 Jul 16 11:54 localized-error-pages.conf -> ../conf-available/localized-error-pages.conf
lrwxrwxrwx 1 root root   46 Jul 16 11:54 other-vhosts-access-log.conf -> ../conf-available/other-vhosts-access-log.conf
lrwxrwxrwx 1 root root   33 Jul 18 09:40 phpmyadmin.conf -> ../conf-available/phpmyadmin.conf
lrwxrwxrwx 1 root root   31 Jul 16 11:54 security.conf -> ../conf-available/security.conf
lrwxrwxrwx 1 root root   36 Jul 16 11:54 serve-cgi-bin.conf -> ../conf-available/serve-cgi-bin.conf
[Mon 2016-07-18 09:40:07]/etc/apache2/conf-enabled>> sudo a2enconf phpmyadmin
ERROR: /etc/apache2/conf-enabled/phpmyadmin.conf is a dangling symlink!
ERROR: Conf phpmyadmin does not exist!
[Mon 2016-07-18 09:42:11]/etc/apache2>> cd ../conf-available
[Mon 2016-07-18 09:48:24]/etc/apache2/conf-available>> ls *php*
phpmyadmin.conf
[Mon 2016-07-18 09:48:32]/etc/apache2/conf-available>> ls -la
total 28
drwxr-xr-x 2 root root 4096 Jul 18 09:26 .
drwxr-xr-x 8 root root 4096 Jul 17 16:29 ..
-rw-r--r-- 1 root root  315 Mar 19 09:48 charset.conf
-rw-r--r-- 1 root root 3224 Mar 19 09:48 localized-error-pages.conf
-rw-r--r-- 1 root root  189 Mar 19 09:48 other-vhosts-access-log.conf
lrwxrwxrwx 1 root root   29 Jul 18 09:26 phpmyadmin.conf -> ../../phpmyadmin/apache2.conf
-rw-r--r-- 1 root root 2174 Mar 19 09:48 security.conf
-rw-r--r-- 1 root root  455 Mar 19 09:48 serve-cgi-bin.conf
[Mon 2016-07-18 09:49:00]/etc/apache2/conf-available>> ls ../../phpmyadmin/apache2.conf
ls: cannot access '../../phpmyadmin/apache2.conf': No such file or directory
[Mon 2016-07-18 09:56:42]/etc/apache2/conf-available>>

There's a dangling symlink after a2enconf.

It seems that the LAMP installation is far from clean, and I don't know where to go from here.

[whistlerspa]

This worked for me when I had the same problem.

Full Link: https://askubuntu.com/questions/387062/ ... and-apache

For Ubuntu 15.04 and 16.04

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
sudo a2enconf phpmyadmin.conf
sudo service apache2 reload

[bbobbo]

does /etc/phpmyadmin exist? if so, what are the contents?

[weyland]

I just get

Code: Select all

sudo a2enconf phpmyadmin.conf
ERROR: /etc/apache2/conf-enabled/phpmyadmin.conf is a dangling symlink!
ERROR: Conf phpmyadmin does not exist!

[bbobbo]

what does

ls -al /etc/phpmyadmin

give you?

[weyland]

does /etc/phpmyadmin exist? if so, what are the contents?

No. Doesn't exist.

I have the results of phpinfo() open, if that might help.

[bbobbo]

did you install phpmyadmin from repository? if so, it seems like the post-installation procedures didn't complete.

i'm going to have a bite to eat now. i'll check back in 30-60 minutes.

[weyland]

Thanks for your help, bbobbo . . .

I installed it following the instructions at https://www.digitalocean.com/community/ ... untu-16-04,

Code: Select all

sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql

[bbobbo]

what does

dpkg -l phpmyadmin

show you?

[weyland]

Doh. I've clearly been wasting your time. My only excuse is that I had no problems with LAMP on 17.3 and assumed it was almost the same set of instructions. Dropped the ball.

My apologies, and thank you.

[bbobbo]

no problem. i'm guessing you thought you installed the phpmyadmin package but actually didn't. here are instructions for anyone else who needs to know how to install phpmyadmin:

https://www.digitalocean.com/community/ ... untu-16-04

[West_Training_8668]

I tried following the instructions here http://www.2daygeek.com/install-lamp-st ... linuxmint/#
and then here https://www.digitalocean.com/community/ ... untu-16-04
but the phpMyAdmin page gives 404 error.

[bbobbo]

have you read through this thread and tried any of the other suggestions?

[dumbbunny]

Hi,

Could not get it working even though all the links etc existed as "weyland" has said. There was some update for PHP included in the system update dialog, I blindly clicked update (as I always do) and was prompted to remove phpmyadmim (didn't work anyway) which I did. After the update had finished I followed the directions:-
https://www.digitalocean.com/community/ ... untu-16-04
After re-boot it all worked.

Thanks,
Paul

[West_Training_8668]

I installed LAMP with this script:

Code: Select all

service apache2 restart && service mysql restart > /dev/null                                                            
  if [ $? -ne 0 ]; then                                                                                                   
      clear                                                                                                               
      echo "Installing apache2, php7, mysql-server"                                                                       
      sudo apt install -y apache2 mariadb-server mariadb-client                                                           
      sudo mysql_secure_installation                                                                                      
      sudo apt install -y php7.0 php7.0-mysql libapache2-mod-php7.0 \                                                     
          php7.0-mbstring php7.0-common php7.0-gd php7.0-mcrypt php-gettext \                                             
          php7.0-curl php7.0-cli                                                                                          
      sudo apt-get install -y phpmyadmin php-mbstring php-gettext
      sudo phpenmod mcrypt
      sudo phpenmod mbstring

      # Restart all the installed services to verify that everything is installed properly                                
      clear                                                                                                               
      service apache2 restart && service mysql restart > /dev/null                                                        
      if [ $? -ne 0 ]; then                                                                                               
        echo "Please Check the Install Services, There is some $(tput bold)$(tput setaf 1)Problem$(tput sgr0)"            
        else                                                                                                              
        echo "Installed Services run $(tput bold)$(tput setaf 2)Sucessfully$(tput sgr0)"                                  
        read                                                                                                              
      fi                                                                                                                  
      echo "========================================================================"                                     
  fi

The problem is it didn't ask me to write anything while installing phpmyadmin as it says here http://www.2daygeek.com/install-lamp-st ... linuxmint/#

is the following symlink in /etc/apache2/conf-available: phpmyadmin.conf -> ../../phpmyadmin/apache2.conf

if not, create it:

Code: Select all

cd /etc/apache2/conf-available
sudo ln -s ../../phpmyadmin/apache2.conf phpmyadmin.conf

is the following symlink in /etc/apache2/conf-enabled: phpmyadmin.conf -> ../conf-available/phpmyadmin.conf

if not, create it and restart apache:

Code: Select all

sudo a2enconf phpmyadmin
sudo /etc/init.d/apache2 restart

Code: Select all

user@linux /etc/apache2/conf-available $ ls
charset.conf  localized-error-pages.conf  other-vhosts-access-log.conf  security.conf  serve-cgi-bin.conf
user@linux /etc/apache2/conf-available $ sudo ln -s ../../phpmyadmin/apache2.conf phpmyadmin.conf
user@linux /etc/apache2/conf-available $ cd ../conf-enabled/
user@linux /etc/apache2/conf-enabled $ ls
charset.conf  localized-error-pages.conf  other-vhosts-access-log.conf  security.conf  serve-cgi-bin.conf
user@linux /etc/apache2/conf-enabled $ sudo ln -s ../conf-available/phpmyadmin.conf phpmyadmin.conf
user@linux /etc/apache2/conf-available $ sudo a2enconf phpmyadmin
ERROR: /etc/apache2/conf-enabled/phpmyadmin.conf is a dangling symlink!
ERROR: Conf phpmyadmin does not exist!
user@linux /etc/apache2/conf-available $ sudo /etc/init.d/apache2 restart
[....] Restarting apache2 (via systemctl): apache2.serviceJob for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.
 failed!

what does

ls -al /etc/phpmyadmin

give you?

Code: Select all

 user@linux /etc/apache2/conf-available $ ls -al /etc/phpmyadmin
total 60
drwxr-xr-x   3 root root      4096 Jul 19 13:10 .
drwxr-xr-x 152 root root     12288 Jul 21 00:38 ..
-rw-r--r--   1 root root      1448 Mar 31 04:16 apache.conf
drwxr-xr-x   2 root root      4096 Jun 17 10:44 conf.d
-rw-r-----   1 root www-data   519 Jul 19 13:04 config-db.php
-rw-r--r--   1 root root       168 Oct 29  2015 config.footer.inc.php
-rw-r--r--   1 root root       168 Oct 29  2015 config.header.inc.php
-rw-r--r--   1 root root      6319 Jan 30 15:05 config.inc.php
-rw-r-----   1 root www-data     8 Jul 19 13:04 htpasswd.setup
-rw-r--r--   1 root root       570 Oct 29  2015 lighttpd.conf
-rw-r--r--   1 root root       198 Oct 29  2015 phpmyadmin.desktop
-rw-r--r--   1 root root       295 Oct 29  2015 phpmyadmin.service

what does

dpkg -l phpmyadmin

show you?

Code: Select all

user@linux /etc/apache2/conf-available $ dpkg -l phpmyadmin
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                     Version           Architecture      Description
+++-========================-=================-=================-======================================================
ii  phpmyadmin               4:4.5.4.1-2ubuntu all               MySQL web administration tool

Hi,

Could not get it working even though all the links etc existed as "weyland" has said. There was some update for PHP included in the system update dialog, I blindly clicked update (as I always do) and was prompted to remove phpmyadmim (didn't work anyway) which I did. After the update had finished I followed the directions:-
https://www.digitalocean.com/community/ ... untu-16-04
After re-boot it all worked.

Thanks,
Paul

I'm going to try that now.

[bbobbo]

your apache configuration file in /etc/phpmyadmin is named apache.conf instead of apache2.conf. so this command:

sudo ln -s ../../phpmyadmin/apache2.conf phpmyadmin.conf

won't work for you. do:

Code: Select all

cd /etc/apache2/conf-available
sudo unlink phpmyadmin.conf
sudo ln -s ../../phpmyadmin/apache.conf phpmyadmin.conf
sudo a2enconf phpmyadmin
sudo /etc/init.d/apache2 restart

also, rather than just doing ls, do ls -al as that will give you more details in the directory listing. if you had done that while in /etc/apache2/conf-available, you would have seen a visual indication that the symlink for phpmyadmin.conf was invalid.

[West_Training_8668]

Thanks! It finally works.