Page 1 of 3

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

Posted: Sun Apr 16, 2017 3:29 pm
by rhyker2u
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!

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

Posted: Sun Apr 16, 2017 3:39 pm
by rhyker2u
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 ;-)

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

Posted: Tue Apr 18, 2017 7:34 am
by skurudo
rhyker2u wrote:Life is bliss again!
Only for nginx+php-fpm, sadly ;-)

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

Posted: Tue Apr 18, 2017 9:02 am
by skurudo
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
;-(

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

Posted: Sun Apr 23, 2017 1:46 am
by nik
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

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

Posted: Wed May 24, 2017 10:56 am
by rhyker2u
@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.

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

Posted: Thu May 25, 2017 3:46 pm
by skurudo
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 ;-(

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

Posted: Thu Jun 01, 2017 11:13 am
by kinnth
How do you connect to adminer via the web gui? usually I connect to phpmyadmin via www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?

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

Posted: Tue Jul 11, 2017 2:29 pm
by skurudo
kinnth wrote:How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?
Similar way as phpmyamin

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

Posted: Wed Aug 02, 2017 4:41 pm
by rhyker2u
skurudo wrote:
kinnth wrote:How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?
Similar way as phpmyamin
No ... the EXACT same way. @kinnth : just follow instructions in the 1st post. Or create a second entry for adminer to have both (and to make things more complicated); I prefer easy :-p