phpmyadmin on Mint 18 is no-go

Questions about applications and software
Forum rules
Before you post please read how to get help
User avatar
dumbbunny
Level 1
Level 1
Posts: 7
Joined: Thu Mar 10, 2016 8:34 pm

phpmyadmin on Mint 18 is no-go

Post by 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
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 28
Joined: Sat Nov 18, 2006 2:37 pm

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by bbobbo »

does /etc/phpmyadmin exist? if so, what are the contents?
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by bbobbo »

what does

ls -al /etc/phpmyadmin

give you?
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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.
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by bbobbo »

what does

dpkg -l phpmyadmin

show you?
User avatar
weyland
Level 1
Level 1
Posts: 42
Joined: Tue Feb 24, 2015 8:44 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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
DarknessCrYsiS
Level 1
Level 1
Posts: 47
Joined: Tue Mar 29, 2016 8:41 am

Re: phpmyadmin on Mint 18 is no-go

Post by DarknessCrYsiS »

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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by bbobbo »

have you read through this thread and tried any of the other suggestions?
User avatar
dumbbunny
Level 1
Level 1
Posts: 7
Joined: Thu Mar 10, 2016 8:34 pm

Re: phpmyadmin on Mint 18 is no-go

Post by 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
DarknessCrYsiS
Level 1
Level 1
Posts: 47
Joined: Tue Mar 29, 2016 8:41 am

Re: phpmyadmin on Mint 18 is no-go

Post by DarknessCrYsiS »

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/#
bbobbo wrote: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!
bbobbo wrote: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
bbobbo wrote: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
dumbbunny wrote: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
Level 1
Level 1
Posts: 16
Joined: Sun Jul 17, 2016 9:40 am

Re: phpmyadmin on Mint 18 is no-go

Post by 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.
DarknessCrYsiS
Level 1
Level 1
Posts: 47
Joined: Tue Mar 29, 2016 8:41 am

Re: phpmyadmin on Mint 18 is no-go

Post by DarknessCrYsiS »

Thanks! It finally works.
Locked

Return to “Software & Applications”