[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
rhyker2u
Posts: 23
Joined: Thu Jan 19, 2017 11:46 am

[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby rhyker2u » Sun Apr 16, 2017 3:29 pm

After a pletora of strange recurring phmyadmin errors like:
- feature/controlusers viewtopic.php?f=14&t=10307
- gettext errors (supposedly due to php7?)
- deprecated notices of all sorts
- strange 403 errors after an update (probably due to blowfish keys being shorter than recommended 32 chars, but whatever I tried couldn't get it work)

Thus I decided to replace phpmyadmin by https://www.adminer.org ... with a twist (to keep the phpmyadmin link working in VestaCP backend). Perform from terminal:

Code: Select all

sudo mkdir /usr/share/adminer
sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/index.php
sudo nano /etc/nginx/conf.d/phpmyadmin.inc


replace two occurrences of /usr/share/phpmyadmin/ by /usr/share/adminer/
restart webserver ... and done!

Code: Select all

sudo apt remove phpmyadmin
sudo apt autoremove


Life is bliss again!
Last edited by rhyker2u on Sun Apr 16, 2017 4:04 pm, edited 4 times in total.

rhyker2u
Posts: 23
Joined: Thu Jan 19, 2017 11:46 am

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby rhyker2u » Sun Apr 16, 2017 3:39 pm

Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/

P.S. I didn't know about adminer till I was about to give up on VestaCP. Things happen for a reason I suppose ;-)

skurudo
VestaCP Team
Posts: 7487
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby skurudo » Tue Apr 18, 2017 7:34 am

rhyker2u wrote:Life is bliss again!


Only for nginx+php-fpm, sadly ;-)
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

skurudo
VestaCP Team
Posts: 7487
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby skurudo » Tue Apr 18, 2017 9:02 am

rhyker2u wrote:Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/


phpmyadmin it's historical choice, and was made when adminer not so popular.

Adminer pretty nice.
Well, we thought about this. And some time ago made idea, but not so many votes for adminer - https://bugs.vestacp.com/issues/145
;-(
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

nik
Posts: 12
Joined: Wed May 07, 2014 10:19 pm

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby nik » Sun Apr 23, 2017 1:46 am

Hi Rhyker2u

Many , many thanks for your post on how to replace phpMyAdmin /w Adminer
which I have been using without any CP
I have been using VestaCP since day 1 . My fav CP , until problems with phpMyAdmin
Thanks to you I am now back on VestaCP

Kind Regards
Nik

rhyker2u
Posts: 23
Joined: Thu Jan 19, 2017 11:46 am

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby rhyker2u » Wed May 24, 2017 10:56 am

@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)

And a small addendum to my opening post: after doing the steps above, edit /etc/nginx/conf.d/phpmyadmin.inc again to replace the first line by these 3.

Code: Select all

location /phpmyadmin {
   allow X.X.X.X;
   deny all;


Where X.X.X.X == https://www.whatismyip.com

As I just used my own howto on a new server setup, and knew there was something I forgot for additional security tightening. Also see viewtopic.php?f=10&t=14346&p=60358#p60358 for more post-install tips.

skurudo
VestaCP Team
Posts: 7487
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Postby skurudo » Thu May 25, 2017 3:46 pm

rhyker2u wrote:@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)


@rhyker2u it's not a deal about adminer... we'd like to add new and more, there is time matter and not such much free time ;-(
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests